private void cleardata()
{
SysFunc.Clearddl(Page);
SysFunc.ClearTextBoxes(Page);
success_add_item.Visible = false;
Image1.ImageUrl = "~/Images/BlankProfile.jpg";
}
//Btn Insert
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@PayModeCode", SqlDbType.Char, 1), //1
new SqlParameter("@PayModeDesc", SqlDbType.VarChar, 50), //2
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //4
new SqlParameter("@Version", SqlDbType.Char, 8), //5
new SqlParameter("@PayModeCodePSMC", SqlDbType.VarChar, 50) //6
};
param[0].Value = "AAAAA";
param[1].Value = txtPayModeCode.Text;
param[2].Value = txtPayModeDesc.Text.Trim();
param[3].Value = Session["UserName"].ToString();
param[4].Value = "1";
param[5].Value = txtVersion.Text;
param[6].Value = txtPayModeCodePSMC.Text;
sysFunc.ExecuteSP_NonQuery("SP_InsertPayMode", param);
sysFunc.ClearTextBoxes(Page);
createGrid();
lblMessage.Text = "New PaymentMode Inserted.";
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
private void cleadata()
{
sysFunc.ClearTextBoxes(Page);
sysFunc.Clearddl(Page);
lblMsg.Text = "";
Create_Grid();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@BankCode", SqlDbType.Char, 5), //1
new SqlParameter("@BankDesc", SqlDbType.VarChar, 50), //2
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //4
new SqlParameter("@BankStatus", SqlDbType.VarChar, 25), //5
//new SqlParameter("@SuzukiFinance",SqlDbType.Bit,1)//6
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtBankCode.Text;
param[2].Value = txtBankDesc.Text.Trim();
param[3].Value = Session["UserName"].ToString();
param[4].Value = Environment.MachineName;
// param[5].Value = ddState.SelectedValue.ToString().Trim();
param[5].Value = ddlBankStatus.SelectedValue.ToString().Trim();;
sysFunc.ExecuteSP_NonQuery("SP_InsertBank", param);
sysFunc.ClearTextBoxes(Page);
createGrid();
lblMessage.Text = "New BANK Data Inserted.";
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
private void cleardata()
{
SysFunc.Clearddl(Page);
SysFunc.ClearTextBoxes(Page);
create_grid();
success_add_item.Visible = false;
}
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);
}
}
private void cleadata()
{
SysFunc.Clearddl(Page);
SysFunc.ClearTextBoxes(Page);
//LoadDDL_JobCategory();
LoadDDL_DefJobCode();
//LoadDDL_AccountCode();
}
private void cleadata()
{
//SysFunc.Clearddl(Page);
SysFunc.ClearTextBoxes(Page);
LoadDDL_DefJobCode();
LoadDDL_AccountCode();
LoadDDL_BayCode();
}
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)
{
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);
}
}
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);
}
}
// String connString = " Data Source=PAKARMY-007;Initial Catalog=BMS;Integrated Security=True ";
protected void btnInsert_Click(object sender, EventArgs e)
{
//String Query = "insert into State(CountryCode,StateCode,StateDesc) values (@CountryCode,@StateCode,@StateDesc)";
//using (SqlConnection conn = new SqlConnection(connString))
//{
// conn.Open();
// SqlCommand cmd = new SqlCommand(Query, conn);
// cmd.Parameters.AddWithValue("@CountryCode", txtCountryCode.Text);
// cmd.Parameters.AddWithValue("@StateCode", txtStateCode.Text);
// cmd.Parameters.AddWithValue("@StateDesc", txtStateDescription.Text);
// cmd.ExecuteNonQuery();
try
{
SqlParameter[] param =
{
new SqlParameter("@CountryCode", SqlDbType.Char, 3), //0
new SqlParameter("@StateCode", SqlDbType.Char, 3), //1
new SqlParameter("@StateDesc", SqlDbType.VarChar, 50) //2
};
param[0].Value = txtCountryCode.Text;
param[1].Value = txtStateCode.Text;
param[2].Value = txtStateDescription.Text.Trim();
sysFunc.ExecuteSP_NonQuery("SP_InsertState", param);
sysFunc.ClearTextBoxes(Page);
createGrid();
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
// INSERT CODE
protected void btnInsert_Click(object sender, EventArgs e)
{
if (ddState.SelectedIndex == 0)
{
lblMessage.Text = "Select State First";
return;
}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@CityCode", SqlDbType.Char, 3), //1
new SqlParameter("@CityDesc", SqlDbType.VarChar, 50), //2
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //4
new SqlParameter("@StateCode", SqlDbType.Char, 3) //5
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtCityCode.Text;
param[2].Value = txtCityDescription.Text.Trim();
param[3].Value = Session["UserName"].ToString();
param[4].Value = "1";
param[5].Value = ddState.SelectedValue.ToString().Trim();
sysFunc.ExecuteSP_NonQuery("SP_InsertCity", param);
sysFunc.ClearTextBoxes(Page);
createGrid();
lblMessage.Text = "New City Inserted.";
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
private void clearData()
{
sysFunc.Clearddl(Page);
sysFunc.ClearTextBoxes(Page);
createGrid();
}
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);
}
}
private void cleardata()
{
sysFunc.Clearddl(Page);
sysFunc.ClearTextBoxes(Page);
Create_Grid();
}
private void cleadata()
{
sysFunc.Clearddl(Page);
sysFunc.ClearTextBoxes(Page);
LoadDLLs();
}
///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);
}
}
private void clearAll()
{
sysfunc.ClearTextBoxes(Page);
sysfunc.Clearddl(Page);
lblMsg.Text = "";
}
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);
}
}