private void AddNewRow() { DataSet ds = new DataSet(); ds = (DataSet)ViewState["ObjPOds"]; DataRow row = ds.Tables["SaleReturnTable"].NewRow(); if (lblSNo.Text.Trim() != string.Empty) { row["Sno"] = lblSNo.Text; } else { row["Sno"] = SysFunc.GetNewMaxID("Sno", 3, ds); } row["Sno"] = ds.Tables["SaleReturnTable"].Rows.Count + 1; row["ItemCode"] = txtItemCode.Text.Trim(); row["PartItemNo"] = SysFunc.GetPartItemNoByItemCode(ddlParts.SelectedValue.ToString()); row["PartItemName"] = SysFunc.GetItemDescByItemCode(ddlParts.SelectedValue.ToString()); row["Unit"] = txtUnit.Text.Trim(); row["UnitCode"] = txtUnitCode.Text.Trim(); row["Rate"] = txtRate.Text.Trim(); row["Qty"] = txtQty.Text; row["Amount"] = txtTotalAmt.Text; row["Location"] = txtLocDesc.Text; row["LocationCode"] = txtLocCode.Text; row["AvgRate"] = txtAvgCost.Text; ds.Tables["SaleReturnTable"].Rows.Add(row); //ViewState["ObjPOds"] = ds; GvMain.DataSource = ds.Tables["SaleReturnTable"]; GvMain.DataBind(); ViewState["ObjPOds"] = ds; }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtSolutionsDesc.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Description", txtSolutionsDesc); return; } else if (txtProject.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Project", txtProject); return; } else { lblMessage.Text = string.Empty; } try { string max = sysFuncs.GetNewMaxID("Solution", "Solution_Code", 4, Session["DealerCode"].ToString()); // string max = sysFuncs.AutoGen("WorkFlowSetup", "WFCode", Session["DealerCode"].ToString(), DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Solution_Code", SqlDbType.Char, 4), //1 new SqlParameter("@Solution_Desc", SqlDbType.VarChar, 50), //2 new SqlParameter("@Project", SqlDbType.VarChar, 50), //3 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //4 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //5 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtSolutionsDesc.Text.Trim(); param[3].Value = txtProject.Text.Trim(); param[4].Value = Session["UserName"].ToString(); param[5].Value = "1"; sysFunc.ExecuteSP_NonQuery("SP_Solution_insert", param); sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtSolutionsDesc); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtItemCatDesc.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Item Category Description", txtItemCatDesc); return; } else { lblMessage.Text = string.Empty; } try { string max = sysFuncs.GetNewMaxID("ItemCategory", "ItemCatCode", 4, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@ItemCatCode", SqlDbType.Char, 4), //1 new SqlParameter("@ItemCatDesc", 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 = max; //param[1].Value = txtItemCatCode.Text.Trim(); param[2].Value = txtItemCatDesc.Text.Trim(); param[3].Value = Session["UserName"].ToString(); param[4].Value = "1"; sysFunc.ExecuteSP_NonQuery("SP_InsertItemCategory", param); sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtItemCatDesc); //lblMessage.Text = "New Item Category Inserted."; } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
///Insert Button protected void btnInsert_Click(object sender, EventArgs e) { if (txtunitdec.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Unit Description", txtunitdec); return; } else { lblMessage.Text = string.Empty; } DataTable dt = (DataTable)Session["UnitCategoryDS"]; // Check value in GridView TextBOX foreach (DataRow dr in dt.Rows) { if (dr["UnitDesc"].ToString().ToUpper() == txtunitdec.Text.ToUpper()) { sysFunc.UserMsg(lblMessage, Color.Red, "Alredy Exist"); return; } } try { string max = sysFuncs.GetNewMaxID("Unit", "UnitCode", 4, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@UnitCode", SqlDbType.Char, 4), //1 new SqlParameter("@UnitDesc", SqlDbType.VarChar, 50), //2 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3 new SqlParameter("@UpdDate", SqlDbType.DateTime), //4 new SqlParameter("@UpdTime", SqlDbType.DateTime), //5 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //6 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtunitdec.Text.ToUpper().Trim(); param[3].Value = Session["UserName"].ToString(); param[4].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[5].Value = DateTime.Now; param[6].Value = "1"; sysFunc.ExecuteSP_NonQuery("SP_Insert_Unit", param); sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtunitdec); //lblMessage.Text = "New Unit Category Inserted."; } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtTaxHead.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Tax Head should not left blank", txtTaxHead); return; } //if (txt.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg); // return; //} //if (txtRemarks.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg); // return; //} DataTable dt = (DataTable)Session["TaxTypeDS"]; try { string max = sysFuncs.GetNewMaxID("TaxType", "TaxID", 2, "COMON"); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@TaxID", SqlDbType.Char, 2), //1 new SqlParameter("@TaxHead", SqlDbType.VarChar, 50), //2 new SqlParameter("@TaxPer", SqlDbType.Decimal), //3 new SqlParameter("@Active", SqlDbType.Char, 1), //4 new SqlParameter("@Type", SqlDbType.VarChar, 50), //5 new SqlParameter("@TaxApplicable", SqlDbType.VarChar, 20), //6 new SqlParameter("@AccCode", SqlDbType.Char, 16), //7 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8 new SqlParameter("@UpdDate", SqlDbType.DateTime), //9 new SqlParameter("@UpdTime", SqlDbType.DateTime), //10 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 11 }; string activeCheck = ""; if (CheckId.Checked) { activeCheck = "Y"; } else { activeCheck = "N"; } // txtAccCode.Text = textAccCode; param[0].Value = "COMON"; param[1].Value = max; param[2].Value = txtTaxHead.Text; param[3].Value = SysFunctions.CustomCDBL(txtTaxPercent.Text); param[4].Value = activeCheck; param[5].Value = ddlType.Text; param[6].Value = ddlTaxApplicable.Text; param[7].Value = txtAccCode.Text; param[8].Value = Session["UserName"].ToString(); param[9].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[10].Value = DateTime.Now; param[11].Value = "1"; if (sysFunc.ExecuteSP_NonQuery("SP_Insert_TaxType", param)) { sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Record " + max + " Insert Sucessfully", txtTaxId); } else { sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtTaxId); } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtreg.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Reg No. should not left blank", txtreg); return; } if (txtNewcustomer.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg); return; } if (txtRemarks.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg); return; } DataTable dt = (DataTable)Session["CVODS"]; try { string max = sysFuncs.GetNewMaxID("CVO", "CVONo", 8, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@CVONo", SqlDbType.Char, 8), //1 new SqlParameter("@CVODate", SqlDbType.DateTime), //2 new SqlParameter("@RegNo", SqlDbType.VarChar, 50), //3 new SqlParameter("@ChassisNo", SqlDbType.VarChar, 50), //4 new SqlParameter("@EngineNo", SqlDbType.VarChar, 50), //5 new SqlParameter("@BrandCode", SqlDbType.Char, 3), //6 new SqlParameter("@ProdCode", SqlDbType.VarChar, 10), //7 new SqlParameter("@VersionCode", SqlDbType.Char, 3), //8 new SqlParameter("@ColorCode", SqlDbType.Char, 5), //9 new SqlParameter("@OwnerShipType", SqlDbType.VarChar, 50), //10 new SqlParameter("@OldCusCode", SqlDbType.VarChar, 50), //11 new SqlParameter("@NewCusCode", SqlDbType.VarChar, 50), //12 new SqlParameter("@Remarks", SqlDbType.VarChar, 50), //13 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //14 new SqlParameter("@UpdDate", SqlDbType.DateTime), //15 new SqlParameter("@UpdTime", SqlDbType.DateTime), //16 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 17 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = sysFunc.SaveDate(txtCVODate.Text); param[3].Value = txtreg.Text; param[4].Value = txtChassisNo.Text; param[5].Value = txtEngineNo.Text; param[6].Value = ""; param[7].Value = txtVehicle.Text; param[8].Value = ""; param[9].Value = ""; param[10].Value = ddlownership.SelectedValue; param[11].Value = txtOldCusCode.Text; param[12].Value = txtNewcustomer.Text; param[13].Value = txtRemarks.Text; param[14].Value = Session["UserName"].ToString(); param[15].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[16].Value = DateTime.Now; param[17].Value = "1"; if (sysFunc.ExecuteSP_NonQuery("SP_Insert_CVO", param)) { //sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtreg); } else { sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtreg); } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtRollsDesc.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Rolls Description", txtRollsDesc); return; } else if (txtPriority.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Priority", txtPriority); return; } else if (txtValidFrom.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Valid From Date", txtValidFrom); return; } else if (txtValidTo.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Valid To Date", txtValidTo); return; } else { lblMessage.Text = string.Empty; } try { string max = sysFuncs.GetNewMaxID("Rolls", "RollsID", 5, Session["DealerCode"].ToString()); // string max = sysFuncs.AutoGen("WorkFlowSetup", "WFCode", Session["DealerCode"].ToString(), DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char,5),//0 new SqlParameter("@RollsID", SqlDbType.Char,5), //1 new SqlParameter("@RollsDesc", SqlDbType.VarChar,50),//2 new SqlParameter("@Priority", SqlDbType.VarChar,50), //3 new SqlParameter("@ValidFrom", SqlDbType.DateTime), //4 new SqlParameter("@ValidTo", SqlDbType.DateTime), new SqlParameter("@Active", SqlDbType.Char,1), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtRollsDesc.Text.Trim(); param[3].Value = txtPriority.Text.Trim(); param[4].Value = sysFuncs.SaveDate(txtValidFrom.Text); param[5].Value = sysFuncs.SaveDate(txtValidTo.Text); param[6].Value = ddlActive.SelectedValue.ToString().Trim(); sysFunc.ExecuteSP_NonQuery("SP_WorkFlowRolls_insert", param); sysFunc.ClearTextBoxes(Page); createGrid(); //txtWorkFlowID.Text = max; sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtRollsDesc); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
private bool InsertCustomer() { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@CusCode", SqlDbType.Char, 8), //1 new SqlParameter("@CusDesc", SqlDbType.VarChar, 50), //2 new SqlParameter("@FatherHusName", SqlDbType.VarChar, 50), //3 //new SqlParameter("@AuxCusCode new SqlParameter("@Address1", SqlDbType.VarChar, 50), //4 new SqlParameter("@Address2", SqlDbType.VarChar, 50), //5 new SqlParameter("@Address3", SqlDbType.VarChar, 50), //6 new SqlParameter("@ContPerson", SqlDbType.VarChar, 50), //7 new SqlParameter("@CreditDays", SqlDbType.Int), //8 new SqlParameter("@CreditLimit", SqlDbType.Float), //9 new SqlParameter("@NIC", SqlDbType.VarChar, 50), //10 new SqlParameter("@CusTypeCode", SqlDbType.Char, 3), //11 new SqlParameter("@DOB", SqlDbType.DateTime), //12 new SqlParameter("@Phone1", SqlDbType.VarChar, 15), //13 new SqlParameter("@Phone2", SqlDbType.VarChar, 15), //14 new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //15 new SqlParameter("@FaxNo", SqlDbType.VarChar, 15), //16 new SqlParameter("@Email", SqlDbType.VarChar, 50), //17 new SqlParameter("@URL", SqlDbType.VarChar, 50), //18 new SqlParameter("@NTNno", SqlDbType.VarChar, 15), //19 new SqlParameter("@AdvanceReceipt", SqlDbType.Float), //20 //new SqlParameter("@AccountCode new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //21 //new SqlParameter("@UpdDate",SqlDbType .DateTime ),//22 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //23 new SqlParameter("@SalesTaxRegNo", SqlDbType.VarChar, 30), //24 new SqlParameter("@Behavior", SqlDbType.Char, 6), //25 new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //26 new SqlParameter("@Distance", SqlDbType.Int) //27 }; param[0].Value = Session["DealerCode"].ToString(); if (ddCustomerCode.Text.Trim() == string.Empty) { AutoGenCode = myFunc.GetNewMaxID("Customer", "CusCode", 8, Session["DealerCode"].ToString()); //txtCustCode.Text = AutoGenCode; param[1].Value = AutoGenCode; } else { param[1].Value = ddCustomerCode.Text; } param[2].Value = txtCustomerName.Text.Trim().ToUpper(); param[3].Value = txtFatherHusband.Text.Trim().ToUpper(); param[4].Value = txtAddress1.Text.Trim().ToUpper(); param[5].Value = txtAddress2.Text.Trim().ToUpper(); param[6].Value = txtAddress3.Text.Trim().ToUpper(); param[7].Value = txtContactPerson.Text.Trim().ToUpper(); if (spnCreditDays.Text.Trim() == "") { spnCreditDays.Text = "0"; param[8].Value = spnCreditDays.Text; } else { param[8].Value = spnCreditDays.Text; } if (txtCreditLimit.Text.Trim() == "") { txtCreditLimit.Text = "0.00"; param[9].Value = txtCreditLimit.Text; } else { param[9].Value = txtCreditLimit.Text; } param[10].Value = txtNICNo.Text; param[11].Value = cmbCustomerType.Text; if (dpDOB.Date.Year > 1900) { param[12].Value = dpDOB.Date; } param[13].Value = txtPhoneNumber.Text; param[14].Value = txtPhoneNumber2.Text; param[15].Value = txtCellNumber.Text; param[16].Value = txtFaxNumber.Text; param[17].Value = txtEmail.Text; param[18].Value = txtURL.Text; param[19].Value = txtNTNNo.Text; param[20].Value = DBNull.Value; param[21].Value = Session["UserName"].ToString(); //param[22].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")); param[22].Value = GlobalVar.mUserIPAddress; // SessionInformation.MachineIP; param[23].Value = txtSaleTaxRegNo.Text; param[24].Value = "GOOD"; param[25].Value = DBNull.Value; if (txtDistance.Text == "") { txtDistance.Text = "0"; param[26].Value = txtDistance.Text; } else { param[26].Value = txtDistance.Text; } if (myFunc.ExecuteSP_NonQuery("sp_Sales_Insert_Customer", param)) { return(true); } else { return(false); } }
protected void 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 BtnSavePartLocation_Click(object sender, EventArgs e) { if (!sec.UserRight("2540", "004")) { Response.Redirect("~/Test.aspx"); } string StrPartLocationCode = "", StrPartLocationDesc = ""; TextBox[] textBoxes = { txtPartLocationDesc }; if (!MasterValidation(textBoxes)) { return; } try { if (txtPartLocationCode.Text.Trim() == string.Empty) { StrPartLocationCode = SysFunc.GetNewMaxID("PartsLocation", "PartsLocCode", 2, Session ["DealerCode"].ToString()); } else { if (!sec.UserRight("2540", "003")) { Response.Redirect("~/Test.aspx"); } StrPartLocationCode = txtPartLocationCode.Text.Trim(); } StrPartLocationDesc = txtPartLocationDesc.Text.Trim(); SqlParameter[] param = { new SqlParameter("@DealerCode", Session["DealerCode"].ToString()), new SqlParameter("@partsLocCode", StrPartLocationCode), new SqlParameter("@partsLocDesc", StrPartLocationDesc), new SqlParameter("@UpdUser", Session["UserName"].ToString()), new SqlParameter("@Updtem", GlobalVar.mUserIPAddress) }; //ObjDLL.SP_Spare_Insert_partslocation(param); if (SysFunc.ExecuteSP_NonQuery("SP_Spare_Insert_partslocation", param)) { SysFunc.UserMsg(LbErr, Color.Green, "Location saved successfully Last Code is :" + StrPartLocationCode, txtPartLocationCode); Load_ddlLocCode(); ddlLocCode.SelectedValue = StrPartLocationCode; ClearSubLoc(); txtAutoPartLocCode.Text = ddlLocCode.SelectedValue.ToString(); txtPartLocationCode.Text = ddlLocCode.SelectedValue.ToString(); } else { SysFunc.UserMsg(LbErr, Color.Red, "Location not save try again", txtPartLocationCode); } } catch (Exception ex) { SysFunc.UserMsg(LbErr, Color.Red, ex.Message, txtPartLocationCode); } }