// Code Added by Naveen K sharma on 06-October-2009 public void GetAllRegions(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETALLREGION") }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Region_Desc"; ddl.DataValueField = "Region_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
// Code added by Bhawesh on 30 dec 11 public void GetUserRegion(DropDownList ddlR) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSER_REGION"), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspASCPaymentMaster", param); ddlR.DataTextField = "Region_Desc"; ddlR.DataValueField = "Region_SNo"; ddlR.DataSource = ds; ddlR.DataBind(); }
public void GetBillsForApprovalMain(GridView gdv) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETBILLS_APPROVAL_DOCWISE"), new SqlParameter("@RegionSno", this.RegionSno), new SqlParameter("@BranchSno", this.BranchSno), new SqlParameter("@Asc_Code", this.ASC_Id) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); gdv.DataSource = ds; gdv.DataBind(); }
public void GetUserRegions(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERREGION"), new SqlParameter("@UserName", this.UserName) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); ddl.DataTextField = "Region_Desc"; ddl.DataValueField = "Region_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
public void GetUserProductDivisionsForRepeateComplaint(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERSPRODUCTDIVISION_REGION_BRANCH_REPEATE_COMPLAINT"), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Unit_desc"; ddl.DataValueField = "Unit_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
public void GetAllProductDivision(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETALLDIVISION"), new SqlParameter("@Asc_Code", this.ASC_Id) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); ddl.DataTextField = "Unit_desc"; ddl.DataValueField = "Unit_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
/// <summary> /// Get Approved/Rejected Bills : for BA /// </summary> /// <param name="gdv"></param> public void GetBills(GridView gdv) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETBILLS_BA"), new SqlParameter("@BranchSno", this.BranchSno), new SqlParameter("@dateFrom", this.dateFrom), new SqlParameter("@dateTo", this.dateTo), new SqlParameter("@Asc_Code", this.ASC_Id) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); gdv.DataSource = ds; gdv.DataBind(); }
public void GetUserBranchs(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSER_BRANCHES"), new SqlParameter("@RegionSno", Convert.ToInt16(this.RegionSno)), new SqlParameter("@UserName", this.UserName) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); ddl.DataTextField = "Branch_Name"; ddl.DataValueField = "Branch_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
// Code added by Naveen K Sharma on 24 Sep 2009 public void GetASCBranchs(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETASCBRANCH_REGION"), new SqlParameter("@RegionSno", int.Parse(this.RegionSno)), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Branch_Name"; ddl.DataValueField = "Branch_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
public void GetUserSCs(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERSSCs_REGION_BRANCH"), new SqlParameter("@Region_Sno", 0), new SqlParameter("@Branch_Sno", 0), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTSpareConsumptionSummary", param); ddl.DataTextField = "SC_Name"; ddl.DataValueField = "SC_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
public void GetUserRegions(DropDownList ddl) { try { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERREGION"), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Region_Desc"; ddl.DataValueField = "Region_SNo"; ddl.DataSource = ds; ddl.DataBind(); } catch (Exception ex) { } }
// Modified by Gaurav Garg on 13 Nov for mto public void GetUserProductDivisions(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERSPRODUCTDIVISION_REGION_BRANCH"), new SqlParameter("@RegionSno", int.Parse(this.RegionSno)), new SqlParameter("@BranchSno", int.Parse(this.BranchSno)), // Added By Gaurav Garg on 13 NOv for MTO new SqlParameter("@BusinessLine_Sno", (this.BusinessLine_Sno)), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Unit_desc"; ddl.DataValueField = "Unit_SNo"; ddl.DataSource = ds; ddl.DataBind(); }
public void GetSCs(DropDownList ddl, int BranchSNo) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETALLASC"), new SqlParameter("@BranchSno", BranchSNo) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); ddl.DataTextField = "SC_Name"; ddl.DataValueField = "SC_SNo"; ddl.DataSource = ds; ddl.DataBind(); for (int k = 0; k < ddl.Items.Count; k++) { ddl.Items[k].Attributes.Add("title", ddl.Items[k].Text); } ddl.Items.Insert(0, new ListItem("Select", "0")); }
// Code added by Bhawesh on 30 dec 11 public DataSet GetUserRegionBranch(DropDownList ddlR, DropDownList DDlB) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSER_REGION_BRANCH"), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddlR.DataTextField = "Region_Desc"; ddlR.DataValueField = "Region_SNo"; ddlR.DataSource = ds; ddlR.DataBind(); DDlB.DataTextField = "Branch_Name"; DDlB.DataValueField = "Branch_SNo"; DDlB.DataSource = ds; DDlB.DataBind(); return(ds); }
//Code Added By Pravesh public void GetUserRegionsMTS_MTO(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERREGION_MTS_MTO"), new SqlParameter("@UserName", this.EmpId), new SqlParameter("@BusinessLine_sno", this.BusinessLine_Sno) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Region_Desc"; ddl.DataValueField = "Region_SNo"; ddl.DataSource = ds; ddl.DataBind(); if (ddl.Items.Count > 1) { ddl.Items.Insert(0, new ListItem("All", "0")); } }
// Code added by Naveen K Sharma on 24 Sep 2009 public void GetUserSCs(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETUSERSSCs_REGION_BRANCH"), new SqlParameter("@RegionSno", int.Parse(this.RegionSno)), new SqlParameter("@BranchSno", int.Parse(this.BranchSno)), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "SC_Name"; ddl.DataValueField = "SC_SNo"; ddl.DataSource = ds; ddl.DataBind(); for (int k = 0; k < ddl.Items.Count; k++) { ddl.Items[k].Attributes.Add("title", ddl.Items[k].Text); } }
// Code added by Naveen K Sharma on 24 Sep 2009 public void GetASCProductDivisions(DropDownList ddl) { SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer(); SqlParameter[] param = { new SqlParameter("@Type", "GETASCPRODUCTDIVISION_REGION_BRANCH"), new SqlParameter("@UserName", this.EmpId) }; DataSet ds = objSIMSSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param); ddl.DataTextField = "Unit_desc"; ddl.DataValueField = "Unit_SNo"; ddl.DataSource = ds; ddl.DataBind(); for (int k = 0; k < ddl.Items.Count; k++) { ddl.Items[k].Attributes.Add("title", ddl.Items[k].Text); } ddl.Items.Insert(0, new ListItem("Select", "0")); }
public static List <SpareBOMMaster> GetSpareBomDetailsonSpareId(int intSpareBOMID, string strType) { List <SpareBOMMaster> lstSBomMaster = new List <SpareBOMMaster>(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@Spare_BOM_Id", intSpareBOMID) }; SIMSSqlDataAccessLayer objsql = new SIMSSqlDataAccessLayer(); DataSet dsSBomMaster = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspSpareBOMMaster", sqlParamG); if (dsSBomMaster != null) { if (dsSBomMaster.Tables.Count > 0) { SpareBOMMaster sBomMst = new SpareBOMMaster(); sBomMst.Spare_BOM_Id = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["Spare_BOM_Id"].ToString()); sBomMst.ProductDivision_Id = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); sBomMst.ProductLine_Id = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ProductLine_Id"].ToString()); sBomMst.Product_Id = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["Product_Id"].ToString()); sBomMst.Spare_Id = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["Spare_Id"].ToString()); sBomMst.QtyPerUnit = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["Spare_BOM_QtyPerUnit"].ToString()); sBomMst.AltSpareCode1 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code1"].ToString()); sBomMst.AltSpareCode2 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code2"].ToString()); sBomMst.AltSpareCode3 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code3"].ToString()); sBomMst.AltSpareCode4 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code4"].ToString()); sBomMst.QtyPerUnitOfAlt1 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code1_QtyPerUnit"].ToString()); sBomMst.QtyPerUnitOfAlt2 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code2_QtyPerUnit"].ToString()); sBomMst.QtyPerUnitOfAlt3 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code3_QtyperUnit"].ToString()); sBomMst.QtyPerUnitOfAlt4 = Convert.ToInt32(dsSBomMaster.Tables[0].Rows[0]["ALT_Spare_Code4_QtyPerUnit"].ToString()); sBomMst.ActiveFlag = dsSBomMaster.Tables[0].Rows[0]["Active_Flag"].ToString(); lstSBomMaster.Add(sBomMst); } } return(lstSBomMaster); }