protected void lnkbtnSearchClick_OnClick(object sender, EventArgs e)
{
try
{
chkSelectAllRows.Checked = false;
SummaryRegisterDAL obj = new SummaryRegisterDAL();
Int64 Tocity = Convert.ToInt64((ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue));
DataTable DsGrdetail = obj.SelectChlnDetail("SelectChlnDetail", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFromDiv.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateToDiv.Text)), Tocity, ApplicationFunction.ConnectionString());
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
grdGrdetals.DataSource = DsGrdetail;
grdGrdetals.DataBind(); //BtnClerForPurOdr.Visible = true;
// btnSubmit.Visible = true; chkSelectAllRows.Visible = true;
}
else
{
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();// BtnClerForPurOdr.Visible = false;
// btnSubmit.Visible = false; chkSelectAllRows.Visible = false;
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
private void BindDropdown()
{
SummaryRegisterDAL objsummary = new SummaryRegisterDAL();
BindDropdownDAL obj = new BindDropdownDAL();
var TruckNolst = obj.BindTruckNo();
// var ToCity = obj.BindToCity();
obj = null;
var driver = objsummary.selectHireDriverName();
objsummary = null;
if (driver != null && driver.Count > 0)
{
ddlDriver.DataSource = driver;
ddlDriver.DataTextField = "Driver_name";
ddlDriver.DataValueField = "Driver_Idno";
ddlDriver.DataBind();
ddlDriver.Items.Insert(0, new ListItem("--Select--", "0"));
}
drptruckno.DataSource = TruckNolst;
drptruckno.DataTextField = "Lorry_No";
drptruckno.DataValueField = "lorry_idno";
drptruckno.DataBind();
drptruckno.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("SummaryRegister.aspx?SummaryIdno=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
SummaryRegisterDAL obj = new SummaryRegisterDAL();
Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument));
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtsummryno.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;
}
if (base.View == false)
{
lblViewList.Visible = false;
}
txtGRDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateFromDiv.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateToDiv.Attributes.Add("onkeypress", "return notAllowAnything(event);");
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCityTo();
}
else
{
this.BindCityTo(Convert.ToInt64(Session["UserIdno"]));
}
BindDropdown();
ddlFromCity.SelectedValue = Convert.ToString(base.UserFromCity);
this.BindDateRange();
ddldateRange.SelectedIndex = 0; ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlFromCity_SelectedIndexChanged(null, null);
ddlDateRange_SelectedIndexChanged(null, null);
SummaryRegisterDAL obj = new SummaryRegisterDAL(); Int64 MaxGRNo = 0; Int32 FromCityIdno = 0; FromCityIdno = Convert.ToInt32(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue));
MaxGRNo = obj.MaxNo(Convert.ToInt32(ddldateRange.SelectedValue), FromCityIdno, ApplicationFunction.ConnectionString());
txtRcptNo.Text = Convert.ToString(MaxGRNo);
txtCrossing.Text = txtWAy.Text = txtfreightCharg.Text = txtotherCharg.Text = txttotal1.Text = "0.00";
txtKatt.Text = txtlabour.Text = txtDelivery.Text = txtOctrai.Text = txttotal2.Text = txtNetTotal.Text = "0.00";
if (Request.QueryString["SummaryIdno"] != null)
{
this.Populate(Convert.ToInt32(Request.QueryString["SummaryIdno"]));
lnkbtnNew.Visible = true; ddlFromCity.Enabled = false; lnkbtnPrintClick.Visible = true;
}
else
{
lnkbtnNew.Visible = false; ddlFromCity.Enabled = true; lnkbtnPrintClick.Visible = false;
}
// txtItemName.Focus();
}
}
private void BindGrid()
{
try
{
SummaryRegisterDAL obj = new SummaryRegisterDAL();
string userclass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (userclass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
Int64 iFromCityIDNO = (Convert.ToString(drpBaseCity.SelectedValue) == "" ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
DataTable DsGrdetail = null;
if (iFromCityIDNO == 0)
{
DsGrdetail = obj.SelectRep("Selectreport", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), UserIdno, ApplicationFunction.ConnectionString());
}
else
{
DsGrdetail = obj.SelectreportwithCity("SelectreportwithCity", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iFromCityIDNO, UserIdno, ApplicationFunction.ConnectionString());
}
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
ViewState["dtCSV"] = DsGrdetail;
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
imgBtnExcel.Visible = true;
//printRep.Visible = true;
}
else
{
ViewState["dtCSV"] = null;
grdMain.DataSource = null;
grdMain.DataBind();
// printRep.Visible = false;
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
string strMsg = string.Empty;
SummaryRegisterDAL objItemMast = new SummaryRegisterDAL();
Int64 intItemIdno = 0;
tblSummaryRegister obj = new tblSummaryRegister();
obj.Year_Idno = Convert.ToInt32(ddldateRange.SelectedValue);
obj.SumReg_No = Convert.ToInt64(Convert.ToString(txtRcptNo.Text.Trim()) == "" ? 0 : Convert.ToInt64(txtRcptNo.Text.Trim()));
obj.SumReg_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGRDate.Text.Trim().ToString()));
obj.Date_Added = DateTime.Now;
obj.Date_Modified = null;
obj.FromCity_Idno = Convert.ToInt64(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue));
obj.Chln_Idno = Convert.ToInt64(Convert.ToString(hidchlnIdno.Value) == "" ? 0 : Convert.ToInt64(hidchlnIdno.Value));
obj.Chln_no = Convert.ToInt64(Convert.ToString(txtchlnNo.Text.Trim()) == "" ? 0 : Convert.ToInt64(txtchlnNo.Text.Trim()));
obj.Truck_Idno = Convert.ToInt64(Convert.ToString(ddltruckno.SelectedValue) == "" ? 0 : Convert.ToInt64(ddltruckno.SelectedValue));
obj.Driver_idno = Convert.ToInt64(Convert.ToString(ddldriver.SelectedValue) == "" ? 0 : Convert.ToInt64(ddldriver.SelectedValue));
obj.Crossing_Amnt = string.IsNullOrEmpty((Convert.ToString(txtCrossing.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtCrossing.Text)).Replace(",", ""));
obj.Way_Amnt = string.IsNullOrEmpty((Convert.ToString(txtWAy.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtWAy.Text)).Replace(",", ""));
obj.Other_Charges = string.IsNullOrEmpty((Convert.ToString(txtotherCharg.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtotherCharg.Text)).Replace(",", ""));
obj.Freight_Amnt = string.IsNullOrEmpty((Convert.ToString(txtfreightCharg.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtfreightCharg.Text)).Replace(",", ""));
obj.Total_Amnt1 = string.IsNullOrEmpty((Convert.ToString(txttotal1.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txttotal1.Text)).Replace(",", ""));
obj.Katt_Amnt = string.IsNullOrEmpty((Convert.ToString(txtKatt.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtKatt.Text)).Replace(",", ""));
obj.Labour_Amnt = string.IsNullOrEmpty((Convert.ToString(txtlabour.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtlabour.Text)).Replace(",", ""));
obj.Delivery_Amnt = string.IsNullOrEmpty((Convert.ToString(txtDelivery.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtDelivery.Text)).Replace(",", ""));
obj.Octrai_Amnt = string.IsNullOrEmpty((Convert.ToString(txtOctrai.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtOctrai.Text)).Replace(",", ""));
obj.Total_Amnt2 = string.IsNullOrEmpty((Convert.ToString(txttotal2.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txttotal2.Text)).Replace(",", ""));
obj.Net_Amnt = string.IsNullOrEmpty((Convert.ToString(txtNetTotal.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtNetTotal.Text)).Replace(",", ""));
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == true)
{
intItemIdno = objItemMast.Insert(obj);
}
else
{
lnkbtnNew.Visible = false; lnkbtnPrintClick.Visible = false;
intItemIdno = objItemMast.Update(obj, Convert.ToInt32(Convert.ToString(hidSummryRegidno.Value) == "" ? 0 : Convert.ToInt32(hidSummryRegidno.Value)));
}
objItemMast = null;
if (intItemIdno > 0)
{
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == false)
{
strMsg = "Record updated successfully.";
}
else
{
strMsg = "Record saved successfully.";
}
this.ClearControls();
}
else if (intItemIdno < 0)
{
strMsg = "Record already exists.";
}
else
{
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == false)
{
strMsg = "Record not updated.";
}
else
{
strMsg = "Record not saved.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
// txtItemName.Focus();
}
protected void lnkbtnDivSubmit_OnClick(object sender, EventArgs e)
{
try
{
if ((grdGrdetals != null) && (grdGrdetals.Rows.Count > 0))
{
string strchkValue = string.Empty; string sAllItemIdnos = string.Empty;
string strchkDetlValue = string.Empty; int Icount = 0;
for (int count = 0; count < grdGrdetals.Rows.Count; count++)
{
CheckBox ChkGr = (CheckBox)grdGrdetals.Rows[count].FindControl("chkId");
if ((ChkGr != null) && (ChkGr.Checked == true))
{
//HiddenField hidChlnIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidChlnIdno");
//chlnIdno = Convert.ToInt64(hidChlnIdno.Value);
HiddenField hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno");
strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ",";
RcptGoodHeadIdno = Convert.ToInt64(hidGrIdno.Value); HidGrAgnstRcptIdno.Value = (hidGrIdno.Value);
Icount++;
}
}
if (Icount > 1)
{
//ShowMessage("Please check only one Gr.");
lblmsg.Visible = true;
lblmsg2.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
// ShowDiv("ShowClient('dvGrdetails')");
return;
}
else
{
lblmsg.Visible = false;
lblmsg2.Visible = false;
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
if (strchkDetlValue == "")
{
lblmsg.Visible = true;
lblmsg2.Visible = true;
lblmsg.Text = "Please select atleast one record.";
lblmsg2.Text = "Please select atleast one record.";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
//ShowMessage("Please check atleast one Gr.");
// ShowDiv("ShowClient('dvGrdetails')");
return;
}
else
{
lblmsg.Visible = false;
lblmsg2.Visible = false;
SummaryRegisterDAL obj = new SummaryRegisterDAL();
string strSbillNo = String.Empty;
DataTable dtRcptDetl = new DataTable(); DataRow Dr;
dtRcptDetl = obj.selectDetails("SelectChlnDetailInRcpt", Convert.ToString(strchkDetlValue), ApplicationFunction.ConnectionString());
ViewState["dt"] = dtRcptDetl;
hidchlnIdno.Value = Convert.ToString(dtRcptDetl.Rows[0]["Chln_idno"]);
ddlFromCity.SelectedValue = Convert.ToString(dtRcptDetl.Rows[0]["ToCity_Idno"]); ddlFromCity.Enabled = false;
txtchlnNo.Text = Convert.ToString(dtRcptDetl.Rows[0]["Chln_No"]); txtchlnNo.Enabled = false;
txtCrossing.Text = Convert.ToString(dtRcptDetl.Rows[0]["CrsngGR_Amnt"]); txtCrossing.Enabled = false;
txtfreightCharg.Text = Convert.ToString(dtRcptDetl.Rows[0]["FreightAmnt"]); txtfreightCharg.Enabled = false;
ddltruckno.SelectedValue = Convert.ToString(dtRcptDetl.Rows[0]["Truck_Idno"]); // ddltruckno.Enabled = false;
ddldriver.SelectedValue = Convert.ToString(dtRcptDetl.Rows[0]["Driver_Idno"]); //ddldriver.Enabled = false;
totalAmntCal1();
NetAmntCal();
}
chkSelectAllRows.Checked = false;
}
else
{
//ShowMessageErr("Gr Details not found.");
//grdMain.DataSource = null;
//grdMain.DataBind();
chkSelectAllRows.Checked = false;
// ddlDelvryPlace.Enabled = true;
//ShowDiv("ShowBillAgainst('dvGrdetails')");
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
private void TotalRecords()
{
SummaryRegisterDAL obj = new SummaryRegisterDAL();
lblTotalRecord.Text = "T. Records: " + obj.TotalRecords().ToString();
}
private void BindGrid()
{
SummaryRegisterDAL obj = new SummaryRegisterDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int summryno = string.IsNullOrEmpty(Convert.ToString(txtsummryno.Text)) ? 0 : Convert.ToInt32(txtsummryno.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));
}
int citto = Convert.ToInt32(drpCityTo.SelectedValue == "" ? 0 : Convert.ToInt32(drpCityTo.SelectedValue));
int truckno = Convert.ToInt32(drptruckno.SelectedValue == "" ? 0 : Convert.ToInt32(drptruckno.SelectedValue));
int driver = Convert.ToInt32(ddlDriver.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDriver.SelectedValue));
int chlnno = Convert.ToInt32(txtCHlnno.Text.Trim() == "" ? 0 : Convert.ToInt32(txtCHlnno.Text.Trim()));
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.SelectSummary(summryno, citto, truckno, chlnno, driver, dtfrom, dtto, yearidno, UserIdno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("SummaryNo", typeof(string));
dt.Columns.Add("SummaryDate", typeof(string));
dt.Columns.Add("City To", typeof(string));
dt.Columns.Add("Challan No", typeof(string));
dt.Columns.Add("Truck No", typeof(string));
dt.Columns.Add("Driver", typeof(string));
dt.Columns.Add("NetAmount", typeof(string));
double TNet = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["SummaryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "SumReg_No"));
dr["SummaryDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "SumReg_Date")).ToString("dd-MM-yyyy");
dr["City To"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "CityTo"));
dr["Challan No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Chln_no"));
dr["Truck No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "driver"));
dr["NetAmount"] = 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["Driver"] = "Total";
drr["NetAmount"] = (TNet).ToString("N2");
dt.Rows.Add(drr);
}
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
//grdprint.DataSource = lstGridData;
//grdprint.DataBind();
imgBtnExcel.Visible = true;
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;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
//grdprint.DataSource = null;
//grdprint.DataBind();
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
