public void userpref()
{
GRPrepDAL objGrprepDAL = new GRPrepDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
AmntRecvdAgnst = Convert.ToInt32(userpref.AmntRecvdAgnst_GRInvce);
UpdateGr = Convert.ToBoolean(userpref.TBB_Rate);
if (string.IsNullOrEmpty(userpref.Menu_FleetMgmt.ToString()) ? false : Convert.ToBoolean(userpref.Menu_FleetMgmt) == true)
{
liFleetMgmt.Visible = true;
}
else
{
liFleetMgmt.Visible = false;
}
if (string.IsNullOrEmpty(userpref.GRRetRequired.ToString()) ? false : Convert.ToBoolean(userpref.GRRetRequired) == true)
{
liRetailMast.Visible = liRetailBookEntry.Visible = true;
hrfGRConsldRepRetlr.Visible = true;
}
else
{
liRetailMast.Visible = liRetailBookEntry.Visible = false;
hrfGRConsldRepRetlr.Visible = false;
}
}
private void PrintGRJainBulk(Int64 GRHeadIdno)
{
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string ServTaxNo = ""; string email = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
private void GRPrep()
{
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
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 = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
private void PrintGRPrep(Int64 GRHeadIdno)
{
GRPrepDAL obj1 = new GRPrepDAL();
if (GRHeadIdno != 0)
{
//DataSet ds = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectPrintOM',@Id='" + GRHeadIdno + "'");
DataSet ds = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectPrint',@Id='" + GRHeadIdno + "'");
ds.Tables[0].TableName = "GRPrint";
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
lblTexInvoice.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Tax_InvNo"]);
lblExciceInvoice.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Exc_InvNo"]);
lblGRno.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Gr_No"]);
lblGrDate.Text = string.Format("{0:MMMM dd, yyyy}", Convert.ToDateTime(ds.Tables["GRPrint"].Rows[0]["Gr_Date"]));//.ToString("dd-MM-yyyy");
lblOrderNO.Text = ds.Tables["GRPrint"].Rows[0]["Ordr_No"].ToString();
lblConsignorName1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Sender"]);// ds.Tables["GRPrint"].Rows[0]["ConsigName"].ToString();
lblConsigneeName1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Receiver"]);
lblConsigneeAddress1.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Recriver Address"]);
lblDeliverCity.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["To_City"]);
lblDeliverPlace.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Delivery_Place"]);
lblDeliverDistrict.Text = "";
lblLorryNo.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Lorry No"].ToString());
lblQty.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Qty"]); //Convert.ToString(dsReport.Tables["GRPrint"].Rows[0]["Unit"]);
lblWeight.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Tot_Weght"]);
lblItemName.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Item_Modl"]);
lblRemark.Text = Convert.ToString(ds.Tables["GRPrint"].Rows[0]["Remark"]);
lblTotalAMT.Text = string.Format("{0:0,0.00}", Convert.ToDouble(ds.Tables["GRPrint"].Rows[0]["Net_Amnt"]));
lblAdvance.Text = "";
lblFuelPayment.Text = "";
lblTotAdvance.Text = "";
lblLorryOwner.Text = "";
lblLorryAddress.Text = "";
lblLorryDriver.Text = "";
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alearMessage", "alert('Wrong GR No. please correct !')", true);
}
}
public void PrintGRPrep(Int64 intGRIdno)
{
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
// HidsRenWages.Value = Convert.ToString(hiduserpref.WagesLabel_Print);
if (hiduserpref.Logo_Req == true && hiduserpref.Logo_Image != null)
{
imgLogoShow.Visible = true;
byte[] img = hiduserpref.Logo_Image;
string base64String = Convert.ToBase64String(img, 0, img.Length);
imgLogoShow.ImageUrl = "data:image/png;base64," + base64String;
}
else
{
imgLogoShow.Visible = false;
imgLogoShow.ImageUrl = "";
}
if (Convert.ToString(hiduserpref.Terms) == "" && Convert.ToString(hiduserpref.Terms1) == "")
{
lblTerms.Visible = false;
lblterms1.Visible = false;
}
else
{
lblTerms.Visible = true;
lblterms1.Visible = true;
lblTerms.Text = "'" + hiduserpref.Terms + "'";
lblterms1.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 = "";
string CompGSTIN = ""; string Email = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
private void PrintGRPrep(Int64 GRHeadIdno)
{
visiFalse.Visible = false;
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
HidsRenWages.Value = Convert.ToString(hiduserpref.WagesLabel_Print);
hidRenamePF.Value = Convert.ToString(hiduserpref.PFLabel_GR);
hidRenameToll.Value = Convert.ToString(hiduserpref.TollTaxLabel_GR);
HidsRenCartage.Value = Convert.ToString(hiduserpref.CartageLabel_GR);
HidRenCommission.Value = Convert.ToString(hiduserpref.CommissionLabel_Gr);
HidRenBilty.Value = Convert.ToString(hiduserpref.BiltyLabel_GR);
//if (hiduserpref.Logo_Req == true && hiduserpref.Logo_Image != null)
//{
// imgLogoShow.Visible = true;
// byte[] img = hiduserpref.Logo_Image;
// string base64String = Convert.ToBase64String(img, 0, img.Length);
// imgLogoShow.ImageUrl = "data:image/png;base64," + base64String;
//}
//else
//{
// imgLogoShow.Visible = false;
// imgLogoShow.ImageUrl = "";
//}
//if (Convert.ToString(hiduserpref.Terms) == "" && Convert.ToString(hiduserpref.Terms1) == "")
//{
// lblTerms.Visible = false;
// lblterms1.Visible = false;
//}
//else
//{
// lblTerms.Visible = true;
// lblterms1.Visible = true;
// lblTerms.Text = "'" + hiduserpref.Terms + "'";
// lblterms1.Text = hiduserpref.Terms1;
//}
if (Convert.ToString(HidsRenWages.Value) != "")
{
lblUnloadingPrint.Text = Convert.ToString(HidsRenWages.Value);
labHam.Text = Convert.ToString(HidsRenWages.Value);
}
else
{
lblUnloadingPrint.Text = "Wages";
labHam.Text = "Wages";
}
if (Convert.ToString(hidRenamePF.Value) != "")
{
lblCollChargePrint.Text = Convert.ToString(hidRenamePF.Value);
labCollCha.Text = Convert.ToString(hidRenamePF.Value);
}
else
{
lblCollChargePrint.Text = "PF";
labCollCha.Text = "PF";
}
if (Convert.ToString(hidRenameToll.Value) != "")
{
lblDelChargesPrint.Text = Convert.ToString(hidRenameToll.Value);
labDelCha.Text = Convert.ToString(hidRenameToll.Value);
}
else
{
lblDelChargesPrint.Text = "Toll Tax";
labDelCha.Text = "Toll Tax";
}
if (Convert.ToString(HidsRenCartage.Value) != "")
{
lblFOVPrint.Text = Convert.ToString(HidsRenCartage.Value);
labFOV.Text = Convert.ToString(HidsRenCartage.Value);
}
else
{
lblFOVPrint.Text = "Cartage";
labFOV.Text = "Cartage";
}
if (Convert.ToString(HidRenCommission.Value) != "")
{
lblOctroiPrint.Text = Convert.ToString(HidRenCommission.Value);
labOctroi.Text = Convert.ToString(HidRenCommission.Value);
}
else
{
lblOctroiPrint.Text = "Commission";
labOctroi.Text = "Commission";
}
if (Convert.ToString(HidRenBilty.Value) != "")
{
lblDemuChargesPrint.Text = Convert.ToString(HidRenBilty.Value);
labDemCha.Text = Convert.ToString(HidRenBilty.Value);
}
else
{
labDemCha.Text = "Bilty";
lblDemuChargesPrint.Text = "Bilty";
}
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 = "", CompDesc = ""; 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 = ""; string RegNo = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
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");
GRPrepDAL obj = new GRPrepDAL();
Int64 ChallanNo = 0; ChallanNo = obj.CheckChallanDetails(intGRIdno);
Int64 InvoiceNo = 0; InvoiceNo = obj.CheckInvoiceDetails(intGRIdno);
Int64 ChlnNo = 0; ChlnNo = obj.CheckChallanDetailsForPayment(intGRIdno);
obj = null;
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.Delete == false)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
if (base.Edit == false)
{
lnkbtnEdit.Visible = false;
}
else
{
lnkbtnEdit.Visible = true;
}
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;
}
if (ChlnNo > 0)
{
lnkbtnPay.Visible = true;
}
else
{
lnkbtnPay.Visible = false;
}
dGrossAmnt = dGrossAmnt + Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Gross_Amnt"));
dNetAmnt = dNetAmnt + Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Net_Amnt"));
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblGrossAmnt = (Label)e.Row.FindControl("lblGrossAmnt");
lblGrossAmnt.Text = dGrossAmnt.ToString("N2");
Label lblAmount = (Label)e.Row.FindControl("lblAmount");
lblAmount.Text = dNetAmnt.ToString("N2");
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("GrPrep.aspx?Gr=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
GRPrepDAL obj = new GRPrepDAL();
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);
}
}
}
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();
GRPrepDAL obj = new GRPrepDAL();
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 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.SelectGR(GrNo, dtfrom, dtto, cityfrom, citydel, citto, senderr, yearidno, UserIdno, strPrefixNum);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
}
}
}
private void BindGrid()
{
GRPrepDAL obj = new GRPrepDAL();
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 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 = obj.SelectGR(GrNo, dtfrom, dtto, cityfrom, citydel, citto, sender, yearidno, UserIdno, strPrefixNum);
obj = 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], "PrefixGr_No")) + Convert.ToString(DataBinder.Eval(lstGridData[i], "Gr_No"));
dr["GrDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "GR_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_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt"));
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
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_Amnt"));
}
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;
}
}
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();
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
#region Validation Messages for Challan Details
if (ddlTranspoter.SelectedIndex == 0)
{
this.ShowMessage("Please select Transporter."); ddlTranspoter.Focus(); return;
}
if (ddlTruckNo.SelectedIndex == 0)
{
this.ShowMessage("Please select Truck No."); ddlTruckNo.Focus(); return;
}
if (txtchlnRef.Text == "")
{
this.ShowMessage("Please Enter Challan Ref.No ."); ddlTruckNo.Focus(); return;
}
string msg = "";
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null)
{
if (dtTemp.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
#endregion
#region Declare Input Variables for Challan Details
//string strMsg = string.Empty;
//Int64 intGrPrepIdno = 0;
//Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddldateRange.SelectedValue);
//DateTime strChallanDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim().ToString()));
//Int64 intChallanNo = string.IsNullOrEmpty(txtchallanNo.Text.Trim()) ? 0 : Convert.ToInt64(txtchallanNo.Text.Trim());
//Int32 intTranspoter = string.IsNullOrEmpty(ddlTranspoter.SelectedValue) ? 0 : Convert.ToInt32(ddlTranspoter.SelectedValue);
//Int32 TruckNoIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue);
//Int32 strChlnRefno = string.IsNullOrEmpty(txtchlnRef.Text) ? 0 : Convert.ToInt32(txtchlnRef.Text);
//DateTime? dtInstDate;
//if (txtInstDate.Text == "")
//{
// dtInstDate = null;
//}
//else
//{
// dtInstDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
//}
#endregion
#region Insert/Update with Transaction
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
string intGrPrepIdno = "";
string ChlnNo = txtchallanNo.Text;
Int32 TrunckIdno = Convert.ToInt32(ddlTruckNo.SelectedValue);
Int32 YearIdno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
GRPrepDAL objDAL = new GRPrepDAL();
isTBBRate = objDAL.SelectTBBRate();
tblUserPref userpref = objDAL.selectuserpref();
itruckcitywise = Convert.ToInt32(userpref.Work_Type);
DataTable dtDetail = (DataTable)ViewState["dt"];
try
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
tblChlnBookHead objtblChlnBookHead = new tblChlnBookHead();
objtblChlnBookHead.Chln_No = txtchallanNo.Text;
objtblChlnBookHead.Chln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.BaseCity_Idno = Convert.ToInt32((DdlfromcityHead.SelectedIndex <= 0) ? "0" : DdlfromcityHead.SelectedValue);
objtblChlnBookHead.DelvryPlc_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue);
objtblChlnBookHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
objtblChlnBookHead.Driver_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Delvry_Instrc = "";
objtblChlnBookHead.Inv_Idno = 0;
objtblChlnBookHead.Gross_Amnt = Convert.ToDouble(txtgrossAmnt.Text);
objtblChlnBookHead.Commsn_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.Transprtr_Idno = Convert.ToInt32(ddlTranspoter.SelectedValue);
objtblChlnBookHead.Chln_type = 2;
objtblChlnBookHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objtblChlnBookHead.Other_Amnt = Convert.ToDouble(txtKattAmnt.Text);
objtblChlnBookHead.Work_type = Convert.ToInt32(hidWorkType.Value);
objtblChlnBookHead.Ref_No = Convert.ToString(txtchlnRef.Text);
objtblChlnBookHead.Adv_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.RcptType_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Bank_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Inst_No = Convert.ToInt32(0);
objtblChlnBookHead.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.Date_Added = Convert.ToDateTime(DateTime.Now);
Int64 value = 0;
if (string.IsNullOrEmpty(hidid.Value) == true)
{
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Insert(objtblChlnBookHead, dtTemp, intGrPrepIdno);
// obj = null;
}
else
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
Int32 ChlnIdno = Convert.ToInt32(hidid.Value);
TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == ChlnIdno).FirstOrDefault();
List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList();
foreach (TblGrDetl rgd in GrDetl)
{
db.TblGrDetls.DeleteObject(rgd);
db.SaveChanges();
}
db.TblGrHeads.DeleteObject(GrHEad);
db.SaveChanges();
db.Connection.Close();
}
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Update(objtblChlnBookHead, Convert.ToInt32(hidid.Value), dtTemp, intGrPrepIdno);
}
if (value > 0)
{
tScope.Complete();
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not Update");
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record saved Successfully ");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
tScope.Dispose();
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not saved Successfully ");
}
}
catch (Exception Ex)
{
tScope.Dispose();
}
#endregion
}
}
