public static bool Insert_MonthlyCommisionMaster(MonthlyCommisionVM model, ref string msg) { try { if (string.IsNullOrEmpty(model.TransCode)) { if (sysfun.IsExist("CommMonth", model.CommMonth, "MonthlyCommision", model.DealerCode, " And Service = '" + model.Service + "'")) { msg = "Monthly Commision for the Month " + model.CommMonth + " for the selected Service is already exists "; //return false; strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode); } else { strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode); } } else { strAutoCode = model.TransCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@TransCode", strAutoCode), //1 new SqlParameter("@TransDate", sysfun.SaveDate(model.TransDate)), //1 new SqlParameter("@CommMonth", model.CommMonth), //2 new SqlParameter("@UpdUser", AuthBase.UserId), //6 new SqlParameter("@UpdDate", DateTime.Now), //8 new SqlParameter("@UpdTerm", General.CurrentIP), //7 new SqlParameter("@Remarks", model.Remarks), //11 new SqlParameter("@Service", model.Service) //12 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Insert_MonthlyCommision", param, Trans)) { IsSaved = true; } else { return(IsSaved); } } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }
public static bool Insert_ProfessionType(ProfessionTypeVM model) { try { if (string.IsNullOrEmpty(model.ProfCode)) { strAutoCode = sysfun.GetNewMaxID("Profession", "ProfCode", 5, "COMON"); } else { strAutoCode = model.ProfCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@ProfTypeCode", strAutoCode), //1 new SqlParameter("@ProfTypeDesc", model.ProfDesc), //2 new SqlParameter("@UpdUser", AuthBase.UserId), //3 new SqlParameter("@UpdTerm", General.CurrentIP) //4 }; dt = DataAccess.getDataTable("Sp_Insert_ProfessionType", param, General.GetBMSConString()); if (dt.Rows.Count > 0) { } IsSaved = true; } catch (Exception) { throw; } return(IsSaved); }
protected void btnInsert_Click(object sender, EventArgs e) { if (ddlControlType.SelectedIndex == 0) { lblMessage.Text = "Select Control Type First"; return; } if (ddlServiceType.SelectedIndex == 0) { lblMessage.Text = "Select Service Type First"; return; } try { string max = sysFunc.GetNewMaxID("FeedBackQuestions", "ParentQuestionCode", 3, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@ParentQuestionCode", SqlDbType.Char, 3), //1 new SqlParameter("@ParentQuestionDesc", SqlDbType.VarChar,100),//2 new SqlParameter("@ControlType", SqlDbType.VarChar,50), //2 new SqlParameter("@ServiceType", SqlDbType.VarChar,50), new SqlParameter("@QSequence", SqlDbType.Int, 3), new SqlParameter("@InActive", SqlDbType.VarChar, 1), new SqlParameter("@UpdUser", SqlDbType.VarChar,50), //3 new SqlParameter("@UpdTerm", SqlDbType.VarChar,50), //4 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtParentQuestionDesc.Text.Trim(); param[3].Value = ddlControlType.SelectedValue.ToString().Trim(); param[4].Value = ddlServiceType.SelectedValue.ToString().Trim(); param[5].Value = txtSequence.Text.Trim(); if (check.Checked) { param[6].Value = "Y"; } else { param[6].Value = "N"; } param[7].Value = Session["UserName"].ToString(); param[8].Value = "1"; sysFunc.ExecuteSP_NonQuery("SP_InsertFeedbackQuestion", param); sysFunc.ClearTextBoxes(Page); createGrid(); lblMessage.Text = "Feedback Question Inserted."; } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnSave1_Click(object sender, EventArgs e) { string strAutoCode = string.Empty; try { if (ddljob_code.SelectedIndex == 0) { strAutoCode = SysFunc.GetNewMaxID("DefaultJob", "DefJobCode", 8, Session["DealerCode"].ToString()); } else { strAutoCode = ddljob_code.SelectedItem.Value; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@JobCatCode", SqlDbType.Char), //1 new SqlParameter("@DefJobCode", SqlDbType.Char), //2 new SqlParameter("@DefJobDesc", SqlDbType.VarChar), //3 new SqlParameter("@UpdUser", SqlDbType.VarChar), //4 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //5 new SqlParameter("@LaborAccount", SqlDbType.Char), //6 new SqlParameter("@StandardTime", SqlDbType.Char), //7 new SqlParameter("@BayCode", SqlDbType.Char) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddljob_category.SelectedValue; param[2].Value = strAutoCode; param[3].Value = txtjob_desc.Text; param[4].Value = Session["UserName"].ToString(); param[5].Value = GlobalVar.mUserIPAddress; param[6].Value = ddlacount_code.SelectedValue; param[7].Value = txtStnTime.Text; param[8].Value = ddlBayNo.SelectedValue; SysFunc.ExecuteSP_NonQuery("Sp_Insert_DefaultJob", param); cleadata(); lblMsg.Visible = true; //lblMsg.Text = "Labor " + strAutoCode + " Added Successfully"; ddljob_category_SelectedIndexChanged(null, null); //Create_Grid(); } catch (Exception ex) { lblMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void btnInsert_Click(object sender, EventArgs e) { try { string max = sysFunc.GetNewMaxID("Designation", "DesigCode", 3, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@DeptCode", SqlDbType.Char, 3), //0 new SqlParameter("@DesigCode", SqlDbType.Char, 3), //1 new SqlParameter("@DesigDesc", SqlDbType.VarChar, 50), //2 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //4 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlDeptCode.SelectedValue; param[2].Value = max; param[3].Value = txtDesigDesc.Text.Trim(); param[4].Value = Session["UserName"].ToString(); param[5].Value = "1"; if (txtDesigDesc.Text != "") { sysFunc.ExecuteSP_NonQuery("SP_InsertDesig", param); sysFunc.ClearTextBoxes(Page); createGrid(); lblMessage.ForeColor = Color.Green; lblMessage.Text = "New Designation " + param[2].Value + " Inserted."; } else { lblMessage.Visible = true; lblMessage.Text = "Designation Description can not be null or empty"; return; } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
public static bool Insert_VehicleType(VehicleTypeVM model) { string temp; try { if (string.IsNullOrEmpty(model.VehTypeCode)) { strAutoCode = sysfun.GetNewMaxID("VehicleType", "VehTypeCode", 5, model.DealerCode); //temp = sysfun.CustomerAutoGen("CRM_EnquiryMaster", "Enquiry_ID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), "00001"); } else { strAutoCode = model.VehTypeCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@VehTypeCode", strAutoCode), //1 new SqlParameter("@VehTypeDesc", model.VehTypeDesc), //2 new SqlParameter("@VehCategory", model.VehCategory), //3 new SqlParameter("@UpdUser", AuthBase.UserId), //4 new SqlParameter("@UpdTerm", General.CurrentIP) //5 }; dt = DataAccess.getDataTable("Sp_Insert_VehicleType", param, General.GetBMSConString()); if (dt.Rows.Count > 0) { } IsSaved = true; } catch (Exception) { throw; } return(IsSaved); }
protected void BtnAdd_Labor_Click(object sender, ImageClickEventArgs e) { ds = new DataSet(); DropDownList ddlbrand_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlbrand_code"); DropDownList ddlprod_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlprod_code"); DropDownList ddlVersion_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlVersion_code"); TextBox txtTaxAmt = (TextBox)gv_labor.FooterRow.FindControl("txtTaxAmt"); TextBox txtAmount = (TextBox)gv_labor.FooterRow.FindControl("txtAmount"); TextBox txtStnTime = (TextBox)gv_labor.FooterRow.FindControl("txtStnTime"); if (ddlbrand_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Made"; return; } if (ddlprod_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Product "; return; } if (ddlVersion_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Version "; return; } if (txtTaxAmt.Text.Trim() == "") { lblMsg.Visible = true; lblMsg.Text = "Tax Amount cannot be empty or Zer(0)"; return; } if (txtAmount.Text == "" || txtAmount.Text == "0") { lblMsg.Visible = true; lblMsg.Text = "Amount cannot be empty or Zer(0)"; return; } if (txtStnTime.Text == "" || txtStnTime.Text == "0") { lblMsg.Visible = true; lblMsg.Text = "Time can not be null"; return; } try { ds = (DataSet)Session["LaborDS"]; foreach (DataRow dr in ds.Tables[0].Rows) { if (ddlbrand_code.SelectedValue == dr["Made"].ToString() && ddlprod_code.SelectedValue.Trim() == dr["Product"].ToString() && ddlVersion_code.SelectedValue == dr["Version"].ToString()) { lblMsg.Visible = true; lblMsg.Text = "Brand Code: " + ddlbrand_code.SelectedValue + " Already Selected"; return; } } if (ds.Tables[0].Rows[0]["DefJobCode"].ToString() == string.Empty) { ds.Tables[0].Rows.RemoveAt(0); create_row(); } else { create_row(); } Session["LaborDS"] = ds; //Uzair string strAutoCode = string.Empty; if (ddljob_code.SelectedIndex == 0) { strAutoCode = SysFunc.GetNewMaxID("DefaultJob", "DefJobCode", 5, Session["DealerCode"].ToString()); } else { strAutoCode = ddljob_code.SelectedItem.Value; } SqlParameter[] param2 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@DefJobCode", SqlDbType.VarChar), //1 new SqlParameter("@ProdCode", SqlDbType.VarChar), //2 new SqlParameter("@VersionCode", SqlDbType.Char), //3 new SqlParameter("@Amount", SqlDbType.Float), //4 new SqlParameter("@UpdUser", SqlDbType.Char), //5 new SqlParameter("@UpdTerm", SqlDbType.Char), //6 new SqlParameter("@ServiceTax", SqlDbType.Decimal), //7 new SqlParameter("@BrandCode", SqlDbType.VarChar), //8 new SqlParameter("@StnTime", SqlDbType.Char) //9 }; param2[0].Value = Session["DealerCode"].ToString(); param2[1].Value = strAutoCode; param2[2].Value = ddlprod_code.SelectedValue; param2[3].Value = ddlVersion_code.SelectedValue; param2[4].Value = txtAmount.Text; param2[5].Value = Session["UserName"].ToString(); param2[6].Value = GlobalVar.mUserIPAddress; param2[7].Value = txtTaxAmt.Text; param2[8].Value = ddlbrand_code.SelectedValue; param2[9].Value = txtStnTime.Text; SysFunc.ExecuteSP_NonQuery("Sp_Insert_LaborDetail", param2); lblMsg.Visible = true; lblMsg.Text = "Labor " + strAutoCode + " Added Successfully"; } catch (Exception ex) { lblMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void btn_save_Click(object sender, EventArgs e) { string strAutoCode = string.Empty; string active = "N"; string leavedate = txtleaving_date.Text; if (txtEmpID.BorderColor == Color.Red) { success_add_item.Visible = true; success_add_item.Text = "This Employee No. is already in use"; return; } if (cbActive.Checked == true) { active = "Y"; } if (cbActive.Checked == false) { active = "N"; } if (active == "Y" && txtleaving_date.Text.Trim() != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Remove Leaving Date If you are still Employee"; return; } if (active == "N" && txtleaving_date.Text == "") { success_add_item.Visible = true; success_add_item.Text = "Enter Leaving Date"; return; } //if(ddldep_code.SelectedValue == "001" && ddldesig_code.SelectedValue == "001") //{ // if(txtEmail.Text == "") // { // RegularExpressionValidator4.IsValid = false; // RegularExpressionValidator4.Visible = true; // RegularExpressionValidator4.ErrorMessage = "Email address is necessary"; // return; // }else // { // RegularExpressionValidator4.Visible = false; // RegularExpressionValidator4.ErrorMessage = ""; // } //} try { //join_date = Convert.ToDateTime(txtjoining_date.Text).Date; join_date = DateTime.ParseExact(txtjoining_date.Text, "dd-MM-yyyy", null); //dob_date = Convert.ToDateTime(txtdob.Text).Date; dob_date = DateTime.ParseExact(txtdob.Text, "dd-MM-yyyy", null); if (txtleaving_date.Text.Trim() != string.Empty) { leav_date = DateTime.ParseExact(txtleaving_date.Text, "dd-MM-yyyy", null); } if (ddlEmployee.SelectedIndex == 0) { strAutoCode = SysFunc.GetNewMaxID("DealerEmp", "EmpCode", 3, Session["DealerCode"].ToString()); } else { strAutoCode = ddlEmployee.SelectedItem.Value; } if (SysFunc.ValidateDate(txtdob.Text) == true) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid DOB, not greater than current Date"; return; } if (SysFunc.ValidateDate(txtjoining_date.Text) == true) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid Joining Date, not greater than current Date"; return; } if (SysFunc.ValidateDate(txtleaving_date.Text) == true && txtleaving_date.Text != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid Leaving, not greater than current Date"; return; } if (dob_date >= join_date) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid DOB, not greater than or equal to Joining Date"; return; } if (join_date >= leav_date && txtleaving_date.Text != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Joining Date not greater than or equal to Leaving Date"; return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@EmpCode", SqlDbType.Char), //1 new SqlParameter("@EmpID", SqlDbType.Char), //2 new SqlParameter("@EmpName", SqlDbType.VarChar), //3 new SqlParameter("@JoiningDate", SqlDbType.DateTime), //4 new SqlParameter("@ContactNo", SqlDbType.VarChar), //5 new SqlParameter("@DOB", SqlDbType.DateTime), //6 new SqlParameter("@Experience", SqlDbType.TinyInt), //7 new SqlParameter("@LeavingDate", SqlDbType.DateTime), //8 new SqlParameter("@DesigCode", SqlDbType.Char), //9 new SqlParameter("@DeptCode", SqlDbType.Char), //10 new SqlParameter("@Remarks", SqlDbType.VarChar), //11 new SqlParameter("@PrimaryTechCode", SqlDbType.Char), //12 new SqlParameter("@UserName", SqlDbType.VarChar), //13 new SqlParameter("@Password", SqlDbType.VarChar), //14 new SqlParameter("@Role", SqlDbType.VarChar), //15 new SqlParameter("@Active", SqlDbType.Char), //16 new SqlParameter("@SecurityUserID", SqlDbType.Char), //17 new SqlParameter("@CNIC", SqlDbType.Char), //18 new SqlParameter("@Picture", SqlDbType.VarChar), //19 new SqlParameter("@Email", SqlDbType.VarChar) //20 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = strAutoCode; param[2].Value = txtEmpID.Text; param[3].Value = txtEmp_name.Text; param[4].Value = join_date; param[5].Value = txtcontact_no.Text; param[6].Value = dob_date; param[7].Value = txtexp.Text; param[8].Value = SysFunc.SaveDate(txtleaving_date.Text); param[9].Value = ddldesig_code.SelectedItem.Value; param[10].Value = ddldep_code.SelectedItem.Value; param[11].Value = txtremarks.Text; param[12].Value = ""; param[13].Value = ""; param[14].Value = ""; param[15].Value = ""; param[16].Value = active; param[17].Value = string.Empty; param[18].Value = txtnic_no.Text.Trim(); param[19].Value = Session["EmployeeImagePath"].ToString(); param[20].Value = txtEmail.Text; SysFunc.ExecuteSP_NonQuery("Sp_Insert_DealerEmp", param); cleardata(); LoadDDL_EmpCode(); success_add_item.Visible = true; success_add_item.ForeColor = Color.Green; if (btn_save.Text == "Save") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true); } if (btn_save.Text == "Update") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true); } } catch (Exception ex) { success_add_item.Visible = true; success_add_item.Text = ex.Message; } }
protected void btn_save_Click(object sender, EventArgs e) { if (!sec.UserRight("2551", "002")) { Response.Redirect("~/Test.aspx"); } string strAutoCode = string.Empty; SqlTransaction trans = null; bool check = false; try { if (ObjTrans.BeginTransaction(ref trans) == true) { } else { return; } if (ddltransfer_no.SelectedIndex == 0) { strAutoCode = SysFunc.GetNewMaxID("PartsLocTransMaster", "TransNo", 8, Session["DealerCode"].ToString()); } else { if (!sec.UserRight("2551", "003")) { Response.Redirect("~/Test.aspx"); } strAutoCode = ddltransfer_no.SelectedItem.Value; } DateTime transDate = DateTime.ParseExact(txtdate.Text, "dd-MM-yyyy", null); DateTime postDate = DateTime.ParseExact(txtdate.Text, "dd-MM-yyyy", null); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@TransNo", SqlDbType.Char), //1 new SqlParameter("@TransDate", SqlDbType.DateTime), //2 new SqlParameter("@Remarks", SqlDbType.VarChar), //3 new SqlParameter("@DelFlag", SqlDbType.Char), //4 new SqlParameter("@UpdUser", SqlDbType.VarChar), //5 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //6 new SqlParameter("@PostDate", SqlDbType.DateTime), //7 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = strAutoCode; param[2].Value = transDate; param[3].Value = txtremarks.Text; param[4].Value = "N"; param[5].Value = Session["UserName"].ToString(); param[6].Value = GlobalVar.mUserIPAddress; param[7].Value = postDate; if (SysFunc.ExecuteSP_NonQuery("Sp_Insert_PartsLocTranstMaster", param, trans) == true) { SqlParameter[] param2 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@TransNo", SqlDbType.Char), //1 new SqlParameter("@ItemCode", SqlDbType.Char), //2 new SqlParameter("@FromLocCode", SqlDbType.Char), //3 new SqlParameter("@ToLocCode", SqlDbType.Char), //4 new SqlParameter("@Qty", SqlDbType.Float), //5 }; for (int j = 0; j < GridView_Location.Rows.Count; j++) { Label lblItemCode = (Label)GridView_Location.Rows[j].FindControl("lblItemNo"); Label lblFromLocCode = (Label)GridView_Location.Rows[j].FindControl("lblFromLocCode"); Label lblToLocCode = (Label)GridView_Location.Rows[j].FindControl("lblToLocCode"); Label lblQty = (Label)GridView_Location.Rows[j].FindControl("lblQty"); param2[0].Value = Session["DealerCode"].ToString(); param2[1].Value = strAutoCode; param2[2].Value = lblItemCode.Text; param2[3].Value = lblFromLocCode.Text; param2[4].Value = lblToLocCode.Text; param2[5].Value = lblQty.Text; SysFunc.ExecuteSP_NonQuery("Sp_Insert_PartsLocTransDetail", param2, trans); if (UpdateItemStock(lblItemCode.Text, lblFromLocCode.Text, lblToLocCode.Text, double.Parse(lblQty.Text), ref trans) == true) { check = true; } else { check = false; return; } } cleardata(); create_grid(); success_add_item.Visible = true; success_add_item.ForeColor = Color.Red; success_add_item.Text = "Location Transfered Successfully"; LoadDDL_TransLoc(); } else { check = false; return; } if (check == true) { ObjTrans.CommittTransaction(ref trans); } else { ObjTrans.RollBackTransaction(ref trans); return; } } catch (Exception ex) { ObjTrans.RollBackTransaction(ref trans); success_add_item.Visible = true; success_add_item.ForeColor = Color.Red; success_add_item.Text = ex.Message; } }
public static string Insert_VehicleMaster(VehicleVM model, string dealerCode) { string msg = ""; try { if (sysfun.IsExist("BrandCode", model.BrandCode, "Vehicle", dealerCode, "and ProdCode = '" + model.ProdCode + "'and VersionCode = '" + model.VersionCode + "'") && model.VehicleCode == null) { return(msg = "Vehicle is already Exists"); } if (model.VehicleCode == null || model.VehicleCode == "" || model.VehicleCode == "0") { strAutoCode = sysfun.GetNewMaxID("Vehicle", "VehicleCode", 8, dealerCode); //strAutoCode = sysfun.AutoGen("Vehicle", "VehicleCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { strAutoCode = model.VehicleCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@BrandCode", SqlDbType.Char), //1 new SqlParameter("@ProdCode", SqlDbType.VarChar), //2 new SqlParameter("@VersionCode", SqlDbType.Char), //3 new SqlParameter("@Color", SqlDbType.VarChar), //4 new SqlParameter("@ColorCode", SqlDbType.Char), //5 new SqlParameter("@ProdDesc", SqlDbType.VarChar), //6 new SqlParameter("@ProdLongDesc", SqlDbType.VarChar), //7 new SqlParameter("@Power", SqlDbType.VarChar), //8 new SqlParameter("@CNGFlag", SqlDbType.Char), //9 new SqlParameter("@CommPerc", SqlDbType.Float), //10 new SqlParameter("@CommAmount", SqlDbType.Float), //11 new SqlParameter("@UpdUser", SqlDbType.VarChar), //12 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //13 new SqlParameter("@Version", SqlDbType.Char), //14 new SqlParameter("@FFS", SqlDbType.Float), //15 new SqlParameter("@PDI", SqlDbType.Float), //16 new SqlParameter("@VehicleStatus", SqlDbType.VarChar), //17 new SqlParameter("@CostPrice", SqlDbType.Float), //18 new SqlParameter("@ProdTitle", SqlDbType.VarChar), //19 new SqlParameter("@ReportingProdCode", SqlDbType.VarChar), //20 new SqlParameter("@IsActive", SqlDbType.Char), //21 new SqlParameter("@SalesAccountCode", SqlDbType.VarChar), //22 new SqlParameter("@EffectiveStartDate", SqlDbType.DateTime), //23 new SqlParameter("@EffectiveEndDate", SqlDbType.DateTime), //24 new SqlParameter("@EnginePrefix", SqlDbType.VarChar), //25 new SqlParameter("@SFS", SqlDbType.Int), //26 new SqlParameter("@TFS", SqlDbType.Int), //27 new SqlParameter("@VehTypeCode", SqlDbType.Char), //28 new SqlParameter("@Seater", SqlDbType.TinyInt), //29 new SqlParameter("@Compartment", SqlDbType.TinyInt), //30 new SqlParameter("@VehiclePrefix", SqlDbType.VarChar), //31 new SqlParameter("@Weight", SqlDbType.Int), //32 new SqlParameter("@SchedulePlan", SqlDbType.TinyInt), //33 new SqlParameter("@FreeServiceCup", SqlDbType.TinyInt), //34 new SqlParameter("@Remarks", SqlDbType.VarChar), //35 new SqlParameter("@Pic", SqlDbType.VarBinary), //36 new SqlParameter("@TransmissionType", SqlDbType.Char), //37 new SqlParameter("@VehicleCode", SqlDbType.Char), //38 new SqlParameter("@Segment", SqlDbType.Char), //39 new SqlParameter("@MSPR", SqlDbType.Char), //40 new SqlParameter("@VehicleCategory", SqlDbType.Char), //41 new SqlParameter("@VehicleStock", SqlDbType.Char), //42 new SqlParameter("@CostofSale", SqlDbType.Char), //43 new SqlParameter("@Revenue", SqlDbType.Char), //44 new SqlParameter("@OwnMoney", SqlDbType.Char), //45 new SqlParameter("@DownMoney", SqlDbType.Char), //44 }; param[0].Value = model.DealerCode; param[1].Value = model.BrandCode; param[2].Value = model.ProdCode; param[3].Value = model.VersionCode; param[4].Value = model.Color; param[5].Value = model.ColorCode; param[6].Value = model.ProdDesc; param[7].Value = model.ProdLongDesc; param[8].Value = model.Power; if (model.CNGFlag != "CNG") { param[9].Value = "N"; } else { param[9].Value = "Y"; } param[10].Value = Convert.ToDouble("0"); param[11].Value = Convert.ToDouble("0"); param[12].Value = AuthBase.UserId; param[13].Value = General.CurrentIP; param[14].Value = (object)DBNull.Value; if (model.FFS == null) { param[15].Value = Convert.ToDouble("0"); } else { param[15].Value = model.FFS; } if (model.PDI == null) { param[16].Value = Convert.ToDouble("0"); } else { param[16].Value = model.PDI; } param[17].Value = model.VehicleStatus; param[18].Value = Convert.ToDouble("0"); param[19].Value = model.ProdTitle; param[20].Value = (object)DBNull.Value; param[21].Value = model.IsActive; param[22].Value = (object)DBNull.Value; param[23].Value = (object)DBNull.Value; param[24].Value = (object)DBNull.Value; param[25].Value = (object)DBNull.Value; if (model.SFS == null) { param[26].Value = Convert.ToDouble("0"); } else { param[26].Value = model.SFS; } if (model.TFS == null) { param[27].Value = Convert.ToDouble("0"); } else { param[27].Value = model.TFS; } param[28].Value = model.VehTypeCode; param[29].Value = Convert.ToByte(model.Seater == "" ? "0" : model.Seater); param[30].Value = Convert.ToByte(model.Compartment == "" ? "0" : model.Compartment); param[31].Value = model.VehiclePrefix; param[32].Value = Convert.ToInt64(model.Weight == "" ? "0" : model.Weight); param[33].Value = Convert.ToByte(model.SchedulePlan == "" ? "0" : model.SchedulePlan); param[34].Value = Convert.ToByte(model.FreeServiceCup == "Y" ? "1" : "0"); param[35].Value = model.Remarks; param[36].Value = (object)DBNull.Value; param[37].Value = model.TransmissionType; param[38].Value = strAutoCode; param[39].Value = model.Segment; param[40].Value = model.MSPR; param[41].Value = model.VehicleCategory; param[42].Value = model.VehicleStock; param[43].Value = model.CostofSale; param[44].Value = model.Revenue; param[45].Value = model.OwnMoney; param[46].Value = model.DownMoney; if (sysfun.ExecuteSP_NonQuery("SP_Sales_Insert_Vehicle", param)) { IsSaved = true; msg = "Completed"; } } catch (Exception ex) { return(ex.Message); //throw; } return(msg); }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtTicketDate.Text == "") { lblMsg.Visible = true; lblMsg.Text = "Ticket Date can not be left blank"; return; } if (txtSubject.Text == "") { lblMsg.Visible = true; lblMsg.Text = "Subject can not be left blank"; return; } if (ddlComplaintby.SelectedValue == "0") { lblMsg.Visible = true; lblMsg.Text = "Complaint By can not be left blank"; return; } if (txtComplaint.Text == "") { lblMsg.Visible = true; lblMsg.Text = "Complaint Description can not be left blank"; return; } if (txtRemarks.Text == "") { lblMsg.Visible = true; lblMsg.Text = "Remarks can not be left blank"; return; } if (ddlPriority.SelectedValue == "0") { lblMsg.Visible = true; lblMsg.Text = "Select an option from Priority"; return; } if (ddlType.SelectedValue == "0") { lblMsg.Visible = true; lblMsg.Text = "Select an option from Type"; return; } if (ddlStatus.SelectedValue == "0") { lblMsg.Visible = true; lblMsg.Text = "Select an option from Status"; return; } try { string imgpath = Session["ImagePath"].ToString(); string max = ""; if (txtTicketNo.Text == "") { max = sysFunc.GetNewMaxID("Complaint", "TicketNo", 5, Session["DealerCode"].ToString()); } else { max = txtTicketNo.Text; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@TicketNo", SqlDbType.Char, 5), //1 new SqlParameter("@TicketDate", SqlDbType.DateTime), //2 // new SqlParameter("@Type",SqlDbType.VarChar,10),//3 new SqlParameter("@ComplaintTypeCode", SqlDbType.Char, 5), //3 new SqlParameter("@ComplaintDesc", SqlDbType.VarChar, 100), //4 new SqlParameter("@ComplaintImg", SqlDbType.VarChar, 50), //5 new SqlParameter("@status", SqlDbType.VarChar, 10), //6 new SqlParameter("@StatusbyOEM", SqlDbType.VarChar, 10), //7 new SqlParameter("@StatusRemarks", SqlDbType.VarChar, 50), //8 new SqlParameter("@Priority", SqlDbType.Char, 10), //9 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //10 new SqlParameter("@UpdDate", SqlDbType.DateTime), //11 new SqlParameter("@UpdTime", SqlDbType.DateTime), //12 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 13 new SqlParameter("@Subject", SqlDbType.VarChar, 50), // 14 new SqlParameter("@Complaintby", SqlDbType.Char, 5), // 15 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtTicketDate.Text.Trim(); param[3].Value = ddlType.SelectedValue.Trim(); param[4].Value = txtComplaint.Text; param[5].Value = imgpath; param[6].Value = ddlStatus.SelectedValue.Trim(); param[7].Value = txtStatusByOEM.Text.Trim(); param[8].Value = txtRemarks.Text.Trim(); param[9].Value = ddlPriority.SelectedValue.Trim(); param[10].Value = Session["UserName"].ToString(); param[11].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[12].Value = DateTime.Now; param[13].Value = "1"; param[14].Value = txtSubject.Text; param[15].Value = ddlComplaintby.SelectedValue.Trim(); if (sysFunc.ExecuteSP_NonQuery("SP_Insert_Complaint", param)) { createGrid(); if (txtTicketNo.Text == "") { lblMsg.ForeColor = System.Drawing.Color.Green; lblMsg.Text = "New Complaint Inserted."; } else { lblMsg.ForeColor = System.Drawing.Color.Green; lblMsg.Text = "New Complaint Updated."; } sysFunc.ClearTextBoxes(Page); } } catch (Exception ex) { sysFunc.UserMsg(lblMsg, System.Drawing.Color.Red, ex.Message); } }
public static bool Insert_Vendor(VendorVM model, string dealerCode) { string csgNo; try { if (model.VendorCode == "" || model.VendorCode == null) { strAutoCode = sysfun.GetNewMaxID("Vendor", "VendorCode", 6, dealerCode); } else { strAutoCode = model.VendorCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@VendorCode", strAutoCode), //1 new SqlParameter("@VendorDesc", model.VendorDesc), //2 // new SqlParameter("@FatherHusName",(object)DBNull.Value),//3 new SqlParameter("@Add1", model.Add1), //4 new SqlParameter("@Add2", (object)DBNull.Value), //5 new SqlParameter("@Add3", (object)DBNull.Value), //6 new SqlParameter("@ContPerson", model.ContPerson), //7 new SqlParameter("@PaymentTerm", model.PaymentTerm), //8 new SqlParameter("@CreditLimit", model.CreditLimit), //9 // new SqlParameter("@NIC",model.NIC),//10 // new SqlParameter("@VendorType",model.VendorType),//11 // new SqlParameter("@DOB",(object)DBNull.Value ),//12 new SqlParameter("@Phone1", model.Phone1), //13 new SqlParameter("@Phone2", model.Phone2), //14 // new SqlParameter("@CellNo",model.CellNo),//15 new SqlParameter("@Fax", model.Fax), //16 new SqlParameter("@Email", model.Email), //17 new SqlParameter("@URL", model.URL), //18 new SqlParameter("@NTN", model.NTN), //19 // new SqlParameter("@AdvanceReceipt",(object)DBNull.Value ),//20 new SqlParameter("@UpdUser", AuthBase.UserId), //21 new SqlParameter("@UpdTerm", General.CurrentIP), //22 new SqlParameter("@GSTno", model.GSTno), //23 // new SqlParameter("@Behavior",(object)DBNull.Value),//24 // new SqlParameter("@Remarks",(object)DBNull.Value),//25 // new SqlParameter("@Distance",model.Distance),//26 // new SqlParameter("@CountryCode", model.CountryCode),//27 // new SqlParameter("@CityCode", model.CityCode),//28 // new SqlParameter("@StateCode", model.StateCode),//29 new SqlParameter("@Title", model.Title), //30 // new SqlParameter("@CSGNo", csgNo),//31 // new SqlParameter("@MCNo", model.MCNo),//32 new SqlParameter("@AccountCode", model.AccountCode), // 33 new SqlParameter("@VendorRecievable", model.VendorRecievable), // 34 new SqlParameter("@VendorPayable", model.VendorPayable) // 35 }; if (sysfun.ExecuteSP_NonQuery("sp_Insert_VendorNew", param)) { IsSaved = true; } } catch (Exception ex) { throw; } return(IsSaved); }
protected void btnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2530", "002")) { Response.Redirect("~/Test.aspx"); } if (txtCusVehCode.Text != "") { if (!sec.UserRight("2530", "003")) { Response.Redirect("~/Test.aspx"); } } TextBox[] textBoxes = { txtCusCode, txtAccCode, txtChassisNo, txtEngineNo, txtRegNo }; //if (sysFuns.CodeExists("CustomerEstimateMaster", "EngineNo", txtEngineNo.Text.Trim(), Session["DealerCode"].ToString())) //{ // lblMsg.Text = "Can not update this Engine number use in Estimate " + txtEngineNo.Text; // lblMsg.ForeColor = Color.Red; // txtEngineNo.Focus(); // return; //} //else //{ // lblMsg.Text = ""; //} //if (sysFuns.CodeExists("CustomerEstimateMaster", "ChassisNo", txtChassisNo.Text.Trim(), Session["DealerCode"].ToString())) //{ // lblMsg.Text = "Can not update this Chassis number use in Estimate " + txtChassisNo.Text; // lblMsg.ForeColor = Color.Red; // txtChassisNo.Focus(); // return; //} //else //{ // lblMsg.Text = ""; //} //if (sysFuns.CodeExists("JobCardMaster", "EngineNo", txtEngineNo.Text.Trim(), Session["DealerCode"].ToString(), " And GatePass='' ")) //{ // lblMsg.Text = "Can not update this Engine number use in Job Card " + txtEngineNo.Text; // lblMsg.ForeColor = Color.Red; // txtEngineNo.Focus(); // return; //} //else //{ // lblMsg.Text = ""; //} //if (sysFuns.CodeExists("JobCardMaster", "ChassisNo", txtChassisNo.Text.Trim(), Session["DealerCode"].ToString(), " And GatePass='' ")) //{ // lblMsg.Text = "Can not update this Chassis number use in Job Card " + txtChassisNo.Text; // lblMsg.ForeColor = Color.Red; // txtChassisNo.Focus(); // return; //} //else //{ // lblMsg.Text = ""; //} if (txtInvDate.Text != "" && txtRegDate.Text != "") { DateTime reg_date, invoice_date; invoice_date = DateTime.ParseExact(txtInvDate.Text, "dd-MM-yyyy", null); reg_date = DateTime.ParseExact(txtRegDate.Text, "dd-MM-yyyy", null); if (reg_date < invoice_date) { lblMsg.Visible = true; lblMsg.ForeColor = Color.Red; lblMsg.Text = "Registration date should not be less then Invoice date"; return; } } if (ddlColor.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.ForeColor = Color.Red; lblMsg.Text = "Please Select the Color"; return; } //TextBox[] textBoxes = { txtCustomerCode, txtEndUser, txtRegDate, txtRegNo, txtEngineNo, txtChassisNo, txtProduct, txtInvoiceNo, txtInvoiceDate }; if (ddlCustomer.SelectedValue.Trim() == "" || ddlAcctof.SelectedValue.Trim() == "0" || ddlAcctof.SelectedIndex == 0 || txtChassisNo.Text.Trim() == "" || txtEngineNo.Text.Trim() == "") { sysFun.UserMsg(lblMsg, Color.Red, "Please Select the Customer First"); return; } if (!MasterValidation(textBoxes)) { return; } else { /// Validate from SMIS Database of Engine number /// DataSet dsValidate = new DataSet(); 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, 20), //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 new SqlParameter("@WorkbookNo", SqlDbType.VarChar, 25), //21 new SqlParameter("@DeliveryDate", SqlDbType.DateTime), //22 new SqlParameter("@CusVehCode", SqlDbType.Char, 8) //23 }; // 101 = Not Available // 102 = Not Understand param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlCustomer.SelectedValue.Trim(); param[2].Value = ddlAcctof.SelectedValue.Trim(); param[3].Value = sysFuns.SaveDate(txtRegDate.Text); param[4].Value = txtRegNo.Text.Trim().ToUpper().ToUpper(); param[5].Value = txtChassisNo.Text.Trim().ToUpper(); param[6].Value = txtEngineNo.Text.Trim().ToUpper(); param[7].Value = ddlBrand.SelectedValue.ToString().Trim(); param[8].Value = ddlProduct.SelectedValue; param[9].Value = ddlVersion.SelectedValue.Trim(); param[10].Value = ddlColor.SelectedValue.ToString().Trim(); param[11].Value = txtInvoiceNo.Text.Trim(); param[12].Value = sysFuns.SaveDate(txtInvDate.Text); param[13].Value = ddlInsCo.SelectedValue.Trim(); param[14].Value = txtPolicyNo.Text.Trim(); param[15].Value = ""; // new SqlParameter("@LossNo",SqlDbType.VarChar,15), param[16].Value = ""; // new SqlParameter("@MeterReading",SqlDbType.VarChar,10), param[17].Value = ""; // new SqlParameter("@MonthReading",SqlDbType.VarChar,4), param[18].Value = ""; // new SqlParameter("@Remarks",SqlDbType.VarChar,100), param[19].Value = Session["UserName"].ToString().ToUpper(); param[20].Value = Environment.MachineName; param[21].Value = txtWBNo.Text; param[22].Value = sysFuns.SaveDate(txtDeliveryDate.Text); //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 ((sysFun.IsExist("CusCode", ddlCustomer.SelectedValue.Trim(), "Customer", Session["DealerCode"].ToString()) == true)) { if ((sysFun.IsExist("BrandCode", ddlBrand.SelectedValue.Trim(), "Brand", Session["DealerCode"].ToString()) == true)) { if ((sysFun.IsExist("VersionCode", ddlVersion.SelectedValue, "Vehicle", Session["DealerCode"].ToString()) == true)) { // apStr = " and versioncode=" + txtVersion.Text + " and ProdCode='" + txtProduct.Text + "'"; if ((sysFun.IsExist("ColorCode", ddlColor.SelectedValue, "Color", Session["DealerCode"].ToString()) == true)) { //if (!sysFun.IsExist("RegNo", txtRegNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) // & !sysFun.IsExist("ChassisNo", txtChassisNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) // & !sysFun.IsExist("EngineNo", txtEngineNo.Text, "CustomerVehicle", Session["DealerCode"].ToString())) if (txtCusVehCode.Text == "") { if ((sysFun.IsExist("ChassisNo", txtChassisNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) == true)) { lblMsg.Text = "Record Not Saved!" + txtChassisNo.Text + " is already exist "; return; } if ((sysFun.IsExist("EngineNo", txtEngineNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) == true)) { lblMsg.Text = "Record Not Saved!" + txtEngineNo.Text + " is already exist "; return; } if ((sysFun.IsExist("RegNo", txtRegNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) == true)) { lblMsg.Text = "Record Not Saved!" + txtRegNo.Text + " is already exist "; return; } AutoGenCode = sysFun.GetNewMaxID("CustomerVehicle", "CusVehCode", 8, Session["DealerCode"].ToString()); param[23].Value = AutoGenCode; if (sysFun.ExecuteSP_NonQuery("sp_CustomerVehicle_Insert", param)) { lblMsg.Text = "Record Saved!" + ddlVersion.SelectedValue; // ClearALL(); ClearTextBoxs(); } else { lblMsg.Text = "Record Not Saved!"; //PopupControlMSG.ShowOnPageLoad = true; } } else { param[23].Value = txtCusVehCode.Text; string apStr = " and ChassisNo ='" + txtChassisNo.Text + "' and jobstatus = null and GatePass = null"; if (sysFun.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString()) & sysFun.IsExist("EngineNo", txtEngineNo.Text, "JobCardMaster", Session["DealerCode"].ToString())) { if (sysFun.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString(), apStr)) { lblMsg.Text = "Record can not be updated"; //PopupControlMSG.ShowOnPageLoad = true; return; } else { if (sysFun.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param)) { // objMBLL.ShowMessageBox("Record Updated", txtCustomerCode); lblMsg.Text = "Record Updated"; //PopupControlMSG.ShowOnPageLoad = true; //GetDataLoaded(true, false); //ClearALL(); // LoadData() ClearTextBoxs(); } else { lblMsg.Text = "Record Not updated"; //PopupControlMSG.ShowOnPageLoad = true; } } } else { if (sysFun.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param)) { //objMBLL.ShowMessageBox("Record Updated", txtCustomerCode); lblMsg.Text = "Record updated"; //PopupControlMSG.ShowOnPageLoad = true; ClearTextBoxs(); //GetDataLoaded(true, false); // LoadData(); } 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() + "/"; //PopupControlMSG.ShowOnPageLoad = true; } } }
protected void btnSave_Click(object sender, EventArgs e) { string strAutoCode = string.Empty; if (Page.IsValid) { try { if (ddlBays.SelectedIndex == 0) { strAutoCode = sysFunc.GetNewMaxID("Bay", "BayID", 4, Session["DealerCode"].ToString()); } else { strAutoCode = ddlBays.SelectedValue; } SqlParameter[] param = { new SqlParameter("@BayID", SqlDbType.Char), //0 new SqlParameter("@BayDesc", SqlDbType.VarChar), //1 new SqlParameter("@ShopID", SqlDbType.Char), //2 new SqlParameter("@UpdUser", SqlDbType.VarChar), //3 new SqlParameter("@UpdTerm", SqlDbType.VarChar), //4 new SqlParameter("@DealerCode", SqlDbType.Char), //5 new SqlParameter("@Active", SqlDbType.Char) //6 }; param[0].Value = strAutoCode; param[1].Value = txtBayDesc.Text; param[2].Value = ddlShop.SelectedValue.Trim(); param[3].Value = Session["UserName"].ToString(); param[4].Value = GlobalVar.mUserIPAddress; param[5].Value = Session["DealerCode"].ToString(); if (chkActive.Checked) { param[6].Value = "Y"; } else { param[6].Value = "N"; } sysFunc.ExecuteSP_NonQuery("Sp_Insert_Bay", param); cleadata(); lblMsg.Visible = true; //lblMsg.Text = "Labor " + strAutoCode + " Added Successfully"; Create_Grid(); Loadddl(); } catch (Exception ex) { lblMsg.Visible = true; lblMsg.Text = ex.Message; } } else { lblMsg.Visible = true; lblMsg.Text = "Fill the Required Fields"; } }
public static bool Insert_SupplierMaster(SupplierVM model) { try { if (model.VendorCode == "" || model.VendorCode == null) { strAutoCode = sysfun.GetNewMaxID("Vendor", "VendorCode", 6, model.DealerCode); } else { strAutoCode = model.VendorCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@VendorCode", SqlDbType.Char), //1 new SqlParameter("@VendorDesc", SqlDbType.VarChar), //2 new SqlParameter("@Add1", SqlDbType.VarChar), //3 new SqlParameter("@Add2", SqlDbType.VarChar), //4 new SqlParameter("@Add3", SqlDbType.VarChar), //5 new SqlParameter("@ContPerson ", SqlDbType.VarChar), //6 new SqlParameter("@Phone1", SqlDbType.VarChar), //7 new SqlParameter("@Phone2", SqlDbType.VarChar), //8 new SqlParameter("@Fax ", SqlDbType.VarChar), //9 new SqlParameter("@Email", SqlDbType.VarChar), //10 new SqlParameter("@URL", SqlDbType.VarChar), //11 new SqlParameter("@GSTno ", SqlDbType.VarChar), //12 new SqlParameter("@NTN ", SqlDbType.VarChar), //13 new SqlParameter("@PaymentTerm", SqlDbType.Float), //14 new SqlParameter("@AccountCode", SqlDbType.VarChar), //15 new SqlParameter("@AdvanceGiven", SqlDbType.Float), //16 new SqlParameter("@UpdUser ", SqlDbType.VarChar), //17 new SqlParameter("@UpdTerm ", SqlDbType.VarChar), //18 new SqlParameter("@CreditLimit", SqlDbType.Float), //19 new SqlParameter("@Title", SqlDbType.VarChar) //20 }; param[0].Value = model.DealerCode; param[1].Value = strAutoCode; param[2].Value = model.VendorDesc; param[3].Value = model.Add1; param[4].Value = model.Add2; param[5].Value = model.Add3; param[6].Value = model.ContPerson; param[7].Value = model.Phone1; param[8].Value = model.Phone2; param[9].Value = model.Fax; param[10].Value = model.Email; param[11].Value = model.URL; param[12].Value = model.GSTno; param[13].Value = model.NTN; param[14].Value = model.PaymentTerm == "" ? "0" : model.PaymentTerm; param[15].Value = model.AccountCode; param[16].Value = 0; param[17].Value = AuthBase.UserName; param[18].Value = General.CurrentIP; param[19].Value = (model.CreditLimit == "" ? "0" : model.CreditLimit); param[20].Value = "Supplier"; if (sysfun.ExecuteSP_NonQuery("Sp_Insert_Vendor", param)) { IsSaved = true; } } catch (Exception) { throw; } return(IsSaved); }
public static bool Insert_Customer(CustomerVM model, string dealerCode, ref string msg) { string csgNo; try { if (model.CusCode == "" || model.CusCode == null) { strAutoCode = sysfun.GetNewMaxID("Customer", "CusCode", 8, dealerCode); string sql = "Select NTNno from Customer where DealerCode='" + dealerCode + "'"; dt = sysfun.GetData(sql, "BMS0517ConnectionString"); if (NTNno == model.NTNno) { msg = "This Record Can't Be Edit or Save. . .! NTNno Should be Unique NTNno."; return(false); } string sql1 = "Select CellNo from Customer where DealerCode='" + dealerCode + "'"; dt = sysfun.GetData(sql1, "BMS0517ConnectionString"); if (dt.Rows.Count > 0) { CellNo = dt.Rows[0]["CellNo"].ToString(); // Delflag = dt.Rows[0]["DelFalg"].ToString(); if (CellNo == model.CellNo) { msg = "This Record Can't Be Edit or Save. . .! CellNo Should be Unique CellNo."; return(false); } } } else { strAutoCode = model.CusCode; } if (model.CSGNo == null) { csgNo = sysfun.CustomerAutoGen("Customer", "CSGNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { csgNo = model.CSGNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@CusCode", strAutoCode), //1 new SqlParameter("@CusDesc", model.CusDesc), //2 new SqlParameter("@FatherHusName", (object)DBNull.Value), //3 new SqlParameter("@Address1", model.Address1), //4 new SqlParameter("@Address2", (object)DBNull.Value), //5 new SqlParameter("@Address3", (object)DBNull.Value), //6 new SqlParameter("@ContPerson", model.ContPerson), //7 new SqlParameter("@CreditDays", model.CreditDays), //8 new SqlParameter("@CreditLimit", model.CreditLimit), //9 new SqlParameter("@NIC", model.NIC), //10 new SqlParameter("@CusTypeCode", model.CusTypeCode), //11 new SqlParameter("@DOB", (object)DBNull.Value), //12 new SqlParameter("@Phone1", model.Phone1), //13 new SqlParameter("@Phone2", model.Phone2), //14 new SqlParameter("@CellNo", model.CellNo), //15 new SqlParameter("@FaxNo", model.FaxNo), //16 new SqlParameter("@Email", model.Email), //17 new SqlParameter("@URL", model.URL), //18 new SqlParameter("@NTNno", model.NTNno), //19 new SqlParameter("@AdvanceReceipt", (object)DBNull.Value), //20 new SqlParameter("@UpdUser", AuthBase.UserId), //21 new SqlParameter("@UpdTerm", General.CurrentIP), //22 new SqlParameter("@SalesTaxRegNo", model.SalesTaxRegNo), //23 new SqlParameter("@Behavior", (object)DBNull.Value), //24 new SqlParameter("@Remarks", (object)DBNull.Value), //25 new SqlParameter("@Distance", model.Distance), //26 new SqlParameter("@CountryCode", model.CountryCode), //27 new SqlParameter("@CityCode", model.CityCode), //28 new SqlParameter("@StateCode", model.StateCode), //29 new SqlParameter("@Title", model.Title), //30 new SqlParameter("@CSGNo", csgNo), //31 new SqlParameter("@MCNo", model.MCNo), //32 new SqlParameter("@AccountCode", model.AccountCode) // 33 }; if (sysfun.ExecuteSP_NonQuery("sp_Insert_Customer", param)) { IsSaved = true; } } catch (Exception ex) { throw; } return(IsSaved); }
public static bool Insert_Customer(CustomerVM model, string dealerCode) { string csgNo; try { if (model.CusCode == "" || model.CusCode == null) { strAutoCode = sysfun.GetNewMaxID("Customer", "CusCode", 8, dealerCode); } else { strAutoCode = model.CusCode; } if (model.CSGNo == null) { csgNo = sysfun.CustomerAutoGen("Customer", "CSGNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { csgNo = model.CSGNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@CusCode", strAutoCode), //1 new SqlParameter("@CusDesc", model.CusDesc), //2 new SqlParameter("@FatherHusName", model.FatherHusName), //3 new SqlParameter("@Address1", model.Address1), //4 new SqlParameter("@Address2", (object)DBNull.Value), //5 new SqlParameter("@Address3", (object)DBNull.Value), //6 new SqlParameter("@ContPerson", model.ContPerson), //7 new SqlParameter("@CreditDays", model.CreditDays), //8 new SqlParameter("@CreditLimit", model.CreditLimit), //9 new SqlParameter("@NIC", model.NIC), //10 new SqlParameter("@CusTypeCode", model.CusTypeCode), //11 new SqlParameter("@DOB", (object)DBNull.Value), //12 new SqlParameter("@Phone1", model.Phone1), //13 new SqlParameter("@Phone2", model.Phone2), //14 new SqlParameter("@CellNo", model.CellNo), //15 new SqlParameter("@FaxNo", model.FaxNo), //16 new SqlParameter("@Email", model.Email), //17 new SqlParameter("@URL", model.URL), //18 new SqlParameter("@NTNno", model.NTNno), //19 new SqlParameter("@AdvanceReceipt", (object)DBNull.Value), //20 new SqlParameter("@UpdUser", AuthBase.UserId), //21 new SqlParameter("@UpdTerm", General.CurrentIP), //22 new SqlParameter("@SalesTaxRegNo", model.SalesTaxRegNo), //23 new SqlParameter("@Behavior", (object)DBNull.Value), //24 new SqlParameter("@Remarks", (object)DBNull.Value), //25 new SqlParameter("@Distance", model.Distance), //26 new SqlParameter("@CountryCode", model.CountryCode), //27 new SqlParameter("@CityCode", model.CityCode), //28 new SqlParameter("@StateCode", model.StateCode), //29 new SqlParameter("@Title", model.Title), //30 new SqlParameter("@CSGNo", csgNo), //31 new SqlParameter("@MCNo", model.MCNo), //32 new SqlParameter("@AccountCode", model.AccountCode), //33 new SqlParameter("@Source", "Sale") // 34 }; if (sysfun.ExecuteSP_NonQuery("sp_Insert_Customer", param)) { IsSaved = true; } } catch (Exception ex) { throw; } return(IsSaved); }