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