private void TotalRecords()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
Int64 iREcvrIDNO = (ddlRecvr.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlRecvr.SelectedValue));
Int64 iSenderIDNO = (ddlSender.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlSender.SelectedValue));
Int64 iDElvryIDNO = (ddlDelvPlce.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlDelvPlce.SelectedValue));
Int32 iGRTypIDNO = (ddlGRType.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlGRType.SelectedValue));
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
GRRepDAL obj = new GRRepDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iREcvrIDNO,
iSenderIDNO, iFromCityIDNO, iDElvryIDNO, iGRTypIDNO, UserIdno, conString);
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void BindGrid()
{
GRPrepRetailerDAL objRet = new GRPrepRetailerDAL();
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 MnNo = string.IsNullOrEmpty(Convert.ToString(txtManNo.Text)) ? "" : Convert.ToString(txtManNo.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 = objRet.SelectGRRetailer(GrNo, dtfrom, dtto, cityfrom, citydel, citto, sender, yearidno, UserIdno, strPrefixNum, MnNo);
objRet = 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], "GRRet_Pref")) + "" + Convert.ToString(DataBinder.Eval(lstGridData[i], "GrRet_No"));
dr["GrDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "GRRet_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_Amount")).ToString("N2");
dt.Rows.Add(dr);
TAmnt += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Gross_Amnt"));
TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amount"));
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_Amount"));
}
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;
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("GrPrepRetailer.aspx?Gr=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
GRPrepRetailerDAL obj = new GRPrepRetailerDAL();
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);
}
}
}
private void SetDate()
{
FinYearDAL objDAL = new FinYearDAL();
var lst = objDAL.FilldateFromTo(3);
hidmindate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "StartDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "StartDate")).ToString("dd-MM-yyyy"));
hidmaxdate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "EndDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "EndDate")).ToString("dd-MM-yyyy"));
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmaxdate.Value)) >= DateTime.Now.Date && DateTime.Now.Date >= Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmindate.Value)))
{
txtDate.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
else
{
txtDate.Text = hidmindate.Value;
}
}
private void BindGrid()
{
HireInvDAL obj = new HireInvDAL();
DateTime? datefromValue = null;
DateTime? dateToValue = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int BillNo = string.IsNullOrEmpty(Convert.ToString(txtInvoiceno.Text)) ? 0 : Convert.ToInt32(txtInvoiceno.Text);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
datefromValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtDateTo.Text)) == false)
{
dateToValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text));
}
int Locidno = Convert.ToInt32(drpCityFrom.SelectedValue == "" ? 0 : Convert.ToInt32(drpCityFrom.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.SelectSerach(BillNo, datefromValue, dateToValue, Locidno, yearidno, UserIdno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = false;
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;
prints.Visible = false;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
prints.Visible = false;
}
}
/// <summary>
/// Registers the applet.
/// </summary>
/// <param name="applet">The applet.</param>
/// <returns>ApplicationFunctionItem.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public ApplicationFunction RegisterApplet(ApplicationFunction applet)
{
throw new NotImplementedException();
}
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 Populate(int AcntIdno)
{
LedgerAccountDAL objAcntMaster = new LedgerAccountDAL();
var objAcntMast = objAcntMaster.SelectById(AcntIdno);
var lst = objAcntMaster.CheckInvGen(AcntIdno);
var objDocHolder = objAcntMaster.SelectDocHolder(AcntIdno);
objAcntMaster = null;
if (objAcntMast != null)
{
hiddriverPopulate.Value = Convert.ToString(lst);
txtAccountPrtyName.Text = Convert.ToString(objAcntMast.Acnt_Name);
txtAccountPrtyNameHindi.Text = Convert.ToString(objAcntMast.AcntName_Hindi);
txtAddress1.Text = Convert.ToString(objAcntMast.Address1);
txtAddress2.Text = Convert.ToString(objAcntMast.Address2);
txtAccount.Text = Convert.ToString(objAcntMast.Account_No);
txtBankName.Text = Convert.ToString(objAcntMast.Bank_Name);
txtBranchName.Text = Convert.ToString(objAcntMast.Branch_Name);
txtIfscNo.Text = Convert.ToString(objAcntMast.Ifsc_Code);
txtagntCommision.Text = Convert.ToString(objAcntMast.Agnt_Commson);
ddlAccountType.SelectedValue = Convert.ToString(objAcntMast.Acnt_Type);
txtContEmail.Text = Convert.ToString(objAcntMast.Cont_Email);
if ((Convert.ToInt32(ddlAccountType.SelectedValue) == 3) || (Convert.ToInt32(ddlAccountType.SelectedValue) == 1))
{
txtcontPrsn.Enabled = false; txtContMob.Enabled = false; txtContEmail.Enabled = false; txtAddress1.Enabled = false;
txtAddress2.Enabled = false; ddlState.Enabled = false; ddlCity.Enabled = false; chkStatus.Enabled = false;
txtPinCode.Enabled = false; txtTin.Enabled = false; txtFax.Enabled = false; ddlCategory.Enabled = false;
rfvState.Enabled = false; rfvCity.Enabled = false; rfvpetroCompany.Enabled = false; rfvpetroCompany.Visible = false;
rfvCity.Visible = false; rfvState.Visible = false; SpanCityRefresh.Visible = false;
ddlState.SelectedIndex = 0; ddlCity.SelectedIndex = 0; ddlDistrict.SelectedIndex = 0;
}
else
{
ddlState.SelectedValue = Convert.ToString(objAcntMast.State_Idno);
this.BindCitywithStateId(Convert.ToInt32(objAcntMast.State_Idno));
if ((Convert.ToString(objAcntMast.City_Idno) != "") && (Convert.ToInt64(objAcntMast.City_Idno) > 0))
{
ddlCity.SelectedValue = Convert.ToString(objAcntMast.City_Idno);
}
}
ddlTitle.SelectedValue = Convert.ToString(objAcntMast.Titl_Idno);
if (Convert.ToInt32(ddlAccountType.SelectedValue) != 12)
{
DivlnkClaimDetails.Visible = false;
}
else
{
DivbtnDriver.Visible = false; DivlnkClaimDetails.Visible = true;
}
if (Convert.ToString(objAcntMast.Acnt_Type) == "9")
{
txtlicense.Text = Convert.ToString(objAcntMast.DrvLicnc_NO);
if (objAcntMast.DrvLNo_ExpDate != null)
{
txtExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy");
}
txtauthority.Text = Convert.ToString(objAcntMast.DrvAuthrty_Plc);
txtaccountno.Text = Convert.ToString(objAcntMast.DrvAcnt_No);
Drpgurenter.SelectedValue = Convert.ToString(objAcntMast.DrvGurntr_Idno);
chkVarified.Checked = Convert.ToBoolean(objAcntMast.DrvLNo_Verfd);
txtDriverSOF.Text = Convert.ToString(objAcntMast.DrvFather_Nm);
txtDriverAddress.Text = Convert.ToString(objAcntMast.Drv_Adres);
txtDriverMobileNo1.Text = Convert.ToString(objAcntMast.Drv_MobNo1);
txtDriverMobileNo2.Text = Convert.ToString(objAcntMast.Drv_MobNo2);
txtDriverBankName.Text = Convert.ToString(objAcntMast.DrvBankAc_Nm);
txtDriverBankAddrs.Text = Convert.ToString(objAcntMast.DrvBankAc_Adres);
txtDriverRTGC.Text = Convert.ToString(objAcntMast.DrvAc_RtgsCode);
txtDriverHazardousL.Text = Convert.ToString(objAcntMast.DrvHazardLic_No);
if (objAcntMast.DrvHazardLic_NoExpDt != null)
{
txtHazardousExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy");
}
ViewState["LincenceNo"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLicnc_NO)) ? "" : Convert.ToString(objAcntMast.DrvLicnc_NO);
ViewState["ExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_ExpDate)) ? "" : Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy");
ViewState["Authority"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAuthrty_Plc)) ? "" : Convert.ToString(objAcntMast.DrvAuthrty_Plc);
ViewState["Account"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAcnt_No)) ? "" : Convert.ToString(objAcntMast.DrvAcnt_No);
ViewState["Guarantor"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvGurntr_Idno)) ? "0" : Convert.ToString(objAcntMast.DrvGurntr_Idno);
ViewState["varified"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_Verfd)) ? "0" : Convert.ToString(objAcntMast.DrvLNo_Verfd);
ViewState["FatherName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvFather_Nm)) ? "" : Convert.ToString(objAcntMast.DrvFather_Nm);
ViewState["Address"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_Adres)) ? "" : Convert.ToString(objAcntMast.Drv_Adres);
ViewState["Mobile1"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo1)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo1);
ViewState["Mobile2"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo2)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo2);
ViewState["BankName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Nm)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Nm);
ViewState["BankAddress"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Adres)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Adres);
ViewState["RTGScode"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAc_RtgsCode)) ? "" : Convert.ToString(objAcntMast.DrvAc_RtgsCode);
ViewState["HazardousLicence"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_No)) ? "" : Convert.ToString(objAcntMast.DrvHazardLic_No);
ViewState["HazardousExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_NoExpDt)) ? "" : Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy");
}
//Other Charge.........
txtdetenPlantchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPlant_charg)) ? "0.00" :Convert.ToString(objAcntMast.detenPlant_charg);
txtdetenPortchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPort_charg)) ? "0.00" : Convert.ToString(objAcntMast.detenPort_charg);
txtcontainerchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Container_charg)) ? "0.00" : Convert.ToString(objAcntMast.Container_charg);
//
//ddlAccountType.Enabled = false;
ddlAccountSubGroup.SelectedValue = Convert.ToString(objAcntMast.ASubGrp_Idno);
ddlBalanceType.SelectedValue = Convert.ToString(objAcntMast.Bal_Type);
txtOpBal.Text = Convert.ToString(objAcntMast.Open_Bal);
chkServExmpt.Checked = Convert.ToBoolean(objAcntMast.ServTax_Exmpt);
txtcontPrsn.Text = Convert.ToString(objAcntMast.Cont_Person);
txtContMob.Text = Convert.ToString(objAcntMast.Cont_Mobile);
txtPinCode.Text = (Convert.ToString(objAcntMast.Pin_Code) == "0")? "" : Convert.ToString(objAcntMast.Pin_Code);
txtFax.Text = Convert.ToString(objAcntMast.Fax_No);
chkStatus.Checked = Convert.ToBoolean(objAcntMast.Status);
ddlCompany.SelectedValue = Convert.ToString(objAcntMast.PetrolComp_Idno);
ddlPrincComp.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objAcntMast.PComp_Idno)) ? "0" : Convert.ToString(objAcntMast.PComp_Idno);
txtPanNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Pan_No)) ? "" : Convert.ToString(objAcntMast.Pan_No);
txtLSTNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Lst_No)) ? "" : Convert.ToString(objAcntMast.Lst_No);
txtcstNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Cst_No)) ? "" : Convert.ToString(objAcntMast.Cst_No);
hidid.Value = Convert.ToString(objAcntMast.Acnt_Idno);
txtGST.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.LdgrGSTIN_No)) ? "" : Convert.ToString(objAcntMast.LdgrGSTIN_No);
txtShortName.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Short_Name)) ? "" : Convert.ToString(objAcntMast.Short_Name);
if (objDocHolder != null && objDocHolder.Count > 0)
{
dtTemp = CreateDt();
for (int counter = 0; counter < objDocHolder.Count; counter++)
{
string strDocName = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocName"));
string strRemark = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocRemark"));
string strImage = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocImage"));
ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strDocName, strRemark, strImage);
}
ViewState["DocumentHolderTable"] = dtTemp;
this.BindDocumentDataGrid();
}
ddlTitle.Focus();
}
}
public void FillGridValue()
{
string filename = String.Empty, filePath = String.Empty, VirtualBinaryImage = "";
decimal size = Math.Round(((decimal)fuPicture.PostedFile.ContentLength / (decimal)1024), 2);
if (size > 600)
{
lblimgError.Visible = true;
lblimgError.Text = "File size must not exceed 600 KB.";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true);
}
else
{
try
{
lblimgError.Visible = false;
string[] validFileTypes = { "bmp", "gif", "png", "jpg", "jpeg" };
HttpPostedFile File1 = fuPicture.PostedFile;
string ext = System.IO.Path.GetExtension(fuPicture.PostedFile.FileName);
bool isValidFile = false;
for (int i = 0; i < validFileTypes.Length; i++)
{
if (ext == "." + validFileTypes[i])
{
isValidFile = true;
break;
}
}
if (!isValidFile)
{
string strMsg = "Invalid File. Please upload a File with extension " + string.Join(",", validFileTypes);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
imgEmp.ImageUrl = "";
}
else
{
if (fuPicture.HasFile)
{
if (fuPicture.PostedFile.ContentLength < 5024000)
{
string subPath = "C:\\tmpImg"; // your code goes here
bool exists = System.IO.Directory.Exists(subPath);
if (!exists)
{
System.IO.Directory.CreateDirectory(subPath);
}
filename = Path.GetFileName(fuPicture.FileName);
filePath = subPath + "\\" + filename;
fuPicture.SaveAs(filePath);
byte[] byteArray = null;
HttpPostedFile file = (HttpPostedFile)fuPicture.PostedFile;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read))
{
byteArray = new byte[fs.Length];
int iBytesRead = fs.Read(byteArray, 0, (int)fs.Length);
if (byteArray != null && byteArray.Length > 0)
{
// Convert the byte into image
string base64String = Convert.ToBase64String(byteArray, 0, byteArray.Length);
VirtualBinaryImage = "data:image/png;base64," + base64String;
}
}
}
}
}
}
catch (Exception ex)
{
}
dtTemp = CreateDt();
dtTemp = (DataTable)ViewState["DocumentHolderTable"];
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
ApplicationFunction.DatatableAddRow(dtTemp, id, txtDocName.Text.Trim(), txtDocRemark.Text.Trim(), VirtualBinaryImage);
ViewState["DocumentHolderTable"] = dtTemp;
this.BindDocumentDataGrid();
txtDocName.Text = string.Empty;
txtDocRemark.Text = string.Empty;
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true);
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
StockTransferDAL objStck = new StockTransferDAL();
int id = Convert.ToInt32(e.CommandArgument);
DtTemp = (DataTable)ViewState["dt"];
//GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
DtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = DtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
drpItemType.SelectedValue = Convert.ToString(drs[0]["ITEM_TYPEID"]);
if (Convert.ToInt32(hidStckid.Value) > 0)
{
BindItemName();
if ((drpItemType.SelectedValue == "1"))
{
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
BindItem();
ddlTyreType.SelectedValue = string.IsNullOrEmpty(ddlTyreType.SelectedValue) ? "0" : Convert.ToString(drs[0]["TYRE_TYPEID"]);
ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true;
txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true;
}
else
{
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1";
drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false;
}
}
else
{
if (drpItemType.SelectedValue == "1")
{
BindItemName();
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
BindItem();
drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]);
ddlTyreType.SelectedValue = Convert.ToString(drs[0]["TYRE_TYPEID"]);
ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true;
txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true;
}
else
{
BindItemName();
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
//drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]);
ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1";
drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false;
}
}
txtQty.Text = Convert.ToString(drs[0]["ITEM_QTY"]);
txtRate.Text = Convert.ToString(drs[0]["ITEM_RATE"]);
hidrowid.Value = Convert.ToString(drs[0]["id"]);
}
drpItemType.Focus();
}
else if (e.CommandName == "cmddelete")
{
DataTable dt = CreateDt();
foreach (DataRow rw in DtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(dt, rw["id"], rw["ITEM_TYPE"], rw["ITEM_TYPEID"], rw["ITEM_SERIAL"],
rw["ITEM_SERIALID"], rw["TYRE_TYPE"], rw["TYRE_TYPEID"], rw["ITEM_QTY"], rw["ITEM_RATE"], rw["ITEM_AMOUNT"], rw["ITEM_NAME"], rw["ITEM_ID"]);
}
}
ViewState["dt"] = dt;
dt.Dispose();
this.BindGrid();
}
}
public virtual void CreateMenu(ApplicationFunction menu)
{
this.Store.CreateMenu(menu);
}
public void CloseFunction(ApplicationFunction function)
{
UserControlFunctionItem<ApplicationFunction> first =
openedUserControlCollection.FirstOrDefault(f => f.Data.ID == function.ID);
if (first != null)
{
//test if exist when the collection removed
var dispose = first.Content as IDisposable;
if (dispose != null)
dispose.Dispose();
openedUserControlCollection.Remove(first);
}
}
public abstract FrameworkElement GetContentFromFunction(ApplicationFunction function, EsuProgressViewModel progress);
public virtual void FunctionClick(ApplicationFunction function)
{
UserControlFunctionItem<ApplicationFunction> first =
openedUserControlCollection.FirstOrDefault(f => f.Data.ID == function.ID);
if (first != null)
{
CurrentUserControl = first;
return;
}
var control = new UserControlFunctionItem<ApplicationFunction>(function.ImageUrl, CloseFunction)
{
Header = function.Name,
Data = function
};
control.Content = GetContentFromFunction(function, control.Progress);
var dataLoad = control.Content as IDataLoad;
if (dataLoad != null)
dataLoad.Load();
openedUserControlCollection.Add(control);
CurrentUserControl = control;
NotifyOfPropertyChange(() => OpenedUserControlCollection);
}
private void BindGrid()
{
try
{
outsndngBillRepDAL obj = new outsndngBillRepDAL();
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));
Int64 iSenderIDNO = (Convert.ToString(drpSenderName.SelectedValue) == "" ? 0 : Convert.ToInt64(drpSenderName.SelectedValue));
Int32 iInvoiceNo = (Convert.ToString(txtInvoiceNo.Text) == "" ? 0 : Convert.ToInt32(txtInvoiceNo.Text));
DataTable DsGrdetail = obj.SelectRep("SelectRep", Convert.ToString(txtDateFrom.Text), Convert.ToString(txtDateTo.Text), iFromCityIDNO, iSenderIDNO, iInvoiceNo, UserIdno, ApplicationFunction.ConnectionString(), Convert.ToString(txtPrefixNo.Text.Trim()));
if ((DsGrdetail != null) && (DsGrdetail.Rows.Count > 0))
{
ViewState["dtCSV"] = DsGrdetail;
grdMain.DataSource = DsGrdetail;
grdMain.DataBind();
Double TotalNetAmount = 0, RecivdAmnt = 0, PendingAmnt = 0, TDSAmnt = 0, DBNoteAmnt = 0;
for (int i = 0; i < DsGrdetail.Rows.Count; i++)
{
RecivdAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["Tot_Recvd"]);
PendingAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["cur_Bal"]);
TDSAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["TDS_Amount"]);
DBNoteAmnt += Convert.ToDouble(DsGrdetail.Rows[i]["DB_Note"]);
TotalNetAmount += Convert.ToDouble(DsGrdetail.Rows[i]["Amount"]);
}
lblNetTotalRecivdAmnt.Text = RecivdAmnt.ToString("N2");
lblNetTotallblPendingAmnt.Text = PendingAmnt.ToString("N2");
lblNetTotalTDSAmnt.Text = TDSAmnt.ToString("N2");
lblNetTotalDBNoteAmnt.Text = DBNoteAmnt.ToString("N2");
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 " + DsGrdetail.Rows.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
imgBtnExcel.Visible = true;
lblTotalRecord.Text = "T. Record(s) : " + Convert.ToString(DsGrdetail.Rows.Count);
}
else
{
ViewState["dtCSV"] = null;
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
protected void lnkbtnUpload_Click(object sender, EventArgs e)
{
string msg = string.Empty;
if (FileUpload.HasFile)
{
GrPrepOntohireDAL obj = new GrPrepOntohireDAL();
string excelfilename = string.Empty;
#region UPLOAD EXCEL AT SERVER
excelfilename = ApplicationFunction.UploadFileServerControl(FileUpload, "ItemsGronhire", "Grprepexcel");
#endregion
if ((System.IO.Path.GetExtension(excelfilename) == ".xls") || (System.IO.Path.GetExtension(excelfilename) == ".xlsx"))
{
DataTable dt = new DataTable();
DataTable dtnew = new DataTable();
BindDropdownDAL objDal = new BindDropdownDAL();
string filepath = Server.MapPath(@"~/ItemsGronhire/" + excelfilename);
string constring = string.Empty;
if (System.IO.Path.GetExtension(filepath) == ".xls")
{
constring = "Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-4;Data Source='" + filepath + "';Extended Properties=\"Excel 8.0;HDR=Yes;\"";
}
else if (System.IO.Path.GetExtension(filepath) == ".xlsx")
{
constring = "Provider= Microsoft.ACE.OLEDB.12.0;OLE DB Services=-4;Data Source='" + filepath + "'; Extended Properties=\"Excel 12.0;HDR=YES;\"";
}
#region Select Excel
OleDbConnection con = new OleDbConnection(constring);
con.Open();
DataTable ExcelTable = new DataTable();
ExcelTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = Convert.ToString(ExcelTable.Rows[0][2]);
OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + SheetName + "] WHERE [GRNo] IS NOT NULL OR [GRDate] IS NOT NULL OR [CHDate] IS NOT NULL OR [CHNo] IS NOT NULL OR [From] IS NOT NULL OR [To] IS NOT NULL OR [LrryNo] IS NOT NULL OR [OwnerName] IS NOT NULL OR [PanNo] IS NOT NULL OR [DspQty] IS NOT NULL OR [Rate] IS NOT NULL OR [Amount] IS NOT NULL", con); DataSet ds = new DataSet();
da.Fill(ds);
#endregion
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns[0].Caption == "SrNo" && ds.Tables[0].Columns[1].Caption == "GRNo" && ds.Tables[0].Columns[2].Caption == "GRDate" && ds.Tables[0].Columns[3].Caption == "CHDate" && ds.Tables[0].Columns[4].Caption == "CHNo" && ds.Tables[0].Columns[5].Caption == "From" && ds.Tables[0].Columns[6].Caption == "To" && ds.Tables[0].Columns[7].Caption == "LrryNo" && ds.Tables[0].Columns[8].Caption == "OwnerName" && ds.Tables[0].Columns[9].Caption == "PanNo" && ds.Tables[0].Columns[10].Caption == "DspQty" && ds.Tables[0].Columns[11].Caption == "Rate" && ds.Tables[0].Columns[12].Caption == "Amount")
{
#region INSERT RECORD IN tblChlnUploadFromExcel TABLE
Int64 intResult = 0;
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
intResult = obj.InsertInGrExcel(
Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[i]["GRDate"].ToString() == "" ? "" : ds.Tables[0].Rows[i]["GRDate"])),
Convert.ToInt64(Convert.ToString(ds.Tables[0].Rows[i]["GRNo"]) == "" ? "0" : ds.Tables[0].Rows[i]["GRNo"]),
Convert.ToDateTime(Convert.ToString(ds.Tables[0].Rows[i]["CHDate"].ToString() == "" ? "" : ds.Tables[0].Rows[i]["CHDate"])),
Convert.ToInt64(Convert.ToString(ds.Tables[0].Rows[i]["CHNo"]) == "" ? "0" : ds.Tables[0].Rows[i]["CHNo"]),
Convert.ToString(Convert.ToString(ds.Tables[0].Rows[i]["From"]) == "" ? "" : ds.Tables[0].Rows[i]["From"]),
Convert.ToString(Convert.ToString(ds.Tables[0].Rows[i]["To"]) == "" ? "" : ds.Tables[0].Rows[i]["To"]),
Convert.ToString(Convert.ToString(ds.Tables[0].Rows[i]["LrryNo"]) == "" ? "" : ds.Tables[0].Rows[i]["LrryNo"]),
Convert.ToString(Convert.ToString(ds.Tables[0].Rows[i]["OwnerName"]) == "" ? "" : ds.Tables[0].Rows[i]["OwnerName"]),
Convert.ToString(Convert.ToString(ds.Tables[0].Rows[i]["PanNo"]) == "" ? "" : ds.Tables[0].Rows[i]["PanNo"]),
Convert.ToInt64(Convert.ToString(ds.Tables[0].Rows[i]["DspQty"]) == "" ? "0" : ds.Tables[0].Rows[i]["DspQty"]),
Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i]["Rate"]) == "" ? "" : ds.Tables[0].Rows[i]["Rate"]),
Convert.ToDouble(Convert.ToString(ds.Tables[0].Rows[i]["Amount"]) == "" ? "" : ds.Tables[0].Rows[i]["Amount"])
, Convert.ToInt64(ddldateRange.SelectedValue == "" ? "0" : ddldateRange.SelectedValue));
}
if (intResult > 0)
{
msg = "Excel uploaded successfully";
ShowMessage(msg);
Tran.Complete();
}
else
{
Tran.Dispose();
}
}
#endregion
}
else
{
msg = "Excel is blank or Excel is not in correct format.";
ShowMessageErr(msg);
return;
}
}
}
else
{
msg = "Please Upload Correct Excel File";
ShowMessageErr(msg);
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
txtTripNo.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();
this.BindLane();
this.bindsender();
this.BindLorry();
imgBtnExcel.Visible = false;
DateTime?dtfrom = null;
DateTime?dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
int TripNo = string.IsNullOrEmpty(Convert.ToString(txtTripNo.Text)) ? 0 : Convert.ToInt32(txtTripNo.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(drpCityFrom.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, citto, senderr, yearidno, UserIdno);
//obj = null;
//if (lstGridData != null && lstGridData.Count > 0)
//{
// lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
//}
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string smsg = string.Empty;
if ((Convert.ToDouble(Convert.ToDouble(taxRate.Text.Trim())) <= 0) || (Convert.ToDouble(Convert.ToDouble(taxRate.Text.Trim())) >= 100))
{
if (Convert.ToDouble(taxRate.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Tax Rate!");
}
else
{
ShowMessageErr("Tax rate cannot be greater than or equal to 100");
}
taxRate.Focus();
return;
}
if (Convert.ToString(drpdownTaxType.SelectedValue) == "2")
{
if (txtLorryFrom.Text == "")
{
txtLorryFrom.Text = "0";
}
if (txtlorryto.Text == "")
{
txtlorryto.Text = "0";
}
if (Convert.ToInt32(txtLorryFrom.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Lorry From!");
txtLorryFrom.Focus();
return;
}
if (Convert.ToInt32(txtlorryto.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Lorry To!");
txtlorryto.Focus();
return;
}
if (Convert.ToInt32(txtlorryto.Text.Trim()) <= Convert.ToInt32(txtLorryFrom.Text.Trim()))
{
ShowMessageErr("Lorry From Should be smaller than Lorry To!");
txtLorryFrom.Focus();
return;
}
}
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
Int64 TaxId = 0;
int compID = 0;//Convert.ToInt32(UsessionValue.CompId);
// DateTime dateModified = DateTime.Now;
int taxtypeIdno = Convert.ToInt32(drpdownTaxType.SelectedValue);
int stateIdno = Convert.ToInt32(drpState.SelectedValue);
double rate = Convert.ToDouble(Convert.ToString(taxRate.Text));
int PANtype = Convert.ToInt32(Convert.ToString(ddlPANType.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlPANType.SelectedValue));
int lorryfrom = Convert.ToInt32(Convert.ToString(txtLorryFrom.Text));
int lorryto = Convert.ToInt32(Convert.ToString(txtlorryto.Text));
bool CalonDf = Convert.ToBoolean((chkCalOnDF.Checked) == true ? 1 : 0);
//bool LowRate = Convert.ToBoolean((chkLowRate.Checked) == true ? 1 : 0);
if (drpdownTaxType.SelectedItem.Text.Trim() == "UGST" || drpdownTaxType.SelectedItem.Text.Trim() == "IGST" || drpdownTaxType.SelectedItem.Text.Trim() == "CGST" || drpdownTaxType.SelectedItem.Text.Trim() == "SGST")
{
PANtype = 0; lorryfrom = 0; lorryto = 0; CalonDf = false; stateIdno = 0;
}
if (string.IsNullOrEmpty(hidTaxid.Value) == true)
{
TaxId = objTaxMastBLL.Insert(taxtypeIdno, stateIdno, rate, compID, Convert.ToDateTime(ApplicationFunction.mmddyyyyDash(txtDate.Text.Trim())), PANtype, lorryfrom, lorryto, CalonDf, empIdno);
}
else
{
TaxId = objTaxMastBLL.Update(Convert.ToInt32(hidTaxid.Value), taxtypeIdno, stateIdno, rate, compID, Convert.ToDateTime(ApplicationFunction.mmddyyyyDash(txtDate.Text.Trim())), PANtype, lorryfrom, lorryto, CalonDf, empIdno);
}
if (TaxId == 0)
{
ShowMessageErr("Record Not Saved ");
}
else if (TaxId < 0)
{
ShowMessageErr("Record already exists.");
}
else if (TaxId > 0)
{
if (hidTaxid.Value == "")
{
ShowMessage("Record Saved Successfully");
}
else
{
ShowMessage("Record Updated Successfully.");
drpState.Enabled = true;
}
this.ClearControls();
this.BindGrid();
}
}
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);
}
}
protected void lnkbtnPreview_OnClick(object sender, EventArgs e)
{
try
{
if (txtDateFrom.Text.Trim() != "" && txtDateTo.Text.Trim() != "")
{
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim())) > Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim())))
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "ShowMessage('Validfrom date can not be greater than Validto date!');", true);
txtDateFrom.Focus();
return;
}
}
this.BindGrid();
}
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();
}
public void Initialize(string[] entities, ApplicationFunction callback, Dictionary<string, Type> typeInfo)
{
string s = string.Join("|", entities);
_RxFetch = new Regex(@"(" + s + @")\.(\w+)\b", RegexOptions.Compiled | RegexOptions.CultureInvariant);
_GetEntityAttributeCallback = callback;
_TypeInfo = typeInfo;
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
EmployeeSalaryDAL Empobj = new EmployeeSalaryDAL();
Int64 value = 0;
string Date = DateTime.Now.Date.ToString("dd-MM-yyyy");
DateTime DateAdd = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Date));
using (TransactionScope dbTran = new TransactionScope(TransactionScopeOption.Required))
{
try
{
if (string.IsNullOrEmpty(hdnQry.Value) == true)
{
value = Empobj.InsertEmployeeDetl(Convert.ToInt64(ddlEmpName.SelectedValue), Convert.ToDouble(txtSalary.Text.Trim()), Convert.ToInt32(ddlMonth.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue), chkStatus.Checked, DateAdd);
}
else
{
value = Empobj.UpdateEmployeeDetl(Convert.ToInt64(hdnQry.Value), Convert.ToInt64(ddlEmpName.SelectedValue), Convert.ToDouble(txtSalary.Text.Trim()), Convert.ToInt32(ddlMonth.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue), chkStatus.Checked, DateAdd);
}
if (value > 0)
{
if (string.IsNullOrEmpty(hdnQry.Value) == true)
{
ShowMessage("Records successfully inserted.");
}
else
{
lnkbtnNew.Visible = false;
ShowMessage("Records successfully updated.");
}
dbTran.Complete();
this.ClearAllData();
}
else
{
if (string.IsNullOrEmpty(hdnQry.Value) == true)
{
ShowMessageErr("Records not inserted!");
}
else
{
ShowMessageErr("Records not updated!");
}
dbTran.Dispose();
}
}
catch (Exception ex)
{
if (string.IsNullOrEmpty(hdnQry.Value) == true)
{
ShowMessageErr("Error in records inserting!");
}
else
{
ShowMessageErr("Error in Records updating!");
}
}
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
DtTemp = CreateDt();
PaymentToOwnDAL obj = new PaymentToOwnDAL();
tblPayToOwnAcc objRGH = new tblPayToOwnAcc();
objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text);
objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue);
objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objRGH.Chln_IdNo = Convert.ToInt64(ddlChallan.SelectedValue);
objRGH.Driver_IdNo = Convert.ToInt64(hidDriverIdno.Value);
objRGH.Inst_No = Convert.ToInt64(Convert.ToString(txtInstNo.Text) == "" ? 0 : Convert.ToInt64(txtInstNo.Text));
objRGH.Date_Added = System.DateTime.Now;
objRGH.Date_Modified = null;
objRGH.Bank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue);
objRGH.RcptType_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue);
objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]);
if (txtInstDate.Text == "")
{
objRGH.Inst_Dt = null;
}
else
{
objRGH.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
}
objRGH.Remark = Convert.ToString(TxtRemark.Text);
objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue);
objRGH.Amnt = Convert.ToDouble(txtAmount.Text.Trim());
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
value = obj.Insert(objRGH);
}
else
{
value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value))));
}
if (value > 0)
{
if (this.PostIntoAccounts(Convert.ToDouble(txtAmount.Text), value, "PTD", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true)
{
obj.UpdateIsPosting(value);
if ((string.IsNullOrEmpty(hidid.Value) == false))
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
this.Clear();
ddlFromCity_SelectedIndexChanged(null, null);
}
else if (value == -1)
{
ShowMessageErr("Pay No. Already Exist");
}
else if (string.IsNullOrEmpty(hidid.Value) == false)
{
ShowMessageErr("Record Not Update");
}
}
else
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record Saved successfully");
this.Clear();
ddlFromCity_SelectedIndexChanged(null, null);
}
else if (value == -1)
{
ShowMessageErr("Pay No. Already Exist");
}
else if ((string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessageErr("Record Not Saved successfully");
}
}
tScope.Complete();
}
else
{
if (string.IsNullOrEmpty(hidpostingmsg.Value) == true)
{
if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false)
{
hidpostingmsg.Value = "Record(s) not updated.";
}
else
{
hidpostingmsg.Value = "Record(s) not saved.";
}
tScope.Dispose();
}
tScope.Dispose();
ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidpostingmsg.Value) + "')", true);
return;
}
}
else
{
if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false)
{
hidpostingmsg.Value = "Record(s) not updated.";
}
else
{
hidpostingmsg.Value = "Record(s) not saved.";
}
tScope.Dispose();
ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidid.Value) + "')", true);
return;
}
}
this.BindMaxNo(Convert.ToInt32(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue)), Convert.ToInt32(Convert.ToString(ddldateRange.SelectedValue) == "" ? 0 : Convert.ToInt32(ddldateRange.SelectedValue)));
}
private DataTable CreateDt()
{
DataTable DtTemp = ApplicationFunction.CreateTable("tbl", "SerialNo", "String", "CompanyName", "String", "LoctionName", "String", "ItemName", "String", "Qty", "String", "Rate", "String", "Amount", "String");
return(DtTemp);
}
private bool PostIntoAccounts(double Amount, Int64 intDocIdno, string strDocType, double dblRndOff, Int32 intCompIdno, Int32 intUserIdno, Int32 intUserType, Int32 intVchrForIdno, Int32 YearIdno)
{
#region Variables Declaration...
Int64 intVchrIdno = 0;
Int64 intValue = 0;
hidpostingmsg.Value = string.Empty;
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
double dblNetAmnt = 0;
double dblDiscAmnt = 0;
DateTime?dtPBillDate = null;
DateTime?dtBankDate = null;
if (string.IsNullOrEmpty(txtInstDate.Text) == false)
{
dtBankDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
}
#endregion
#region Account link Validations...
//clsAccountPosting objclsAccountPosting = new clsAccountPosting();
// tblAcntLink objAcntLink = objclsAccountPosting.GetAccountLinkData();
// if (objAcntLink == null)
// {
// hidpostingmsg.Value = " Account link is not defined. Kindly define.";
// }
// else
// {
// }
#endregion
PaymentToOwnDAL obj = new PaymentToOwnDAL();
Int32 IAcntIdno = 0;
// Int32 ILType = obj.selectTruckType(Convert.ToInt32(ddlTruckNo.SelectedValue)); //Convert.ToInt32(clsDataAccessFunction.ExecuteScaler("select Lorry_type from LorryMast where Lorry_Idno=" + Convert.ToInt32(cmbTruckNo.SelectedValue) + "", Tran, Program.DataConn));
//if (ILType == 1)
//{
//IAcntIdno = Convert.ToInt32(ddlDriverName.SelectedValue);
//}
//else
//{
IAcntIdno = Convert.ToInt32((string.IsNullOrEmpty((hidDriverIdno.Value)) ? "0" : hidDriverIdno.Value));
//}
if (Request.QueryString["q"] == null)
{
intValue = 1;
}
else
{
intValue = objclsAccountPosting.DeleteAccountPosting(intDocIdno, strDocType);
}
if (intValue > 0)
{
//IAcntIdno = Convert.ToInt32(ddlDriverName.SelectedValue);
IAcntIdno = 0;
Int64 VchrNo = objclsAccountPosting.GetMaxVchrNo(2, 0, Convert.ToInt32(ddldateRange.SelectedValue));
intValue = objclsAccountPosting.InsertInVchrHead(
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim())),
1,
Convert.ToInt32((ddlRcptTyp.SelectedIndex == -1) ? 0 : Convert.ToInt32(ddlRcptTyp.SelectedValue)),
"Receipt No :" + Convert.ToString(txtRcptNo.Text) + " Receipt Date: " + txtDate.Text.Trim() + "Total Paid Amount :" + Convert.ToDouble(txtAmount.Text.Trim().Replace("'", "")) + "",
true,
0,
strDocType,
IAcntIdno,
0,
0,
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim())),
((VchrNo == 0) ? 1 : VchrNo),
0,
YearIdno,
0, 0);
if (intValue > 0)
{
intVchrIdno = intValue;
intValue = 0; IAcntIdno = Convert.ToInt32((ddlRcptTyp.SelectedIndex == -1) ? 0 : Convert.ToInt32(ddlRcptTyp.SelectedValue));
intValue = objclsAccountPosting.InsertInVchrDetl(
intVchrIdno,
Convert.ToInt32((ddlRcptTyp.SelectedIndex == -1) ? 0 : Convert.ToInt32(ddlRcptTyp.SelectedValue)),
"Receipt No :" + Convert.ToString(txtRcptNo.Text) + " Receipt Date: " + txtDate.Text.Trim() + "Total Amount Paid :" + Convert.ToDouble(txtAmount.Text.Trim().Replace("'", "")) + " ",
Amount,
Convert.ToByte(1),
Convert.ToByte(0),
Convert.ToString(txtInstNo.Text),
true,
dtBankDate,
Convert.ToString(ddlCustmerBank.SelectedValue), 0);
if (intValue > 0)
{
intVchrIdno = intValue;
intValue = 0;
intValue = objclsAccountPosting.InsertInVchrDetl(
intVchrIdno,
Convert.ToInt32(hidDriverIdno.Value),
"Receipt No :" + Convert.ToString(txtRcptNo.Text) + " Receipt Date: " + txtDate.Text.Trim() + "Total Paid Received :" + Convert.ToDouble(txtAmount.Text.Trim().Replace("'", "")) + " ",
Amount,
Convert.ToByte(2),
Convert.ToByte(0),
Convert.ToString(txtInstNo.Text),
false,
dtBankDate,
Convert.ToString(ddlCustmerBank.SelectedValue), 0);
}
else
{
return(false);
}
#region VchrIdDetl Posting...
if (intValue > 0)
{
intValue = 0;
intValue = objclsAccountPosting.InsertInVchrIdDetl(intVchrIdno, intDocIdno, strDocType);
if (intValue == 0)
{
return(false);
}
}
#endregion
}
else
{
return(false);
}
}
else
{
return(false);
}
#region Deallocate variables...
objclsAccountPosting = null;
return(true);
#endregion
}
private void SetDate()
{
if (ddlDateRange.SelectedIndex != -1)
{
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
FinYearDAL objDAL = new FinYearDAL();
var lst = objDAL.FilldateFromTo(intyearid);
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
int numDays = DateTime.DaysInMonth(year, month);
hidmindate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "StartDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "StartDate")).ToString("dd-MM-yyyy"));
hidmaxdate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "EndDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "EndDate")).ToString("dd-MM-yyyy"));
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmaxdate.Value)) >= DateTime.Now.Date && DateTime.Now.Date >= Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmindate.Value)))
{
Datefrom.Text = Convert.ToString(hidmindate.Value);
Dateto.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
else
{
Datefrom.Text = Convert.ToString(hidmindate.Value);
Dateto.Text = Convert.ToString(hidmaxdate.Value);
//Dateto.Text = hidmindate.Value;
}
}
//BindDropdownDAL obj = new BindDropdownDAL();
//Array list = obj.BindDate();
//Datefrom.Text = Convert.ToString(list.GetValue(0));
//Dateto.Text = Convert.ToString(list.GetValue(1));
}
protected void ddlRcptType_SelectedIndexChanged(object sender, EventArgs e)
{
txtInstNo.Text = ""; rfvinstDate.Enabled = false; rfvinstno.Enabled = false; //rfvCusBank.Enabled = false; // lokesh, its remove b/c its not required
txtInstNo.Enabled = false;
txtInstDate.Enabled = false; ddlCustmerBank.Enabled = false;
if (ddlRcptTyp.SelectedIndex > 0)
{
PaymentToOwnDAL obj = new PaymentToOwnDAL();
DataTable dt = obj.BindRcptTypeDel(Convert.ToInt32((ddlRcptTyp.SelectedValue) == "" ? "0" : ddlRcptTyp.SelectedValue), ApplicationFunction.ConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
Int64 intAcnttype = Convert.ToInt64(dt.Rows[0]["ACNT_TYPE"]);
if (intAcnttype == 4)
{
txtInstNo.Enabled = true;
txtInstDate.Enabled = true;
ddlCustmerBank.Enabled = true;
rfvinstDate.Enabled = true; rfvinstno.Enabled = true; //rfvCusBank.Enabled = true;
}
}
}
}
private void BindGrid()
{
GRRepDAL obj = new GRRepDAL();
Int64 iREcvrIDNO = (ddlRecvr.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlRecvr.SelectedValue));
Int64 iSenderIDNO = (ddlSender.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlSender.SelectedValue));
Int64 iDElvryIDNO = (ddlDelvPlce.SelectedIndex <= 0 ? 0 : Convert.ToInt64(ddlDelvPlce.SelectedValue));
Int32 iGRTypIDNO = (ddlGRType.SelectedIndex <= 0 ? 0 : Convert.ToInt32(ddlGRType.SelectedValue));
Int64 iFromCityIDNO = (drpBaseCity.SelectedIndex <= 0 ? 0 : Convert.ToInt64(drpBaseCity.SelectedValue));
string strreporttypr = "";
if (ddlreporttype.SelectedValue == "1")
{
strreporttypr = "SelectRep";
}
else
{
strreporttypr = "SelectRepItemWise";
}
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
DataTable list = obj.SelectRep(strreporttypr, Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iREcvrIDNO,
iSenderIDNO, iFromCityIDNO, iDElvryIDNO, iGRTypIDNO, UserIdno, conString);
if ((list != null) && (list.Rows.Count > 0))
{
ViewState["CSVdt"] = list;
grdMain.DataSource = list;
grdMain.DataBind();
Double TotalNetAmount = 0, TotGrossAmnt = 0, TotSurcharge = 0, TotWages = 0, TotServTax = 0;
for (int i = 0; i < list.Rows.Count; i++)
{
TotGrossAmnt += Convert.ToDouble(list.Rows[i]["Gross_Amnt"]);
TotSurcharge += Convert.ToDouble(list.Rows[i]["Surcrg_Amnt"]);
TotWages += Convert.ToDouble(list.Rows[i]["Wages_Amnt"]);
TotServTax += Convert.ToDouble(list.Rows[i]["ServTax_Amnt"]);
TotalNetAmount += Convert.ToDouble(list.Rows[i]["Net_Amnt"]);
}
lblGrossAmnt.Text = TotGrossAmnt.ToString("N2");
lblSurcharge.Text = TotSurcharge.ToString("N2");
lblWages.Text = TotWages.ToString("N2");
lblServtax.Text = TotServTax.ToString("N2");
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 " + list.Rows.Count.ToString();
lblcontant.Visible = true;
imgBtnExcel.Visible = true;
divpaging.Visible = true;
lblTotalRecord.Text = "T. Record (s): " + list.Rows.Count;
if (ddlreporttype.SelectedValue == "1")
{
grdMain.Columns[7].Visible = false;
grdMain.Columns[8].Visible = false;
//grdMain.Columns[9].Visible = false;
grdMain.Columns[10].Visible = false;
grdMain.Columns[11].Visible = false;
grdMain.Columns[12].Visible = false;
grdMain.Columns[13].Visible = false;
}
else
{
grdMain.Columns[7].Visible = true;
grdMain.Columns[8].Visible = true;
//grdMain.Columns[9].Visible = true;
grdMain.Columns[10].Visible = true;
grdMain.Columns[11].Visible = true;
grdMain.Columns[12].Visible = true;
grdMain.Columns[13].Visible = true;
}
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
lblTotalRecord.Text = "T. Record (s): 0 ";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void ddlRcptTyp_SelectedIndexChanged(object sender, EventArgs e)
{
txtInstNo.Text = ""; ddlCustmerBank.SelectedIndex = 0; txtInstDate.Text = "";
rfvinstDate.Enabled = rfvinstno.Enabled = false;
txtInstNo.Enabled = false; //rfvCusBank.Enabled = false;
txtInstDate.Enabled = false;
ddlCustmerBank.Enabled = false; //rfvCusBank.Enabled = false;
ChlnBookingDAL obj = new ChlnBookingDAL();
DataTable dt = obj.BindRcptTypeDel(Convert.ToInt32(ddlRcptTyp.SelectedValue), ApplicationFunction.ConnectionString());
if (dt != null && dt.Rows.Count > 0)
{
Int64 intAcnttype = Convert.ToInt64(dt.Rows[0]["ACNT_TYPE"]);
if (intAcnttype == 4)
{
rfvinstno.Enabled = true;
txtInstNo.Enabled = true; rfvinstno.Enabled = rfvinstDate.Enabled = true;
txtInstDate.Enabled = true;
ddlCustmerBank.Enabled = true; //rfvCusBank.Enabled = true;
}
}
ddlRcptTyp.Focus();
}
private void TotalRecords()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
string UserClass = Convert.ToString(Session["Userclass"]);
Int64 UserIdno = 0;
if (UserClass != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
outsndngBillRepDAL obj = new outsndngBillRepDAL();
DataTable list1 = obj.SelectRep("SelectRep", Convert.ToString(txtDateFrom.Text), Convert.ToString(txtDateTo.Text), 0, 0, 0, UserIdno, ApplicationFunction.ConnectionString(), Convert.ToString(txtPrefixNo.Text.Trim()));
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(list1.Rows.Count);
}
}
private void ExportGridToPDF()
{
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 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");
CompName = Convert.ToString(CompDetl.Tables[0].Rows[0]["Comp_Name"]);
Add1 = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress1"]);
Add2 = Convert.ToString(CompDetl.Tables[0].Rows[0]["Adress2"]);
//PhNo = "Phone No. (O) :" + Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"] + "," + CompDetl.Tables[0].Rows[0]["Phone_Res"]);
PhNo = "Phone No. (O) :" + Convert.ToString(CompDetl.Tables[0].Rows[0]["Phone_Off"]);
City = Convert.ToString(CompDetl.Tables[0].Rows[0]["City_Idno"]);
State = Convert.ToString(CompDetl.Tables[0].Rows[0]["State_Idno"]) + " - " + Convert.ToString(CompDetl.Tables[0].Rows[0]["Pin_No"]);
TinNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["TIN_NO"]);
//ServTaxNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Serv_Tax"]);
FaxNo = Convert.ToString(CompDetl.Tables[0].Rows[0]["Fax_No"]);
var titleFont = FontFactory.GetFont("Arial", 10, Font.BOLD);
var boldFooterFont = FontFactory.GetFont("Arial", 8, Font.BOLD);
var bodyFont = FontFactory.GetFont("Arial", 8, Font.NORMAL);
var bodyFont2 = FontFactory.GetFont("Arial", 9, Font.NORMAL);
string html = "";
html = html + "<html><head></head><Body>";
html = html + "<table width='100%' border='0'>";
html = html + "<tr><td align='center'></td></tr>";
html = html + "<tr><td align='center'><strong>" + CompName + "</strong></td></tr>";
html = html + "<tr><td align='center' style='font-size:small;'>" + Add1 + "," + Add2 + "," + City + "," + State + "</td></tr>";
html = html + "<tr><td align='center' style='font-size:small;'>" + PhNo + "</td></tr>";
html = html + "<tr><td align='center'></td></tr>";
html = html + "<tr><td align='center'><strong>Challan Payment</strong></td></tr>";
html = html + "<tr><td><div style='border-width:1px;border-color:#000;border-style:solid;Height:40px;'>";
html = html + "</div></td></tr></table>";
html = html + "</body></html>";
DataSet PrtyAdd = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select AM.Address1,Am.Address2,CM.City_Name,SM.State_Name from acntmast AM inner join tblcitymaster CM on AM.City_idno=CM.City_Idno inner join tblstatemaster SM on CM.State_idno=SM.State_idno where AM.Acnt_Idno=" + hidDriverIdno.Value + "");
PdfPTable tblprtyAdd = new PdfPTable(1);
tblprtyAdd.WidthPercentage = 90;
tblprtyAdd.DefaultCell.Border = Rectangle.NO_BORDER;
if (PrtyAdd.Tables[0].Rows.Count > 0)
{
PdfPCell CellAdd = new PdfPCell(new Phrase(("Party Address : " + Convert.ToString(PrtyAdd.Tables[0].Rows[0][0]) + "," + Convert.ToString(PrtyAdd.Tables[0].Rows[0][1]) + "," + Convert.ToString(PrtyAdd.Tables[0].Rows[0][02]) + "," + Convert.ToString(PrtyAdd.Tables[0].Rows[0][3])), bodyFont2));
CellAdd.BorderWidth = 0;
PdfPCell CellAdd1 = new PdfPCell(new Phrase((""), bodyFont2));
CellAdd1.BorderWidth = 0;
tblprtyAdd.AddCell(CellAdd);
tblprtyAdd.AddCell(CellAdd1);
}
PdfPTable tblprty = new PdfPTable(3);
tblprty.WidthPercentage = 90;
PdfPCell cell1Text = new PdfPCell(new Phrase(("Pay No : " + txtRcptNo.Text), bodyFont2));
cell1Text.BorderWidth = 0;
PdfPCell cell2Text = new PdfPCell(new Phrase(("Date : " + txtDate.Text), bodyFont2));
cell2Text.BorderWidth = 0;
PdfPCell cell3Text = new PdfPCell(new Phrase(("From City : " + ddlFromCity.SelectedItem.Text), bodyFont2));
cell3Text.BorderWidth = 0;
PdfPCell cell4Text = new PdfPCell(new Phrase(("Driver Name : " + txtDriverName.Text), bodyFont2));
cell4Text.Colspan = 2;
cell4Text.BorderWidth = 0;
//PdfPCell cell6Text = new PdfPCell(new Phrase((""), bodyFont));
//cell6Text.BorderWidth = 0;
tblprty.AddCell(cell1Text);
tblprty.AddCell(cell2Text);
tblprty.AddCell(cell3Text);
tblprty.AddCell(cell4Text);
//tblprty.AddCell(cell6Text);
}
private void BindGrid()
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Lane_Idno = Convert.ToInt64(ddlLane.SelectedValue);
Int64 lorry_Idno = Convert.ToInt64(ddlLorry_No.SelectedValue);
int TripNo = string.IsNullOrEmpty(Convert.ToString(txtTripNo.Text)) ? 0 : Convert.ToInt32(txtTripNo.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(drpCityFrom.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.SelectTrip(TripNo, dtfrom, dtto, cityfrom, sender, yearidno, Lane_Idno, lorry_Idno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("Trip No.", typeof(string));
dt.Columns.Add("Pref No.", typeof(string));
dt.Columns.Add("Trip_Date", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("Truck No", typeof(string));
dt.Columns.Add("Driver", typeof(string));
dt.Columns.Add("Driver No", typeof(string));
dt.Columns.Add("Vehicle Size", typeof(string));
dt.Columns.Add("Total KM", typeof(string));
dt.Columns.Add("Qty", typeof(string));
dt.Columns.Add("Lane", typeof(string));
dt.Columns.Add("DSL_Card_Name", typeof(string));
dt.Columns.Add("DSL_Card_Number", typeof(string));
dt.Columns.Add("DSL_Qty", typeof(string));
dt.Columns.Add("DSL_Rate", typeof(string));
dt.Columns.Add("DSL_Amt", typeof(string));
dt.Columns.Add("DSL_Card_Amt", typeof(string));
dt.Columns.Add("Total_DSL_Qty", typeof(string));
dt.Columns.Add("Total_DSL_Amt", typeof(string));
dt.Columns.Add("Milage", typeof(string));
dt.Columns.Add("Cash", typeof(string));
dt.Columns.Add("Toll", typeof(string));
dt.Columns.Add("Wages", typeof(string));
dt.Columns.Add("Food_Exp", typeof(string));
dt.Columns.Add("Repair", typeof(string));
dt.Columns.Add("Adv_in_Driver", typeof(string));
dt.Columns.Add("Other", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Trip No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Trip_Idno"));
dr["Trip_Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Trip_Date")).ToString("dd-MM-yyyy");;
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["City"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Truck No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_Name"));
dr["Total KM"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotalKms"));
dr["Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Quantity"));
dr["Lane"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lane_Name"));
dr["Pref No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Pref_No"));
dr["Driver No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_No"));
dr["Vehicle Size"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Vehicle_Size"));
dr["DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Qty"));
dr["DSL_Rate"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Rate"));
dr["DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Amt")).ToString("N2");
dr["DSL_Card_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Card_Amt")).ToString("N2");
dr["DSL_Card_Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Name"));
dr["DSL_Card_Number"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Number"));
dr["Total_DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Qty"));
dr["Total_DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "Total_DSL_Amt")).ToString("N2");
dr["Cash"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Cash"));
dr["Toll"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Toll"));
dr["Wages"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Wages"));
dr["Food_Exp"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Food_Exp"));
dr["Repair"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Repair"));
dr["Adv_in_Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Adv_in_Driver"));
dr["Other"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Other"));
dr["Milage"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Milage"));
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Total_Amt")).ToString("N2");
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
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 SetDate()
{
Int32 intyearid = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue);
objFinYearDAL = new FinYearDAL();
var lst = objFinYearDAL.FilldateFromTo(intyearid);
objFinYearDAL = null;
hidmindate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "StartDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "StartDate")).ToString("dd-MM-yyyy"));
hidmaxdate.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "EndDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[0], "EndDate")).ToString("dd-MM-yyyy"));
if (ddlDateRange.SelectedIndex >= 0)
{
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmaxdate.Value)) >= DateTime.Now.Date && DateTime.Now.Date >= Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidmindate.Value)))
{
txtBillDateFrom.Text = hidmindate.Value;
txtBillDateTo.Text = DateTime.Now.Date.ToString("dd-MM-yyyy");
}
else
{
txtBillDateFrom.Text = hidmindate.Value;
txtBillDateTo.Text = hidmaxdate.Value;
}
}
}
/// <summary>
/// Registers the applet async.
/// </summary>
/// <param name="info">The info.</param>
/// <param name="onAppletRegistered">The on applet registered.</param>
/// <exception cref="System.NotImplementedException"></exception>
public void RegisterAppletAsync(ApplicationFunction info, Action<ApplicationFunction> onAppletRegistered)
{
throw new NotImplementedException();
}
