protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("DeliveryChallanDetails.aspx?dc=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument));
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtChlnNo.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);
}
}
private void BindDriver(Int32 var)
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
if (var == 0)
{
var lst = obj.selectOwnerDriverName();
obj = null;
if (lst != null && lst.Count > 0)
{
ddldriverName.DataSource = lst;
ddldriverName.DataTextField = "Acnt_Name";
ddldriverName.DataValueField = "Acnt_Idno";
ddldriverName.DataBind();
}
ddldriverName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
var lst = obj.selectHireDriverName();
obj = null;
if (lst != null && lst.Count > 0)
{
ddldriverName.DataSource = lst;
ddldriverName.DataTextField = "Driver_name";
ddldriverName.DataValueField = "Driver_Idno";
ddldriverName.DataBind();
}
ddldriverName.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
try
{
grdGrdetals.DataSource = null;
grdGrdetals.DataBind();
Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue);
DateTime DtFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text));
DateTime DtTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text));
Int64 DelvPlace = Convert.ToInt64(ddldelvplace.SelectedValue);
DeliveryChallanDetailsDAL Obj = new DeliveryChallanDetailsDAL();
var Lst = Obj.SearchGR(YearIdno, DtFrom, DtTo, DelvPlace);
if (Lst != null && Lst.Count > 0)
{
grdGrdetals.DataSource = Lst;
grdGrdetals.DataBind();
lnkbtnokClick.Visible = true;
}
else
{
lnkbtnokClick.Visible = false;
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
}
public void Countall()
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
Int64 count = obj.countall();
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
}
private void Populate(Int64 HeadId)
{
imgSearch.Enabled = false;
ddlDelvryPlace.Enabled = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
tblDelvChlnHead chlnhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(chlnhead.Year_Idno);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtchallanNo.Text = Convert.ToString(chlnhead.DelvChln_No);
txtDate.Text = Convert.ToDateTime(chlnhead.DelvChln_Date).ToString("dd-MM-yyyy");
ddlDelvryPlace.SelectedValue = Convert.ToString(chlnhead.DelvryPlc_Idno);
ddlTransportName.SelectedValue = Convert.ToString(chlnhead.Transprtr_Idno);
ddlTruckNo.SelectedValue = Convert.ToString(chlnhead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
ddldriverName.SelectedValue = Convert.ToString(chlnhead.Driver_Idno);
txtDelvInstruction.Text = Convert.ToString(chlnhead.Delvry_Instrc);
txtkatt.Text = Convert.ToDouble(chlnhead.Katt_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(chlnhead.Net_Amnt).ToString("N2");
txtOtherAmnt.Text = Convert.ToDouble(chlnhead.Other_Amnt).ToString("N2");
txtGrosstotal.Text = Convert.ToDouble(chlnhead.Gross_Amnt).ToString("N2");
//if (Convert.ToInt32(hidWorkType.Value) > 1)
//{
// ddlDelvryPlace.Visible = false;
// ddlTruckNo.Enabled = false;
//}
//else
//{
// ddlDelvryPlace.Visible = true;
// ddlTruckNo.Enabled = true;
// ddlDelvryPlace.Enabled = false;
//}
DtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId);
ViewState["dt"] = DtTemp;
this.BindGrid();
imgSearch.Enabled = false;
Int64 value = 0;
value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString());
if (value > 0)
{
lnkbtnSave.Enabled = false;
}
else
{
lnkbtnSave.Enabled = true;
}
PrintChallan(HeadId);
obj = null;
}
private void BindFromCity()
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
var lst = obj.SelectCityCombo();
obj = null;
if (lst.Count > 0)
{
drpCityDelivery.DataSource = lst;
drpCityDelivery.DataTextField = "City_Name";
drpCityDelivery.DataValueField = "City_Idno";
drpCityDelivery.DataBind();
drpCityDelivery.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
private void BindGrid()
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
DateTime?dtfrom = null;
DateTime?dtto = null;
Int32 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int ChallanNo = string.IsNullOrEmpty(Convert.ToString(txtChlnNo.Text)) ? 0 : Convert.ToInt32(txtChlnNo.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 cityfrom = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(drpCityDelivery.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"]);
}
DataTable lstGridData = obj.ReportDelvChallan(UserIdno, yearIDNO, dtfrom, dtto, cityfrom, ChallanNo, ApplicationFunction.ConnectionString());
obj = null;
if (lstGridData != null && lstGridData.Rows.Count > 0)
{
ViewState["CSVdt"] = lstGridData;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Rows.Count;
//grdprint.DataSource = lstGridData;
//grdprint.DataBind();
ImgCSV.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "Total Record (s): 0 ";
//grdprint.DataSource = null;
//grdprint.DataBind();
ImgCSV.Visible = false;
}
}
private void BindGrid()
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
DateTime?dtfrom = null;
DateTime?dtto = null;
Int32 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int ChallanNo = string.IsNullOrEmpty(Convert.ToString(txtChlnNo.Text)) ? 0 : Convert.ToInt32(txtChlnNo.Text);
Int32 DriverIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue);
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 cityfrom = Convert.ToInt32(drpCityDelivery.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.SearchDelvChallan(UserIdno, yearIDNO, dtfrom, dtto, cityfrom, ChallanNo, DriverIdno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("DelvChlnNo", typeof(string));
dt.Columns.Add("Date", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("Lorry", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("Groos Amount", typeof(string));
dt.Columns.Add("Katt Amount", typeof(string));
dt.Columns.Add("Other Amount", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
double TNet = 0, TKatt = 0, TGross = 0, TOther = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["DelvChlnNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DelvChln_No"));
dr["Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "DelvChln_Date")).ToString("dd-MM-yyyy");
dr["City"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Lorry"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["Groos Amount"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Gross_Amnt"));
dr["Katt Amount"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Katt_Amnt"));
dr["Other Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Other_Amnt")).ToString("N2");
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2");
dt.Rows.Add(dr);
TKatt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Katt_Amnt"));
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
TGross += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt"));
TOther += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Other_Amnt"));
if (i == lstGridData.Count - 1)
{
DataRow drr = dt.NewRow();
drr["Party"] = "Total";
dr["Groos Amount"] = (TGross).ToString("N2");
dr["Katt Amount"] = (TKatt).ToString("N2");
dr["Other Amount"] = (TOther).ToString("N2");
dr["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 TotalGrossAmnt = 0; Double TotalKatAmnt = 0; Double TotalOtherAmnt = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
TotalGrossAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt"));
TotalKatAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Katt_Amnt"));
TotalOtherAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Other_Amnt"));
TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt"));
}
lblNetTotalAmount.Text = TotalGrossAmnt.ToString("N2");
lblKatAmount.Text = TotalKatAmnt.ToString("N2");
lblNetAmount.Text = TotalNetAmount.ToString("N2");
lblOtherAmount.Text = TotalOtherAmnt.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;
prints.Visible = false;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
//grdprint.DataSource = null;
//grdprint.DataBind();
prints.Visible = false;
}
}
protected void lnkbtnokClick_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 hidGrIdno = (HiddenField)grdGrdetals.Rows[count].FindControl("hidGrIdno");
strchkDetlValue = strchkDetlValue + hidGrIdno.Value + ",";
Icount++;
}
}
if (Icount > 1)
{
////ShowMessage("Please check only one Gr.");
//lblmsg.Visible = true;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowClient('dvGrdetails')", true);
//// ShowDiv("ShowClient('dvGrdetails')");
//return;
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "Please select at least one Gr.";
}
if (strchkDetlValue != "")
{
strchkDetlValue = strchkDetlValue.Substring(0, strchkDetlValue.Length - 1);
}
if (strchkDetlValue == "")
{
lblmsg.Text = "Please select atleast one Gr.";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
//ShowMessage("Please check atleast one Gr.");
// ShowDiv("ShowClient('dvGrdetails')");
return;
}
else
{
lblmsg.Visible = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
string strSbillNo = String.Empty;
DataTable dtRcptDetl = new DataTable();
dtRcptDetl = obj.SelectDELVGrDetails(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToString(strchkDetlValue));
ViewState["dt"] = dtRcptDetl;
grdMain.DataSource = null;
//foreach (GridViewRow row in grdMain.Rows)
//{
// ImageButton imgbtndelete = (ImageButton)row.FindControl("imgbtndelete");
// imgbtndelete.Enabled = false;
//}
grdMain.DataSource = dtRcptDetl;
grdMain.DataBind();
ddlDelvryPlace.SelectedValue = ddldelvplace.SelectedValue;
}
}
else
{
ShowMessageErr("Gr Details not found.");
grdMain.DataSource = null;
grdMain.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openModal();", true);
}
ddlTruckNo.Focus();
}
catch (Exception Ex)
{
ApplicationFunction.ErrorLog(Ex.Message);
}
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowClient('dvGrdetails')", true);
//ddldelvplace.SelectedIndex = 0;
//grdGrdetals.DataSource = null;
//grdGrdetals.DataBind(); btnSubmit.Visible = false; BtnClerForPurOdr.Visible = false;
}
private void ChallanNo(Int32 YearIdno)
{
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
txtchallanNo.Text = Convert.ToString(obj.GetChallanNo(YearIdno, ApplicationFunction.ConnectionString()));
}
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;
}
this.Bind();
this.BindCity();
this.BindDropdown();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindFromCity();
}
else
{
this.BindFromCity(Convert.ToInt64(Session["UserIdno"]));
ddlDelvryPlace.SelectedValue = Convert.ToString(base.UserFromCity);
}
this.BindDateRange();
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddldateRange.SelectedIndex = 0;
ddldateRange_SelectedIndexChanged(null, null);
DeliveryChallanDetailsDAL objDeliveryChallanDetailsDAL = new DeliveryChallanDetailsDAL();
tblUserPref obj = objDeliveryChallanDetailsDAL.selectUserPref();
this.ChallanNo(Convert.ToInt32(ddldateRange.SelectedValue));
if (Request.QueryString["dc"] != null)
{
Populate(Convert.ToInt64(Request.QueryString["dc"]));
hidid.Value = Convert.ToString(Request.QueryString["dc"]);
lnkbtnNew.Visible = true;
lnkbtnPrint.Visible = true;
}
else
{
lnkbtnNew.Visible = false;
lnkbtnPrint.Visible = false;
}
txtOwnrNme.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtchallanNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtkatt.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);");
ddldateRange.Focus();
}
}
protected void lnkbtnSave_OnClick(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;
}
Int64 RateIdno = 0; bool isinsert = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
tblDelvChlnHead objChlnDelvHead = new tblDelvChlnHead();
objChlnDelvHead.DelvChln_No = Convert.ToInt64(txtchallanNo.Text);
objChlnDelvHead.DelvChln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objChlnDelvHead.DelvryPlc_Idno = Convert.ToInt32((ddlDelvryPlace.SelectedIndex <= 0) ? "0" : ddlDelvryPlace.SelectedValue);
objChlnDelvHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue);
objChlnDelvHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
objChlnDelvHead.Driver_Idno = Convert.ToInt32((ddldriverName.SelectedIndex <= 0) ? "0" : ddldriverName.SelectedValue);
objChlnDelvHead.Delvry_Instrc = txtDelvInstruction.Text.Trim().Replace("'", "");
objChlnDelvHead.Transprtr_Idno = Convert.ToInt32((ddlTransportName.SelectedIndex <= 0) ? "0" : ddlTransportName.SelectedValue);
objChlnDelvHead.Inv_Idno = 0;
objChlnDelvHead.Gross_Amnt = Convert.ToDouble(txtGrosstotal.Text);
objChlnDelvHead.Katt_Amnt = Convert.ToDouble(txtkatt.Text);
objChlnDelvHead.DelvChln_type = 1;
objChlnDelvHead.Other_Amnt = Convert.ToDouble(txtOtherAmnt.Text);
objChlnDelvHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objChlnDelvHead.Date_Added = Convert.ToDateTime(DateTime.Now);
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
value = obj.Insert(objChlnDelvHead, DtTemp, Convert.ToInt32(ddlDelvryPlace.SelectedValue), ApplicationFunction.ConnectionString());
tScope.Complete();
obj = null;
}
else
{
value = obj.Update(objChlnDelvHead, Convert.ToInt32(hidid.Value), DtTemp, Convert.ToInt32(txtchallanNo.Text), ApplicationFunction.ConnectionString());
tScope.Complete();
}
if ((string.IsNullOrEmpty(hidid.Value) == false))
{
if (value > 0)
{
ShowMessage("Record Update successfully");
Clear();
}
else if (value == -1)
{
ShowMessageErr("Challan No Already Exist");
}
else
{
ShowMessageErr("Record Not Update");
}
}
else if (string.IsNullOrEmpty(hidid.Value) == true)
{
if (value > 0)
{
ShowMessage("Record saved Successfully ");
Clear();
}
else if (value == -1)
{
ShowMessageErr("Challan No Already Exist");
}
else
{
ShowMessageErr("Record Not saved Successfully ");
}
}
}
}
