//string CCon = ConfigurationManager.AppSettings["ConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.DisplayGroupTree = false;
RD = new ReportDocument();
ReportID = Request.QueryString["ReportID"];
if (ReportID == "PartItemLedger")
{
string StrToDateFrom = "", StrDateTo = "";
RD = new ReportDocument();
dsrpt = new DataSet1();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//DataSet ds1 = new DataSet();
StrToDateFrom = Request.QueryString["FromDate"];
StrDateTo = Request.QueryString["ToDate"];
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0
new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Request.QueryString["FromCode"].ToString();
param[2].Value = Request.QueryString["ToCode"].ToString();
param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd");
param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd");
ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param);
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'");
//dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader());
RD.Load(base.Server.MapPath("rptItemStockLedger.rpt"));
//RD.Load(base.Server.MapPath("rptLedger.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["FromDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["ToDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\"";
RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
// RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
}
CrystalReportViewer1.ReportSource = RD;
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2544", "004"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (SysFunc.CheckVoucherPostFlag(Session["DealerCode"].ToString(), txtVoucherNo.Text))
{
SysFunc.UserMsg(LbErr, Color.Red, "Can't Edit or Delete the Voucher '" + txtVoucherNo.Text + "' is already Posted");
return;
}
SysFunc.UpdateJV(Session["DealerCode"].ToString(), txtVoucherNo.Text);
string ItemCode = string.Empty;
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
ItemCode = gvr.Cells[1].Text;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10), //0
new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //1
new SqlParameter("@GRNNo", SqlDbType.Char, 8), //2
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPayInvNo.SelectedValue.ToString();
param[2].Value = ddlGRN.SelectedValue.ToString().Trim();
param[3].Value = ItemCode;
if (SysFunc.ExecuteSP_NonQuery("sp_PurInvMasterDetail_Delete", param))
{
SysFunc.UserMsg(LbErr, Color.Green, "Deleted Successfully");
btnClear_Click(BtnDelete, EventArgs.Empty);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Deletealert()", true);
}
else
{
SysFunc.UserMsg(LbErr, Color.Red, "Record not delete Try again");
}
}
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2582", "002"))
{
Response.Redirect("~/Test.aspx");
}
if (txtExtno.Text != "")
{
if (!sec.UserRight("2582", "003"))
{
Response.Redirect("~/Test.aspx");
}
}
TextBox[] textBoxes = { txtExtno, txtLossNo };
try
{
SqlParameter[] CustomerEstimate_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@CustomerEstimateCode", SqlDbType.Char, 8),
/*2*/ new SqlParameter("@LossDate", SqlDbType.DateTime),
/*3*/ new SqlParameter("@LossNo", SqlDbType.VarChar, 50),
};
CustomerEstimate_param[0].Value = Session["DealerCode"].ToString();
CustomerEstimate_param[1].Value = txtExtno.Text;
CustomerEstimate_param[2].Value = SysFunc.SaveDate(txtCreateDate.Text);
CustomerEstimate_param[3].Value = txtLossNo.Text.Trim();
if (SysFunc.ExecuteSP_NonQuery("[sp_Update_CustomerEstimate_LossNo]", CustomerEstimate_param))
{
SysFunc.UserMsg(lblMsg, Color.Green, "Record Saved Successfully: " + txtExtno.Text, txtExtno);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true);
}
else
{
SysFunc.UserMsg(lblMsg, Color.Green, "Record Not Saved Successfully: " + txtExtno.Text, txtExtno);
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
private void Save_InsertMasterDetail(SqlTransaction Trans, string strIssueDate, string strReqSource, string strJobCardNO, string strInvoiceNo, ref bool Check, ref string StrReturnNo)
{
string StrIssueDate = "";
try
{
StrIssueDate = txtRetDate.Text;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1
new SqlParameter("@ReturnDate", SqlDbType.DateTime), //2
new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3
new SqlParameter("@ReqSource", SqlDbType.VarChar, 10), //4
new SqlParameter("@JobCardNO", SqlDbType.Char, 8), //5
new SqlParameter("@InvoiceNo", SqlDbType.Char, 8), //6
new SqlParameter("@Remarks", SqlDbType.VarChar, 70), //7
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //9
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = SysFunc.AutoGen("StockReturn", "ReturnNo", txtRetDate.Text.Trim());;
param[2].Value = SysFunc.SaveDate(txtRetDate.Text);
param[3].Value = ddlIssueNo.SelectedValue.ToString().Trim();
param[4].Value = strReqSource.Trim();
param[5].Value = strJobCardNO.Trim();
param[6].Value = strInvoiceNo.Trim();
param[7].Value = txtRemarks.Text.Replace("'", " ");
param[8].Value = Session["UserName"].ToString();
param[9].Value = GlobalVar.mUserIPAddress;;
if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturne_Insert", param, Trans))
{
StrReturnNo = param[1].Value.ToString();
for (int i = 0; i < GvMain.Rows.Count; i++)
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //2
new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3
new SqlParameter("@PartsTransLocCode", SqlDbType.VarChar, 7), //4
new SqlParameter("@ReturnQty", SqlDbType.Float), //5
new SqlParameter("@Rate", SqlDbType.Float), //6
new SqlParameter("@Amount", SqlDbType.Float) //7
};
Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode");
Label LbPartsTransLocCode = (Label)GvMain.Rows[i].FindControl("LbPartsTransLocCode");
HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode");
Label LbRetQty = (Label)GvMain.Rows[i].FindControl("LbRetQty");
Label LbAmount = (Label)GvMain.Rows[i].FindControl("LbAmount");
Label LbRate = (Label)GvMain.Rows[i].FindControl("LbRate");
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = StrReturnNo;
param1[2].Value = LbItemCode.Text;
param1[3].Value = ddlIssueNo.SelectedValue.ToString().Trim();
param1[4].Value = HDPartsTransLocCode.Value;
param1[5].Value = LbRetQty.Text;
param1[6].Value = LbRate.Text;
param1[7].Value = LbAmount.Text;
if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturneDetail_Insert", param1, Trans))
{
Check = true;
}
else
{
Check = false;
break;
}
}
}
}
catch (Exception ex)
{
LbErr.Text = ex.Message;
}
}
protected void btnLookup_Click(object sender, EventArgs e)
{
DataTable dtSMSApplic = new DataTable();
DataTable dtQuery = new DataTable();
DataTable dtMessage = new DataTable();
string DealerCode = "00249";
string squery = "Select * from BMS_SMSApplicable where IsActive = 'Y'";
dtSMSApplic = myFunc.GetData(squery);
DataRow[] dr = dtSMSApplic.Select();
for (int j = 0; j < dr.Length; j++)
{
string squery1 = dtSMSApplic.Rows[j]["squery"].ToString().Trim() + "and A.DealerCode = '" + DealerCode + "'";
dtQuery = myFunc.GetData(squery1);
DataRow[] drr = dtQuery.Select();
for (int i = 0; i < drr.Length; i++)
{
SqlParameter[] param3 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@DMSRefNo", SqlDbType.Char, 8),
new SqlParameter("@CustomerCode", SqlDbType.VarChar, 8),
new SqlParameter("@CustomerDes", SqlDbType.VarChar, 50),
new SqlParameter("@Module", SqlDbType.VarChar, 10),
new SqlParameter("@ModuleType", SqlDbType.VarChar, 10),
new SqlParameter("@SMSApplicCode", SqlDbType.Char, 5),
};
if (dtQuery.Rows[i]["DMSRefNo"].ToString() != "")
{
param3[0].Value = Session["DealerCode"].ToString();
param3[1].Value = dtQuery.Rows[i]["DMSRefNo"].ToString();
param3[2].Value = dtQuery.Rows[i]["CustomerCode"].ToString();
param3[3].Value = dtQuery.Rows[i]["CustomerDes"].ToString();
param3[4].Value = dtQuery.Rows[i]["Module"].ToString();
param3[5].Value = dtQuery.Rows[i]["ModuleType"].ToString();
param3[6].Value = dtSMSApplic.Rows[j]["SMSApplicCode"].ToString();
myFunc.ExecuteSP_NonQuery("SP_Insert_BMS_SMSTransMaster", param3);
}
}
//string query3 = "exec SP_SMSMessage '" + Session["DealerCode"].ToString() + "' , '" + dtSMSApplic.Rows[j]["SMSApplicCode"].ToString().Trim() + "'";
//string AutoNum = "";
//dtMessage = myFunc.GetData(query3);
//drr = dtMessage.Select();
//for (int i = 0; i < drr.Length; i++)
//{
// string username = "******";
// string password = "******";
// string from = "MasterMotor";
// if (dtMessage.Rows[i]["CellNo"].ToString().StartsWith("0"))
// {
// AutoNum = "92" + dtMessage.Rows[i]["CellNo"].ToString().Substring(dtMessage.Rows[i]["CellNo"].ToString().Length - (dtMessage.Rows[i]["CellNo"].ToString().Length - 1));
// }
// string to = AutoNum;
// string message = dtMessage.Rows[i]["Message"].ToString();
// //string urlString = string.Format("http://weblogin.premiumsms.pk/sendsms_url.html?Username={0}&Password={1}&From={2}&To={3}&Message={4}", username, password, from, to, message);
// //Uri URI = new Uri(urlString);
// //WebClient wc = new WebClient();
// //string res = wc.DownloadString(URI);
// string qry = "Update BMS_SMSTransMaster set SMSText = '" + message + "' ,"+
// " SMSApplicCode = '" + dtSMSApplic.Rows[j]["SMSApplicCode"].ToString() + "' ,"+
// " SMSTo = '" + to + "', SMSFrom = '" + from + "' , "+
// " SendDate ='" + myFunc.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")) + "',"+
// " where SMSTransID = '"+ dtMessage.Rows[i]["SMSTransID"].ToString() + "'";
// myFunc.ExecuteQuery_NonQuery(qry);
//}
}
}
//protected void ChkBox_CheckedChanged(object sender, EventArgs e)
//{
// if (ChkBox.Checked)
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// TotalAmount = TotalAmount + Convert.ToDecimal(gvr.Cells[5].Text.Trim());
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = true;
// }
// txtTotalAmount.Text = TotalAmount.ToString();
// CalculatePSTPercentage();
// }
// else
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = false;
// txtTotalAmount.Text = "0.00";
// //txtPstAmt.Text = "0.00";
// }
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2583", "002"))
{
Response.Redirect("~/Test.aspx");
}
try
{
int grd = Grdbillings.Rows.Count;
if (grd > 0)
{
//Auto Generated Code//
DateTime dt = DateTime.Now;
string strYear = dt.Year.ToString();
string BillNo;
if (ddlBillingNo.SelectedValue.Trim() == "0")
{
BillNo = ObjGenral.AutoGen("JENBillMaster", "JENBillNo", DateTime.Now.ToString("dd-MM-yyyy"));
}
else
{
BillNo = ddlBillingNo.SelectedValue.Trim();
}
//Auto Generated Code//
string Remarks = txtRemarks.Text.Trim().ToString();
float BillRecAmount = 0;
string DelFlag = "N", PostFlag = "N";
string UpdUser = Session["UserName"].ToString();
//FFI PDI Master Insert here
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@BillDate", SqlDbType.DateTime), //2
new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //3
new SqlParameter("@BillQty", SqlDbType.Int), //4
new SqlParameter("@BillAmount", SqlDbType.Float, 15), //5
new SqlParameter("@BillRecAmount", SqlDbType.Float, 15), //6
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8
new SqlParameter("@UpdUser", SqlDbType.VarChar, 5), //9
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//10
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//11
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //12
new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //13
new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //14
new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //15
new SqlParameter("@SoftwareVersion", SqlDbType.VarChar, 25), //16
new SqlParameter("@BillType", SqlDbType.VarChar, 5), //17
new SqlParameter("@VehType", SqlDbType.Char, 3), //17
new SqlParameter("@CreditNo", SqlDbType.VarChar, 50), //17
new SqlParameter("@GSTAmount", SqlDbType.Decimal, 50), //17
new SqlParameter("@SSTAmount", SqlDbType.Decimal, 50), //17
//new SqlParameter("@SSTAge",SqlDbType.Decimal,18),//18
//new SqlParameter("@SSTAmount",SqlDbType.Decimal,18),//19
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = BillNo;
param[2].Value = ObjGenral.SaveDate(txtBillDate.Text);
//param[2].Value = txtBillDate.Text;
param[3].Value = Remarks.ToUpper();
param[4].Value = Grdbillings.Rows.Count;
param[5].Value = txtTotalAmount.Text.Trim().ToString();
param[6].Value = BillRecAmount;
param[7].Value = DelFlag;
param[8].Value = PostFlag;
param[9].Value = Session["UserName"].ToString();
//param[10].Value = ObjGenral.SaveDate(DateTime.Now.ToString());
//param[11].Value = ObjGenral.SaveTime(DateTime.Now.ToString());
param[10].Value = GlobalVar.mUserIPAddress;
param[11].Value = "C";
param[12].Value = null;
param[13].Value = null;
param[14].Value = null;
param[15].Value = ddlTypes.SelectedValue.ToString();
param[16].Value = txtCreditNo.Text;
param[17].Value = txtGSTAmt.Text.Trim();
param[18].Value = txtLabPST.Text.Trim();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillMaster_Insert", param, Trans))
{
lblLastBillNo.Text = "Last Code Generated : " + " " + BillNo;
}
}
else
{
lblMessage.Text = "Error";
}
//FFI PDI Master Insert here
//Insert Detail Data Here
foreach (GridViewRow gvr in Grdbillings.Rows)
{
string DealerCode = Session["DealerCode"].ToString();
string PPRCode = gvr.Cells[1].Text.Trim().ToString();
string BillNoDetail = BillNo;
// string Billtype = ddlTypes.SelectedValue.ToString();
string BillAmount = gvr.Cells[5].Text.Trim().ToString();
CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@JENBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@PPRCode", SqlDbType.Char, 8), //2
new SqlParameter("@PPRDate", SqlDbType.DateTime), //3
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 15), //4
new SqlParameter("@Parts", SqlDbType.Float), //5
new SqlParameter("@Sublet", SqlDbType.Float), //6
new SqlParameter("@Labor", SqlDbType.Float), //7
new SqlParameter("@TotalAmount", SqlDbType.Float), //8
new SqlParameter("@GSTAmount", SqlDbType.Float), //9
new SqlParameter("@PSTLaborAmount", SqlDbType.Float), //10
new SqlParameter("@PSTSublet", SqlDbType.Float), //11
new SqlParameter("@HandlingAmount", SqlDbType.Float), //12
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = BillNoDetail;
param1[2].Value = PPRCode;
param1[3].Value = sysFunc.SaveDate(gvr.Cells[2].Text.Trim().ToString());
param1[4].Value = gvr.Cells[4].Text.Trim().ToString();
param1[5].Value = SysFunctions.CustomCDBL(gvr.Cells[12].Text);
param1[6].Value = SysFunctions.CustomCDBL(gvr.Cells[13].Text);
param1[7].Value = SysFunctions.CustomCDBL(gvr.Cells[14].Text);
param1[8].Value = SysFunctions.CustomCDBL(gvr.Cells[15].Text);
param1[9].Value = SysFunctions.CustomCDBL(gvr.Cells[7].Text);
param1[10].Value = SysFunctions.CustomCDBL(gvr.Cells[9].Text);
param1[11].Value = SysFunctions.CustomCDBL(gvr.Cells[11].Text);
param1[12].Value = SysFunctions.CustomCDBL(gvr.Cells[6].Text);
// param1[3].Value = Billtype;
if (Chk.Checked == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1, Trans))
{
lblMessage.Text = "Record Has been Inserted Sucessfully !!!";
ClearAll();
}
// ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1,Trans);
}
//Insert Detail Data Here
}
}
else
{
string script = "alert(\"User should select some Bills !!!\");";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true);
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Text = ex.Message;
}
ObjTrans.CommittTransaction(ref Trans);
}
//protected void ddlFromCode_SelectedIndexChanged(object sender, EventArgs e)
//{
// ddlToCode.SelectedValue = ddlFromCode.SelectedValue;
//}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2574", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (txtFromItemCode.Text == "")
{
//ObjGenral.UserMsg(lblMsg, Color.Red, "Please Select From Code ");
//ddlFromCode.Focus();
return;
}
if (txtToItemCode.Text == "")
{
//ObjGenral.UserMsg(lblMsg, Color.Red, "Please Select To Code ");
//ddlToCode.Focus();
return;
}
ReportDocument RD;
ReportDocument crReportDocument;
ReportDocument rpt;
SqlDataReader rder;
string ReportID = "";
DXBMS.Data.DataSet1 dsrpt;
SysFunctions ObjSysFunc = new SysFunctions();
string FromDate = txtFromDate.Text.Substring(6, 4) + "/" + txtFromDate.Text.Substring(3, 2) + "/" + txtFromDate.Text.Substring(0, 2);
string ToDate = txtToDate.Text.Substring(6, 4) + "/" + txtToDate.Text.Substring(3, 2) + "/" + txtToDate.Text.Substring(0, 2);
string RptName = "PartItemLedger";
RD = new ReportDocument();
string StrToDateFrom = "", StrDateTo = "";
RD = new ReportDocument();
dsrpt = new DXBMS.Data.DataSet1();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//DataSet ds1 = new DataSet();
StrToDateFrom = FromDate;
StrDateTo = ToDate;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0
new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtFromItemCode.Text;
param[2].Value = txtToItemCode.Text;
param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd");
param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd");
ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param);
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'");
dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader());
//RD.Load(base.Server.MapPath("rptItemStockLedger.rpt"));
RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/rptItemStockLedger.rpt"));
//RD.Load(Server.MapPath("~/Modules/Reports/rptStockLedgerNew.rpt"));
// //RD.Load(base.Server.MapPath("rptLedger.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(FromDate).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(ToDate).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
RD.SetDataSource(dsrpt);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "PartItemLedger" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
////crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS");
//// ConnectionInfo conninfo = new ConnectionInfo();
//Session["RD"] = RD;
////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
////crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
private bool InsertCustomer()
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@CusCode", SqlDbType.Char, 8), //1
new SqlParameter("@CusDesc", SqlDbType.VarChar, 50), //2
new SqlParameter("@FatherHusName", SqlDbType.VarChar, 50), //3
//new SqlParameter("@AuxCusCode
new SqlParameter("@Address1", SqlDbType.VarChar, 50), //4
new SqlParameter("@Address2", SqlDbType.VarChar, 50), //5
new SqlParameter("@Address3", SqlDbType.VarChar, 50), //6
new SqlParameter("@ContPerson", SqlDbType.VarChar, 50), //7
new SqlParameter("@CreditDays", SqlDbType.Int), //8
new SqlParameter("@CreditLimit", SqlDbType.Float), //9
new SqlParameter("@NIC", SqlDbType.VarChar, 50), //10
new SqlParameter("@CusTypeCode", SqlDbType.Char, 3), //11
new SqlParameter("@DOB", SqlDbType.DateTime), //12
new SqlParameter("@Phone1", SqlDbType.VarChar, 15), //13
new SqlParameter("@Phone2", SqlDbType.VarChar, 15), //14
new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //15
new SqlParameter("@FaxNo", SqlDbType.VarChar, 15), //16
new SqlParameter("@Email", SqlDbType.VarChar, 50), //17
new SqlParameter("@URL", SqlDbType.VarChar, 50), //18
new SqlParameter("@NTNno", SqlDbType.VarChar, 15), //19
new SqlParameter("@AdvanceReceipt", SqlDbType.Float), //20
//new SqlParameter("@AccountCode
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //21
//new SqlParameter("@UpdDate",SqlDbType .DateTime ),//22
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //23
new SqlParameter("@SalesTaxRegNo", SqlDbType.VarChar, 30), //24
new SqlParameter("@Behavior", SqlDbType.Char, 6), //25
new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //26
new SqlParameter("@Distance", SqlDbType.Int) //27
};
param[0].Value = Session["DealerCode"].ToString();
if (ddCustomerCode.Text.Trim() == string.Empty)
{
AutoGenCode = myFunc.GetNewMaxID("Customer", "CusCode", 8, Session["DealerCode"].ToString());
//txtCustCode.Text = AutoGenCode;
param[1].Value = AutoGenCode;
}
else
{
param[1].Value = ddCustomerCode.Text;
}
param[2].Value = txtCustomerName.Text.Trim().ToUpper();
param[3].Value = txtFatherHusband.Text.Trim().ToUpper();
param[4].Value = txtAddress1.Text.Trim().ToUpper();
param[5].Value = txtAddress2.Text.Trim().ToUpper();
param[6].Value = txtAddress3.Text.Trim().ToUpper();
param[7].Value = txtContactPerson.Text.Trim().ToUpper();
if (spnCreditDays.Text.Trim() == "")
{
spnCreditDays.Text = "0";
param[8].Value = spnCreditDays.Text;
}
else
{
param[8].Value = spnCreditDays.Text;
}
if (txtCreditLimit.Text.Trim() == "")
{
txtCreditLimit.Text = "0.00";
param[9].Value = txtCreditLimit.Text;
}
else
{
param[9].Value = txtCreditLimit.Text;
}
param[10].Value = txtNICNo.Text;
param[11].Value = cmbCustomerType.Text;
if (dpDOB.Date.Year > 1900)
{
param[12].Value = dpDOB.Date;
}
param[13].Value = txtPhoneNumber.Text;
param[14].Value = txtPhoneNumber2.Text;
param[15].Value = txtCellNumber.Text;
param[16].Value = txtFaxNumber.Text;
param[17].Value = txtEmail.Text;
param[18].Value = txtURL.Text;
param[19].Value = txtNTNNo.Text;
param[20].Value = DBNull.Value;
param[21].Value = Session["UserName"].ToString();
//param[22].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy"));
param[22].Value = GlobalVar.mUserIPAddress; // SessionInformation.MachineIP;
param[23].Value = txtSaleTaxRegNo.Text;
param[24].Value = "GOOD";
param[25].Value = DBNull.Value;
if (txtDistance.Text == "")
{
txtDistance.Text = "0";
param[26].Value = txtDistance.Text;
}
else
{
param[26].Value = txtDistance.Text;
}
if (myFunc.ExecuteSP_NonQuery("sp_Sales_Insert_Customer", param))
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (myFunc.CodeExists("JobCardMaster", "EngineNo", txtEngNo.Text.Trim(), " And GatePass='' "))
{
lblMSG.Text = "Can not update this Engine number use in Job Card " + txtEngNo.Text;
PopupControlMSG.ShowOnPageLoad = true;
return;
}
else
{
lblMasg.Text = "";
}
if (myFunc.CodeExists("JobCardMaster", "ChassisNo", txtChassisNo.Text.Trim(), " And GatePass='' "))
{
lblMSG.Text = "Can not update this Chassis number use in Job Card " + txtChassisNo.Text;
PopupControlMSG.ShowOnPageLoad = true;
return;
}
else
{
lblMasg.Text = "";
}
//TextBox[] textBoxes = { txtCustomerCode, txtEndUser, txtRegDate, txtRegNo, txtEngineNo, txtChassisNo, txtProduct, txtInvoiceNo, txtInvoiceDate };
if (txtCustomerName.Text.Trim() == "" || txtEndUserName.Text.Trim() == "" || txtChassisNo.Text.Trim() == "" || txtEngNo.Text.Trim() == "")
{
return;
}
else
{
/// Validate from SMIS Database of Engine number ///
DataSet dsValidate = new DataSet();
DateTime InvDate = dpInvoiceDate.Date;
if (cmbBrand.Value.ToString().Trim() == "001")
{
//if (InvDate >= Convert.ToDateTime("2009-10-01"))
//{
// SqlParameter[] paramData = {
// new SqlParameter("@EngineNo",SqlDbType.VarChar,5),
// new SqlParameter ("@Chk" ,SqlDbType.Char,1)
// };
// paramData[0].Value = txtEngNo.Text;
// paramData[1].Value = "Y";
// dsValidate = SqlHelper.ExecuteDataset(GlobalVar.mCon, "sp_2W_Get_NewVehicleInfo_SDMS", paramData);
// if (dsValidate.Tables[0].Rows.Count > 0)
// {
// if (dsValidate.Tables[0].Rows[0]["ChasisNo"].ToString() != txtChassisNo.Text.Trim())
// {
// lblMSG.Text = "Enter valid Chassis No."+ txtChassisNo.Text;
// PopupControlMSG.ShowOnPageLoad = true;
// return;
// }
// if (dsValidate.Tables[0].Rows[0]["ProdCode"].ToString() != cmbProdCode.Text.Trim())
// {
// lblMSG.Text = "Enter valid Product Code." + cmbProdCode.Text;
// PopupControlMSG.ShowOnPageLoad = true;
// return;
// }
// //if(txtInvoiceNo.Text .Trim () >
// //if (dsValidate.Tables[0].Rows[0]["InvoiceNo"].ToString() != txtInvoiceNo.Text.Trim())
// //{
// // grl.UserMsg(lblMasg, Color.Red, "Enter valid InvoiceNo.", txtInvoiceNo );
// // return;
// //}
// //if (Convert.ToDateTime (dsValidate.Tables[0].Rows[0]["InvoiceDate"].ToString ()).ToString ("dd/MM/yyyy") != InvDate.ToString ("dd/MM/yyyy"))
// //{
// // grl.UserMsg(lblMasg, Color.Red, "Enter valid InvoiceDate.", txtInvoiceDate );
// // return;
// //}
// if (dsValidate.Tables[0].Rows[0]["VersionCode"].ToString() != txtVersion.Text)
// {
// lblMSG.Text = "Enter valid Version Code" + txtVersion.Text;
// PopupControlMSG.ShowOnPageLoad = true;
// return;
// }
// }
// else
// {
// lblMSG.Text = "Enter valid Engine No." + txtEngNo.Text;
// PopupControlMSG.ShowOnPageLoad = true;
// return;
// }
//}
}
////////////////////////////////////////////////
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.VarChar, 5), //0
new SqlParameter("@CusCode", SqlDbType.VarChar, 8), //1
new SqlParameter("@EndUserCode", SqlDbType.Char, 8), //2
new SqlParameter("@CtdDate", SqlDbType.DateTime), //3
new SqlParameter("@RegNo", SqlDbType.VarChar, 15), //4
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30), //5
new SqlParameter("@EngineNo", SqlDbType.VarChar, 30), //6
new SqlParameter("@BrandCode", SqlDbType.Char, 3), //7
new SqlParameter("@ProdCode", SqlDbType.VarChar, 10), //8
new SqlParameter("@VersionCode", SqlDbType.Char, 3), //9
new SqlParameter("@ColorCode", SqlDbType.Char, 5), //10
new SqlParameter("@InvoiceNo", SqlDbType.VarChar, 25), //11
new SqlParameter("@InvoiceDate", SqlDbType.DateTime), //12
new SqlParameter("@InsCompCode", SqlDbType.Char, 4), //13
new SqlParameter("@InsPolicyNo", SqlDbType.VarChar, 25), //14
new SqlParameter("@LossNo", SqlDbType.VarChar, 15), //15
new SqlParameter("@MeterReading", SqlDbType.VarChar, 10), //16
new SqlParameter("@MonthReading", SqlDbType.VarChar, 4), //17
new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //18
new SqlParameter("@UpdUser", SqlDbType.VarChar, 30), //19
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 30) //20
};
// 101 = Not Available
// 102 = Not Understand
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = cmbCustomerCode.Text.Trim().ToUpper();
param[2].Value = cmbEndUser.Text.Trim().ToUpper();
param[3].Value = myFunc.SaveDate(dpRegDate.Text);
param[4].Value = txtRegNo.Text.Trim().ToUpper().ToUpper();
param[5].Value = txtChassisNo.Text.Trim().ToUpper();
param[6].Value = txtEngNo.Text.Trim().ToUpper();
param[7].Value = cmbBrand.Value.ToString().Trim();
param[8].Value = cmbProdCode.Text.Trim();
param[9].Value = txtVersion.Text.Trim();
param[10].Value = cmbColorCode.Text.Trim();
param[11].Value = txtInvoiceNo.Text.Trim();
param[12].Value = myFunc.SaveDate(dpInvoiceDate.Text);
param[13].Value = cmbInsCode.Text.Trim();
param[14].Value = txtPolicyNo.Text.Trim();
param[15].Value = "102"; // new SqlParameter("@LossNo",SqlDbType.VarChar,15),
param[16].Value = "101"; // new SqlParameter("@MeterReading",SqlDbType.VarChar,10),
param[17].Value = "101"; // new SqlParameter("@MonthReading",SqlDbType.VarChar,4),
param[18].Value = "101"; // new SqlParameter("@Remarks",SqlDbType.VarChar,100),
param[19].Value = Session["UserName"].ToString().ToUpper();
param[20].Value = Environment.MachineName;
//select * from brand where BrandCode=''
//select * from version Where Version=''
//select * from customer where CusCode=''
//select * from vehicle where BrandCode=='' and ProdCode='' and VersionCode='' and ColorCode
//select * from color where ColorCode = ''
try
{
if ((myFunc.IsExist("CusCode", cmbCustomerCode.Text, "Customer", Session["DealerCode"].ToString()) == true))
{
if ((myFunc.IsExist("BrandCode", cmbBrand.Value.ToString(), "Brand", Session["DealerCode"].ToString()) == true))
{
if ((myFunc.IsExist("VersionCode", txtVersion.Text, "Vehicle", Session["DealerCode"].ToString()) == true))
{
// apStr = " and versioncode=" + txtVersion.Text + " and ProdCode='" + txtProduct.Text + "'";
if ((myFunc.IsExist("ColorCode", cmbColorCode.Text, "Vehicle", Session["DealerCode"].ToString()) == true))
{
if (!myFunc.IsExist("RegNo", txtRegNo.Text, "CustomerVehicle", Session["DealerCode"].ToString())
& !myFunc.IsExist("ChassisNo", txtChassisNo.Text, "CustomerVehicle", Session["DealerCode"].ToString())
& !myFunc.IsExist("EngineNo", txtEngNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()))
{
if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Insert", param))
{
lblMSG.Text = "Record Saved!" + txtVersion.Text;
PopupControlMSG.ShowOnPageLoad = true;
GetDataLoaded(true, false);
btnDelete.Enabled = true;
}
else
{
lblMSG.Text = "Record Not Saved!";
PopupControlMSG.ShowOnPageLoad = true;
}
}
else
{
apStr = " and ChassisNo ='" + txtChassisNo.Text + "' and jobstatus = null and GatePass = null";
if (myFunc.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString())
& myFunc.IsExist("EngineNo", txtEngNo.Text, "JobCardMaster", Session["DealerCode"].ToString()))
{
if (myFunc.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString(), apStr))
{
lblMSG.Text = "Record can not be updated";
PopupControlMSG.ShowOnPageLoad = true;
return;
}
else
{
if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param))
{
// objMBLL.ShowMessageBox("Record Updated", txtCustomerCode);
lblMSG.Text = "Record Updated";
PopupControlMSG.ShowOnPageLoad = true;
GetDataLoaded(true, false);
}
else
{
lblMSG.Text = "Record Not updated";
PopupControlMSG.ShowOnPageLoad = true;
}
}
}
else
{
if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param))
{
//objMBLL.ShowMessageBox("Record Updated", txtCustomerCode);
lblMSG.Text = "Record updated";
PopupControlMSG.ShowOnPageLoad = true;
GetDataLoaded(true, false);
}
else
{
lblMSG.Text = "Record can not be updated";
PopupControlMSG.ShowOnPageLoad = true;
}
}
}
}
}
else
{
//objMBLL.ShowMessageBox("'Version' not exist! ", txtCustomerCode);
lblMSG.Text = "Version not exist";
PopupControlMSG.ShowOnPageLoad = true;
}
}
else
{
lblMSG.Text = "Product not exist!";
PopupControlMSG.ShowOnPageLoad = true;
}
}
else
{
lblMSG.Text = "Brand not exist";
PopupControlMSG.ShowOnPageLoad = true;
}
}
catch (Exception ex)
{
var LineNumber = new StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
lblMSG.Text = "Error : " + ex.Message + "/" + ex.StackTrace.ToString() + "/" + LineNumber.ToString();
PopupControlMSG.ShowOnPageLoad = true;
}
}
}
private bool InsertPPRMaster(SqlTransaction Trans)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@PPRCode", SqlDbType.Char, 8), //1
new SqlParameter("@JobCardCode", SqlDbType.Char, 8), //2
new SqlParameter("@PPRDate", SqlDbType.DateTime), //3
new SqlParameter("@CusCode", SqlDbType.Char, 8), //4
new SqlParameter("@UserName", SqlDbType.Char, 75), //5
new SqlParameter("@UserAddress1", SqlDbType.VarChar, 100), //6
new SqlParameter("@UserPhoneNo", SqlDbType.Char, 50), //7
new SqlParameter("@VehEngineNo", SqlDbType.VarChar, 30), //8
new SqlParameter("@VehChassisNo", SqlDbType.VarChar, 30), //9
new SqlParameter("@VehRegNo", SqlDbType.Char, 15), //10
new SqlParameter("@InvoiceDate", SqlDbType.DateTime), //11
new SqlParameter("@MeterReadingKM", SqlDbType.Char, 5), //12
new SqlParameter("@DateOfProblem", SqlDbType.DateTime), //13
new SqlParameter("@RoadCondition", SqlDbType.Char, 10), //14
new SqlParameter("@NoOfProblems", SqlDbType.Int), //15
new SqlParameter("@CompletionDate", SqlDbType.DateTime), //16
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //17
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //18
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //19
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//20
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//21
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //20
new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //21
new SqlParameter("@Status", SqlDbType.Char, 1), //22
new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //23
new SqlParameter("@TotalAmount", SqlDbType.Float), //24
new SqlParameter("@SaleDealerCode", SqlDbType.Char, 5), //25
new SqlParameter("@SaleDealerName", SqlDbType.VarChar, 100), //26
};
param[0].Value = Session["DealerCode"].ToString();
if (ddlPRNo.SelectedValue == "0" || ddlPRNo.SelectedValue.ToString().Trim() == "__/_____")
{
param[1].Value = sysFuncs.AutoGen("PPRMaster", "PPRCode", DateTime.Now.ToString("dd-MM-yyyy"));
//txtPPRNo.Text = param[1].Value.ToString();
ViewState["PPRCode"] = param[1].Value.ToString();
}
else
{
param[1].Value = ddlPRNo.SelectedValue;
}
//param[1].Value =txtPPRNo.Text;
param[2].Value = txtJobCardNo.Text;
param[3].Value = sysFuncs.SaveDate(txtPPRDate.Text);
param[4].Value = txtCustCode.Text;
param[5].Value = txtUserName.Text;
param[6].Value = txtUserAddress.Text;
param[7].Value = txtPhoneNo.Text;
param[8].Value = txtEngNo.Text;
param[9].Value = txtChasisNo.Text;
param[10].Value = txtRegNo.Text;
param[11].Value = sysFuncs.SaveDate(txtInvDate.Text);
param[12].Value = txtKM.Text;
param[13].Value = sysFuncs.SaveDate(dtProblemDate.Text);
param[14].Value = ddlRoadCond.SelectedValue;
param[15].Value = 1;
param[16].Value = sysFuncs.SaveDate(dtComplitionDate.Text);
param[17].Value = "N";
param[18].Value = "N";
param[19].Value = Session["UserName"].ToString();
//param[19].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
//param[20].Value = ObjGenral.SaveTime(DateTime.Now.ToString("HH:MM"));
param[20].Value = GlobalVar.mUserIPAddress;
param[21].Value = "C";
param[22].Value = "C";
param[23].Value = txtCompletionDesc.Text;
param[24].Value = txtPPRTotalAmount.Text;
param[25].Value = "";
param[26].Value = "";
if (sysFuncs.ExecuteSP_NonQuery("sp_2W_Service_Insert_PPRMaster", param, Trans))
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlGType.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select GatePass Type First!", txtRegNo);
}
if (ddlModule.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select Trans Type First!", txtRegNo);
}
if (txtGatePassCode.Text == "")
{
if (!sec.UserRight("2590", "002"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = myFunc.AutoGen("GatePassTemp", "GatePassCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
if (!sec.UserRight("2590", "003"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = txtGatePassCode.Text;
string CCon = CConnection.GetConnectionString();
SqlDataAdapter dta = new SqlDataAdapter("Select Post from GatePassTemp where CompCode='" + Session["DealerCode"].ToString() + "' and GatePassCode='" + txtGatePassCode.Text + "' and DelFlag<>'Y' ", CCon);
DataTable dt = new DataTable();
dta.Fill(dt);
if (dt.Rows.Count > 0)
{
string Postflag = dt.Rows[0]["Post"].ToString();
if (Postflag == "Y")
{
sysfun.UserMsg(lblMessage, Color.Red, "GatePass Can't Be Edit or Delete. . .! It is Already Posted. ");
return;
}
}
}
SqlParameter[] GatePass_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@GatePassCode", SqlDbType.Char, 8),
/*2*/ new SqlParameter("@GatePassDate", SqlDbType.DateTime),
/*4*/ new SqlParameter("@TransCode", SqlDbType.VarChar, 8),
/*3*/ new SqlParameter("@GatePassType", SqlDbType.Char, 1),
/*4*/ new SqlParameter("@Remarks", SqlDbType.Char, 100),
/*6*/ new SqlParameter("@Module", SqlDbType.VarChar, 50),
/*7*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50),
/*8*/ new SqlParameter("@UpdTerm", SqlDbType.Char, 50),
/*9*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*10*/ new SqlParameter("@InvoiceNo", SqlDbType.VarChar, 8),
/*11*/ new SqlParameter("@InDate", SqlDbType.DateTime),
/*12*/ new SqlParameter("@InTime", SqlDbType.DateTime),
/*13*/ new SqlParameter("@OutDate", SqlDbType.DateTime),
/*14*/ new SqlParameter("@OutTime", SqlDbType.DateTime),
};
GatePass_param[0].Value = Session["DealerCode"].ToString();
GatePass_param[1].Value = Autostr;
GatePass_param[2].Value = sysfun.SaveDate(txtGatePassDate.Text);
GatePass_param[3].Value = "";
GatePass_param[4].Value = ddlGType.SelectedValue;
GatePass_param[5].Value = txtRemarks.Text;
GatePass_param[6].Value = ddlModule.SelectedValue;
GatePass_param[7].Value = Session["UserName"].ToString();
GatePass_param[8].Value = GlobalVar.mUserIPAddress;
GatePass_param[9].Value = "N";
GatePass_param[10].Value = "";
GatePass_param[11].Value = sysfun.SaveDate(txtInDate.Text);
GatePass_param[12].Value = Convert.ToDateTime(txtInTime.Text).ToString("HH:mm");
GatePass_param[13].Value = sysfun.SaveDate(txtOutDate.Text);
GatePass_param[14].Value = Convert.ToDateTime(txtOutTime.Text).ToString("HH:mm");;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (txtGatePassCode.Text == "")
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
else
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
}
if (ObjTrans.CommittTransaction(ref Trans) == true)
{
lblMessage.ForeColor = Color.Green;
if (txtGatePassCode.Text.Trim() == "") //ddlJobCardCode.SelectedIndex
{
lblMessage.Text = "Record Saved Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
else
{
lblMessage.Text = "Record Updated Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true);
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
sysfun.UserMsg(lblMessage, Color.Red, "Record not saved Try again. Or contact to support team ");
}
ClearGatePassTextBoxes();
}
catch (Exception ex)
{
sysfun.UserMsg(lblMessage, Color.Red, ex.Message, txtGatePassCode);
}
}
protected void gv_PSF_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataSet ds_update = new DataSet();
TextBox txtLetterSentDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtLetterSentDate");
TextBox txtCallDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtCallDate");
TextBox txtSmsDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtSmsDate");
TextBox txtRemarks = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtRemarks");
Label JobCode = (Label)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("lblJobCode");
ds_update = (DataSet)Session["NextDueMaintenance"];
//Uzair
foreach (DataRow dr in ds_update.Tables[0].Rows)
{
if (dr["JobCardCode"].ToString().Trim() == JobCode.Text.Trim())
{
dr["LetterSentDate"] = sysFunc.SaveDate(txtLetterSentDate.Text);
if (txtCallDate.Text == "")
{
dr["CalledDate10Day"] = null;
}
else
{
dr["CalledDate10Day"] = sysFunc.SaveDate(txtCallDate.Text);
}
if (txtSmsDate.Text == "")
{
dr["SMSSendDate"] = null;
}
else
{
dr["SMSSendDate"] = sysFunc.SaveDate(txtSmsDate.Text);
}
dr["Remarks2Day"] = txtRemarks.Text.Trim();
}
}
grdNextDueMaintenance.EditIndex = -1;
grdNextDueMaintenance.DataSource = ds_update;
grdNextDueMaintenance.DataBind();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@JObCardCode", SqlDbType.Char, 8),
new SqlParameter("@LetterSentDate", SqlDbType.DateTime),
new SqlParameter("@CalledDate10Day", SqlDbType.DateTime),
new SqlParameter("@SMSSendDate", SqlDbType.DateTime),
new SqlParameter("@Remarks2Day", SqlDbType.VarChar, 50)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = JobCode.Text;
if (txtLetterSentDate.Text == "")
{
param[2].Value = null;
}
else
{
param[2].Value = sysFunc.SaveDate(txtLetterSentDate.Text);
}
if (txtCallDate.Text == "")
{
param[3].Value = null;
}
else
{
param[3].Value = sysFunc.SaveDate(txtCallDate.Text);
}
if (txtSmsDate.Text == "")
{
param[4].Value = null;
}
else
{
param[4].Value = sysFunc.SaveDate(txtSmsDate.Text);
}
param[5].Value = txtRemarks.Text.Trim();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
myFunc.ExecuteSP_NonQuery("[sp_SP_CRM_PostSales_NextDueMaintenance_Update]", param, Trans);
//string sql = "update CRM_PostSales_NextDueMaintenance set LetterSentDate = '" + sysFunc.SaveDate(txtLetterSentDate.Text) + "', Remarks2Day = '" + txtRemarks.Text + "' , CalledDate10Day ='" + sysFunc.SaveDate(txtCallDate.Text) + "'" +
// ", SMSSendDate = '" + sysFunc.SaveDate(txtSmsDate.Text) + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCardCode = '" + JobCode.Text + "' ";
//myFunc.ExecuteQuery(sql, Trans);
}
lblMessage.Visible = true;
lblMessage.ForeColor = Color.Green;
lblMessage.Text = "Record " + JobCode.Text + " Updated";
Session["NextDueMaintenance"] = ds_update;
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
//ObjTrans.CommittTransaction(ref Trans);
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
protected void BtnSavePartLocation_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2540", "004"))
{
Response.Redirect("~/Test.aspx");
}
string StrPartLocationCode = "", StrPartLocationDesc = "";
TextBox[] textBoxes = { txtPartLocationDesc };
if (!MasterValidation(textBoxes))
{
return;
}
try
{
if (txtPartLocationCode.Text.Trim() == string.Empty)
{
StrPartLocationCode = SysFunc.GetNewMaxID("PartsLocation", "PartsLocCode", 2, Session ["DealerCode"].ToString());
}
else
{
if (!sec.UserRight("2540", "003"))
{
Response.Redirect("~/Test.aspx");
}
StrPartLocationCode = txtPartLocationCode.Text.Trim();
}
StrPartLocationDesc = txtPartLocationDesc.Text.Trim();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", Session["DealerCode"].ToString()),
new SqlParameter("@partsLocCode", StrPartLocationCode),
new SqlParameter("@partsLocDesc", StrPartLocationDesc),
new SqlParameter("@UpdUser", Session["UserName"].ToString()),
new SqlParameter("@Updtem", GlobalVar.mUserIPAddress)
};
//ObjDLL.SP_Spare_Insert_partslocation(param);
if (SysFunc.ExecuteSP_NonQuery("SP_Spare_Insert_partslocation", param))
{
SysFunc.UserMsg(LbErr, Color.Green, "Location saved successfully Last Code is :" + StrPartLocationCode, txtPartLocationCode);
Load_ddlLocCode();
ddlLocCode.SelectedValue = StrPartLocationCode;
ClearSubLoc();
txtAutoPartLocCode.Text = ddlLocCode.SelectedValue.ToString();
txtPartLocationCode.Text = ddlLocCode.SelectedValue.ToString();
}
else
{
SysFunc.UserMsg(LbErr, Color.Red, "Location not save try again", txtPartLocationCode);
}
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message, txtPartLocationCode);
}
}
