public void btnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2542", "002")) { Response.Redirect("~/Test.aspx"); } if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date > Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd")).Date) { myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not greater then current date."); return; } if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date < Convert.ToDateTime(myFunc.SaveDate(txtPODate.Text)).Date) { myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not less then PO Date."); return; } if (txtVendorDCn0.Text == "") { myFunc.UserMsg(lblMessage, Color.Red, "Please enter vendor DC Number."); return; } if (gv_DC.Rows.Count == 0) { lblMessage.ForeColor = Color.Red; lblMessage.Text = "Please Select PO Number."; return; } string newDCNo = ""; if (ddlDCno.SelectedValue == "0") { //newDCNo = myFunc.GetNewDCNumber(this.Session["DealerCode"].ToString()); newDCNo = myFunc.AutoGen("DCMaster", "DCNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); } else { if (ddlDCno.SelectedValue != "") { if (!sec.UserRight("2542", "003")) { Response.Redirect("~/Test.aspx"); } newDCNo = ddlDCno.SelectedValue; } else { newDCNo = this.Session["DCNumber"].ToString(); } } string sql = ""; if (myFunc.isDCExist(newDCNo, Session["DealerCode"].ToString())) { sql = "UPDATE DCMaster SET VendorDCNo='" + txtVendorDCn0.Text + "',Remarks='" + txtRemarks.Text + "' where DCNo='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'"; } else { sql = "INSERT INTO DCMaster (DealerCode,DCNo,DCDate,PONo,VendorDCNo,VendorCode,Remarks,DelFlag,UpdUser,UpdDate,UpdTime)"; sql += " VALUES ('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + myFunc.SaveDate(txtDCDate.Text) + "','" + ddlPONo.SelectedValue + "','"; sql += txtVendorDCn0.Text.Trim() + "','" + txtVendor.Text + "','" + txtRemarks.Text.Trim() + "','N','" + this.Session["UserID"].ToString() + "',"; sql += "CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)"; } try { int slct = 0; if (ObjTrans.BeginTransaction(ref Trans) == true) { myFunc.ExecuteQuery_NonQuery(sql, Trans); // save detail RemoveQTYFromPO(newDCNo, "-"); sql = "delete from DCDetail where DCNo ='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'"; myFunc.ExecuteQuery_NonQuery(sql, Trans); DataTable dt = (DataTable)Session["DCTable"]; string ItemCode = ""; int i = 0; foreach (GridViewRow row in gv_DC.Rows) { CheckBox chkSelect = (CheckBox)row.FindControl("cbSelect"); if (chkSelect.Checked) { ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString(), Session["DealerCode"].ToString()); sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)"; sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','"; sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')"; myFunc.ExecuteQuery_NonQuery(sql, Trans); slct++; } i++; } } else { ObjTrans.RollBackTransaction(ref Trans); } //Commented By Uzair //for (int i = 0; i < dt.Rows.Count; i++) //{ // slct = dt.Rows[i]["Selected"].ToString(); // if (slct == "True") // { // ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString()); // sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)"; // sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','"; // sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')"; // myFunc.GetData(sql); // } //} if (slct > 0) { ObjTrans.CommittTransaction(ref Trans); RemoveQTYFromPO(newDCNo, "+"); lblMessage.ForeColor = Color.Green; lblMessage.Text = newDCNo + " has been saved"; ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + newDCNo + "')", true); ClearAll(); lOADddl(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true); } else { ObjTrans.RollBackTransaction(ref Trans); lblMessage.ForeColor = Color.Red; lblMessage.Text = "At least one row should be selected"; } } catch (Exception) { ObjTrans.RollBackTransaction(ref Trans); } //ddDCNumber.Text = newDCNo; }
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; } }
private void Save_InsertMasterDetail(SqlTransaction Trans, ref bool Check) { //Trans = null; //Check = false; string StrIssueDate = ""; try { //if (GvMain.Rows.Count == 0) //{ // ObjGeneral.UserMsg(LbErr, Color.Red, "At least one part must be add...", txtPartItem); // return; //} //else //{ // LbErr.Text = ""; //} StrIssueDate = txtIssueDate.Text; int IssueDate = Convert.ToInt32(txtIssueDate.Text.Substring(6, 4) + txtIssueDate.Text.Substring(3, 2) + txtIssueDate.Text.Substring(0, 2)); int SIRDate = Convert.ToInt32(txtSIRDate.Text.Substring(6, 4) + txtSIRDate.Text.Substring(3, 2) + txtSIRDate.Text.Substring(0, 2)); if (txtSource.Text == "J") { if (IssueDate < SIRDate) { SysFunc.UserMsg(LbErr, Color.Red, "Issuance date should not be less than jobcard date...", txtIssueDate); return; } else { LbErr.Text = ""; } } if (txtSource.Text == "C") { if (IssueDate < SIRDate) { SysFunc.UserMsg(LbErr, Color.Red, "Issuance date should not be less than counter sale date...", txtIssueDate); return; } else { LbErr.Text = ""; } } //if (ObjTrans.BeginTransaction(ref Trans) == false) //{ // return; //} //if (ObjGeneral.IsPosted("StockIssue", "IssueNo", txtIssueNo.Text) == true) //{ // ObjGeneral.UserMsg(LbErr, Color.Red, "The Issuance is already posted; now you could not change/delete/Post the record...", txtIssueNo); // return; //} //else //{ // LbErr.Text = ""; //} SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@IssueNo", SqlDbType.Char), //1 new SqlParameter("@IssueDate", SqlDbType.DateTime), //2 new SqlParameter("@SIRNo", SqlDbType.Char), //3 new SqlParameter("@ReqSource", SqlDbType.VarChar), //4 new SqlParameter("@JobCardNO", SqlDbType.Char), //5 new SqlParameter("@InvoiceNo", SqlDbType.Char), //6 new SqlParameter("@Remarks", SqlDbType.VarChar), //7 new SqlParameter("@UpdUser", SqlDbType.VarChar), //8 //new SqlParameter("@UpdDate",SqlDbType.DateTime),//9 //new SqlParameter("@UpdTime",SqlDbType.DateTime),//10 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //11 }; param[0].Value = Session["DealerCode"].ToString(); strIssueNo = SysFunc.AutoGen("StockIssue", "IssueNo", txtIssueDate.Text.Trim()); param[1].Value = strIssueNo; param[2].Value = SysFunc.SaveDate(txtIssueDate.Text);; param[3].Value = ddlSirNo.SelectedValue.ToString().Trim(); param[4].Value = txtSource.Text; if (txtSource.Text == "J") { param[5].Value = txtJC_CS_No.Text; param[6].Value = (Object)DBNull.Value; } else if (txtSource.Text == "C") { param[5].Value = (Object)DBNull.Value; param[6].Value = txtJC_CS_No.Text; } param[7].Value = txtRemarks.Text.Replace("'", " "); param[8].Value = Session["UserName"].ToString(); //param[9].Value = ObjGeneral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")); //param[10].Value = ObjGeneral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")); param[9].Value = GlobalVar.mUserIPAddress; if (SysFunc.SP_Parts_Insert_StockIssue(Trans, param)) { foreach (GridViewRow gvr in GvMain.Rows) { CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect"); if (chkSelect.Checked) { SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@IssueNo", SqlDbType.Char), //1 new SqlParameter("@ItemCode", SqlDbType.Char), //2 new SqlParameter("@SIRNo", SqlDbType.Char), //3 new SqlParameter("@PartsTransLocCode", SqlDbType.Char), //4 new SqlParameter("@IssueQty", SqlDbType.Float), //5 new SqlParameter("@Rate", SqlDbType.Float), //6 new SqlParameter("@Amount", SqlDbType.Float) //7 }; //Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode"); DropDownList ddlLocation = (DropDownList)gvr.FindControl("ddlLocation"); //HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode"); TextBox txtIssueQty = (TextBox)gvr.FindControl("txtIssueQty"); Label lblAvgCost = (Label)gvr.FindControl("lblAvgCost"); Label LbAmount = (Label)gvr.FindControl("LbAmount"); param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = strIssueNo; param1[2].Value = gvr.Cells[1].Text.Trim(); param1[3].Value = ddlSirNo.SelectedValue.ToString(); param1[4].Value = ddlLocation.SelectedValue.ToString(); param1[5].Value = txtIssueQty.Text.Trim(); param1[6].Value = lblAvgCost.Text; param1[7].Value = LbAmount.Text; if (SysFunc.Sp_Parts_Insert_StockIssueDetail(Trans, param1)) { Check = true; } else { Check = false; break; } } } } } catch (Exception ex) { //ObjTrans.RollBackTransaction(ref Trans); SysFunc.UserMsg(LbErr, Color.Red, ex.Message); } }
private void JobCardEntry() { ///////////////// if (txtSRNo.Text.Trim() == string.Empty) { txtSRNo.Text = sysfuncs.AutoGen("FIRMaster", "FIRCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); } #region JobCard Master Param SqlParameter[] JobCardMaster_param = { /*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@FIRCode", SqlDbType.VarChar, 8), /*2*/ new SqlParameter("@FIRDate", SqlDbType.DateTime), /*3*/ new SqlParameter("@Subject", SqlDbType.VarChar, 100), /*4*/ new SqlParameter("@RegNo", SqlDbType.VarChar, 15), /*5*/ new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30), /*6*/ new SqlParameter("@EngineNo", SqlDbType.VarChar, 30), /*7*/ new SqlParameter("@CusComment", SqlDbType.VarChar, 400), /*8*/ new SqlParameter("@KM", SqlDbType.Char, 8), /*9*/ new SqlParameter("@ProblemDate", SqlDbType.DateTime), /*10*/ new SqlParameter("@ItemCode", SqlDbType.Char, 25), /*11*/ new SqlParameter("@VendorCode", SqlDbType.Char, 6), /*12*/ new SqlParameter("@Defect", SqlDbType.VarChar, 100), /*13*/ new SqlParameter("@Problem", SqlDbType.VarChar, 100), /*14*/ new SqlParameter("@CorrectiveAction", SqlDbType.VarChar, 100), /*15*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1), /*16*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50), /*17*/ new SqlParameter("@UpdTerm", SqlDbType.Char, 50), /*18*/ new SqlParameter("@Pic1", SqlDbType.VarChar, 200), /*19*/ new SqlParameter("@Part1", SqlDbType.Char, 8), /*20*/ new SqlParameter("@Part2", SqlDbType.Char, 8), /*21*/ new SqlParameter("@Part3", SqlDbType.Char, 8), /*22*/ new SqlParameter("@Part4", SqlDbType.Char, 8), /*23*/ new SqlParameter("@InspDate", SqlDbType.DateTime), /*24*/ new SqlParameter("@Status", SqlDbType.VarChar, 30), /*25*/ new SqlParameter("@Result", SqlDbType.VarChar, 30), /*26*/ new SqlParameter("@RoNo", SqlDbType.VarChar, 10), /*27*/ new SqlParameter("@RoDate", SqlDbType.DateTime), /*28*/ new SqlParameter("@PartAttach", SqlDbType.Char, 1), /*29*/ new SqlParameter("@followupdate", SqlDbType.DateTime), /*30*/ new SqlParameter("@Request", SqlDbType.VarChar, 200), /*31*/ new SqlParameter("@KeyNo", SqlDbType.VarChar, 15), /*31*/ new SqlParameter("@SerialNo", SqlDbType.Char, 8) }; JobCardMaster_param[0].Value = Session["DealerCode"].ToString(); JobCardMaster_param[2].Value = sysfunc.SaveDate(txtDate.Text.Trim()); JobCardMaster_param[3].Value = txtSubject.Text.Trim(); JobCardMaster_param[4].Value = txtRegNo.Text.Trim().ToUpper(); JobCardMaster_param[5].Value = ddlVinNo.SelectedValue.ToString().Trim(); JobCardMaster_param[6].Value = txtEngineNo.Text.Trim(); JobCardMaster_param[7].Value = txtCustComp.Text.Trim(); JobCardMaster_param[8].Value = txtKM.Text.Trim().ToUpper(); JobCardMaster_param[9].Value = sysfunc.SaveDate(txtFailureDate.Text); JobCardMaster_param[10].Value = txtFailedPart.Text.Trim(); JobCardMaster_param[11].Value = Session["DealerCode"].ToString(); if (RadioButton1.Checked) { JobCardMaster_param[12].Value = "Y"; } else { JobCardMaster_param[12].Value = "N"; } JobCardMaster_param[13].Value = txtPrblmCause.Text.Trim(); JobCardMaster_param[14].Value = txtCorAction.Text.Trim(); JobCardMaster_param[15].Value = "N"; if (Session["UserName"] == null) { JobCardMaster_param[16].Value = ""; } else { JobCardMaster_param[16].Value = Session["UserName"].ToString().Trim(); } JobCardMaster_param[16].Value = Session["UserName"].ToString().Trim(); JobCardMaster_param[17].Value = GlobalVar.mUserIPAddress; if (Session["Sketch"].ToString() == null || Session["Sketch"].ToString().Trim() == "" || Session["Sketch"] == null) { JobCardMaster_param[18].Value = ""; } else { JobCardMaster_param[18].Value = Session["Sketch"].ToString().Trim(); } JobCardMaster_param[19].Value = txtPart1.Text.Trim(); JobCardMaster_param[20].Value = txtPart2.Text.Trim(); JobCardMaster_param[21].Value = txtPart3.Text.Trim(); JobCardMaster_param[22].Value = txtPart4.Text.Trim(); JobCardMaster_param[23].Value = sysfunc.SaveDate(txtInspDate.Text.Trim()); JobCardMaster_param[24].Value = ddlStatus.SelectedValue.Trim(); JobCardMaster_param[25].Value = ddlResult.SelectedValue.Trim(); JobCardMaster_param[26].Value = txtRoNo.Text.Trim(); JobCardMaster_param[27].Value = sysfunc.SaveDate(txtRepairDate.Text.Trim()); if (RadioButton3.Checked) { JobCardMaster_param[28].Value = "Y"; } else { JobCardMaster_param[28].Value = "N"; } JobCardMaster_param[29].Value = sysfunc.SaveDate(txtFollowUpDate.Text); JobCardMaster_param[30].Value = txtRequest.Text.Trim(); JobCardMaster_param[31].Value = txtKeyNo.Text.Trim(); JobCardMaster_param[32].Value = txtSerial.Text.Trim(); #endregion try { if (ObjTrans.BeginTransaction(ref Trans) == true) { DataSet dsJc = new DataSet(); if (ddlDRNo.SelectedIndex == 0) { JobCardMaster_param[1].Value = sysfuncs.AutoGen("FIRMaster", "FIRCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); //txtReferenceNo.Text; HFJobCard.Value = JobCardMaster_param[1].Value.ToString(); sysfunc.ExecuteSP_NonQuery("[sp_FIRMaster_Insert]", JobCardMaster_param, Trans); } else { JobCardMaster_param[1].Value = ddlDRNo.SelectedValue.ToString().Trim(); HFJobCard.Value = JobCardMaster_param[1].Value.ToString(); sysfunc.ExecuteSP_NonQuery("[sp_UpdateFIRMasterFull]", JobCardMaster_param, Trans); } if (ObjTrans.CommittTransaction(ref Trans) == true) { sysfunc.UserMsg(lblMsg, Color.Green, "Record Saved Successfully: " + HFJobCard.Value); } else { ObjTrans.RollBackTransaction(ref Trans); sysfunc.UserMsg(lblMsg, Color.Red, "Record not saved Try again. Or contact to support team "); } clearAll(); } } catch (Exception ex) { sysfunc.UserMsg(lblMsg, Color.Red, "Error: " + ex.Message, txtSRNo); ObjTrans.RollBackTransaction(ref Trans); } }
protected void BtnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2544", "002")) { Response.Redirect("~/Test.aspx"); } SqlTransaction Trans = null; bool Chek = false; bool chkSelectRow = false; string strPurInvNo = string.Empty; try { if (ddlPayInvNo.SelectedIndex > 0) { if (!sec.UserRight("2544", "003")) { Response.Redirect("~/Test.aspx"); } SysFunc.UserMsg(LbErr, Color.Red, "Update not allowd please delete and save again"); return; } if (ddlVendor.SelectedIndex == 0) { SysFunc.UserMsg(LbErr, Color.Red, "Select Vendor"); return; } if (ddlGRN.SelectedIndex == 0) { SysFunc.UserMsg(LbErr, Color.Red, "Select GRN Number."); return; } if (txtPrincipalInvNo.Text.Trim() == string.Empty) { SysFunc.UserMsg(LbErr, Color.Red, "Principal Inv No can not be empty"); return; } if (txtPayInvDate.Text.Trim() == string.Empty) { SysFunc.UserMsg(LbErr, Color.Red, "Principal Inv Date can not be empty"); return; } if (txtOrder.Text.Trim() == string.Empty) { SysFunc.UserMsg(LbErr, Color.Red, "Order No can not be empty"); return; } foreach (GridViewRow gvr in gvPurInvDetail.Rows) { CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect"); //TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty"); if (chkSelect.Checked == true) { chkSelectRow = true; break; } else { chkSelectRow = false; } } if (chkSelectRow == false) { SysFunc.UserMsg(LbErr, Color.Red, "Select Rows from list"); return; } foreach (GridViewRow gvr in gvPurInvDetail.Rows) { CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect"); TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty"); decimal dtxtPayableQty = Convert.ToDecimal(txtPayableQty.Text == "" ? "0" : txtPayableQty.Text); decimal dAccQty = Convert.ToDecimal(gvr.Cells[4].Text.Trim()); decimal dPaidQty = Convert.ToDecimal(gvr.Cells[5].Text.Trim()); decimal dRemainingQty = dAccQty - dPaidQty; if (chkSelect.Checked == true && dtxtPayableQty == 0) { SysFunc.UserMsg(LbErr, Color.Red, "Payable quantity can not be Zero(0) or empty."); return; } if (chkSelect.Checked == true && dtxtPayableQty > dRemainingQty) { chkSelect.Checked = false; SysFunc.UserMsg(LbErr, Color.Red, "Remaining payable Qty is " + dRemainingQty + " you can not enter greater then Remaining Qty"); return; } } if (ObjTrans.BeginTransaction(ref Trans) == false) { return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //1 new SqlParameter("@PurInvDate", SqlDbType.DateTime), //2 new SqlParameter("@VendorCode", SqlDbType.Char, 6), //3 new SqlParameter("@GRNNo", SqlDbType.Char, 8), //4 new SqlParameter("@VendorInvNo", SqlDbType.VarChar, 20), //5 new SqlParameter("@VendorInvDate", SqlDbType.DateTime), //6 new SqlParameter("@OrderNo", SqlDbType.VarChar, 20), //7 new SqlParameter("@DiscountAmt", SqlDbType.Decimal), //8 new SqlParameter("@Remarks", SqlDbType.VarChar, 70), //9 new SqlParameter("@TotalAmt", SqlDbType.Decimal), //10 new SqlParameter("@TotPayment", SqlDbType.Decimal), //11 new SqlParameter("@UpdUser", SqlDbType.VarChar), //12 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //13 new SqlParameter("@TotPaidQty", SqlDbType.Int), //14 new SqlParameter("@GSTPercent", SqlDbType.Decimal), //15 new SqlParameter("@GSTTotal", SqlDbType.Decimal), //16 new SqlParameter("@ExTaxPercent", SqlDbType.Decimal), //17 new SqlParameter("@ExTaxTotal", SqlDbType.Decimal), //18 new SqlParameter("@FurTaxPercent", SqlDbType.Decimal), //19 new SqlParameter("@FurTaxTotal", SqlDbType.Decimal), //20 new SqlParameter("@TotalIncTax", SqlDbType.Decimal), //21 }; param[0].Value = Session["DealerCode"].ToString(); if (ddlPayInvNo.SelectedIndex == 0) { strPurInvNo = SysFunc.AutoGen("PurInvMaster", "PurInvNo", DateTime.Parse(SysFunc.SaveDate(txtPayInvDate.Text).ToString()).ToString("dd-MM-yyyy")); } else { if (!sec.UserRight("2544", "003")) { Response.Redirect("~/Test.aspx"); } strPurInvNo = ddlPayInvNo.SelectedValue; } param[1].Value = strPurInvNo.Trim(); param[2].Value = SysFunc.SaveDate(txtPayInvDate.Text); param[3].Value = ddlVendor.SelectedValue.ToString().Trim(); param[4].Value = ddlGRN.SelectedValue.ToString().Trim(); param[5].Value = txtPrincipalInvNo.Text.Trim(); //txtRemarks.Text.Trim().Replace(",", " "); param[6].Value = SysFunc.SaveDate(txtPrincipalInvDate.Text); //Convert.ToDecimal((lblFooterTotalAmt.Text == "" ? "0" : lblFooterTotalAmt.Text)); param[7].Value = txtOrder.Text.Trim(); param[8].Value = Convert.ToDecimal(ViewState["TotalDiscount"].ToString() == "" ? "0" : ViewState["TotalDiscount"].ToString()); param[9].Value = txtRemarks.Text.Trim().Replace(",", " "); param[10].Value = Convert.ToDecimal(ViewState["TotalAmt"].ToString() == "" ? "0" : ViewState["TotalAmt"].ToString()); param[11].Value = "0";//Convert.ToDecimal(ViewState["TotalAmt"].ToString() == "" ? "0" : ViewState["TotalAmt"].ToString()); param[12].Value = Session["UserName"].ToString(); param[13].Value = GlobalVar.mUserIPAddress.ToString(); param[14].Value = Convert.ToDecimal(ViewState["TotalPaidQty"].ToString() == "" ? "0" : ViewState["TotalPaidQty"].ToString()); param[15].Value = Convert.ToDecimal(lblGstPerc.Text.Trim().Replace("%", "")); param[16].Value = Convert.ToDecimal(txtGstAmt.Text.Trim() == "" ? "0" : txtGstAmt.Text.Trim()); param[17].Value = Convert.ToDecimal(lblExTaxPerc.Text.Trim().Replace("%", "")); param[18].Value = Convert.ToDecimal(txtExTaxAmt.Text.Trim() == "" ? "0" : txtExTaxAmt.Text.Trim()); param[19].Value = Convert.ToDecimal(lblFurTaxPerc.Text.Trim().Replace("%", "")); param[20].Value = Convert.ToDecimal(txtFurTaxAmt.Text.Trim() == "" ? "0" : txtFurTaxAmt.Text.Trim()); param[21].Value = Convert.ToDecimal(txtTotalAmt.Text.Trim() == "" ? "0" : txtTotalAmt.Text.Trim()); if (SysFunc.sp_PurInvMaster_Insert(Trans, param)) { foreach (GridViewRow gvr in gvPurInvDetail.Rows) { TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty"); Label lblDiscountAmt = (Label)gvr.Cells[9].FindControl("lblDiscountAmt"); Label lblGrossAmt = (Label)gvr.Cells[10].FindControl("lblGrossAmt"); CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect"); if (chkSelect.Checked) { SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), //0 new SqlParameter("@GRNNo", SqlDbType.Char, 8), //1 new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //2 new SqlParameter("@ItemCode", SqlDbType.Char, 8), //3 new SqlParameter("@AccQty", SqlDbType.Decimal), //4 new SqlParameter("@paidQty", SqlDbType.Decimal), //5 new SqlParameter("@Rate", SqlDbType.Decimal), //6 new SqlParameter("@DiscountAmt", SqlDbType.Decimal), //7 new SqlParameter("@Amount", SqlDbType.Decimal), //8 new SqlParameter("@DiscountPerc", SqlDbType.Decimal), //9 }; param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = ddlGRN.SelectedValue.ToString(); param1[2].Value = strPurInvNo; param1[3].Value = gvr.Cells[1].Text.Trim(); param1[4].Value = Convert.ToDecimal(gvr.Cells[4].Text.Trim() == "" ? "0" : gvr.Cells[4].Text.Trim()); param1[5].Value = Convert.ToDecimal(txtPayableQty.Text.Trim() == "" ? "0" : txtPayableQty.Text.Trim()); param1[6].Value = Convert.ToDecimal(gvr.Cells[7].Text.Trim() == "" ? "0" : gvr.Cells[7].Text.Trim()); param1[7].Value = Convert.ToDecimal(lblDiscountAmt.Text.Trim() == "" ? "0" : lblDiscountAmt.Text.Trim()); param1[8].Value = Convert.ToDecimal(lblGrossAmt.Text.Trim() == "" ? "0" : lblGrossAmt.Text.Trim()); param1[9].Value = Convert.ToDecimal(gvr.Cells[8].Text.Trim() == "" ? "0" : gvr.Cells[8].Text.Trim()); if (SysFunc.sp_PurInvDetail_Insert(Trans, param1)) { Chek = true; } else { Chek = false; break; } } } if (Chek == false) { ObjTrans.RollBackTransaction(ref Trans); SysFunc.UserMsg(LbErr, Color.Red, "Recored not saved try again "); } else { ObjTrans.CommittTransaction(ref Trans); SysFunc.UserMsg(LbErr, Color.Green, "Saved Successfully Sales Invoice No. " + strPurInvNo); ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + strPurInvNo + "')", true); btnClear_Click(BtnSave, EventArgs.Empty); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true); } } } catch (Exception ex) { ObjTrans.RollBackTransaction(ref Trans); SysFunc.UserMsg(LbErr, Color.Red, ex.Message); } }
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 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); }
public bool Insert_PaymentRefund() { SqlParameter[] PmtRecMaster_param = { /*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@RefundNo",SqlDbType.Char, 8), /*2*/ new SqlParameter("@RefundDate", SqlDbType.DateTime), /*3*/ new SqlParameter("@AdvanceCode", SqlDbType.Char, 8), /*4*/ new SqlParameter("@CusCode", SqlDbType.VarChar, 8), /*5*/ new SqlParameter("@Remarks", SqlDbType.Char, 100), /*6*/ new SqlParameter("@PayModeCode",SqlDbType.Char, 1), /*7*/ new SqlParameter("@InsNo", SqlDbType.VarChar, 15), /*8*/ new SqlParameter("@InsDate",SqlDbType.DateTime), /*9*/ new SqlParameter("@AmountPaid", SqlDbType.Float), /*10*/ new SqlParameter("@BankCode", SqlDbType.Char, 5), /*11*/ new SqlParameter("@Branch", SqlDbType.VarChar, 50), /*12*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1), /*13*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50), /*14*/ new SqlParameter("@UpdTerm",SqlDbType.Char, 50), /*15*/ new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), /*16*/ new SqlParameter("@VoucherFlag",SqlDbType.Char, 1), /*17*/ new SqlParameter("@TransType", SqlDbType.VarChar, 30), /*17*/ new SqlParameter("@RefundType",SqlDbType.VarChar, 30), }; PmtRecMaster_param[0].Value = Session["DealerCode"].ToString(); PmtRecMaster_param[2].Value = SysFuncs.SaveDate(txtRefundDate.Text); //EstimateCode PmtRecMaster_param[3].Value = ddlReceiptNo.SelectedItem.Value; PmtRecMaster_param[4].Value = txtCusVenCode.Text; PmtRecMaster_param[5].Value = ""; PmtRecMaster_param[6].Value = ddlpayment_mode.SelectedItem.Value; PmtRecMaster_param[7].Value = txtinstrument_no.Text.Trim().ToUpper(); PmtRecMaster_param[8].Value = SysFuncs.SaveDate(txtinstrument_date.Text); PmtRecMaster_param[9].Value = txtins_amount.Text.Trim().Replace(" ", "") == "" ? "0" : txtins_amount.Text.Trim(); PmtRecMaster_param[10].Value = ddlbank.SelectedItem.Value; PmtRecMaster_param[11].Value = txtbranch.Text.Trim().Replace(" ", ""); PmtRecMaster_param[12].Value = "N"; PmtRecMaster_param[13].Value = Session["UserName"].ToString(); PmtRecMaster_param[14].Value = GlobalVar.mUserIPAddress; PmtRecMaster_param[15].Value = ""; PmtRecMaster_param[16].Value = "N"; PmtRecMaster_param[17].Value = txtInvType.Text; if (RbtnType.SelectedValue == "Customer") { PmtRecMaster_param[18].Value = "Customer"; } else { PmtRecMaster_param[18].Value = "Vendor"; } try { if (ObjTrans.BeginTransaction(ref Trans) == true) { if (txtRefundCode.Text == "") { strReceiptNo = SysFunc.AutoGen("RefundPayment", "RefundCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); } else { strReceiptNo = txtRefundCode.Text; } PmtRecMaster_param[1].Value = strReceiptNo; if (SysFuncs.ExecuteSP_NonQuery("[sp_W2_PaymentRefund_Master_Insert]", PmtRecMaster_param, Trans)) { SqlParameter[] UpdateAdvance_param = { /*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@ReceiptNo", SqlDbType.Char, 8), /*2*/ new SqlParameter("@AdvanceReceiptNo", SqlDbType.Char, 8), /*3*/ new SqlParameter("@AdvanceAdjustedAmount", SqlDbType.Float) }; UpdateAdvance_param[0].Value = Session["DealerCode"].ToString(); UpdateAdvance_param[1].Value = ddlReceiptNo.SelectedValue.ToString(); UpdateAdvance_param[2].Value = strReceiptNo; UpdateAdvance_param[3].Value = double.Parse(txtins_amount.Text == "" ? "0" : txtins_amount.Text); SysFuncs.ExecuteSP_NonQuery("[sp_PaymentRefund_UpdateOnAdvance]", UpdateAdvance_param, Trans); ObjTrans.CommittTransaction(ref Trans); ClearAll(); SysFuncs.UserMsg(success_add_item, Color.Green, "Record Saved Sucessfully against Refund No" + strReceiptNo); ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + strReceiptNo + "')", true); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true); return(true); } else { ObjTrans.RollBackTransaction(ref Trans); return(false); } } else { return(false); } } catch (Exception ex) { SysFuncs.UserMsg(success_add_item, Color.Red, ex.Message); 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); } }
private void Save_InsertMasterDetail(SqlTransaction Trans, ref bool Check, ref string StrSRNo) { try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@SRNo", SqlDbType.Char, 8), //1 new SqlParameter("@SRDate", SqlDbType.DateTime), //2 new SqlParameter("@CusCode", SqlDbType.Char, 8), //3 new SqlParameter("@Remarks", SqlDbType.Text), //4 new SqlParameter("@TotalQty", SqlDbType.Float), //5 new SqlParameter("@TotalAmount", SqlDbType.Float), //6 new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7 new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //9 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //10 new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //11 new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //12 new SqlParameter("@SaleInvNo", SqlDbType.Char, 8), //13 new SqlParameter("@SaleType", SqlDbType.VarChar, 15), //14 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = SysFunc.AutoGen("SRMaster", "SRNo", txtRetDate.Text.Trim()); param[2].Value = SysFunc.SaveDate(txtRetDate.Text); param[3].Value = ddlCustomer.SelectedValue.ToString().Trim(); param[4].Value = txtRemarks.Text.Trim(); param[5].Value = txtTotalQty.Text.Trim(); param[6].Value = txtTotalAmount.Text.Trim(); param[10].Value = GlobalVar.mUserIPAddress; param[7].Value = "N"; param[8].Value = "N"; param[9].Value = Session["UserName"].ToString(); param[11].Value = ""; param[12].Value = ""; param[13].Value = ddlSaleInvNo.SelectedValue.ToString(); if (rdCounterSale.Checked) { param[14].Value = rdCounterSale.Text; } else if (rdJobCard.Checked) { param[14].Value = rdJobCard.Text; } if (SysFunc.sp_2W_SRMaster_Insert(Trans, param)) { StrSRNo = param[1].Value.ToString(); for (int i = 0; i < GvMain.Rows.Count; i++) { SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@SRNo", SqlDbType.Char, 8), //1 new SqlParameter("@ItemCode", SqlDbType.Char, 8), //2 new SqlParameter("@PartsTransLocCode", SqlDbType.VarChar, 7), //3 new SqlParameter("@RetQty", SqlDbType.Float), //4 new SqlParameter("@Rate", SqlDbType.Float), //5 new SqlParameter("@Amount", SqlDbType.Float), //6 new SqlParameter("@AvgRate", 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 LbIssueQty = (Label)GvMain.Rows[i].FindControl("LbQty"); Label LbAmount = (Label)GvMain.Rows[i].FindControl("LbAmount"); Label LbRate = (Label)GvMain.Rows[i].FindControl("LbRate"); Label LbAvgRate = (Label)GvMain.Rows[i].FindControl("LbAvgCost"); param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = StrSRNo; param1[2].Value = LbItemCode.Text; param1[3].Value = HDPartsTransLocCode.Value; param1[4].Value = LbIssueQty.Text; param1[5].Value = LbRate.Text; param1[6].Value = LbAmount.Text; param1[7].Value = LbAvgRate.Text; if (SysFunc.sp_W2_SRDetail_Insert(Trans, param1)) { Check = true; } else { Check = false; break; } } } } catch (Exception ex) { LbErr.Text = ex.Message; } }
protected void btnSave1_Click(object sender, EventArgs e) { if (ddlSolution.SelectedIndex == 0) { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Solution", txtComment); return; } else if (ddlPolicyType.SelectedIndex == 0) { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select PolicyType", txtComment); return; } else if (ddlStatus.SelectedIndex == 0) { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Status", txtComment); return; } else if (txtComment.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Comment", txtComment); return; } else { lblMessage.Text = string.Empty; } try { SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@WFPolicyMasterID", SqlDbType.Char), //1 new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char), //2 WFPolicyMasterDesc new SqlParameter("@WFPolicyMasterDesc", SqlDbType.VarChar), //3 new SqlParameter("@Solution_Code", SqlDbType.Char), //4 new SqlParameter("@PolicyType", SqlDbType.VarChar), //5 new SqlParameter("@PolicyStartDate", SqlDbType.DateTime), //6 new SqlParameter("@PolicyEndDate", SqlDbType.DateTime), //7 new SqlParameter("@Status", SqlDbType.VarChar), //8 new SqlParameter("@Comments", SqlDbType.VarChar), //9 new SqlParameter("@DelFlag", SqlDbType.Char), //10 new SqlParameter("@UpdUser", SqlDbType.VarChar), //11 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //12 }; string max2; string max1 = sysFuncs.GetNewMaxID("WFPolicyMaster", "WFPolicyMasterID", 4, Session["DealerCode"].ToString()); if (ddlWFPolicyMasterCode.SelectedIndex == 0) { max2 = sysFuncs.AutoGen("WFPolicyMaster", "WFPolicyMasterCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); } else { max2 = ddlWFPolicyMasterCode.SelectedValue; } param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = max1; param1[2].Value = max2; param1[3].Value = txtPolicyDesc.Text; param1[4].Value = ddlSolution.SelectedValue; param1[5].Value = ddlPolicyType.SelectedValue; param1[6].Value = txtStartDate.Text.Trim(); param1[7].Value = txtEndDate.Text.Trim(); param1[8].Value = ddlStatus.SelectedValue; param1[9].Value = txtComment.Text.Trim(); param1[10].Value = 'N'; param1[11].Value = Session["UserName"].ToString(); param1[12].Value = "1"; if (sysFunc.ExecuteSP_NonQuery("SP_WFPolicyMaster_insert", param1)) { SqlParameter[] param2 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@WFPolicyMasterID", SqlDbType.Char), //1 new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char), //2 new SqlParameter("@ApprovalCode", SqlDbType.Char), //3 new SqlParameter("@Priority", SqlDbType.Int), //4 new SqlParameter("@ApprovalRoll", SqlDbType.VarChar), //5 new SqlParameter("@BatchNo", SqlDbType.Char), //6 // new SqlParameter("@IsMandatory",SqlDbType.VarChar), //7 new SqlParameter("@Status", SqlDbType.VarChar), //7 }; //string max3 = sysFuncs.GetNewMaxID("WFPolicyDetail", "ApprovalCode", 10, Session["DealerCode"].ToString()); PartsDT = (DataTable)ViewState["WFPolicyDS"]; DataSet ds = (DataSet)Session["WFPolicyDS"]; DataRow[] drr = ds.Tables[0].Select(); for (int j = 0; j < drr.Length; j++) { if (ds.Tables[0].Rows[j]["ApprovalCode"].ToString() != "") { param2[0].Value = Session["DealerCode"].ToString(); param2[1].Value = max1; param2[2].Value = max2; param2[3].Value = ds.Tables[0].Rows[j]["ApprovalCode"].ToString(); param2[4].Value = ds.Tables[0].Rows[j]["Priority"].ToString(); param2[5].Value = ds.Tables[0].Rows[j]["ApprovalRoll"].ToString(); param2[6].Value = ds.Tables[0].Rows[j]["BatchNo"].ToString(); param2[7].Value = ds.Tables[0].Rows[j]["Status"].ToString(); } sysFunc.ExecuteSP_NonQuery("SP_WFPolicyDetail_insert", param2); sysFuncs.UserMsg(lblMsg, Color.Green, "Data Inserted", txtComment); } } } catch (Exception ex) { lblMsg.Visible = true; lblMsg.ForeColor = Color.Red; lblMsg.Text = ex.Message; } }
protected void BtnSubmit_Click(object sender, EventArgs e) { try { string max; if (ddlfeedbackNo.SelectedIndex <= 0) { max = sysFuncs.AutoGen("FeedBackMaster", "FeedBackCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); } else { max = ddlfeedbackNo.SelectedValue.Trim(); } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1 new SqlParameter("@FeedBackDate", SqlDbType.DateTime), //2 new SqlParameter("@JobcardCode", SqlDbType.Char, 8), //2 new SqlParameter("@CusCode", SqlDbType.Char, 8), new SqlParameter("@ServiceType", SqlDbType.VarChar, 50), new SqlParameter("@DelFlag", SqlDbType.Char, 1), new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), }; FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"]; DataRow[] drr = FeedBackDT.Select(); param[0].Value = Session["DealerCode"].ToString(); // 0 param[1].Value = max; param[2].Value = sysFuncs.SaveDate(txtfeedbackDate.Text); param[3].Value = ddlJobCardCode.SelectedValue; param[4].Value = txtCusCode.Text; param[5].Value = ddlServiceType.SelectedValue.ToString(); param[6].Value = "N"; param[7].Value = Session["UserName"]; if (sysFunc.ExecuteSP_NonQuery("SP_SaveFeedbackQuestions", param)) { SqlParameter[] param2 = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1 new SqlParameter("@JobcardCode", SqlDbType.Char, 8), new SqlParameter("@ParentQuestionCode", SqlDbType.Char, 8), //3 new SqlParameter("@Rating", SqlDbType.VarChar,20), //4 }; FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"]; for (int i = 0; i < drr.Length; i++) { //if (FeedBackDT.Rows[i]["ItemCode"].ToString() != "") //{ //} param2[0].Value = Session["DealerCode"].ToString(); // 0 param2[1].Value = max; //1 param2[2].Value = ddlJobCardCode.SelectedValue; param2[3].Value = FeedBackDT.Rows[i]["ParentQuestionCode"].ToString(); param2[4].Value = FeedBackDT.Rows[i]["Rating"].ToString(); sysFunc.ExecuteSP_NonQuery("SP_InsertQuestionsDetail", param2); } //createGrid(); lblMessage.Text = "FeeBack Inserted."; BtnClear_Click(null, null); gv_FeedbackQuestions.DataSource = null; gv_FeedbackQuestions.DataBind(); } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }