// 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);
}
