protected void FillData(string vehicleid)
{
Handler hd = new Handler();
DataTable dtcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION CATEGORY' and lm.headid=hm.srno ");
ddleditcategory.DataSource = dtcategory;
ddleditcategory.DataTextField = "NAME";
ddleditcategory.DataValueField = "VALUE";
ddleditcategory.DataBind();
DataTable dtsubcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION SUBCATEGORY' and lm.headid=hm.srno ");
ddleditsubcategory.DataSource = dtsubcategory;
ddleditsubcategory.DataTextField = "NAME";
ddleditsubcategory.DataValueField = "VALUE";
ddleditsubcategory.DataBind();
ddleditsubcategory.Items.Insert(0, "--Select--");
string sql = "SELECT * FROM TERMSCONDITION TM WHERE TM.SRNO=" + ViewState["termid"].ToString().Trim().ToString();
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sql);
txteditterms.Text = dtstate.Rows[0]["TERMS"].ToString().Trim();
txteditdescription.Text = dtstate.Rows[0]["DESCRIPTION"].ToString().Trim();
ddleditcategory.Items.FindByText(dtstate.Rows[0]["CATEGORY"].ToString().Trim()).Selected = true;
if (dtstate.Rows[0]["STATUS"].ToString().Trim() == "True")
{
ddlstatus.SelectedValue = "1";
}
else
{
ddlstatus.SelectedValue = "0";
}
}
private void ShowMenu()
{
Handler hd = new Handler();
string rights = " select mt.menuid,mt.menuname,mt.menutype ,mt.mainmenu from menumaster mt inner join userrights ur on " +
"ur.menuid=mt.menuid inner join userrolemaster urm on urm.srno=ur.roleid " +
"where urm.userdesignation='" + Session["designation"].ToString() + "' and mt.status=0 and menutype='menu' order by mt.menutype";
DataTable dtrights = hd.GetTable(rights);
string subrights = " select mt.menuid,mt.menuname,mt.menutype ,mt.mainmenu,mm.menuname as mainmaenuname" +
" from menumaster mt inner join userrights ur on ur.menuid=mt.menuid inner join userrolemaster urm on urm.srno=ur.roleid " +
" inner join menumaster mm on mt.mainmenu=mm.menuid where urm.userdesignation='" + Session["designation"].ToString() + "' and mt.status=0 order by mt.menutype";
DataTable dtsubrights = hd.GetTable(subrights);
string main = string.Empty;
string menu = string.Empty;
rights = string.Empty;
foreach (DataRow dr in dtrights.Rows)
{
rights += dr["menuname"] + ",";
}
foreach (DataRow dr in dtsubrights.Rows)
{
menu += dr["menuname"] + ",";
main += dr["mainmaenuname"] + ",";
}
hdnrights.Value = rights;
hdnmenu.Value = menu;
hdnmainmenu.Value = main;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "hidediv();", true);
}
public void FillPreviousData()
{
string sqlcolliery = "SELECT CM.SRNO AS COLLIERYID,CM.COLLIERYNAME FROM COLLIERYMASTER CM WHERE STATUS=0";
Handler hdncolliery = new Handler();
DataTable dtcolliery = hdncolliery.GetTable(sqlcolliery);
ddlcolliery.DataSource = dtcolliery;
ddlcolliery.DataTextField = "COLLIERYNAME";
ddlcolliery.DataValueField = "COLLIERYID";
ddlcolliery.DataBind();
ddlcolliery.Items.Insert(0, "--Select--");
string sqldepartment = "SELECT LM.PARTYNAME,LM.SRNO FROM PARTYMASTER LM ORDER BY LM.PARTYNAME";
Handler hdndepartment = new Handler();
DataTable dtdepartment = hdndepartment.GetTable(sqldepartment);
ddlparty.DataSource = dtdepartment;
ddlparty.DataTextField = "PARTYNAME";
ddlparty.DataValueField = "SRNO";
ddlparty.DataBind();
ddlparty.Items.Insert(0, "-- Party --");
string sqlauction = "SELECT AUCTIONID,AUCTIONNAME FROM AUCTIONMASTER WHERE STATUS=0";
Handler hdnauction = new Handler();
DataTable dtauction = hdnauction.GetTable(sqlauction);
ddlauction.DataSource = dtauction;
ddlauction.DataTextField = "AUCTIONNAME";
ddlauction.DataValueField = "AUCTIONID";
ddlauction.DataBind();
ddlauction.Items.Insert(0, "-- Select Auction --");
string sqlcoaltype = "SELECT SRNO,COALTYPE FROM COALMASTER CM WHERE STATUS=0 AND COALTYPEID IS NULL";
Handler hdncoaltype = new Handler();
DataTable dtcoaltype = hdncoaltype.GetTable(sqlcoaltype);
ddlcoaltype.DataSource = dtcoaltype;
ddlcoaltype.DataTextField = "COALTYPE";
ddlcoaltype.DataValueField = "SRNO";
ddlcoaltype.DataBind();
ddlcoaltype.Items.Insert(0, "-- Select Coal --");
string sqlcolliery2 = "SELECT LM.NAME,LM.SRNO FROM LOOKUPMASTER LM INNER JOIN LOOKUPHEADINGMASTER LHM ON LM.HEADID=LHM.SRNO" +
" WHERE LHM.STATUS=0 AND LM.STATUS=0 AND LHM.HEAD='SUPPLY MONTH'";
Handler hdncolliery2 = new Handler();
DataTable dtcolliery2 = hdncolliery.GetTable(sqlcolliery2);
ddlmonth.DataSource = dtcolliery2;
ddlmonth.DataTextField = "NAME";
ddlmonth.DataValueField = "SRNO";
ddlmonth.DataBind();
ddlmonth.Items.Insert(0, "--Select--");
}
protected void lnkedit_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
ViewState["stateid"] = lnk.CommandArgument.ToString();
string sql = "SELECT SM.STATEID,SM.STATENAME,SM.UNIONTERITARY,SM.STATUS FROM STATEMASTER SM WHERE SM.STATEID=" + lnk.CommandArgument.Trim().ToString();
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sql);
txteditname.Text = dtstate.Rows[0]["STATENAME"].ToString().Trim();
if (dtstate.Rows[0]["UNIONTERITARY"].ToString().Trim() == "True")
{
ddledittype.SelectedValue = "1";
}
else
{
ddledittype.SelectedValue = "0";
}
if (dtstate.Rows[0]["STATUS"].ToString().Trim() == "True")
{
ddlstatus.SelectedValue = "1";
}
else
{
ddlstatus.SelectedValue = "0";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "EditState();", true);
}
protected void btnaccount_Click(object sender, EventArgs e)
{
string sponsorid = string.Empty;
Handler hdn = new Handler();
DataTable dt = hdn.GetTable("SELECT SRNO,NAME FROM REGISTRATIONTABLE RT WHERE SPONSORSEMICODE='" + txtsponsorid.Text.Trim() + "'");
if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
{
registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj.registrationtable_SRNO = -1;
obj.registrationtable_NAME = txtname.Text.Trim();
obj.registrationtable_SEMICODE = txtsemid.Text.Trim();
obj.registrationtable_PHONENO = txtmobileno.Text.Trim();
obj.registrationtable_EMAILID = txtemail.Text.Trim();
if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
{
obj.registrationtable_SPONSORID = General.Parse<int>(dt.Rows[0]["SRNO"].ToString());
obj.registrationtable_SPONSORNAME = dt.Rows[0]["NAME"].ToString();
obj.registrationtable_SPONSORSEMICODE = txtsponsorid.Text.Trim();
}
else
{
obj.registrationtable_SPONSORID = -1;
}
obj.registrationtable_STATUS = -1;
string condition = "SRNO=" + Session["userid"].ToString();
if (obj.Insert(false, "registrationtable", condition))
{
MessageBox("Profile Updated Successfully");
}
}
}
private DataTable FillCity(string stateid)
{
string sqlcity = "SELECT RTRIM(CITYNAME) AS CITYNAME,RTRIM(CITYID) AS CITYID FROM CITYMASTER CM WHERE CM.STATUS=0 AND CM.STATEID=" + stateid + " ORDER BY CM.CITYNAME";
Handler hdncity = new Handler();
DataTable dtcity = hdncity.GetTable(sqlcity);
return dtcity;
}
private void FillData(string collieryid)
{
string sqlcolliery = "SELECT * FROM collierymaster CM WHERE CM.SRNO=" + collieryid;
Handler hdncolliery = new Handler();
DataTable dtcolliery = hdncolliery.GetTable(sqlcolliery);
if (dtcolliery.Rows.Count > 0)
{
txtcollieryname.Text =dtcolliery.Rows[0]["COLLIERYNAME"].ToString().Trim();
txtcollierycode.Text = dtcolliery.Rows[0]["COLLIERYCODE"].ToString().Trim();
if (dtcolliery.Rows[0]["COLLIERYREGION"].ToString() == "NAGPUR DEPOT")
{
rdnagpur.Checked = true;
}
else if (dtcolliery.Rows[0]["COLLIERYREGION"].ToString() == "WANI DEPOT")
{
rdwani.Checked = true;
}
}
string sqldetail = "SELECT * FROM collierydetailmaster CDM INNER JOIN COALMASTER CM ON CM.SRNO=CDM.COALID WHERE CM.STATUS=0 AND CDM.COLLIERYID=" + collieryid;
Handler hdndetails = new Handler();
DataTable dtsql = hdndetails.GetTable(sqldetail);
ViewState["data"] = dtsql;
coaltyperepeater.DataSource = dtsql;
coaltyperepeater.DataBind();
}
private DataTable FillData(string id)
{
string sql = "SELECT DATE,NAME,CONTACTNO,ACTIVITY,RESULT,REMARK FROM REPORTINGMASTER RM WHERE STATUS=0 AND RELATIONSHIPID=" + id.ToString();
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
return dt;
}
protected void updateLogin()
{
string sql = "SELECT RELATIONSHIPID FROM USERTABLE UT WHERE UT.USERID='" + ID + "' AND PASSWORD='******' AND STATUS=2";
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
if (dt.Rows.Count > 0)
{
usertable obj1 = new usertable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj1.usertable_SRNO = -1;
obj1.usertable_RELATIONSHIPID = -1;
obj1.usertable_STATUS = 0;
string condition = "USERID = '" + ID + "' AND PASSWORD = '******'";
if (obj1.Insert(false, "usertable", condition))
{
}
registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj.registrationtable_SRNO = -1;
obj.registrationtable_SPONSORID = -1;
obj.registrationtable_STATUS = 0;
string condition1 = "SRNO =" + dt.Rows[0][0].ToString(); ;
if (obj.Insert(false, "registrationtable", condition1))
{
}
}
}
private void FillData(string fromdate,string todate)
{
string sql = "SELECT PT.FIRSTNAME+' '+CASE WHEN PT.MIDDLENAME IS NULL THEN '' ELSE PT.MIDDLENAME END +' '+CASE WHEN PT.LASTNAME IS NULL THEN '' ELSE PT.LASTNAME END +'('+PR.ASSOSIATEDFEILD+')' AS LEDGER," +
" TT.AMOUNT,TT.VOUCHERTYPE,TT.TRANSDATE,TT.NARRATION,TT.LTRNTYPE2 AS LTRNTYPE FROM TRANSACTIONTABLE TT INNER JOIN PERSONALRELATION PR ON PR.SRNO=TT.LEDGER2" +
" INNER JOIN PERSONALTABLE PT ON PT.RELATIONSHIPID=PR.RELATIONSHIPID WHERE TT.BRANCHID =" + Session["branchid"].ToString() + " AND TT.STATUS=0 " +
" AND (convert(datetime, TT.TRANSDATE, 103) BETWEEN convert(datetime, '" + fromdate.Trim().ToString() + "', 103) AND convert(datetime, '" + todate.Trim().ToString() + "', 103)) AND" +
" TT.LEDGER1=(SELECT SRNO FROM PERSONALRELATION PR1 INNER JOIN PERSONALTABLE PT1 ON PT1.RELATIONSHIPID=PR1.RELATIONSHIPID WHERE PT1.FIRSTNAME='CASH ACCOUNT' AND" +
" PT1.BRANCHID=" + Session["branchid"].ToString() + ") AND (TT.TRANSACTIONTYPE=1 OR TT.TRANSACTIONTYPE=2)";
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
string value = GetOpeningAmount(fromdate);
DataRow newrow = dt.NewRow();
string[] columnarr = value.Split('~');
dt.Rows.InsertAt(newrow, 0);
dt.Rows[0]["LEDGER"] = "OPENING AMOUNT";
dt.Rows[0]["AMOUNT"] = columnarr[0].ToString();
dt.Rows[0]["LTRNTYPE"] = columnarr[1].ToString();
DataTable dtcash = GetBalance(dt, "AMOUNT", "LTRNTYPE");
ViewState["cashbook"] = dtcash;
if (dt.Rows.Count > 0)
{
gvcashbook.DataSource = (DataTable)ViewState["cashbook"];
gvcashbook.DataBind();
}
else
{
gvcashbook.DataSource = null;
gvcashbook.DataBind();
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
Handler hdnpartycode=new Handler();
DataTable dtpartycode = hdnpartycode.GetTable("SELECT VEHICLEID FROM VEHICLEMASTER VM WHERE TRANSPORTERID=" + ddltransporter.SelectedValue.ToString().Trim() + " AND VEHICLENO='" + txtvehicleno.Text.Trim().ToString() + "'");
if (dtpartycode.Rows.Count == 0)
{
vehiclemaster objvehiclemaster = new vehiclemaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objvehiclemaster.vehiclemaster_VEHICLEID = -1;
objvehiclemaster.vehiclemaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.ToString().Trim());
objvehiclemaster.vehiclemaster_STATUS = 0;
objvehiclemaster.vehiclemaster_CAPACITY = ddlcapacity.SelectedItem.Text.Trim();
objvehiclemaster.vehiclemaster_VEHICLENO = txtvehicleno.Text.Trim().ToString();
objvehiclemaster.vehiclemaster_VEHICLENAME = txtvehiclename.Text.Trim().ToString();
if (objvehiclemaster.Insert(true, "vehiclemaster"))
{
MessageBox("Vehicle Added Successfully");
ddltransporter.SelectedIndex = 0;
ddlcapacity.SelectedIndex = 0;
txtvehicleno.Text = string.Empty;
txtvehiclename.Text = string.Empty;
FillVehicle();
}
}
else
{
MessageBox("Vehicle Already Present");
}
}
private void FillState()
{
string sqlstate = "SELECT STATENAME,STATEID FROM STATEMASTER SM WHERE SM.STATUS=0 ORDER BY STATENAME";
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sqlstate);
ddlstate.DataSource = dtstate;
ddlstate.DataTextField = "STATENAME";
ddlstate.DataValueField = "STATEID";
ddlstate.DataBind();
ddlworkstate.DataSource = dtstate;
ddlworkstate.DataTextField = "STATENAME";
ddlworkstate.DataValueField = "STATEID";
ddlworkstate.DataBind();
DataTable dtcity = FillCity(dtstate.Rows[0]["STATEID"].ToString());
ddlcity.Enabled = true;
ddlcity.DataSource = dtcity;
ddlcity.DataTextField = "CITYNAME";
ddlcity.DataValueField = "CITYID";
ddlcity.DataBind();
ddlworkcity.Enabled = true;
ddlworkcity.DataSource = dtcity;
ddlworkcity.DataTextField = "CITYNAME";
ddlworkcity.DataValueField = "CITYID";
ddlworkcity.DataBind();
}
private DataTable FillCoolieryList()
{
string sqlpartylist = "SELECT CM.SRNO AS COLLIERYID,CM.COLLIERYNAME,CM.COLLIERYCODE,CM.COLLIERYREGION,CASE WHEN STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM collierymaster CM";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private void FillData(string contractid)
{
string sqldepartment = "SELECT * FROM CONTRACTMASTER CM WHERE CONTRACTID=" + contractid;
Handler hdndepartment = new Handler();
DataTable dtcontract = hdndepartment.GetTable(sqldepartment);
if (dtcontract.Rows[0]["CONTRACTTYPEID"].ToString() == "1")
{
rdservicecontract.Checked = true;
}
else
{
rdtransportcontract.Checked = true;
}
ddlparty.SelectedValue = dtcontract.Rows[0]["PARTYID"].ToString();
FillPartyDetails(contractid.Trim().ToString());
ddlcontactperson.SelectedValue = dtcontract.Rows[0]["PARTYCONTACTPERSONID"].ToString();
txtdate.Text = dtcontract.Rows[0]["CONTRACTDATE"].ToString();
txtrefno.Text = dtcontract.Rows[0]["REFNO"].ToString();
txtrefdate.Text = dtcontract.Rows[0]["REFDATE"].ToString();
txtcontractdate.Text = dtcontract.Rows[0]["STARTDATE"].ToString();
txtexpirydate.Text = dtcontract.Rows[0]["ENDDATE"].ToString();
txtquantity.Text = dtcontract.Rows[0]["QUANTITY"].ToString();
ddlquantitytype.SelectedValue = dtcontract.Rows[0]["QUANTITYPER"].ToString();
txtrate.Text = dtcontract.Rows[0]["RATE"].ToString();
txtchargservice.Text = dtcontract.Rows[0]["SERVICECHARGE"].ToString();
if (dtcontract.Rows[0]["CONTRACTTYPEID"].ToString() == "1")
{
rdservicetaxapplicable.Checked = true;
}
else
{
rdservicetaxnotapplicable.Checked = true;
}
}
private DataTable FillTransporterList()
{
string sqlpartylist = "SELECT TM.SRNO AS TRANSPORTERID,TM.TRANSPORTERNAME,TM.TRANSPORTERCODE,TM.TRANTYPE,TM.MOBILENO,TM.EMAILID,TM.ADDRESS,CASE WHEN TM.STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM transportermaster TM WHERE TM.STATUS=0";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillContractList()
{
string sqlpartylist = "SELECT BRANCHID,BRANCHNAME,STATENAME,CITYNAME,ADDRESS,CASE WHEN STATUS=0 THEN 'ACTIVE' ELSE 'NON-ACTIVE' END AS STATUS FROM BRANCHMASTER BM WHERE BM.CMPID=" + Session["cmpid"].ToString();
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private void FillData()
{
string sqlgodown = "SELECT SRNO,GODOWNNAME FROM GODOWNMASTER GM WHERE STATUS=0";
Handler hdn = new Handler();
DataTable dtgodown = hdn.GetTable(sqlgodown);
ddldepot.DataSource = dtgodown;
ddldepot.DataTextField = "GODOWNNAME";
ddldepot.DataValueField = "SRNO";
ddldepot.DataBind();
string sqlcoaltype = "SELECT SRNO AS COALID, COALTYPE FROM COALMASTER CM WHERE STATUS=0 AND COALTYPEID IS NULL";
Handler hdncoaltype = new Handler();
DataTable dtcoaltype = hdncoaltype.GetTable(sqlcoaltype);
ViewState["coaltype"] = dtcoaltype;
string sqlgrade = "SELECT SRNO AS GRADEID, GRADE,COALTYPEID FROM COALMASTER CM WHERE STATUS=0 AND COALTYPEID IS NOT NULL";
Handler hdngrade = new Handler();
DataTable dtgrade = hdngrade.GetTable(sqlgrade);
ViewState["grade"] = dtgrade;
DataTable dtdata = FillGride();
ViewState["stock"] = dtdata;
gvcoaldetailsstock.DataSource = (DataTable)ViewState["stock"];
gvcoaldetailsstock.DataBind();
}
private DataTable FillGodownList()
{
string sqlpartylist = "SELECT GM.SRNO AS GODOWNID,GM.GODOWNNAME,GM.CITYNAME,GM.STATENAME,GM.PHONE,GM.EMAIL,GM.ADDRESS FROM godownmaster GM WHERE STATUS=0";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillMemberList(string fromdate,string todate)
{
string sqlpartylist = "SELECT * FROM REPORTINGMASTER RM WHERE STATUS=0 AND RELATIONSHIPID=" + Session["userid"].ToString() + " AND DATE BETWEEN '" + fromdate + "' AND '" + todate + "'";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillSubgroup(string groupid)
{
string sql = "SELECT GROUPNAME,GROUPID FROM accountgroup AG WHERE ASSOGROUPID=" + groupid + " AND BRANCHID=0";
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
return dt;
}
private void FillCompany()
{
if (Session["userid"] != null && Session["userid"].ToString() != string.Empty)
{
Handler company = new Handler();
string sqlcmp = "SELECT CM.CMPID,CM.CMPNAME FROM PERMISSIONMASTER PM INNER JOIN COMPANYMASTER CM ON CM.CMPID=PM.CMPID"+
" WHERE CM.STATUS=0 AND PM.STATUS=0 AND PM.USERID="+ Session["userid"].ToString()+" GROUP BY CM.CMPID,CM.CMPNAME";
DataTable dtcompany = company.GetTable(sqlcmp);
if (dtcompany.Rows.Count > 0)
{
ddlcompany.DataSource = dtcompany;
ddlcompany.DataTextField = "CMPNAME";
ddlcompany.DataValueField = "CMPID";
ddlcompany.DataBind();
ddlcompany.Enabled = true;
}
}
else
{
ddlcompany.DataSource = null;
ddlcompany.DataBind();
ddlcompany.Items.Insert(0, new ListItem("--Select Company--", "--Select Company--"));
ddlcompany.Enabled = false;
}
}
private DataTable FillContractList()
{
string sqlpartylist = "SELECT AM.AUCTIONID,AM.AUCTIONNAME,AM.DESCRIPTION,AM.AUCTIONDATE,AM.STARTDATE,AM.ENDDATE,CASE WHEN STATUS=0 THEN 'ACTIVE' WHEN AM.STATUS=1 THEN 'COMPLETE' ELSE 'CANCEL' END AS STATUS " +
" FROM AUCTIONMASTER AM WHERE AM.CMPID=" + Session["cmpid"].ToString();
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillMemberList()
{
string sqlpartylist = "SELECT RT.SRNO,RT.NAME,RT.SPONSORNAME,RT.SPONSORSEMICODE,RT.SEMICODE,RT.EMAILID,RT.PHONENO," +
" CASE WHEN RT.STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM REGISTRATIONTABLE RT WHERE STATUS=1";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillPartyList()
{
string sqlpartylist = "SELECT PM.SRNO AS PARTYID,PM.PARTYNAME,PM.PARTYCODE,PM.PANNO,PM.WEBSITE,PM.PHONENO,PM.EMAIL,PAD.CITYNAME,PAD.STATENAME FROM partymaster PM " +
" INNER JOIN partyaddressmaster PAD ON PM.SRNO=PAD.PARTYID AND PAD.ADDRESSTYPE=1 WHERE PAD.STATUS=0 GROUP BY PM.SRNO,PM.PARTYNAME,PM.PARTYCODE,PM.PANNO,PM.WEBSITE,PM.PHONENO,PM.EMAIL,PAD.CITYNAME,PAD.STATENAME";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Session["downline"] == null)
{
string sql = "SELECT UT.SRNO AS RELATIONSHIPID,RT.SRNO,RT.NAME AS USERNAME,CONCAT(RT.NAME,'-',RT.SEMICODE) AS NAME FROM REGISTRATIONTABLE RT INNER JOIN USERTABLE UT ON RT.SRNO=UT.RELATIONSHIPID WHERE RT.SPONSORID=" + Session["relationshipid"].ToString();
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
relationshipid = Session["relationshipid"].ToString();
downline = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
//if (i > 0)
{
if (downline != string.Empty)
{
downline += "," + dt.Rows[i]["RELATIONSHIPID"].ToString();
}
else
{
downline = dt.Rows[i]["RELATIONSHIPID"].ToString();
}
}
string sql1 = "SELECT UT.SRNO AS RELATIONSHIPID,RT.SRNO,RT.NAME AS USERNAME,CONCAT(RT.NAME,'-',RT.SEMICODE) AS NAME FROM REGISTRATIONTABLE RT INNER JOIN USERTABLE UT ON RT.SRNO=UT.RELATIONSHIPID WHERE RT.SPONSORID=" + dt.Rows[i]["SRNO"].ToString().Trim();
Handler hdn1 = new Handler();
DataTable dt1 = hdn1.GetTable(sql1);
dt.Merge(dt1);
}
ViewState["relationshipid"] = relationshipid;
ViewState["downline"] = downline;
Session["downline"] = dt;
}
string id = Request.QueryString["upload"];
if (id != null)
{
MessageBox("Record Uploaded Successfully");
}
if (Session["userid"] == null)
{
Response.Redirect("register.aspx?login=1");
}
txtfromdate.Text = DateTime.Now.ToString("dd/MM/yyyy");
txttodate.Text = DateTime.Now.ToString("dd/MM/yyyy");
ViewState["data"] = FillData(Session["userid"].ToString());
grvExcelData.DataSource = (DataTable)ViewState["data"];
grvExcelData.DataBind();
}
else
{
txtfromdate.Text = Request.Form[txtfromdate.UniqueID];
txttodate.Text = Request.Form[txttodate.UniqueID];
}
}
private DataTable FillContractList()
{
string sqlpartylist = "SELECT DM.DOID,DM.DOFOR,DM.DONO,DM.DODATE,DM.MONTH,DM.DESTINATION,CASE WHEN DM.DOFOR='AUCTION' THEN AM.AUCTIONNAME ELSE PM.PARTYNAME END AS PARTY FROM DOMASTER DM"+
" LEFT OUTER JOIN PARTYMASTER PM ON PM.SRNO=DM.PARTYID LEFT OUTER JOIN AUCTIONMASTER AM ON AM.AUCTIONID=DM.PARTYID"+
" WHERE DM.CMPID=" + Session["cmpid"].ToString();
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillContractList()
{
string sqlpartylist = " SELECT SRNO,ACCOUNTNAME,ACCOUNTNO,BANKNAME,BANKBRANCHNAME,IFSCCODE,ADDRESS,"+
" CASE WHEN STATUS=0 THEN 'ACTIVE' ELSE 'DEACTIVE' END AS STATUS FROM BANKMASTER BM"+
" WHERE BM.BRANCHID IN( SELECT B.BRANCHID FROM BRANCHMASTER B WHERE B.CMPID="+Session["cmpid"].ToString()+")" ;
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillContractList()
{
string sqlpartylist = "SELECT CM.CONTRACTID,PM.PARTYNAME,CM.CONTRACTTYPE, CM.STARTDATE,CM.ENDDATE,CAST(CM.QUANTITY AS VARCHAR(20)) +' '+CM.QUANTITYPER AS QUANTITY," +
" CM.RATE,CM.SERVICECHARGE,CASE WHEN CM.STATUS='0' THEN 'ACTIVE' ELSE 'COMPLETE' END AS STATUS FROM CONTRACTMASTER CM " +
" INNER JOIN PARTYMASTER PM ON PM.SRNO=CM.PARTYID ";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private DataTable FillContractList()
{
string sqlpartylist = "SELECT RTRIM(QUOTATIONID) AS QUOTATIONID,RTRIM(DATE) AS DATE,RTRIM(EXPIRYDATE) AS EXPIRYDATE,RTRIM(REFNO) AS REFNO," +
" RTRIM(COALCOST) AS COALCOST,RTRIM(TAXCOST) AS TAXCOST,RTRIM(TRANSPORTATIONCOST) AS TRANSPORTATIONCOST," +
" RTRIM(TOTALCOST) AS TOTALCOST FROM QUOTATIONMASTER QM";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
private void FillState()
{
string sql = "SELECT SM.STATEID,SM.STATENAME,CASE WHEN SM.UNIONTERITARY=0 THEN 'STATE' ELSE 'UNION TERITARY' END AS TYPE," +
" CASE WHEN SM.STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM STATEMASTER SM ORDER BY SM.STATENAME";
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sql);
ViewState["list"] = dtstate;
gvstatelist.DataSource = (DataTable)ViewState["list"];
gvstatelist.DataBind();
}
