private void Populate(Int32 slipidno)
{
LorryHireDAL obj1 = new LorryHireDAL();
tblLorryHireSlip obj = obj1.SelectById(slipidno);
if (obj != null)
{
hidlorryhireidno.Value = Convert.ToString(obj.LryHire_Idno);
ddlDateRange.SelectedValue = Convert.ToString(obj.Year_Idno);
ddlDateRange_SelectedIndexChanged(null, null);
ddlDateRange.Enabled = false;
txtslipdate.Text = Convert.ToDateTime(obj.Lry_Date).ToString("dd-MM-yyyy");
txtslipno.Text = Convert.ToString(obj.Lry_SlipNo);
ddlFromCity.SelectedValue = Convert.ToString(obj.Loc_Idno);
ddllorryno.SelectedValue = Convert.ToString(obj.Lry_Idno);
ddllorryno_SelectedIndexChanged(null, null);
txtsupliedby.Text = Convert.ToString(obj.SupliedTo);
txtfreight.Text = Convert.ToDouble(obj.TotalFrghtAmnt).ToString("N2");
txtadvance.Text = Convert.ToDouble(obj.AdvanceAmnt).ToString("N2");
txtnetamnt.Text = Convert.ToDouble(obj.Net_amnt).ToString("N2");
txtremark.Text = Convert.ToString(obj.Remark);
txtothercharges.Text = Convert.ToDouble(obj.OtherCharges).ToString("N2");
txtUnloading.Text = Convert.ToDouble(obj.Unloading).ToString("N2");
txtDetectionCharges.Text = Convert.ToDouble(obj.DetectionCharges).ToString("N2");
txtDiesel.Text = Convert.ToDouble(obj.Diesel).ToString("N2");
txtTds.Text = Convert.ToDouble(obj.TDS).ToString("N2");
}
DtTemp = obj1.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), slipidno);
obj1 = null;
ViewState["dt"] = DtTemp;
this.BindGrid();
}
protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
try
{
LorryHireDAL obj = new LorryHireDAL();
Int64 LorryIdno = Convert.ToInt64(ddllorryno.SelectedValue);
Int32 ifromCityIdno = Convert.ToInt32(ddlFromCity.SelectedValue);
DataTable DsGrdetail;
DsGrdetail = obj.SelectGRDetailTruckNo("SelectGRDetailTruckNo", Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(txtDateFrom.Text.Trim()), Convert.ToString(txtDateTo.Text), ifromCityIdno, LorryIdno, ApplicationFunction.ConnectionString());
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
grdGrdetals.DataSource = DsGrdetail;
grdGrdetals.DataBind();
lnkbtnSubmit.Visible = true; lnkbtnCloase.Visible = true;
}
else
{
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
lnkbtnSubmit.Visible = false; lnkbtnCloase.Visible = false;
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
lnkbtnSearch.Focus();
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
protected void ddllorryno_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if ((ddllorryno.SelectedIndex > 0))
{
LorryHireDAL obj = new LorryHireDAL();
obj.selectOwnerName(Convert.ToInt32(ddllorryno.SelectedValue));
var lst = obj.selectOwnerName(Convert.ToInt32(ddllorryno.SelectedValue));
if (lst != null)
{
txtsupliedby.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
{
txtsupliedby.Text = "";
}
}
catch (Exception Ex)
{
}
ddllorryno.Focus();
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("LorryHireSlip.aspx?Lh=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
LorryHireDAL obj = new LorryHireDAL();
Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument));
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
ddlDateRange.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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.ADD == false)
{
lnkbtnSave.Visible = false;
}
this.BindDateRange();
txtfreight.Attributes.Add("onChange", "SetNumFormt('" + txtfreight.ClientID + "')");
txtadvance.Attributes.Add("onChange", "SetNumFormt('" + txtadvance.ClientID + "')");
txtnetamnt.Attributes.Add("onChange", "SetNumFormt('" + txtnetamnt.ClientID + "')");
txtothercharges.Attributes.Add("onChange", "SetNumFormt('" + txtothercharges.ClientID + "')");
this.BindLorry();
txtslipdate.Text = DateTime.Now.ToString("dd-MM-yyyy");
SetDate();
if (Request.QueryString["Lh"] != null)
{
Populate(Convert.ToInt32(Request.QueryString["Lh"]));
PrintLorryHire(Convert.ToInt32(Request.QueryString["Lh"]));
lnkBtnNew.Visible = true;
lnkbtnPrint.Visible = true;
}
else
{
lnkBtnNew.Visible = false;
lnkbtnPrint.Visible = false;
}
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
LorryHireDAL obj = new LorryHireDAL();
var lst = obj.SelectCityCombo();
obj = null;
ddlFromCity.DataSource = lst;
ddlFromCity.DataTextField = "City_Name";
ddlFromCity.DataValueField = "City_Idno";
ddlFromCity.DataBind();
ddlFromCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
//this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
}
ddlDateRange.Focus();
}
public void Countalllorryslip()
{
LorryHireDAL obj = new LorryHireDAL();
Int64 count = obj.countallslip();
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
}
private void BindLorry()
{
LorryHireDAL obj = new LorryHireDAL();
var lst = obj.BindTruckNo();
obj = null;
if (lst.Count > 0)
{
ddllorryno.DataSource = lst;
ddllorryno.DataTextField = "Lorry_No";
ddllorryno.DataValueField = "Lorry_Idno";
ddllorryno.DataBind();
}
ddllorryno.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.Print == false)
{
imgBtnExcel.Visible = false;
}
this.BindDateRange();
this.BindLorry();
ddlDateRange_SelectedIndexChanged(null, null);
txtdatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtdateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
LorryHireDAL obj = new LorryHireDAL();
var lst = obj.SelectCityCombo();
obj = null;
ddlFromCity.DataSource = lst;
ddlFromCity.DataTextField = "City_Name";
ddlFromCity.DataValueField = "City_Idno";
ddlFromCity.DataBind();
ddlFromCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
//this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
Countalllorryslip();
ddlDateRange.Focus();
}
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
try
{
BindDropdownDAL objbind1 = new BindDropdownDAL();
if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0))
{
string strchkValue = string.Empty; string sAllItemIdnos = string.Empty;
string strchkDetlValue = string.Empty;
for (int count = 0; count < grdGrdetals.Rows.Count; count++)
{
CheckBox ChkGr = (CheckBox)grdGrdetals.Rows[count].FindControl("chkId");
if ((ChkGr != null) && (ChkGr.Checked == true))
{
HiddenField hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno");
strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ",";
}
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
if (strchkDetlValue == "")
{
ShowMessageErr("Please select atleast one Gr.");
ShowDiv("ShowClient('dvGrdetails')");
}
else
{
LorryHireDAL ObjChlnBookingDAL = new LorryHireDAL();
string strSbillNo = String.Empty;
DataTable dtRcptDetl = new DataTable();
DataTable dtKMDetl = new DataTable();
dtRcptDetl = ObjChlnBookingDAL.SelectGrChallanDetails(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(strchkDetlValue));
ViewState["dt"] = dtRcptDetl;
BindGrid();
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
if (grdMain.Rows.Count > 0)
{
foreach (GridViewRow Dr in grdMain.Rows)
{
Label lblSubTotAmnt = (Label)Dr.FindControl("lblSubTotAmnt");
dGrAmnt += Convert.ToDouble(lblSubTotAmnt.Text);
}
}
txtfreight.Text = Convert.ToString(dGrAmnt);
netamntcal();
}
}
else
{
ShowMessageErr("Gr Details not found.");
grdMain.DataSource = null;
grdMain.DataBind();
// ddlDelvryPlace.Enabled = true;
ShowDiv("ShowBillAgainst('dvGrdetails')");
}
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp != null)
{
if (DtTemp.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
string strMsg = string.Empty;
LorryHireDAL objlorry = new LorryHireDAL();
Int64 intSlip = 0;
DateTime? slipDate = null;
slipDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtslipdate.Text));
DateTime DateAdded = System.DateTime.Now;
Int64 yearId = Convert.ToInt32(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue));
if (txtfreight.Text == string.Empty || Convert.ToDouble(txtfreight.Text) <= 0)
{
this.ShowMessage("Freight Amount must be greater than 0!"); txtfreight.Focus(); txtfreight.SelectText();
return;
}
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == true)
{
intSlip = objlorry.Insert(string.IsNullOrEmpty(txtslipno.Text) ? 0 : Convert.ToInt64(txtslipno.Text), slipDate, string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue), string.IsNullOrEmpty(ddllorryno.SelectedValue) ? 0 : Convert.ToInt64(ddllorryno.SelectedValue), txtsupliedby.Text.Trim(), yearId, Convert.ToDouble(txtfreight.Text), Convert.ToDouble(txtadvance.Text), Convert.ToDouble(txtnetamnt.Text), DateAdded, txtremark.Text.Trim(), Convert.ToDouble(txtothercharges.Text), Convert.ToDouble(txtUnloading.Text), Convert.ToDouble(txtDetectionCharges.Text), Convert.ToDouble(txtDiesel.Text), Convert.ToDouble(txtTds.Text), DtTemp);
}
else
{
intSlip = objlorry.Update(Convert.ToInt32(hidlorryhireidno.Value), string.IsNullOrEmpty(txtslipno.Text) ? 0 : Convert.ToInt64(txtslipno.Text), slipDate, string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue), string.IsNullOrEmpty(ddllorryno.SelectedValue) ? 0 : Convert.ToInt64(ddllorryno.SelectedValue), txtsupliedby.Text.Trim(), yearId, Convert.ToDouble(txtfreight.Text), Convert.ToDouble(txtadvance.Text), Convert.ToDouble(txtnetamnt.Text), DateAdded, txtremark.Text.Trim(), Convert.ToDouble(txtothercharges.Text), Convert.ToDouble(txtUnloading.Text), Convert.ToDouble(txtDetectionCharges.Text), Convert.ToDouble(txtDiesel.Text), Convert.ToDouble(txtTds.Text), DtTemp);
}
objlorry = null;
if (intSlip > 0)
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == false)
{
Tran.Complete();
strMsg = "Record updated successfully.";
grdMain.DataSource = null;
grdMain.DataBind();
}
else
{
Tran.Complete();
strMsg = "Record saved successfully.";
}
ClearControls();
}
else
{
if (string.IsNullOrEmpty(hidlorryhireidno.Value) == false)
{
Tran.Dispose();
strMsg = "Record not updated.";
}
else
{
Tran.Dispose();
strMsg = "Record not saved.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
//private void BindCity()
//{
// LorryHireDAL obj = new LorryHireDAL();
// var lst = obj.SelectCity();
// obj = null;
// ddlToCity.DataSource = lst;
// ddlToCity.DataTextField = "City_Name";
// ddlToCity.DataValueField = "City_Idno";
// ddlToCity.DataBind();
// ddlToCity.Items.Insert(0, new ListItem("--Select--", "0"));
//}
private void HireSlipNo(Int32 YearIdno, Int32 FromCityIdno)
{
LorryHireDAL obj = new LorryHireDAL();
txtslipno.Text = Convert.ToString(obj.MaxLorrySlipNo(YearIdno, FromCityIdno));
}
private void BindGrid()
{
LorryHireDAL obj = new LorryHireDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
int slipno = string.IsNullOrEmpty(Convert.ToString(txtslipno.Text)) ? 0 : Convert.ToInt32(txtslipno.Text);
Int32 lorryidno = string.IsNullOrEmpty(ddllorryno.SelectedValue) ? 0 : Convert.ToInt32(ddllorryno.SelectedValue);
if (string.IsNullOrEmpty(Convert.ToString(txtdatefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtdatefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtdatefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtdateto.Text));
}
int cityfrom = Convert.ToInt32(ddlFromCity.SelectedValue);
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
var lstGridData = obj.SearchLorryHire(lorryidno, yearidno, cityfrom, slipno, dtfrom, dtto);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("Slip No", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("Location", typeof(string));
dt.Columns.Add("Lorry No", typeof(string));
dt.Columns.Add("Supplied To", typeof(string));
dt.Columns.Add("Frieght Amount", typeof(string));
dt.Columns.Add("Advance Amount", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
double TNet = 0, advance = 0, freight = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Slip No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lry_SlipNo"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Lry_Date")).ToString("dd-MM-yyyy");
dr["Location"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Lorry No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Supplied To"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "SupliedTo"));
dr["Frieght Amount"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotalFrghtAmnt"));
dr["Advance Amount"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "AdvanceAmnt"));
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_amnt")).ToString("N2");
dt.Rows.Add(dr);
freight += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "TotalFrghtAmnt"));
advance += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "AdvanceAmnt"));
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Supplied To"] = "Total";
drr["Advance Amount"] = (advance).ToString("N2");
drr["Frieght Amount"] = (freight).ToString("N2");
drr["Net Amount"] = (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;
//grdprint.DataSource = lstGridData;
//grdprint.DataBind();
Double TotalNetAmount = 0; Double TotalFreightAmnt = 0; Double TotalAdvanceAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalFreightAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "TotalFrghtAmnt"));
TotalAdvanceAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "AdvanceAmnt"));
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblFreightAmount.Text = TotalFreightAmnt.ToString("N2");
lblAdvanceAmount.Text = TotalAdvanceAmnt.ToString("N2");
lblNetAmount.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;
//grdprint.DataSource = null;
//grdprint.DataBind();
}
}
