protected void ddlTruckNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if ((ddlTruckNo.SelectedIndex >= 0))
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
obj.selectOwnerName(Convert.ToInt32(ddlTruckNo.SelectedValue));
var lst = obj.selectOwnerName(Convert.ToInt32(ddlTruckNo.SelectedValue));
if (lst != null)
{
txtOwnrNme.Text = Convert.ToString(lst.Owner_Name + '-' + ((lst.Pan_No == null) ? "" : lst.Pan_No) + "-" + ((lst.Lorry_Type == 0) ? "O" : "H"));
hidOwnerId.Value = Convert.ToString(lst.Prty_Idno);
}
}
else
{
txtOwnrNme.Text = "";
}
ddlTruckNo.Focus();
}
catch (Exception Ex)
{
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
double dblChallanAmnt = 0;
if (e.Row.RowType == DataControlRowType.DataRow)
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
Int64 ChlnIdno = Convert.ToInt64(DataBinder.Eval(e.Row.DataItem, "Chln_Idno"));
if ((obj.CheckBilled(ChlnIdno, ApplicationFunction.ConnectionString())) > 0)
{
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
lnkbtnDelete.Visible = false;
e.Row.ForeColor = System.Drawing.Color.Maroon;
}
obj = null;
dblChallanAmnt = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Net_Amnt"));
dblTChallanAmnt = dblChallanAmnt + dblTChallanAmnt;
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblTChallanAmnt = (Label)e.Row.FindControl("lblNetAmnt");
lblTChallanAmnt.Text = dblTChallanAmnt.ToString("N2");
}
}
catch (Exception ex)
{
throw;
}
}
private void BindMaxNo(Int32 FromCityIdno, Int32 YearId)
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
Int64 MaxNo = obj.MaxNo(YearId, FromCityIdno, ApplicationFunction.ConnectionString());
txtchallanNo.Text = Convert.ToString(MaxNo);
}
public void Countall()
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
Int64 count = obj.CountALL();
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
protected void DdlfromcityHead_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ChlnBookingCrsngDAL objGR = new ChlnBookingCrsngDAL();
Int64 MaxCRNo = 0;
MaxCRNo = objGR.MaxNo(Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(Convert.ToString(DdlfromcityHead.SelectedValue) == "" ? 0 : Convert.ToInt32(DdlfromcityHead.SelectedValue)), ApplicationFunction.ConnectionString());
txtchallanNo.Text = Convert.ToString(MaxCRNo);
DdlfromcityHead.Focus(); txtchallanNo.SelectText();
return;
}
catch (Exception Ex)
{
}
}
private void Populate(Int64 HeadId)
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
tblChlnBookHead chlnBookhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(chlnBookhead.Year_Idno);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtchallanNo.Text = chlnBookhead.Chln_No;
txtDate.Text = Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy");
ddlTranspoter.SelectedValue = Convert.ToString(chlnBookhead.Transprtr_Idno);
txtchlnRef.Text = Convert.ToString(chlnBookhead.Ref_No);
ddlTruckNo.SelectedValue = Convert.ToString(chlnBookhead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
txtgrossAmnt.Text = Convert.ToDouble(chlnBookhead.Gross_Amnt).ToString("N2");
txtKattAmnt.Text = Convert.ToDouble(chlnBookhead.Other_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(chlnBookhead.Net_Amnt).ToString("N2");
hidWorkType.Value = Convert.ToString(chlnBookhead.Work_type);
DdlfromcityHead.SelectedValue = Convert.ToString(chlnBookhead.BaseCity_Idno);
dtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId);
ViewState["dt"] = dtTemp;
this.BindGridT();
// imgSearch.Enabled = false;
Int64 value = 0;
value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString());
if (value > 0)
{
lnkbtnSave.Enabled = false;
}
else
{
lnkbtnSave.Enabled = true;
}
obj = null;
}
private void BindGrid()
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
String challanNo = txtReceiptNo.Text;
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text));
}
// int delvPlace = Convert.ToInt32(ddlDelvPlacce.SelectedValue);
int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex <= 0) ? "0" : drpCityFrom.SelectedValue);
int TruckId = Convert.ToInt32((ddltruckNo.SelectedIndex <= 0) ? "0" : ddltruckNo.SelectedValue);
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("ChlnDate", typeof(string));
dt.Columns.Add("ChlnNo", typeof(string));
dt.Columns.Add("LorryNo", typeof(string));
dt.Columns.Add("FromCity", typeof(string));
dt.Columns.Add("NetAmnt", typeof(string));
double TNet = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = Convert.ToString(i + 1);
dr["ChlnDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Chln_Date")).ToString("dd-MM-yyyy");
dr["ChlnNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Chln_No"));
dr["LorryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity"));
dr["NetAmnt"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["ChlnDate"] = "";
drr["ChlnNo"] = "";
drr["LorryNo"] = "";
drr["FromCity"] = "Total";
drr["NetAmnt"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
Double TotalNetAmount = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblNetTotalAmount.Text = TotalNetAmount.ToString("N2");
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;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
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
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.ADD == false)
{
lnkbtnSave.Visible = false;
}
if (base.View == false)
{
lblViewList.Visible = false;
}
if (!Page.IsPostBack)
{
this.ValidateControls();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
//if (Convert.ToString(Session["Userclass"]) == "Admin")
//{
// BindDropdownDAL obja = new BindDropdownDAL();
// var senderLst = obja.BindSender();
// ddlSenderName.DataSource = senderLst;
// ddlSenderName.DataTextField = "Acnt_Name";
// ddlSenderName.DataValueField = "Acnt_Idno";
// ddlSenderName.DataBind();
// ddlSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
//}
//else
//{
// this.BindDropdown();
//}
this.BindDateRange();
this.BindDropdown();
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlSenderName.SelectedValue = Convert.ToString(base.Sender);
DdlfromcityHead.SelectedValue = Convert.ToString(base.UserFromCity);
this.BindMaxNo(Convert.ToInt32((DdlfromcityHead.SelectedValue) == "" ? 0 : Convert.ToInt32(DdlfromcityHead.SelectedValue)), Convert.ToInt32(ddldateRange.SelectedValue));
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
ChlnBookingCrsngDAL objChlnBookingDAL = new ChlnBookingCrsngDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
if (obj != null)
{
hidWorkType.Value = Convert.ToString(obj.Work_Type);
}
if (Request.QueryString["q"] != null)
{
Populate(Convert.ToInt64(Request.QueryString["q"]));
hidid.Value = Convert.ToString(Request.QueryString["q"]);
lnkbtnMnNew.Visible = true;
}
else
{
lnkbtnMnNew.Visible = false;
}
txtKattAmnt.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);");
this.ddldateRange_SelectedIndexChanged(null, null);
}
}
