private void LoadDDL_JobCategory()
{
string WhereQuery = "DealerCode in('" + Session["DealerCode"] + "','COMON')";
string[] Columns = new string[] { "JobCatCode", "JobCatDesc" };
SysFunc.GetMultiColumnsDDL(ddljob_category, Columns, "JobCategory", WhereQuery, "JobCatCode", "", false, false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["UserName"] == null)
{
Response.Redirect("~/login.aspx");
}
if (Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Session["LookUpData"].ToString()))
{
SelectedPartDetail(Session["LookUpData"].ToString());
}
}
if (!IsPostBack)
{
Session["LookUpData"] = string.Empty;
ThreadStart childthreat = new ThreadStart(Load_ddlParts);
Thread child = new Thread(childthreat);
child.Start();
Load_ddlVehRegNo();
txtDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
string WhereClause = "DealerCode = '" + Session["DealerCode"].ToString() + "'";
string[] Columns = new string[] { "FIRCode", "ChassisNo", "RegNo", "EngineNo" };
sysfunc.GetMultiColumnsDDL(ddlDRNo, Columns, "FIRMaster ", WhereClause, "FIRCode", "", false, false);
// Session["Sketch"] = "";
}
// Session["Sketch"] = "";
}
private void LoadDLLs()
{
ddlRoadCond.Items.Add(new ListItem("Select", "Select"));
ddlRoadCond.Items.Add(new ListItem("Paved", "Paved"));
ddlRoadCond.Items.Add(new ListItem("City", "City"));
ddlRoadCond.Items.Add(new ListItem("Rural", "Rural"));
ddlAppSt.Items.Add(new ListItem("Select", "Select"));
ddlAppSt.Items.Add(new ListItem("Approved", "Approved"));
ddlAppSt.Items.Add(new ListItem("Reject", "Reject"));
ddlAppSt.Items.Add(new ListItem("Return", "Return"));
string Where = "1=1";
string[] Columns1 = new string[] { "ComplainCode", "ComplainDesc" };
sysFunc.GetMultiColumnsDDL(ddlComplains, Columns1, "ComplainType", Where, "ComplainCode", "", false, false);
string[] Columns2 = new string[] { "DefectCode", "DefectDesc" };
sysFunc.GetMultiColumnsDDL(ddlDefect, Columns2, "Defect", Where, "DefectCode", "", false, false);
string WhereQuery = "DealerCode = '" + Session["DealerCode"] + "'";
string[] Columns0 = new string[] { "PPRCode", "PPRDate", "UserName", "VehRegNo" };
sysFunc.GetMultiColumnsDDL(ddlPRNo, Columns0, "PPRMaster", WhereQuery, "PPRCode", "", false, false);
string[] Columns = new string[] { "VendorCode", "VendorDesc" };
sysFunc.GetMultiColumnsDDL(ddlVendor, Columns, "Vendor", WhereQuery, "VendorCode", "", false, false);
//string where = "JobCardType = '008'";
//string[] Columns3 = new string[] { "JobCardCode", "UserName", "RegNo" };
//sysFunc.GetMultiColumnsDDL(ddljob_code, Columns3, "JobCardMaster", where, "JobCardCode", "", false, false);
}
private void LoadDDLs()
{
string where = "DealerCode IN ('COMON','" + Session["DealerCode"].ToString() + "')";
string[] Columns = new string[] { "CusCode", "CusDesc+' '+FatherHusName", " Address1", "isnull(phone1,isnull(phone2,CellNo))" };
sysFun.GetMultiColumnsDDL(ddlCustomer, Columns, "Customer", where, "CusCode", " Order by CusCode Desc ", false, false);
string where1 = "DealerCode IN ('COMON','" + Session["DealerCode"].ToString() + "')";
string[] Columns1 = new string[] { "CusCode", "CusDesc", " Address1", "isnull(phone1,isnull(phone2,CellNo))" };
sysFun.GetMultiColumnsDDL(ddlAcctof, Columns1, "Customer", where1, "CusCode", " Order by CusCode Desc ", false, false);
string where2 = "DealerCode IN ('COMON','" + Session["DealerCode"].ToString() + "')";
string[] Columns2 = new string[] { "BrandCode", "BrandDesc" };
sysFun.GetMultiColumnsDDL(ddlBrand, Columns2, "Brand", where2, "BrandCode", "", false, false);
//string where3 = "DealerCode IN ('AAAAA','" + Session["DealerCode"].ToString() + "')";
//string[] Columns3 = new string[] { "ColorCode" , "ColorDesc" };
//sysFun.GetMultiColumnsDDL(ddlColor, Columns3, "Color", where3, "ColorCode", "", false, false);
sysFun.FillDropDown(ddlColor, "SELECT ColorCode,ColorDesc FROM Color Where DealerCode IN('AAAAA', 'COMON') ", "ColorDesc", "ColorCode", "Select");
string where4 = "DealerCode = 'COMON'";
string[] Columns4 = new string[] { "InsCompCode", "InsCompDescription" };
sysFun.GetMultiColumnsDDL(ddlInsCo, Columns4, "InsuranceCompanies", where4, "InsCompCode", "", false, false);
}
private void lOADddl()
{
// DDLColums retrive
string[] col1 = new string[] { "A.DCNo", "convert(varchar(12),A.DCDate,103)", "A.PONo", "B.VendorDesc", "A.VendorDCNo" };
string Where = " A.VendorCode = B.VendorCode AND A.DealerCode= '" + Session["DealerCode"].ToString() + "'and a.DelFlag = 'N' "
+ " and a.VendorCode = b.VendorCode and B.DealerCode in(A.DealerCode,'COMON') "
+ " and a.DCNo Not IN (Select DCNo from GRNMaster Where DealerCode in ('" + Session["DealerCode"].ToString() + "','AAAAA') and Delflag = 'N') ";
sysFunc.GetMultiColumnsDDL(ddlDCno, col1, "DCMaster A, Vendor B ", Where, "DCNo", "ORDER BY A.DCNO DESC", false, false);
string[] col = new string[] { "a.PONo", "convert(varchar(20), a.PODate, 103)", "c.VendorDesc", "d.NName" };
string Where2 = "a.VendorCode = c.VendorCode and a.DealerCode = b.DealerCode and c.DealerCode in (a.DealerCode,'COMON') "
+ "and a.PONo = b.PONo "
+ " and a.DeliveryType = d.NName"
+ " and a.DealerCode in( '" + Session["DealerCode"].ToString() + "')"
+ " and a.TransferStatus ='T'";
sysFunc.GetMultiColumnsDDL(ddlPONo, col, "POMaster a,PODetail b,Vendor c,partsDeliveryTypes d", Where2, "PONo", "Order by a.PONo DESC", true, true, "Having sum(b.POQty) > sum(b.RecQty)");
//string WhereQuery = "1=1";
//string[] col1 = new string[] { "VendorCode", "VendorDesc" };
//sysFunc.GetMultiColumnsDDL(ddlVendor, col1, "Vendor", WhereQuery, "VendorCode", "", false, false);
//string[] col3 = new string[] { "NName" };
//sysFunc.GetMultiColumnsDDL(ddlDeliveryType, col3, "PartsDeliveryTypes", WhereQuery, "NName", "", false, false);
}
private void LoadDDL_TransLoc()
{
string WhereQuery = "DealerCode = '" + Session["DealerCode"] + "' AND DelFlag = 'N' ";
string[] Columns = new string[] { "TransNo", "TransDate" };
SysFunc.GetMultiColumnsDDL(ddltransfer_no, Columns, "PartsLocTransMaster", WhereQuery, "TransNo", "", false, false);
}
private void lOADddl()
{
string WhereQuery = "DealerCode= '" + Session["DealerCode"].ToString() + "' ";
string[] col = new string[] { "JobCardCode", "UserName", "EngineNo", "ChassisNo" };
sysFunc.GetMultiColumnsDDL(ddlJobCardCode, col, "JobCardMaster", WhereQuery, "JobCardCode", "", false, false);
txtfeedbackDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
}
private void Loadddl()
{
string WhereClause = "DealerCode = '" + Session["DealerCode"] + "'";
string[] Columns = new string[] { "BayID", "BayDesc", "ShopID" };
sysFunc.GetMultiColumnsDDL(ddlBays, Columns, "Bay", WhereClause, "BayID", "", false, false);
string[] Columns1 = new string[] { "ShopID", "ShopDesc" };
sysFunc.GetMultiColumnsDDL(ddlShop, Columns1, "Shops", "DealerCode in ('" + Session["DealerCode"] + "','COMON')", "ShopID", "", false, false);
}
private void LoadddlBillingNo()
{
string WhereClause = "DealerCode = '" + Session["DealerCode"] + "' and DelFlag='N'";
string[] Columns = new string[] { "JEnBillNo", "BillDate", "Remarks" };
sysFunc.GetMultiColumnsDDL(ddlBillingNo, Columns, "JENBillMaster ", WhereClause, "JENBillNo", "", false, false);
}
private void LoadDDL_EmpCode()
{
string WhereQuery = "DealerCode = '" + Session["DealerCode"] + "'";
string[] Columns = new string[] { "EmpCode", "EmpName", "CNIC" };
SysFunc.GetMultiColumnsDDL(ddlEmployee, Columns, "DealerEmp", WhereQuery, "EmpCode", "", false, false);
}
private void LoadDDL_CustPayment()
{
string WhereQuery = " DealerCode ='" + Session["DealerCode"].ToString() + "' " +
// "And CusCode='" + ddlCust.SelectedValue.ToString().Trim() + "' " +
"And IsAdjustAdvance='Y' " +
"And AmountPaid - AdvanceAdjustedAmount >= 1";
string[] Columns = new string[] { "ReceiptNo", "CONVERT(VARCHAR(10),ReceiptDate,105)", "'Paid=' + Convert(Varchar(20),amountpaid)", "'Adj=' +CONVERT(VARCHAR(10),AdvanceAdjustedAmount)", "'Bal='+CONVERT(VARCHAR(10),AdvanceBalanceAmount)" };
SysFuncs.GetMultiColumnsDDL(ddlReceiptNo, Columns, "PaymentReceiptMaster", WhereQuery, "ReceiptNo", "Order by ReceiptNo Desc", true, false);
}
private void LoadGRN_DDL()
{
string WhereQuery = "1=1";
// string[] Columns = new string[] { "RegNo", "App_Id" };
// sysFunc.GetMultiColumnsDDL(ddlRegNo, Columns, "CustomerVisit", WhereQuery, "RegNo", "", false, false);
string[] col = new string[] { "ProdTitle" };
sysFunc.GetMultiColumnsDDL(ddlVehicleModel, col, "Vehicle", WhereQuery, "ProdTitle", "", false, false);
}
private void LoadGRN_DDL()
{
string WhereQuery = "1=1";
// string[] Columns = new string[] { "RegNo", "App_Id" };
// sysFunc.GetMultiColumnsDDL(ddlRegNo, Columns, "CustomerVisit", WhereQuery, "RegNo", "", false, false);
string[] col = new string[] { "StateCode", "StateDesc" };
sysFunc.GetMultiColumnsDDL(ddState, col, "State", WhereQuery, "StateCode", "", false, false);
}
private void lOADddl()
{
ddlDeptCode.Items.Clear();
ddlDeptCode.Items.Add(new ListItem("Select", "Select"));
ddlDeptCode.Items.Add(new ListItem("General", "General"));
ddlDeptCode.Items.Add(new ListItem("Extended", "Extended"));
//// DDLColums retrive
string WhereQuery = "DealerCode in ( '" + Session["DealerCode"].ToString() + "','COMON') ";
string[] col2 = new string[] { "DeptCode", "DeptDesc" };
sysFunc.GetMultiColumnsDDL(ddlDeptCode, col2, "Department", WhereQuery, "DeptCode", "", false, false);
}
private void lOADddl()
{
// DDLColums retrive
string WhereQuery = "DealerCode= '" + Session["DealerCode"].ToString() + "' ";
// string[] Columns = new string[] { "RegNo", "App_Id" };
// sysFunc.GetMultiColumnsDDL(ddlRegNo, Columns, "CustomerVisit", WhereQuery, "RegNo", "", false, false);
string[] col1 = new string[] { "VendorCode", "VendorDesc" };
sysFunc.GetMultiColumnsDDL(ddlVendorCode, col1, "Vendor", WhereQuery, "VendorCode", "", false, false);
txtFromDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
txtToDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
}
private void lOADddl()
{
ddlPolicyType.Items.Clear();
ddlPolicyType.Items.Add(new ListItem("Select", "Select"));
ddlPolicyType.Items.Add(new ListItem("General", "General"));
ddlPolicyType.Items.Add(new ListItem("Extended", "Extended"));
ddlStatus.Items.Clear();
ddlStatus.Items.Add(new ListItem("Select", "Select"));
ddlStatus.Items.Add(new ListItem("Active", "Active"));
ddlStatus.Items.Add(new ListItem("De-Active", "De-Active"));
//// DDLColums retrive
string WhereQuery = "DealerCode= '" + Session["DealerCode"].ToString() + "' ";
string[] col1 = new string[] { "Solution_Code", "Solution_Desc" };
sysFunc.GetMultiColumnsDDL(ddlSolution, col1, "Solution", WhereQuery, "Solution_Code", "", false, false);
string[] col2 = new string[] { "WFPolicyMasterCode", "WFPolicyMasterDesc" };
sysFunc.GetMultiColumnsDDL(ddlWFPolicyMasterCode, col2, "WFPolicyMaster", WhereQuery, "WFPolicyMasterCode", "", false, false);
txtStartDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
txtEndDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
}
//private void LoadDDL_JobCategory()
//{
// string WhereQuery = "1=1";
// string[] Columns = new string[] { "JobCatCode", "JobCatDesc" };
// SysFunc.GetMultiColumnsDDL(ddljob_category, Columns, "JobCategory", WhereQuery, "JobCatCode", "", false, false);
//}
//private void LoadDDL_AccountCode()
//{
// string WhereQuery = "1=1";
// string[] Columns = new string[] { "AccountCode" };
// SysFunc.GetMultiColumnsDDL(ddlacount_code, Columns, "JobCategory", WhereQuery, "AccountCode", "", false, false);
//}
private void LoadDDL_DefJobCode()
{
string WhereQuery = "DealerCode in ( '" + Session["DealerCode"].ToString() + "','COMON')";
string[] Columns = new string[] { "DefJobCode", "DefJobDesc" };
SysFunc.GetMultiColumnsDDL(ddljob_code, Columns, "DefaultJob", WhereQuery, "DefJobCode", "", false, false);
}