protected void btnSaveJC_Click(object sender, EventArgs e)
{
try
{
if (ddlVinNo.SelectedIndex == 0)
{
lblMsg.Text = "Please select VIN No first";
return;
}
if (txtFailedPart.Text.Trim() == "")
{
lblMsg.Text = "Please select Failed part first";
return;
}
TextBox[] textBoxes = { txtRegNo, txtKM, txtSubject, txtEngineNo, txtInspDate };
if (!MasterValidation(textBoxes))
{
return;
}
else
{
JobCardEntry();
}
}
catch (Exception ex)
{
sysfunc.UserMsg(lblMsg, Color.Red, ex.Message, txtSRNo);
}
}
public void SelectedPartDetail(string item)
{
try
{
txtAccCode.Text = item;
TxtAccDesc.Text = GetAccounttitle(item);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, Color.Red, ex.Message);
}
}
public void addVisitor(object sender, EventArgs e)
{
string autoCode = string.Empty;
try
{
// if(ddlRegNo.SelectedIndex == 0)
// {
// clearData();
// return;
//}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.VarChar), //0
new SqlParameter("@RegNo", SqlDbType.VarChar), //1
new SqlParameter("@VisitDate", SqlDbType.DateTime), //2
new SqlParameter("@CustName", SqlDbType.VarChar), //3
new SqlParameter("@Contact", SqlDbType.VarChar), //4
new SqlParameter("@TimeSlot", SqlDbType.VarChar), //5
new SqlParameter("@Purpose", SqlDbType.VarChar), //6
new SqlParameter("@Priority", SqlDbType.VarChar), //7
new SqlParameter("@VehicleModel", SqlDbType.VarChar), //8
new SqlParameter("@Date", SqlDbType.DateTime) //9
};
DateTime visitDate = DateTime.ParseExact(txtVisitDate.Text, "dd-MM-yyyy", null);
DateTime Date = DateTime.ParseExact(txtDate.Text, "dd-MM-yyyy", null);
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtRegNo.Text;
param[2].Value = visitDate;
param[3].Value = txtCustName.Text;
param[4].Value = txtContactNo.Text;
param[5].Value = ddlTimeSlot.Text;
param[6].Value = ddlpurpose.Text;
param[7].Value = ddlPriority.Text;
param[8].Value = ddlVehicleModel.Text;
param[9].Value = Date;
sysFunc.ExecuteSP_NonQuery("Sp_Insert_CustomerVisit", param);
clearData();
LoadGRN_DDL();
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Green, "Customer visit added Successfully");
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
throw;
}
}
//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);
}
}
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);
}
}
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 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 btn_save_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2588", "002"))
{
Response.Redirect("~/Test.aspx");
}
if (ddlReceiptNo.SelectedIndex == 0)
{
SysFuncs.UserMsg(success_add_item, Color.Red, "Please Select the Receipt First!");
return;
}
if (ddlpayment_mode.SelectedIndex == 0)
{
SysFuncs.UserMsg(success_add_item, Color.Red, "Please Select the Payment Mode First!");
return;
}
else
{
if (txtRefundCode.Text != "")
{
if (!sec.UserRight("2588", "003"))
{
Response.Redirect("~/Test.aspx");
}
}
}
if (Session["Adj"].ToString() == "Adj")
{
Insert_PaymentRefund();
}
else
{
SysFuncs.UserMsg(success_add_item, Color.Red, "Please Adjust Amount First!");
return;
}
}
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);
}
}
protected void SelectedPartDetail(string item)
{
try
{
lOADddl();
if (btnValue == 2)
{
ddlPONo.SelectedValue = item.ToString();
ddlPONo_SelectedIndexChanged(null, null);
}
else
{
ddlDCno.SelectedValue = item;
ddlDCno_SelectedIndexChanged(null, null);
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, 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);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
//Coneection String by default empty
string ConStr = "";
//Extantion of the file upload control saving into ext because
//there are two types of extation .xls and .xlsx of Excel
HttpPostedFile postedFile = FileUpload1.PostedFile;
if (FileUpload1.HasFile == false)
{
sysFunc.UserMsg(lblMessage, Color.Red, "Choose file first");
return;
}
string ext = Path.GetExtension(FileUpload1.FileName).ToLower();
//getting the path of the file
string path = Server.MapPath("~/Download/" + FileUpload1.FileName);
//saving the file inside the MyFolder of the server
FileUpload1.SaveAs(path);
//Label1.Text = FileUpload1.FileName + "\'s Data showing into the GridView";
//checking that extantion is .xls or .xlsx
if (ext.Trim() == ".xls" || ext.Trim() == ".xlsx")
{
try
{
if (ext.Trim() == ".xls")
{
//connection string for that file which extantion is .xls
ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (ext.Trim() == ".xlsx")
{
//connection string for that file which extantion is .xlsx
ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
//making query
string query = "SELECT * FROM [Sheet1$]";
//Providing connection
OleDbConnection conn = new OleDbConnection(ConStr);
//checking that connection state is closed or not if closed the
//open the connection
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
//create command object
OleDbCommand cmd = new OleDbCommand(query, conn);
// create a data adapter and get the data into dataadapter
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
//fill the Excel data to data set
da.Fill(ds);
//set data source of the grid view
Session["ImportItem"] = ds.Tables[0];
grdItem.DataSource = ds.Tables[0];
grdItem.DataBind();
grdItem.HeaderRow.TableSection = TableRowSection.TableHeader;
//close the connection
conn.Close();
//string script = "window.onload = function() { ShowProgress(); };";
//ClientScript.RegisterStartupScript(this.GetType(), "ShowProgress", script, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, Color.Red, ex.Message);
return;
}
}
else
{
sysFunc.UserMsg(lblMessage, Color.Red, "Please Select the Excel sheet with extension .xls or .xlsx. This format is not suppoerted.");
return;
}
//Response.Redirect("~/Modules/Setup/ImportItem.aspx");
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (txtChassis.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Chassis No. should not left blank", txtChassis);
return;
}
if (txtNewreg.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Registration Feilds should not left blank", txtNewreg);
return;
}
//if (txtRemarks.Text == "")
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtRemarks);
// return;
//}
DataTable dt = (DataTable)Session["URFDS"];
// Check value in GridView TextBOX
foreach (DataRow d in dt.Rows)
{
if (d["RegNo"].ToString().ToUpper() == txtNewreg.Text.ToUpper())
{
sysFunc.UserMsg(lblMessage, Color.Red, "Alredy Exist");
return;
}
}
try
{
// string max = sysFuncs.GetNewMaxID("URF", "URFNo", 8, Session["DealerCode"].ToString());
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30), //4
new SqlParameter("@EngineNo", SqlDbType.VarChar, 30), //5
new SqlParameter("@RegNo", SqlDbType.Char, 15), //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtChassis.Text;
param[2].Value = txtEngineNo.Text;
param[3].Value = txtNewreg.Text.Trim().ToUpper().ToUpper();
//SP_Insert_URF
if (sysFunc.ExecuteSP_NonQuery("sp_Update_URF", param))
{
//sysFunc.ClearTextBoxes(Page);
createGrid();
sysFuncs.UserMsg(lblMessage, Color.Green, "Reg No Update", txtChassis);
}
else
{
sysFuncs.UserMsg(lblMessage, Color.Green, "RegNo Not Update", txtChassis);
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void txtCustomer_TextChanged(object sender, EventArgs e)
{
if (txtCustomer.Text == "" && txtCellNo.Text == "" && txtCNIC.Text == "" && txtNTN.Text == "" && txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "")
{
sysfun.UserMsg(lblMsg, Color.Red, "Type Something For Search", txtCustomer);
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@CusCode", SqlDbType.VarChar, 50), //1
new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //2
new SqlParameter("@NIC", SqlDbType.VarChar, 15), //3
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 50), //4
new SqlParameter("@EngineNo", SqlDbType.VarChar, 50), //5
new SqlParameter("@Regno", SqlDbType.VarChar, 20), //6
new SqlParameter("@Product", SqlDbType.VarChar, 20) //7
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtCustomer.Text.Trim();
param[2].Value = txtCellNo.Text.Trim();
param[3].Value = txtCNIC.Text.Trim();
param[4].Value = txtChasisNo.Text.Trim();
param[5].Value = txtEngineNo.Text.Trim();
param[6].Value = txtRegno.Text.Trim();
param[7].Value = txtProduct.Text.Trim();
#region Comment
//sQuery = "Select B.CusDesc Customer , B.CellNo ,A.ChassisNo , A.EngineNo , A.RegNo , V.ProdDesc ProdCode from Customer B " +
// "inner join CustomerVehicle A on A.CusCode = B.CusCode and A.DealerCode = B.DealerCode " +
// "inner join Vehicle V on A.DealerCode = V.DealerCode and A.ProdCode = V.ProdCode " +
// " where B.DealerCode = '" + Session["DealerCode"].ToString() + "' ";
//if (txtCellNo.Text.Trim() != string.Empty)
//{
// param[0].Value = txtCellNo.Text.Trim();
// //sQuery = sQuery + " and CellNo like '%" + txtCellNo.Text.Trim() + "%'";
//}
//else
//{
// param[1].Value = "";
//}
//if (txtCustomer.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and (B.CusDesc like '%" + txtCustomer.Text.Trim() + "%' or B.CusCode like '%" + txtCustomer.Text.Trim() + "%' )";
//}
//if (txtCNIC.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and B.NIC like '%" + txtCNIC.Text.Trim() + "%' ";
//}
//if (txtNTN.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and B.NTNNo like '%" + txtNTN.Text.Trim() + "%' ";
//}
//if (txtChasisNo.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.ChassisNo like '%" + txtChasisNo.Text.Trim() + "%' ";
//}
//if (txtEngineNo.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.EngineNo like '%" + txtEngineNo.Text.Trim() + "%' ";
//}
//if (txtRegno.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.RegNo like '%" + txtRegno.Text.Trim() + "%' ";
//}
//if (txtProduct.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and (V.ProdDesc like '%" + txtProduct.Text.Trim() + "%' or V.ProdCode like '%" + txtProduct.Text.Trim() + "%') ";
//}
#endregion
DataSet ds = new DataSet();
try
{
ds = sysfuns.FillDataSet("SP_CustomerVehicleSearch", param);
gvCusVeh.DataSource = ds.Tables[0]; gvCusVeh.DataBind(); ViewState["Cusveh"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_JobCardSearch", param);
gvJobCard.DataSource = ds.Tables[0]; gvJobCard.DataBind(); ViewState["JobCard"] = ds.Tables[0];
if (txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "")
{
ds = sysfuns.FillDataSet("SP_CounterSaleSearch", param);
gvCounterSale.DataSource = ds.Tables[0]; gvCounterSale.DataBind(); ViewState["CounterSale"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_PaymentReceiptSearch", param);
gvPaymentReceipt.DataSource = ds.Tables[0]; gvPaymentReceipt.DataBind(); ViewState["PaymentReceipt"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_BalanceAmountSearch", param);
gvBalanceAmount.DataSource = ds.Tables[0]; gvBalanceAmount.DataBind(); ViewState["BalAmt"] = ds.Tables[0];
if (ds.Tables[0].Rows.Count < 1)
{
return;
}
if (ds.Tables[0].Rows[0]["CustomerOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["InsuranceOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["DirectSale"].ToString() != "")
{
object sumCustOut, sumInsOut, sumDirectSale;
sumCustOut = ds.Tables[0].Compute("Sum(CustomerOustanding)", string.Empty);
sumInsOut = ds.Tables[0].Compute("Sum(InsuranceOustanding)", string.Empty);
sumDirectSale = ds.Tables[0].Compute("Sum(DirectSale)", string.Empty);
double sum = Convert.ToDouble(sumCustOut) + Convert.ToDouble(sumInsOut) + Convert.ToDouble(sumDirectSale);
lblCusOut.Text = sumCustOut.ToString();
lblInsOut.Text = sumInsOut.ToString();
lblDirectSales.Text = sumDirectSale.ToString();
lblTotalAmount.Text = sum.ToString();
}
}
}
catch (Exception ex)
{
sysfun.UserMsg(lblMsg, Color.Red, ex.Message);
return;
}
}
///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 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 btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2580", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
//if (ddlVendorCode.SelectedIndex == 0)
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Vendor Option");
// return;
//}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@VendorCode", SqlDbType.VarChar) //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
param[3].Value = ddlVendorCode.SelectedValue.ToString().Trim();
SqlDataReader rder = null;
//SP_VendorLedger_Report
// Store Procedure check and load
if (sysFunc.ExecuteSP("SP_VendorLedger_Report", param, ref rder)) //Database SP
{
data.SP_VendorLedger_Report.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("../crptVendorLedgerReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
//RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt"));
// RD.Load(Server.MapPath("../rptJobHistory.rpt"));
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Vendor Ledger Report" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "VendorLedgerReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
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 SelectedPartDetail(string item)
{
DataTable dt = new DataTable();
try
{
if (ViewState["lookupid"].ToString() == "3")
{
txtRegNo.Text = item;
ddlVehRegNo_SelectedIndexChanged(txtRegNo, EventArgs.Empty);
}
else if (ViewState["lookupid"].ToString() == "96")
{
txtGatePassCode.Text = item;
GetGatePassDetail();
}
}
catch (Exception ex)
{
sysfun.UserMsg(lblMessage, Color.Red, ex.Message);
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2567", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
if (ddlUtilityAudit.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Utility Audit Option");
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar) //2
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
SqlDataReader rder = null;
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
if (sysFunc.ExecuteSP("SP_EstimateReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
if (sysFunc.ExecuteSP("SP_JobCardReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
if (sysFunc.ExecuteSP("SP_CounterSaleMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
if (sysFunc.ExecuteSP("SP_GRNMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
if (sysFunc.ExecuteSP("SP_ChargeOutMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
RD.Load(Server.MapPath("../crpUtilityAuditReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Estimate Report" + "\"";
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Job Card Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Counter Sale Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Invoice Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Payment Receipt Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Report" + "\"";
}
//RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "UtilityAuditReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?ReportID=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
string max;
if (ddlfeedbackNo.SelectedIndex <= 0)
{
max = sysFuncs.AutoGen("FeedBackMaster", "FeedBackCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
max = ddlfeedbackNo.SelectedValue.Trim();
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1
new SqlParameter("@FeedBackDate", SqlDbType.DateTime), //2
new SqlParameter("@JobcardCode", SqlDbType.Char, 8), //2
new SqlParameter("@CusCode", SqlDbType.Char, 8),
new SqlParameter("@ServiceType", SqlDbType.VarChar, 50),
new SqlParameter("@DelFlag", SqlDbType.Char, 1),
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50),
};
FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"];
DataRow[] drr = FeedBackDT.Select();
param[0].Value = Session["DealerCode"].ToString(); // 0
param[1].Value = max;
param[2].Value = sysFuncs.SaveDate(txtfeedbackDate.Text);
param[3].Value = ddlJobCardCode.SelectedValue;
param[4].Value = txtCusCode.Text;
param[5].Value = ddlServiceType.SelectedValue.ToString();
param[6].Value = "N";
param[7].Value = Session["UserName"];
if (sysFunc.ExecuteSP_NonQuery("SP_SaveFeedbackQuestions", param))
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1
new SqlParameter("@JobcardCode", SqlDbType.Char, 8),
new SqlParameter("@ParentQuestionCode", SqlDbType.Char, 8), //3
new SqlParameter("@Rating", SqlDbType.VarChar,20), //4
};
FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"];
for (int i = 0; i < drr.Length; i++)
{
//if (FeedBackDT.Rows[i]["ItemCode"].ToString() != "")
//{
//}
param2[0].Value = Session["DealerCode"].ToString(); // 0
param2[1].Value = max; //1
param2[2].Value = ddlJobCardCode.SelectedValue;
param2[3].Value = FeedBackDT.Rows[i]["ParentQuestionCode"].ToString();
param2[4].Value = FeedBackDT.Rows[i]["Rating"].ToString();
sysFunc.ExecuteSP_NonQuery("SP_InsertQuestionsDetail", param2);
}
//createGrid();
lblMessage.Text = "FeeBack Inserted.";
BtnClear_Click(null, null);
gv_FeedbackQuestions.DataSource = null;
gv_FeedbackQuestions.DataBind();
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
public bool Insert_PaymentRefund()
{
SqlParameter[] PmtRecMaster_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@AdvanceID",SqlDbType.Char, 8),
/*2*/ new SqlParameter("@AdvanceDate", SqlDbType.DateTime),
/*3*/ new SqlParameter("@CusCode", SqlDbType.VarChar, 8), /*4*/ new SqlParameter("@InsCompCode",SqlDbType.Char, 4),
/*5*/ new SqlParameter("@BranchCode", SqlDbType.Char, 4),
/*6*/ new SqlParameter("@PayModeCode", SqlDbType.Char, 1),
/*7*/ new SqlParameter("@InsNo", SqlDbType.VarChar, 15), /*8*/ new SqlParameter("@InsDate",SqlDbType.DateTime),
/*9*/ new SqlParameter("@AmountPaid", SqlDbType.Float), /*10*/ new SqlParameter("@BankCode", SqlDbType.Char, 5),
/*11*/ new SqlParameter("@Branch", SqlDbType.VarChar, 50),
/*12*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*13*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50), /*14*/ new SqlParameter("@UpdTerm",SqlDbType.Char, 50),
/*15*/ new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), /*16*/ new SqlParameter("@VoucherFlag",SqlDbType.Char, 1),
/*17*/ new SqlParameter("@Remarks", SqlDbType.VarChar, 100), /*18*/ new SqlParameter("@AdvanceBalanceAmount",SqlDbType.Float),
};
PmtRecMaster_param[0].Value = Session["DealerCode"].ToString();
PmtRecMaster_param[2].Value = SysFuncs.SaveDate(txtRefundDate.Text); //EstimateCode
PmtRecMaster_param[3].Value = "";
PmtRecMaster_param[4].Value = ddlInsCo.SelectedValue;
PmtRecMaster_param[5].Value = ddlInsBranch.SelectedValue;
PmtRecMaster_param[6].Value = ddlpayment_mode.SelectedItem.Value;
PmtRecMaster_param[7].Value = txtinstrument_no.Text.Trim().ToUpper();
PmtRecMaster_param[8].Value = SysFuncs.SaveDate(txtinstrument_date.Text);
PmtRecMaster_param[9].Value = txtins_amount.Text.Trim().Replace(" ", "") == "" ? "0" : txtins_amount.Text.Trim();
PmtRecMaster_param[10].Value = ddlbank.SelectedItem.Value;
PmtRecMaster_param[11].Value = txtbranch.Text.Trim().Replace(" ", "");
PmtRecMaster_param[12].Value = "N";
PmtRecMaster_param[13].Value = Session["UserName"].ToString();
PmtRecMaster_param[14].Value = GlobalVar.mUserIPAddress;
PmtRecMaster_param[15].Value = "";
PmtRecMaster_param[16].Value = "N";
PmtRecMaster_param[17].Value = txtRemarks.Text;
PmtRecMaster_param[18].Value = txtins_amount.Text;
try
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (txtRefundCode.Text == "")
{
strReceiptNo = SysFunc.AutoGen("AdvancePayment", "AdvanceID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
strReceiptNo = txtRefundCode.Text;
}
PmtRecMaster_param[1].Value = strReceiptNo;
if (SysFuncs.ExecuteSP_NonQuery("[sp_W2_AdvancePayment_Master_Insert]", PmtRecMaster_param, Trans))
{
ObjTrans.CommittTransaction(ref Trans);
ClearAll();
SysFuncs.UserMsg(success_add_item, Color.Green, "Record Saved Sucessfully against Advance No" + strReceiptNo);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
return(true);
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
SysFuncs.UserMsg(success_add_item, Color.Red, ex.Message);
return(false);
}
}
protected void 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);
}
}
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);
}
}