protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblGridNo = (Label)e.Row.FindControl("lblGridNo"); Int32 intGRIdno = Convert.ToInt32(lblGridNo.Text); LinkButton lnkbtnEdit = (LinkButton)e.Row.FindControl("lnkbtnEdit"); LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); LinkButton lnkbtnSold = (LinkButton)e.Row.FindControl("lnkbtnSold"); LinkButton lnkbtnchallan = (LinkButton)e.Row.FindControl("lnkbtnchallan"); LinkButton lnkbtnPay = (LinkButton)e.Row.FindControl("lnkbtnPay"); GRPrepRetailerDAL obj = new GRPrepRetailerDAL(); Int64 ChallanNo = 0; ChallanNo = obj.CheckChallanDetails(intGRIdno); Int64 InvoiceNo = 0; InvoiceNo = obj.CheckInvoiceDetails(intGRIdno); obj = null; if (ChallanNo > 0) { lnkbtnDelete.Visible = false; lnkbtnchallan.Visible = true; e.Row.ForeColor = System.Drawing.Color.Maroon; lnkbtnSold.Visible = false; } else if (InvoiceNo > 0) { lnkbtnDelete.Visible = false; lnkbtnchallan.Visible = false; e.Row.ForeColor = System.Drawing.Color.Maroon; lnkbtnSold.Visible = true; } else { if (base.CheckUserRights(intFormId) == false) { Response.Redirect("PermissionDenied.aspx"); } if (base.Delete == false) { lnkbtnDelete.Visible = false; } else { lnkbtnDelete.Visible = true; } lnkbtnchallan.Visible = false; lnkbtnSold.Visible = false; } } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = string.Empty; if (e.CommandName == "cmdedit") { Response.Redirect("GrPrepRetailer.aspx?Gr=" + e.CommandArgument, true); } if (e.CommandName == "cmddelete") { GRPrepRetailerDAL obj = new GRPrepRetailerDAL(); Int32 intValue = obj.DeleteGR(Convert.ToInt32(e.CommandArgument)); obj = null; if (intValue > 0) { this.BindGrid(); strMsg = "Record deleted successfully."; txtGRNo.Focus(); } else { if (intValue == -1) { strMsg = "Record can not be deleted. It is in use."; } else { strMsg = "Record not deleted."; } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); } if (e.CommandName == "cmdexport") { GRPrepDAL obj = new GRPrepDAL(); Int32 gr_id = Convert.ToInt32(e.CommandArgument); Int32 grtype = obj.SelectGrTpe(gr_id); ExportCSV = obj.GrCSVReport1(gr_id, grtype, ApplicationFunction.ConnectionString()); obj = null; if (ExportCSV != null) { grdReport.DataSource = ExportCSV; grdReport.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "PopUp", "openModalGrdReport();", true); } else { grdReport.DataSource = null; grdReport.DataBind(); lblTotalRecord.Text = "Total Record (s): 0 "; } obj = null; } if (e.CommandName == "Pay") { GRPrepDAL obj = new GRPrepDAL(); Int32 gr_id = Convert.ToInt32(e.CommandArgument); Int32 ChlnIdno = obj.SelectChlnIdno(gr_id); if (ChlnIdno > 0) { Response.Redirect("PaymentToOwn.aspx?ChlnIdno=" + ChlnIdno, true); } } }
private void BindGrid() { GRPrepRetailerDAL objRet = new GRPrepRetailerDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue); int GrNo = string.IsNullOrEmpty(Convert.ToString(txtGRNo.Text)) ? 0 : Convert.ToInt32(txtGRNo.Text); string MnNo = string.IsNullOrEmpty(Convert.ToString(txtManNo.Text)) ? "" : Convert.ToString(txtManNo.Text); string strPrefixNum = txtPrefixNum.Text.Trim(); if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text)); } int citto = Convert.ToInt32(drpCityTo.SelectedValue); int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue); int citydel = Convert.ToInt32(drpCityDelivery.SelectedValue); int sender = Convert.ToInt32(ddlSender.SelectedValue == "" ? 0 : Convert.ToInt32(ddlSender.SelectedValue)); Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue)); Int64 UserIdno = 0; if (Convert.ToString(Session["Userclass"]) != "Admin") { UserIdno = Convert.ToInt64(Session["UserIdno"]); } var lstGridData = objRet.SelectGRRetailer(GrNo, dtfrom, dtto, cityfrom, citydel, citto, sender, yearidno, UserIdno, strPrefixNum, MnNo); objRet = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("SrNo", typeof(string)); dt.Columns.Add("GrNo", typeof(string)); dt.Columns.Add("GrDate", typeof(string)); dt.Columns.Add("GRType", typeof(string)); dt.Columns.Add("Sender", typeof(string)); dt.Columns.Add("Receiver", typeof(string)); dt.Columns.Add("FromCity", typeof(string)); dt.Columns.Add("ToCity", typeof(string)); dt.Columns.Add("ViaCity", typeof(string)); dt.Columns.Add("LorryNo", typeof(string)); dt.Columns.Add("OwnerName", typeof(string)); dt.Columns.Add("Qty", typeof(string)); dt.Columns.Add("Amount", typeof(string)); dt.Columns.Add("NetAmount", typeof(string)); double TNet = 0; double TAmnt = 0; for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr["SrNo"] = Convert.ToString(i + 1); dr["GrNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "GRRet_Pref")) + "" + Convert.ToString(DataBinder.Eval(lstGridData[i], "GrRet_No")); dr["GrDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "GRRet_Date")).ToString("dd-MM-yyyy"); dr["GRType"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "GR_Typ")); dr["Sender"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Sender")); dr["Receiver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Receiver")); dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityFrom")); dr["ToCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityTo")); dr["ViaCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityVia")); dr["LorryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No")); dr["OwnerName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Owner_Name")); dr["Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Qty")); dr["Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt")).ToString("N2"); dr["NetAmount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amount")).ToString("N2"); dt.Rows.Add(dr); TAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt")); TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amount")); if (i == lstGridData.Count - 1) { DataRow drr = dt.NewRow(); drr["ToCity"] = "Total"; drr["Amount"] = (TAmnt).ToString("N2"); drr["NetAmount"] = (TNet).ToString("N2"); dt.Rows.Add(drr); } } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } // Double TotalGrossNetAmount = 0; Double TotalNetAmount = 0; for (int i = 0; i < lstGridData.Count; i++) { TotalGrossNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt")); TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amount")); } lblNetGrossTotalAmount.Text = TotalGrossNetAmount.ToString("N2"); lblNetTotalAmount.Text = TotalNetAmount.ToString("N2"); grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; //grdprint.DataSource = lstGridData; //grdprint.DataBind(); int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; imgBtnExcel.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; //grdprint.DataSource = null; //grdprint.DataBind(); imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { txtPrefixNum.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);"); txtGRNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);"); if (Request.UrlReferrer == null) { base.AutoRedirect(); } if (!Page.IsPostBack) { if (base.CheckUserRights(intFormId) == false) { Response.Redirect("PermissionDenied.aspx"); } if (base.Print == false) { imgBtnExcel.Visible = false; } if (Convert.ToString(Session["Userclass"]) == "Admin") { this.BindCityFrom(); } else { this.BindCityFrom(Convert.ToInt64(Session["UserIdno"])); } // drpCityFrom.SelectedValue = Convert.ToString(base.UserFromCity); Datefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);"); Dateto.Attributes.Add("onkeypress", "return notAllowAnything(event);"); this.BindDateRange(); ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng); ddlDateRange_SelectedIndexChanged(null, null); this.BindCity(); bindsender(); GRPrepRetailerDAL obj = new GRPrepRetailerDAL(); DateTime? dtfrom = null; DateTime? dtto = null; Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue); int GrNo = string.IsNullOrEmpty(Convert.ToString(txtGRNo.Text)) ? 0 : Convert.ToInt32(txtGRNo.Text); //if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false) //{ // dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text)); //} //if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false) //{ // dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text)); //} string MnNo = string.IsNullOrEmpty(Convert.ToString(txtManNo.Text)) ? "0" : Convert.ToString(txtManNo.Text); string strPrefixNum = txtPrefixNum.Text.Trim(); int citto = Convert.ToInt32(drpCityTo.SelectedValue); int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue); int citydel = Convert.ToInt32(drpCityDelivery.SelectedValue); int senderr = Convert.ToInt32(ddlSender.SelectedValue == "" ? 0 : Convert.ToInt32(ddlSender.SelectedValue)); Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue)); Int64 UserIdno = 0; if (Convert.ToString(Session["Userclass"]) != "Admin") { UserIdno = Convert.ToInt64(Session["UserIdno"]); } var lstGridData = obj.SelectGRRetailer(GrNo, dtfrom, dtto, cityfrom, citydel, citto, senderr, yearidno, UserIdno, strPrefixNum, MnNo); obj = null; if (lstGridData != null && lstGridData.Count > 0) { lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; } } }
private void PrintGRPrep(Int64 GRHeadIdno) { Repeater obj = new Repeater(); GRPrepDAL obj1 = new GRPrepDAL(); tblUserPref hiduserpref = obj1.selectuserpref(); lblConsigneeGSTIN.Text = "'" + hiduserpref.Terms + "'"; lblConsigneeGSTIN.Text = hiduserpref.Terms1; double dcmsn = 0, dblty = 0, dcrtge = 0, dsuchge = 0, dwges = 0, dPF = 0, dtax = 0, dtoll = 0, dqty = 0, damnt = 0, dweight = 0; string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string ServTaxNo = ""; string Through = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = ""; int iPrintOption, PrintRcptAmnt = 0; string strTermCond = ""; Int32 PriPrinted = 0; Int32 ReportTyp = 0; int compID = 0; string numbertoent = ""; GRPrepRetailerDAL objGRRet = new GRPrepRetailerDAL(); DataTable dt = objGRRet.SelectGRPrintKajaria(ApplicationFunction.ConnectionString(), GRHeadIdno); //DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectKajariaPrint',@Id='" + GRHeadIdno + "'"); if (dt != null && dt.Rows.Count > 0) { lblGRNo.Text = Convert.ToString(dt.Rows[0]["GrRet_No"]); lblDate.Text = Convert.ToDateTime(dt.Rows[0]["GrRet_Date"]).ToString("dd-MM-yyyy"); lblFromCity.Text = Convert.ToString(dt.Rows[0]["From_City"]); lblToCity.Text = Convert.ToString(dt.Rows[0]["To_City"]); lblConsigneeName.Text = Convert.ToString(dt.Rows[0]["Sender"]); lblConsigneeGSTIN.Text = Convert.ToString(dt.Rows[0]["SenderGSTIN"]); lblConsignorName.Text = Convert.ToString(dt.Rows[0]["Receiver"]); lblConsignorGSTIN.Text = Convert.ToString(dt.Rows[0]["ReceiverGSTIN"]); lblRemark.Text = Convert.ToString(dt.Rows[0]["Remark"]); lblDelvryPlace.Text = Convert.ToString(dt.Rows[0]["Delivery_Place"]); lblValue.Text = Convert.ToString(dt.Rows[0]["Value"]); lblRefInvNo.Text = Convert.ToString(dt.Rows[0]["Ref_No"]); lblFreight.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Gross_Amnt"])); lblSurcharge.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Stcharg_Amnt"])); lblLabour.Text = "0"; lblPickUp.Text = "0"; lblLocalFreight.Text = "0"; lblBilty.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Bilty_Amnt"])); lblDoorDel.Text = "0"; lblTotal.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Total_Amnt"])); lblValue.Text = "0"; GSTIdno = dt.Rows[0]["GST_Idno"].ToString(); if (GSTIdno != String.Empty && GSTIdno == "1") { SGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["SGST_per"])); CGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["CGST_Per"])); SGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["SGST_Amt"])); CGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["CGST_Amt"])); lblGST.Text = (Convert.ToDouble(SGSTAmt == "" ? "0" : SGSTAmt) + Convert.ToDouble(CGSTAmt == "" ? "0" : CGSTAmt)).ToString("N2"); } if (GSTIdno != String.Empty && GSTIdno == "2") { IGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["IGST_Per"])); IGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["IGST_Amt"])); lblGST.Text = (Convert.ToDouble(IGSTAmt == "" ? "0" : IGSTAmt)).ToString("N2"); } if (GSTIdno != String.Empty && GSTIdno == "3") { UGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["UGST_Per"])); UGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["UGST_Amt"])); lblGST.Text = (Convert.ToDouble(UGSTAmt == "" ? "0" : UGSTAmt)).ToString("N2"); } lblGrossTotal.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Gross_Amnt"])); Repeater1.DataSource = dt; Repeater1.DataBind(); } }