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);
}
}
