public int Delete(int intUsrPrefIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref objUserPrefence = (from mast in db.tblUserPrefs
where mast.UserPref_Idno == intUsrPrefIdno
select mast).FirstOrDefault();
if (objUserPrefence != null)
{
db.tblUserPrefs.DeleteObject(objUserPrefence);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
public Int64 UpdateLogo(byte[] logo, bool Flag)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref objUserPrefence = (from mast in db.tblUserPrefs
select mast).FirstOrDefault();
if (objUserPrefence != null)
{
objUserPrefence.Logo_Req = Flag;
objUserPrefence.Logo_Image = logo;
db.SaveChanges();
intValue = objUserPrefence.UserPref_Idno;
}
}
}
catch (Exception ex)
{
intValue = 0;
}
return(intValue);
}
private void Clear()
{
ViewState["dt"] = null;
dtTemp = null;
hidid.Value = string.Empty; hidOwnerId.Value = string.Empty;
ddlTruckNo.SelectedValue = "0";
txtOwnrNme.Text = "";
txtDate.Text = "";
txtchallanNo.Text = "";
ddldateRange.SelectedIndex = 0;;
BindGridT();
ddldateRange.Enabled = true;
ddldateRange.SelectedIndex = 0;
ChlnBookingDAL objChlnBookingDAL = new ChlnBookingDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
if (obj != null)
{
hidWorkType.Value = Convert.ToString(obj.Work_Type);
}
lnkbtnSave.Enabled = true;
}
/// <summary>
/// To check record existence in LorryMast
/// </summary>
/// <param name="strOwnerrName"></param>
/// <param name="intLorryIdno"></param>
/// <returns></returns>
public bool IsExists(Int64 intUsrPrefIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref objUserPrefence = new tblUserPref();
if (intUsrPrefIdno <= 0)
{
objUserPrefence = (from mast in db.tblUserPrefs
where mast.UserPref_Idno == intUsrPrefIdno
select mast).FirstOrDefault();
}
else if (intUsrPrefIdno > 0)
{
objUserPrefence = (from mast in db.tblUserPrefs
where mast.UserPref_Idno == intUsrPrefIdno
select mast).FirstOrDefault();
}
if (objUserPrefence != null)
{
return(true);
}
else
{
return(false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SessionValues svalue = new SessionValues();
// base.UsessionValue = svalue.FetchUsersAndComp(string.IsNullOrEmpty(Convert.ToString(Session["Visageuseridno"])) ? 0 : Convert.ToInt32(Session["Visageuseridno"]));
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;
}
txtDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDate.Text = System.DateTime.Now.ToString("dd-MM-yyyy");
this.BindDateRange();
ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlDateRange.SelectedIndex = 0;
ddlDateRange_SelectedIndexChanged(null, null);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BidFromCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
tblUserPref obj = objChallanDelverdDAL.selectUserPref();
ddlToCity.SelectedValue = Convert.ToString(base.UserFromCity);
BindChlnNo();
ViewState["dt"] = null;
if (Request.QueryString["chlnrcptidno"] != null)
{
lnkSubmit.Visible = false; ddlChallanDetl.Enabled = false; DivRcptNo.Visible = true; txtRcptNo.Visible = true; ddlToCity.Enabled = false;
this.Populate(Convert.ToInt32(Request.QueryString["chlnrcptidno"]));
this.Title = "Edit Delivery Challan";
lnkBtnNew.Visible = true;
}
else
{
lnkSubmit.Visible = true; ddlChallanDetl.Enabled = true; txtRcptNo.Visible = false; DivRcptNo.Visible = false; lblRcptDtNo.Text = "Receipt Date"; ddlToCity.Enabled = true;
lnkBtnNew.Visible = false;
}
ddlDateRange.Focus();
}
svalue = null;
}
private void userpref()
{
RateMastFTDAL objGrprepDAL = new RateMastFTDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
}
public void userpref()
{
GRPrepDAL objGrprepDAL = new GRPrepDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
AmntRecvdAgnst = Convert.ToInt32(userpref.AmntRecvdAgnst_GRInvce);
UpdateGr = Convert.ToBoolean(userpref.TBB_Rate);
if (string.IsNullOrEmpty(userpref.Menu_FleetMgmt.ToString()) ? false : Convert.ToBoolean(userpref.Menu_FleetMgmt) == true)
{
liFleetMgmt.Visible = true;
}
else
{
liFleetMgmt.Visible = false;
}
if (string.IsNullOrEmpty(userpref.GRRetRequired.ToString()) ? false : Convert.ToBoolean(userpref.GRRetRequired) == true)
{
liRetailMast.Visible = liRetailBookEntry.Visible = true;
hrfGRConsldRepRetlr.Visible = true;
}
else
{
liRetailMast.Visible = liRetailBookEntry.Visible = false;
hrfGRConsldRepRetlr.Visible = false;
}
}
private void userpref()
{
CommissionMasterDAL objGrprepDAL = new CommissionMasterDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
SessionValues svalue = new SessionValues();
// base.UsessionValue = svalue.FetchUsersAndComp(string.IsNullOrEmpty(Convert.ToString(Session["Visageuseridno"])) ? 0 : Convert.ToInt32(Session["Visageuseridno"]));
// conString = ConfigurationManager.ConnectionStrings["VisageConnectionString"].ToString();
svalue = null;
if (!Page.IsPostBack)
{
this.Title = "Manage Delivery Register";
this.BindDateRange();
ddlDateRange.SelectedIndex = 0;
ddlDateRange_SelectedIndexChanged(null, null);
this.BidFromCity();
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
tblUserPref obj = objChallanDelverdDAL.selectUserPref();
ddlTocity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);");
this.Countall();
ddlDateRange.Focus();
}
}
public void userpref()
{
PaymentToOwnDAL obj = new PaymentToOwnDAL();
tblUserPref userpref = obj.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
}
public tblUserPref selectUserPref()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref Objtbl = (from obj in db.tblUserPrefs select obj).FirstOrDefault();
return(Objtbl);
}
}
public tblUserPref selectuserpref()
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref userpref = (from UP in db.tblUserPrefs select UP).FirstOrDefault();
return(userpref);
}
}
private void userpref()
{
RateMasterRetailerDAL objGrprepDAL = new RateMasterRetailerDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
//IsWeight = Convert.ToBoolean(userpref.WeightWise_Rate);
}
private void BindGrid()
{
ChlnBookingDAL objChlnBookingDAL = new ChlnBookingDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
grdMain.DataSource = (DataTable)ViewState["dt"];
grdMain.DataBind();
}
private void PrintGRJainBulk(Int64 GRHeadIdno)
{
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string ServTaxNo = ""; string email = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
// string con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
#endregion
#region Page Load...
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
txtReceiptNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtReceiptDatefrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtReceiptDateto.Attributes.Add("onkeypress", "return notAllowAnything(event);");
InvoiceDAL objInvoiceDAL = new InvoiceDAL();
tblUserPref obj = objInvoiceDAL.SelectUserPref();
hidAdminApp.Value = Convert.ToString(obj.AdminApp_Inv);
if (Convert.ToBoolean(hidAdminApp.Value) == true)
{
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
grdMain.Columns[7].Visible = true;
}
else
{
grdMain.Columns[7].Visible = false;
}
}
else
{
grdMain.Columns[7].Visible = false;
}
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.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ddlFromCity.SelectedValue = Convert.ToString(base.UserFromCity);
this.BindDateRange();
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddldateRange.SelectedIndex = 0;
ddldateRange_SelectedIndexChanged(null, null);
Bind();
this.CountTotalRecords();
}
}
public tblUserPref GetUserPrefDetail()
{
tblUserPref uPref = null;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
uPref = db.tblUserPrefs.SingleOrDefault();
}
return(uPref);
}
private void GRPrep()
{
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
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 PanNo; 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");
# region Company Details
private void ClearControls()
{
lnkBtnNew.Visible = false;
txtGrno.Text = "";
ddlLocation.SelectedValue = "0";
grdMain.Visible = false;
hidMtrlRcptid.Value = hidMtrlTrnsfDt.Value = string.Empty;
lnkSubmit.Visible = true; ddlLocation.Enabled = true;
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
tblUserPref obj = objChallanDelverdDAL.selectUserPref();
ddlLocation.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
}
public int SaveUserPrefDetail(tblUserPref tblData)
{
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var data = db.tblUserPrefs.SingleOrDefault();
data.ReqShtgGST = tblData.ReqShtgGST;
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
// conString = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ToString();
conString = ApplicationFunction.ConnectionString();
UFinYear = base.FatchFinYear(1);
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.View == false)
{
lnkbtnPreview.Visible = true;
}
this.BindSenderName();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
drpBaseCity.SelectedValue = Convert.ToString(base.UserFromCity);
}
BindDateRange();
ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng);
SetDate();
TotalRecords();
InvoiceDAL objInvoiceDAL = new InvoiceDAL();
tblUserPref obj = objInvoiceDAL.SelectUserPref();
hidPrintType.Value = Convert.ToString(obj.InvPrint_Type);
}
txtDateFrom.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDateTo.Attributes.Add("onkeypress", "return notAllowAnything(event);");
ddlDateRange.Focus();
}
private void ClearControls()
{
lnkBtnNew.Visible = false;
txtLocGrAmnt.Text = "";
txtoutGrAmnt.Text = "";
txtNetAmnt.Text = "";
ddlToCity.SelectedIndex = 0;
ddlChallanDetl.SelectedValue = "0";
txtRcptNo.Text = string.Empty;
hidMtrlRcptid.Value = hidMtrlTrnsfDt.Value = string.Empty;
grdMain.DataSource = null;
grdMain.DataBind();
ddlToCity.Enabled = true;
ddlChallanDetl.Enabled = true;
lnkSubmit.Visible = true; ddlChallanDetl.Enabled = true; txtRcptNo.Visible = false; DivRcptNo.Visible = false; lblRcptDtNo.Text = "Receipt Date"; ddlToCity.Enabled = true;
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
tblUserPref obj = objChallanDelverdDAL.selectUserPref();
ddlToCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
}
public void PrintGRPrep(Int64 intGRIdno)
{
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
// HidsRenWages.Value = Convert.ToString(hiduserpref.WagesLabel_Print);
if (hiduserpref.Logo_Req == true && hiduserpref.Logo_Image != null)
{
imgLogoShow.Visible = true;
byte[] img = hiduserpref.Logo_Image;
string base64String = Convert.ToBase64String(img, 0, img.Length);
imgLogoShow.ImageUrl = "data:image/png;base64," + base64String;
}
else
{
imgLogoShow.Visible = false;
imgLogoShow.ImageUrl = "";
}
if (Convert.ToString(hiduserpref.Terms) == "" && Convert.ToString(hiduserpref.Terms1) == "")
{
lblTerms.Visible = false;
lblterms1.Visible = false;
}
else
{
lblTerms.Visible = true;
lblterms1.Visible = true;
lblTerms.Text = "'" + hiduserpref.Terms + "'";
lblterms1.Text = hiduserpref.Terms1;
}
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 PanNo; 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 = "";
string CompGSTIN = ""; string Email = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
public Int32 UpdateStatus(int intUsrPrefIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref objUserPrefence = (from mast in db.tblUserPrefs
where mast.UserPref_Idno == intUsrPrefIdno
select mast).FirstOrDefault();
if (objUserPrefence != null)
{
objUserPrefence.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
scriptManager.RegisterPostBackControl(this.lnkbtnPrintClick);
//con = ConfigurationManager.ConnectionStrings["TransportMandiConnectionString"].ConnectionString;
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;
}
txtInstDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
this.userpref(); this.BindDateRange();
Int32 intYearIdno = Convert.ToInt32(Convert.ToString(ddldateRange.SelectedValue) == "" ? 0 : Convert.ToInt32(ddldateRange.SelectedValue));
// ddlFromCity.SelectedValue = Convert.ToString(iFromCity);
this.BindReceiptType();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
this.BindCity();
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ddlFromCity.SelectedValue = Convert.ToString(base.UserFromCity);
ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng);
this.BindMaxNo(Convert.ToInt32(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue)), Convert.ToInt32(Convert.ToString(ddldateRange.SelectedValue) == "" ? 0 : Convert.ToInt32(ddldateRange.SelectedValue)));
this.BindCityANDLocation();
this.BindPartName();
this.BindCustBank();
PaymentToOwnDAL objChlnPayDAL = new PaymentToOwnDAL();
tblUserPref obj = objChlnPayDAL.selectuserpref();
hidPrintType.Value = Convert.ToString(obj.PayChln_Print);
ddldateRange.SelectedIndex = 0;
ddldateRange_SelectedIndexChanged(null, null);
ddlRcptType_SelectedIndexChanged(null, null);
if (Request.QueryString["q"] != null)
{
Populate(Convert.ToInt64(Request.QueryString["q"])); GridChlnDetails(Convert.ToInt32(ddlChallan.SelectedValue));
hidid.Value = Convert.ToString(Request.QueryString["q"]);
lnkbtnNew.Visible = true;
if ((string.IsNullOrEmpty(hidPrintType.Value) ? 0 : Convert.ToInt32(hidPrintType.Value)) == 1)
{
//lnkbtnPrintClick.Visible = true;
LinkButton1.Visible = false;
}
else
{
lnkbtnPrintClick.Visible = false;
//LinkButton1.Visible = true;
}
}
else
{
lnkbtnPrintClick.Visible = false;
lnkbtnNew.Visible = false;
LinkButton1.Visible = false;
}
if (Request.QueryString["ChlnIdno"] != null)
{
DirectPaymentFromGr(Convert.ToInt64(Request.QueryString["ChlnIdno"]));
}
ddldateRange.Focus();
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
#region Validation Messages for Challan Details
if (ddlTranspoter.SelectedIndex == 0)
{
this.ShowMessage("Please select Transporter."); ddlTranspoter.Focus(); return;
}
if (ddlTruckNo.SelectedIndex == 0)
{
this.ShowMessage("Please select Truck No."); ddlTruckNo.Focus(); return;
}
if (txtchlnRef.Text == "")
{
this.ShowMessage("Please Enter Challan Ref.No ."); ddlTruckNo.Focus(); return;
}
string msg = "";
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null)
{
if (dtTemp.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
#endregion
#region Declare Input Variables for Challan Details
//string strMsg = string.Empty;
//Int64 intGrPrepIdno = 0;
//Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddldateRange.SelectedValue);
//DateTime strChallanDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim().ToString()));
//Int64 intChallanNo = string.IsNullOrEmpty(txtchallanNo.Text.Trim()) ? 0 : Convert.ToInt64(txtchallanNo.Text.Trim());
//Int32 intTranspoter = string.IsNullOrEmpty(ddlTranspoter.SelectedValue) ? 0 : Convert.ToInt32(ddlTranspoter.SelectedValue);
//Int32 TruckNoIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue);
//Int32 strChlnRefno = string.IsNullOrEmpty(txtchlnRef.Text) ? 0 : Convert.ToInt32(txtchlnRef.Text);
//DateTime? dtInstDate;
//if (txtInstDate.Text == "")
//{
// dtInstDate = null;
//}
//else
//{
// dtInstDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
//}
#endregion
#region Insert/Update with Transaction
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
string intGrPrepIdno = "";
string ChlnNo = txtchallanNo.Text;
Int32 TrunckIdno = Convert.ToInt32(ddlTruckNo.SelectedValue);
Int32 YearIdno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
GRPrepDAL objDAL = new GRPrepDAL();
isTBBRate = objDAL.SelectTBBRate();
tblUserPref userpref = objDAL.selectuserpref();
itruckcitywise = Convert.ToInt32(userpref.Work_Type);
DataTable dtDetail = (DataTable)ViewState["dt"];
try
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
tblChlnBookHead objtblChlnBookHead = new tblChlnBookHead();
objtblChlnBookHead.Chln_No = txtchallanNo.Text;
objtblChlnBookHead.Chln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.BaseCity_Idno = Convert.ToInt32((DdlfromcityHead.SelectedIndex <= 0) ? "0" : DdlfromcityHead.SelectedValue);
objtblChlnBookHead.DelvryPlc_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue);
objtblChlnBookHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
objtblChlnBookHead.Driver_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Delvry_Instrc = "";
objtblChlnBookHead.Inv_Idno = 0;
objtblChlnBookHead.Gross_Amnt = Convert.ToDouble(txtgrossAmnt.Text);
objtblChlnBookHead.Commsn_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.Transprtr_Idno = Convert.ToInt32(ddlTranspoter.SelectedValue);
objtblChlnBookHead.Chln_type = 2;
objtblChlnBookHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objtblChlnBookHead.Other_Amnt = Convert.ToDouble(txtKattAmnt.Text);
objtblChlnBookHead.Work_type = Convert.ToInt32(hidWorkType.Value);
objtblChlnBookHead.Ref_No = Convert.ToString(txtchlnRef.Text);
objtblChlnBookHead.Adv_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.RcptType_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Bank_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Inst_No = Convert.ToInt32(0);
objtblChlnBookHead.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.Date_Added = Convert.ToDateTime(DateTime.Now);
Int64 value = 0;
if (string.IsNullOrEmpty(hidid.Value) == true)
{
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Insert(objtblChlnBookHead, dtTemp, intGrPrepIdno);
// obj = null;
}
else
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
Int32 ChlnIdno = Convert.ToInt32(hidid.Value);
TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == ChlnIdno).FirstOrDefault();
List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList();
foreach (TblGrDetl rgd in GrDetl)
{
db.TblGrDetls.DeleteObject(rgd);
db.SaveChanges();
}
db.TblGrHeads.DeleteObject(GrHEad);
db.SaveChanges();
db.Connection.Close();
}
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Update(objtblChlnBookHead, Convert.ToInt32(hidid.Value), dtTemp, intGrPrepIdno);
}
if (value > 0)
{
tScope.Complete();
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not Update");
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record saved Successfully ");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
tScope.Dispose();
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not saved Successfully ");
}
}
catch (Exception Ex)
{
tScope.Dispose();
}
#endregion
}
}
private void PrintGRPrep(Int64 GRHeadIdno)
{
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
lblConsigneeGSTIN.Text = "'" + hiduserpref.Terms + "'";
lblConsigneeGSTIN.Text = hiduserpref.Terms1;
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 PanNo; 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 = "";
GRPrepRetailerDAL objGRRet = new GRPrepRetailerDAL();
DataTable dt = objGRRet.SelectGRPrintKajaria(ApplicationFunction.ConnectionString(), GRHeadIdno);
//DataSet dsReport = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "EXEC [spGRPrep] @ACTION='SelectKajariaPrint',@Id='" + GRHeadIdno + "'");
if (dt != null && dt.Rows.Count > 0)
{
lblGRNo.Text = Convert.ToString(dt.Rows[0]["GrRet_No"]);
lblDate.Text = Convert.ToDateTime(dt.Rows[0]["GrRet_Date"]).ToString("dd-MM-yyyy");
lblFromCity.Text = Convert.ToString(dt.Rows[0]["From_City"]);
lblToCity.Text = Convert.ToString(dt.Rows[0]["To_City"]);
lblConsigneeName.Text = Convert.ToString(dt.Rows[0]["Sender"]);
lblConsigneeGSTIN.Text = Convert.ToString(dt.Rows[0]["SenderGSTIN"]);
lblConsignorName.Text = Convert.ToString(dt.Rows[0]["Receiver"]);
lblConsignorGSTIN.Text = Convert.ToString(dt.Rows[0]["ReceiverGSTIN"]);
lblRemark.Text = Convert.ToString(dt.Rows[0]["Remark"]);
lblDelvryPlace.Text = Convert.ToString(dt.Rows[0]["Delivery_Place"]);
lblValue.Text = Convert.ToString(dt.Rows[0]["Value"]);
lblRefInvNo.Text = Convert.ToString(dt.Rows[0]["Ref_No"]);
lblFreight.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Gross_Amnt"]));
lblSurcharge.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Stcharg_Amnt"]));
lblLabour.Text = "0";
lblPickUp.Text = "0";
lblLocalFreight.Text = "0";
lblBilty.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Bilty_Amnt"]));
lblDoorDel.Text = "0";
lblTotal.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Total_Amnt"]));
lblValue.Text = "0";
GSTIdno = dt.Rows[0]["GST_Idno"].ToString();
if (GSTIdno != String.Empty && GSTIdno == "1")
{
SGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["SGST_per"]));
CGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["CGST_Per"]));
SGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["SGST_Amt"]));
CGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["CGST_Amt"]));
lblGST.Text = (Convert.ToDouble(SGSTAmt == "" ? "0" : SGSTAmt) + Convert.ToDouble(CGSTAmt == "" ? "0" : CGSTAmt)).ToString("N2");
}
if (GSTIdno != String.Empty && GSTIdno == "2")
{
IGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["IGST_Per"]));
IGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["IGST_Amt"]));
lblGST.Text = (Convert.ToDouble(IGSTAmt == "" ? "0" : IGSTAmt)).ToString("N2");
}
if (GSTIdno != String.Empty && GSTIdno == "3")
{
UGSTPer = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["UGST_Per"]));
UGSTAmt = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["UGST_Amt"]));
lblGST.Text = (Convert.ToDouble(UGSTAmt == "" ? "0" : UGSTAmt)).ToString("N2");
}
lblGrossTotal.Text = string.Format("{0:0,0.00}", Convert.ToDouble(dt.Rows[0]["Gross_Amnt"]));
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
}
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();
}
}
/// <summary>
/// Insert records in LorryMast
/// </summary>
/// <param name="strNarrName"></param>
/// <param name="strLorryMake"></param>
/// <param name="bStatus"></param>
/// <returns></returns>
//public Int64 InsertLorryMast(string strLorryMake, string strOwnerName, Int32 LorryType, Int64 PartyName, string strChasisNo, string strEngineNo, string strLorryNo, string strPanNo, bool bStatus)
//{
// Int64 intValue = 0;
// Int32 intCompIdno = 1;
// try
// {
// using (TransportMandiEntities db = new TransportMandiEntities())
// {
// LorryMast objLorryMast = new LorryMast();
// objLorryMast.Lorry_Make = strLorryMake;
// objLorryMast.Owner_Name = strOwnerName;
// objLorryMast.Lorry_Type = LorryType;
// objLorryMast.Status = bStatus;
// objLorryMast.Comp_Idno = intCompIdno;
// objLorryMast.Prty_Idno = PartyName;
// objLorryMast.Chassis_no = strChasisNo;
// objLorryMast.Eng_No = strEngineNo;
// objLorryMast.Lorry_No = strLorryNo;
// objLorryMast.Pan_No = strPanNo;
// objLorryMast.Date_Added = System.DateTime.Now;
// if (IsExists(strOwnerName, 0) == true)
// {
// intValue = -1;
// }
// else
// {
// db.LorryMasts.AddObject(objLorryMast);
// db.SaveChanges();
// intValue = objLorryMast.Lorry_Idno;
// }
// }
// }
// catch (Exception ex)
// {
// //ApplicationFunction.ErrorLog(ex.ToString());
// }
// return intValue;
//}
/// <summary>
/// Update records in LorryMast
/// </summary>
/// <param name="strNarrName"></param>
/// <param name="strNarrDesc"></param>
/// <param name="bStatus"></param>
/// <param name="intNarrIdno"></param>
/// <returns></returns>
public Int64 UpdateUserPrefence(Int64 BaseCity, Int32 CmbType, Int32 InvoicePrint, Int32 ChallanPrint, String strWagesAs, Double ServTax, Double Surchage, Double Bility, Double Wages, Double TollTax, Double ServTxValid, Double StaxPan, bool bTbbRate, bool bTDS, bool GRrate, Int32 AmntRcvdAgnst, Int32 Rate_Invo_Gr, bool ExcelChln, Int32 PayChlnPrint, bool ContRate, bool CntrSBillReq, bool RateEdit, bool DisChlnEntry, bool AdminApproval, bool GrPrintWithoutHeader, int GRPrint, bool ItemGrade, String PFChanges, String TollTaxRename, String refrename, bool LogoReq, Int32 InvGrType, string Terms, string Terms1, string TnCGRRet, bool WeightWise_R, string HireslipTerms, bool GRRetRequired, string strCartage, string strCommission, string strBilty, bool TypeDel, string strStCharge, bool strWithGstAmnt, bool bLessChlnAmntInv, bool GstCalGr)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserPref objUserPrefence = (from mast in db.tblUserPrefs
select mast).FirstOrDefault();
if (objUserPrefence != null)
{
objUserPrefence.BaseCity_Idno = BaseCity;
objUserPrefence.Work_Type = CmbType;
objUserPrefence.InvPrint_Type = InvoicePrint;
objUserPrefence.ChlnPrint_Type = ChallanPrint;
objUserPrefence.WagesLabel_Print = strWagesAs;
objUserPrefence.ServTax_Perc = ServTax;
objUserPrefence.Surchg_Per = Surchage;
objUserPrefence.Bilty_Amnt = Bility;
objUserPrefence.Wages_Amnt = Wages;
objUserPrefence.TollTax_Amnt = TollTax;
objUserPrefence.GRRate = GRrate;
objUserPrefence.TDSEdit = bTDS;
objUserPrefence.ServTax_Valid = ServTxValid;
objUserPrefence.STaxPer_TDS = StaxPan;
objUserPrefence.TBB_Rate = bTbbRate;
objUserPrefence.Date_Added = System.DateTime.Now;
objUserPrefence.AmntRecvdAgnst_GRInvce = AmntRcvdAgnst;
objUserPrefence.Rate_Invo_Gr = Rate_Invo_Gr;
objUserPrefence.Chln_Excel = ExcelChln;
objUserPrefence.PayChln_Print = PayChlnPrint;
objUserPrefence.Cont_Rate = ContRate;
objUserPrefence.CntrSBill_Req = CntrSBillReq;
objUserPrefence.ShrtgRateChlnConf = RateEdit;
objUserPrefence.DisableChlnEntry = DisChlnEntry;
objUserPrefence.AdminApp_Inv = AdminApproval;
objUserPrefence.GRPrint_WithoutHeader = GrPrintWithoutHeader;
objUserPrefence.ItemGrade_Req = ItemGrade;
objUserPrefence.PFLabel_GR = PFChanges;
objUserPrefence.TollTaxLabel_GR = TollTaxRename;
objUserPrefence.Reflabel_Gr = refrename;
objUserPrefence.GRPrintPref = GRPrint;
objUserPrefence.Logo_Req = LogoReq;
objUserPrefence.InvGen_GrType = InvGrType;
objUserPrefence.Terms = Terms;
objUserPrefence.Terms1 = Terms1;
objUserPrefence.WeightWise_Rate = WeightWise_R;
objUserPrefence.HireslipTerms = HireslipTerms;
objUserPrefence.GRRetRequired = GRRetRequired;
objUserPrefence.CartageLabel_GR = strCartage;
objUserPrefence.CommissionLabel_Gr = strCommission;
objUserPrefence.BiltyLabel_GR = strBilty;
objUserPrefence.Terms_Con_Retailer = TnCGRRet;
objUserPrefence.TypeDelPlace = TypeDel;
objUserPrefence.StChargLabel_GR = strStCharge;
objUserPrefence.With_GstAmnt = strWithGstAmnt;
objUserPrefence.GstCal_Gr = GstCalGr;
if (LogoReq == false)
{
objUserPrefence.Logo_Image = null;
}
db.SaveChanges();
intValue = objUserPrefence.UserPref_Idno;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
private void PrintGRPrep(Int64 GRHeadIdno)
{
visiFalse.Visible = false;
Repeater obj = new Repeater();
GRPrepDAL obj1 = new GRPrepDAL();
tblUserPref hiduserpref = obj1.selectuserpref();
HidsRenWages.Value = Convert.ToString(hiduserpref.WagesLabel_Print);
hidRenamePF.Value = Convert.ToString(hiduserpref.PFLabel_GR);
hidRenameToll.Value = Convert.ToString(hiduserpref.TollTaxLabel_GR);
HidsRenCartage.Value = Convert.ToString(hiduserpref.CartageLabel_GR);
HidRenCommission.Value = Convert.ToString(hiduserpref.CommissionLabel_Gr);
HidRenBilty.Value = Convert.ToString(hiduserpref.BiltyLabel_GR);
//if (hiduserpref.Logo_Req == true && hiduserpref.Logo_Image != null)
//{
// imgLogoShow.Visible = true;
// byte[] img = hiduserpref.Logo_Image;
// string base64String = Convert.ToBase64String(img, 0, img.Length);
// imgLogoShow.ImageUrl = "data:image/png;base64," + base64String;
//}
//else
//{
// imgLogoShow.Visible = false;
// imgLogoShow.ImageUrl = "";
//}
//if (Convert.ToString(hiduserpref.Terms) == "" && Convert.ToString(hiduserpref.Terms1) == "")
//{
// lblTerms.Visible = false;
// lblterms1.Visible = false;
//}
//else
//{
// lblTerms.Visible = true;
// lblterms1.Visible = true;
// lblTerms.Text = "'" + hiduserpref.Terms + "'";
// lblterms1.Text = hiduserpref.Terms1;
//}
if (Convert.ToString(HidsRenWages.Value) != "")
{
lblUnloadingPrint.Text = Convert.ToString(HidsRenWages.Value);
labHam.Text = Convert.ToString(HidsRenWages.Value);
}
else
{
lblUnloadingPrint.Text = "Wages";
labHam.Text = "Wages";
}
if (Convert.ToString(hidRenamePF.Value) != "")
{
lblCollChargePrint.Text = Convert.ToString(hidRenamePF.Value);
labCollCha.Text = Convert.ToString(hidRenamePF.Value);
}
else
{
lblCollChargePrint.Text = "PF";
labCollCha.Text = "PF";
}
if (Convert.ToString(hidRenameToll.Value) != "")
{
lblDelChargesPrint.Text = Convert.ToString(hidRenameToll.Value);
labDelCha.Text = Convert.ToString(hidRenameToll.Value);
}
else
{
lblDelChargesPrint.Text = "Toll Tax";
labDelCha.Text = "Toll Tax";
}
if (Convert.ToString(HidsRenCartage.Value) != "")
{
lblFOVPrint.Text = Convert.ToString(HidsRenCartage.Value);
labFOV.Text = Convert.ToString(HidsRenCartage.Value);
}
else
{
lblFOVPrint.Text = "Cartage";
labFOV.Text = "Cartage";
}
if (Convert.ToString(HidRenCommission.Value) != "")
{
lblOctroiPrint.Text = Convert.ToString(HidRenCommission.Value);
labOctroi.Text = Convert.ToString(HidRenCommission.Value);
}
else
{
lblOctroiPrint.Text = "Commission";
labOctroi.Text = "Commission";
}
if (Convert.ToString(HidRenBilty.Value) != "")
{
lblDemuChargesPrint.Text = Convert.ToString(HidRenBilty.Value);
labDemCha.Text = Convert.ToString(HidRenBilty.Value);
}
else
{
labDemCha.Text = "Bilty";
lblDemuChargesPrint.Text = "Bilty";
}
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 = "", CompDesc = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; 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 = ""; string RegNo = "";
DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast");
# region Company Details
