Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

DataAccess.cs

using System;
using System.Data;
using System.Configuration;
////using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
////using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;

/// <summary>
/// Summary description for DataAccess
/// </summary>
public class DataAccess
{
    SqlConnection con = new SqlConnection();
    static string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConncectionStr"].ConnectionString;
    SqlDataAdapter adpt = new SqlDataAdapter();
    SqlCommand cmd = new SqlCommand();
    DataSet ds = new DataSet();
    DbCommand dbcommand;
    SqlDatabase db = new SqlDatabase(connString);

#region Variables

private string _Text, _Description, _ParentID, _NavigateUrl,_OldPassword, _NewPassword, _UserName;
    private string _name, _description, _district,_Password, _ID,_AchID,_UploadID,_AchDetail,_ActYear;
    private string _fname, _fcompany, _faddress, _ftelno, _ffax, _femail, _fcomment, _fdate,_lang,_file,_filesize;
    private string _advtdt, _newspaper, _bidsubdt, _bidopendt, _divisionid, _districtid, _uploaddate, _isdeleted, _colorid, _despdt, _despdtcirc;
    private string _budYearF, _budYearT, _distId, _AllDist, _loginid, _pass, _User_name, _MenuID;

public string User_name
    {
        get
        {
            return this._User_name;
        }
        set
        {
            this._User_name = value.Trim();
        }
    }
    
    public string pass
    {
        get
        {
            return this._pass;
        }
        set
        {
            this._pass = value.Trim();
        }
    }
    public string loginid
    {
        get
        {
            return this._loginid;
        }
        set
        {
            this._loginid = value.Trim();
        }
    }
    public string AllDist
    {
        get
        {
            return this._AllDist;
        }
        set
        {
            this._AllDist = value.Trim();
        }
    }
    public string distId
    {
        get
        {
            return this._distId;
        }
        set
        {
            this._distId = value;
        }
    }
    public string budYearF
    {
        get
        {
            return this._budYearF;
        }
        set
        {
            this._budYearF = value.Trim();
        }
    }
    public string budYearT
    {
        get
        {
            return this._budYearT;
        }
        set
        {
            this._budYearT = value.Trim();
        }
    }

public string despdtcirc
    {
        get
        {
            return this._despdtcirc;
        }
        set
        {
            this._despdtcirc = value.Trim();
        }
    }
    public string despdt
    {
        get
        {
            return this._despdt;
        }
        set
        {
            this._despdt = value.Trim();
        }
    }
    public string colorid
    {
        get
        {
            return this._colorid;
        }
        set
        {
            this._colorid = value.Trim();
        }
    }
    public string isdeleted
    {
        get
        {
            return this._isdeleted;
        }
        set
        {
            this._isdeleted = value.Trim();
        }
    }
    public string uploaddate
    {
        get
        {
            return this._uploaddate;
        }
        set
        {
            this._uploaddate = value.Trim();
        }
    }
    public string districtid
    {
        get
        {
            return this._districtid;
        }
        set
        {
            this._districtid = value.Trim();
        }
    }
    public string divisionid
    {
        get
        {
            return this._divisionid;
        }
        set
        {
            this._divisionid = value.Trim();
        }
    }
    public string bidopendt
    {
        get
        {
            return this._bidopendt;
        }
        set
        {
            this._bidopendt = value.Trim();
        }
    }
    public string bidsubdt
    {
        get
        {
            return this._bidsubdt;
        }
        set
        {
            this._bidsubdt = value.Trim();
        }
    }
    public string newspaper
    {
        get
        {
            return this._newspaper;
        }
        set
        {
            this._newspaper = value.Trim();
        }
    }
    public string advtdt
    {
        get
        {
            return this._advtdt;
        }
        set
        {
            this._advtdt = value.Trim();
        }
    }
    public string filesize
    {
        get
        {
            return this._filesize;
        }
        set
        {
            this._filesize = value.Trim();
        }
    }
    public string file
    {
        get
        {
            return this._file;
        }
        set
        {
            this._file = value.Trim();
        }
    }
    public string lang
    {
        get
        {
            return this._lang;
        }
        set
        {
            this._lang = value.Trim();
        }
    }
    public string ActYear
    {
        get
        {
            return this._ActYear;
        }
        set
        {
            this._ActYear = value.Trim();
        }
    }
   public string AchDetail
    {
        get
        {
            return this._AchDetail;
        }
        set
        {
            this._AchDetail = value.Trim();
        }
    }
    public string UploadID
    {
        get
        {
            return this._UploadID;
        }
        set
        {
            this._UploadID = value.Trim();
        }
    }
    public string Text
    {
        get
        {
            return this._Text;
        }
        set
        {
            this._Text = value.Trim();
        }
    }
    public string Description
    {
        get
        {
            return this._Description;
        }
        set
        {
            this._Description = value.Trim();
        }
    }
    public string ParentID
    {
        get
        {
            return this._ParentID;
        }
        set
        {
            this._ParentID = value.Trim();
        }
    }
    public string NavigateUrl
    {
        get
        {
            return this._NavigateUrl;
        }
        set
        {
            this._NavigateUrl = value.Trim();
        }
    }
    public string district
    {
        get
        {
            return this._district;
        }
        set
        {
            this._district = value.Trim();
        }
    }
    public string name
    {
        get
        {
            return this._name;
        }
        set
        {
            this._name = value.Trim();
        }
    }
    public string MenuID
    {
        get
        {
            return this._MenuID;
        }
        set
        {
            this._MenuID = value.Trim();
        }
    }
    public string description
    {
        get
        {
            return this._description;
        }
        set
        {
            this._description = value.Trim();
        }
    }
    public string Password
    {
        get
        {
            return this._Password;
        }
        set
        {
            this._Password = value.Trim();
        }
    }
    public string ID
    {
        get
        {
            return this._ID;
        }
        set
        {
            this._ID = value.Trim();
        }
    }
    public string UserName
    {
        get
        {
            return this._UserName;
        }
        set
        {
            this._UserName = value.Trim();
        }
    }
    public string fname
    {
        get
        {
            return this._fname;
        }
        set
        {
            this._fname = value.Trim();
        }
    }
    public string fcompany
    {
        get
        {
            return this._fcompany;
        }
        set
        {
            this._fcompany = value.Trim();
        }
    }
    public string faddress
    {
        get
        {
            return this._faddress;
        }
        set
        {
            this._faddress = value.Trim();
        }
    }
    public string ftelno
    {
        get
        {
            return this._ftelno;
        }
        set
        {
            this._ftelno = value.Trim();
        }
    }
    public string ffax
    {
        get
        {
            return this._ffax;
        }
        set
        {
            this._ffax = value.Trim();
        }
    }
    public string femail
    {
        get
        {
            return this._femail;
        }
        set
        {
            this._femail = value.Trim();
        }
    }
   
    public string AchID
    {
        get
        {
            return this._AchID;
        }
        set
        {
            this._AchID = value.Trim();
        }
    }
    
    public string fdate
    {
        get
        {
            return this._fdate;
        }
        set
        {
            this._fdate = value.Trim();
        }
    }
    public string fcomment
    {
        get
        {
            return this._fcomment;
        }
        set
        {
            this._fcomment = value.Trim();
        }
    }
    public string OldPassword
    {
        get
        {
            return this._OldPassword;
        }
        set
        {
            this._OldPassword = value.Trim();
        }
    }
    public string NewPassword
    {
        get
        {
            return this._NewPassword;
        }
        set
        {
            this._NewPassword = value.Trim();
        }
    }
    #endregion
    public DataAccess()
    {
       // con.ConnectionString = ConfigurationManager.ConnectionStrings["Constr"].ToString();
    }
    public DataSet FillDs(string str)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = str;
        cmd.ExecuteNonQuery();
        adpt.SelectCommand = cmd;
        adpt.Fill(ds);
        con.Close();
        return ds;
    }
    public void Fillgrid(GridView gv, string qry)
    {
        gv.DataSource = FillDs(qry);
        gv.DataBind();
    }
    public void IDU(string a)
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandText = a;
        cmd.ExecuteNonQuery();
        con.Close();

}

#region SELECT

public DataSet uspPanelChart(int PM_Id)
    {
        dbcommand = db.GetStoredProcCommand("uspPanelChart", PM_Id);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet uspEventForHeaderPart1()
    {
        dbcommand = db.GetStoredProcCommand("uspEventForHeader1");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;

}
    public DataSet uspGetPlanMaster()
    {
        dbcommand = db.GetStoredProcCommand("uspGetPlanMaster");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet uspGetEvent(int PM_Id, DateTime event_start)
    {
        dbcommand = db.GetStoredProcCommand("uspGetEvent", PM_Id, event_start);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet uspGetInsertEvent(int PM_Id, DateTime event_start, DateTime event_end, string Number1, string Number2, string Number3)
    {

dbcommand = db.GetStoredProcCommand("uspGetInsertEvent", PM_Id, event_start, event_end, Number1, Number2, Number3);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getallMenu()
    {
        dbcommand = db.GetStoredProcCommand("sp_GetAllMenu");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet UpdateMemberDetails(int MM_ID, int MenuID, string MM_FirmName, string MM_Address, string MM_Dist, string MM_State, string MM_PincodeNo, string MM_LandlineNo, string MM_MobileNo, string MM_FaxNo, string MM_Email, string MM_Website, string MM_description, string MM_ContactPersons, string MM_PanCardNO, string MM_TINNO, string MM_ExpiredDays, string MM_ImagePath)
    {

dbcommand = db.GetStoredProcCommand("uspUpdateMemberDetails",MM_ID,MenuID  ,  MM_FirmName,MM_Address,MM_Dist,MM_State,MM_PincodeNo,MM_LandlineNo,MM_MobileNo,MM_FaxNo,MM_Email,MM_Website,MM_description,MM_ContactPersons , MM_PanCardNO,MM_TINNO, MM_ExpiredDays,MM_ImagePath);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet MemberDetailsforEdit(int MM_ID, int MenuID)
    {

dbcommand = db.GetStoredProcCommand("usp_getMemberDetailsforEdit", MM_ID, MenuID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet InsertImage(int IM_ImageType,byte[] IM_Image)
    {
        dbcommand = db.GetStoredProcCommand("uspInsertImage", IM_ImageType, IM_Image);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetAllOverdueMember(int MenuID)
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllOverdueMember", MenuID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet InsertUser(string username, string upass, int typeofuser, int typeofadd)
    {
        dbcommand = db.GetStoredProcCommand("uspInsertusers", username, upass, typeofuser, typeofadd);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet HeaderImageDetails_Insert(string dsXml, int HID_CreatedBy)
    {

dbcommand = db.GetStoredProcCommand("HeaderImageDetails_Insert", dsXml, HID_CreatedBy);

ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet HeaderImageDetails_load()
    {

dbcommand = db.GetStoredProcCommand("HeaderImageDetails_load");

ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet InsertMemberDetails(string dsXml, int MenuID, int MM_CreatedBy)
    {

dbcommand = db.GetStoredProcCommand("uspInsertMemberDetails", dsXml, MenuID, MM_CreatedBy);

ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetMemberDetails(int MenuID, string SearchText, int Flag, int pageNumber)
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllMemberDetails", MenuID, SearchText, Flag, pageNumber);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet DeleteMemberDetails(int MM_ID)
    {
        dbcommand = db.GetStoredProcCommand("uspDeleteMemberDetails", MM_ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet DeleteUser(int id)
    {
        dbcommand = db.GetStoredProcCommand("uspDeleteUser", id);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetAllCity()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllCity");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetAllAdd()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllAdd");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getallpagecontent()
    {
        dbcommand = db.GetStoredProcCommand("sp_getallpagecontent");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetStatiticsPdf()
    {
        dbcommand = db.GetStoredProcCommand("sp_GetStatiticsPdf");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetContactUsPdf()
    {
        dbcommand = db.GetStoredProcCommand("sp_GetContactUsPdf");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetReportsPdf()
    {
        dbcommand = db.GetStoredProcCommand("sp_GetReportsPdf");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet uspGetLiveNumber()
    {
        dbcommand = db.GetStoredProcCommand("uspGetLiveNumber");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getpagecontentbyID(int MenuID)
    {
        dbcommand = db.GetStoredProcCommand("UspGetAllpagecontentbyMenuID", MenuID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getLogin()
    {
        dbcommand = db.GetStoredProcCommand("uspGetLogin", UserName, Password);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getFileUpload()
    {
        dbcommand = db.GetStoredProcCommand("uspGetFileUpload");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getActsAndRules()
    {
        dbcommand = db.GetStoredProcCommand("uspGetActsAndRules");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getStateLiveDetail()
    {
        dbcommand = db.GetStoredProcCommand("uspGetStateLiveDetail");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getDistrictDetail()
    {
        dbcommand = db.GetStoredProcCommand("uspGetDistrictDetail", district);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getCirculars()
    {
        dbcommand = db.GetStoredProcCommand("uspGetCirculars");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getOrders()
    {
        dbcommand = db.GetStoredProcCommand("uspGetOrders");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetUpload()
    {
        dbcommand = db.GetStoredProcCommand("uspGetUpload");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getTender()
    {
        dbcommand = db.GetStoredProcCommand("uspGetTender");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetAllLogin()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllLogin");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet GetFeedback()
    {
        dbcommand = db.GetStoredProcCommand("uspGetFeedback");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetRepliedFeedback()
    {
        dbcommand = db.GetStoredProcCommand("uspGetRepliedFeedback");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getDownloadForms()
    {
        dbcommand = db.GetStoredProcCommand("uspGetDownloadForms");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet getadminbyusernamepass()
    {
        dbcommand = db.GetStoredProcCommand("sp_getadminbyusernamepass", UserName, Password);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getAllParentMenus()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllParentMenus");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet NewsDetails_load()
    {
        dbcommand = db.GetStoredProcCommand("NewsDetails_load");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet ContentMasterByContentID(int CM_ID)
    {
        dbcommand = db.GetStoredProcCommand("ContentMasterByContentID", CM_ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet NewsDetailsbyMenu(int MenuID)
    {
        dbcommand = db.GetStoredProcCommand("NewsDetailsbyMenu", MenuID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet ContentMaster_Load()
    {
        dbcommand = db.GetStoredProcCommand("ContentMaster_Load");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getAllHeaderMenus()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAllHeaderMenus");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet uspInsertMenuOrder(string dsXml)
    {
        dbcommand = db.GetStoredProcCommand("uspInsertMenuOrder", dsXml);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
      public DataSet getAllMenus()
      {
          dbcommand = db.GetStoredProcCommand("uspGetAllMenus");
          ds = db.ExecuteDataSet(dbcommand);
          return ds;
      }
      public DataSet GetAllImageForAdd(int IM_ImageType, int pageNumber)
      {
          dbcommand = db.GetStoredProcCommand("uspGetAllImage", IM_ImageType, pageNumber);
          ds = db.ExecuteDataSet(dbcommand);
          return ds;
      }

public DataSet GetMenuToEdit()
    {
        dbcommand = db.GetStoredProcCommand("uspGetMenuToEdit");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public void DeleteTrnFileUpload()
    {
        dbcommand = db.GetStoredProcCommand("uspTrnFileUploadDelete", ID);
        db.ExecuteNonQuery(dbcommand);
    }

public DataSet updatepass(string uname, string opass, string npass)
    {
        dbcommand = db.GetStoredProcCommand("usp_Updatepassword", uname, opass, npass);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public void updatepagecontent(int MenuID, string description)
    {
        dbcommand = db.GetStoredProcCommand("sp_Updatepagecontent", MenuID, description);
        db.ExecuteNonQuery(dbcommand);
    }

public DataSet GetMenuToEditByID()
    {
        dbcommand = db.GetStoredProcCommand("uspGetMenuToEditByID", ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

//Bhupendra 12.07.2010
    public DataSet GetFeedbackToEditByID()
    {
        dbcommand = db.GetStoredProcCommand("uspFeedbackToEditByID", ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    //Bhupendra 28.07.2010
    public DataSet getHeadOfficeAnnualTarget()
    {
        dbcommand = db.GetStoredProcCommand("sp_HeadOffAnnualTarget", budYearF, budYearT,distId,ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
 //Bhupendra 29.07.2010
    public DataSet getHeadOffAnnualTargetActivityWise()
    {
        dbcommand = db.GetStoredProcCommand("sp_HeadOffAnnualTargetActivityWise", budYearF, budYearT, distId,AllDist);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet Getsp_SelectLogin()
    {
        dbcommand = db.GetStoredProcCommand("uspGetLogin", User_name, Password);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getUnions()
    {
        dbcommand = db.GetStoredProcCommand("uspGetUnion");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet getAchievments()
    {
        dbcommand = db.GetStoredProcCommand("uspGetAchievments");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

#endregion
    #region INSERT
    public DataSet ContentMasterDetails_Insert(int CM_ID, string CMD_Content, int CMD_CreatedBy)
    {
        dbcommand = db.GetStoredProcCommand("ContentMasterDetails_Insert", CM_ID,CMD_Content, CMD_CreatedBy);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet FillcboContentMaster()
    {
        dbcommand = db.GetStoredProcCommand("FillcboContentMaster");
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet NewsDetails_Insert( int MenuID,
                                        string ND_SummaryNews,
                                        string ND_NewsDescription ,
                                        string ND_IconImageUrl ,
                                        string ND_FullImageUrl ,
                                        string ND_VideoImagePath ,
                                        string ND_NewsLink,
                                        int ND_CreatedBy)
    {
        dbcommand = db.GetStoredProcCommand("NewsDetails_Insert", MenuID,  ND_SummaryNews,  ND_NewsDescription,  ND_IconImageUrl,  ND_FullImageUrl,
                                                                    ND_VideoImagePath,  ND_NewsLink,  ND_CreatedBy);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public DataSet InsertNewMenu()
    {
        dbcommand = db.GetStoredProcCommand("uspAddNewMenu", Text, description, ParentID, NavigateUrl);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }
    public Int32 EditUploadFilesToUpdateByID()
    {
        dbcommand = db.GetStoredProcCommand("GetUploadFilesToUpdateByID", UploadID, AchID, AchDetail, ActYear, lang, file, filesize);
        return db.ExecuteNonQuery(dbcommand);
    }
    public Int32 InsertTrn_File_upload()
    {
        dbcommand = db.GetStoredProcCommand("sp_InsertTrn_File_upload", UploadID, AchDetail, file, filesize, advtdt, newspaper, bidsubdt, bidopendt, divisionid, districtid, ActYear, uploaddate, lang, isdeleted, colorid, despdt, despdtcirc);
        return db.ExecuteNonQuery(dbcommand);
    }

#endregion
    #region UPDATE
    public void InsertFeedback()
    {
        dbcommand = db.GetStoredProcCommand("uspInsertFeedback", fname, fcompany, faddress, ftelno, ffax, femail, fcomment);
        db.ExecuteNonQuery(dbcommand);
    }

public DataSet ChangePassword()
    {
        dbcommand = db.GetStoredProcCommand("uspChangePassword", OldPassword, NewPassword, UserName);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
        //db.ExecuteNonQuery(dbcommand);
    }
    public DataSet UploadFilesByID()
    {
        dbcommand = db.GetStoredProcCommand("GetUploadFilesByID", ID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public DataSet GetUploadFilesToEditByID()
    {
        dbcommand = db.GetStoredProcCommand("GetUploadFilesToEditByID", ID,AchID);
        ds = db.ExecuteDataSet(dbcommand);
        return ds;
    }

public Int32 UpdateMenu()
    {
        int i;
        dbcommand = db.GetStoredProcCommand("uspUpdateMenu",ID,Text,Description,ParentID,NavigateUrl);
        return db.ExecuteNonQuery(dbcommand);
    }
    //Bhupendra 12.07.2010
    public Int32 UpdateFeedbackReply()
    {
        int i;
        dbcommand = db.GetStoredProcCommand("uspUpdateFeedbackReply", ID, fname, faddress, ffax, femail, fcomment);
        return db.ExecuteNonQuery(dbcommand);
    }
    #endregion
    #region DELETE

public void ContentMaster_Delete(int CM_ID)
    {
        dbcommand = db.GetStoredProcCommand("ContentMaster_Delete", CM_ID);
        db.ExecuteNonQuery(dbcommand);
    }
    public void NewsDetails_Delete(int ND_ID)
    {
        dbcommand = db.GetStoredProcCommand("NewsDetails_Delete", ND_ID);
        db.ExecuteNonQuery(dbcommand);
    }

public void DeleteMenuByMenuID()
    {
        dbcommand = db.GetStoredProcCommand("uspDeleteMenuByMenuID", ID);
        db.ExecuteNonQuery(dbcommand);
    }
    //Bhupendra 06.07.2010
    public void DeleteFeedback()
    {
        dbcommand = db.GetStoredProcCommand("uspDeleteFeedback", ID);
        db.ExecuteNonQuery(dbcommand);
    }
    #endregion

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2017-09-17 02:37:42
..	dir	-	0/0	0777	2023-01-29 07:10:04
CalendarEvent.cs	text/plain	363 B	0/0	0666	2017-10-18 05:44:30
ClsArrearMaster.cs	text/plain	2.76 KB	0/0	0666	2017-10-18 05:44:41
DataAccess.cs	text/plain	27.5 KB	0/0	0666	2017-10-18 05:44:31
DataInteraction.cs	text/plain	3.35 KB	0/0	0666	2017-10-18 05:44:32
DataIntraction.cs	text/plain	445 B	0/0	0666	2017-10-18 05:44:32
EventDAO.cs	text/plain	6.2 KB	0/0	0666	2017-10-18 05:44:32
ImproperCalendarEvent.cs	text/plain	366 B	0/0	0666	2017-10-18 05:44:32
WebService.cs	text/plain	1.59 KB	0/0	0666	2017-10-18 05:44:32
clsDBOperations.cs	text/plain	23.79 KB	0/0	0666	2017-10-18 05:44:31
clsGenral.cs	text/plain	23.19 KB	0/0	0666	2017-10-18 05:44:31

Team Anon Force

https://t.me/Professor6T9x