public static string GetSpareDetails(int spareBomId)
{
string strResult = string.Empty;
try
{
var data = SpareBOMMaster.GetSpareBomDetailsonSpareId(spareBomId, "SELECT_ON_SPARE_BOM_ID");
JavaScriptSerializer json = new JavaScriptSerializer();
return(json.Serialize(data));
}
catch (Exception ex)
{
return(strResult);
}
}
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);
}
public static string GetAlternateSpare(int intProductDivisionId)
{
return(SpareBOMMaster.GetAlternateSpare(intProductDivisionId));
}
public static string GetProductDetails(int intProductLine)
{
return(SpareBOMMaster.GetProductDetails(intProductLine));
}
public static string GetProductLineDetails(int intDivisionId)
{
return(SpareBOMMaster.GetProductLineDetails(intDivisionId));
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objSIMSCommonClass = null;
objSpareBOMMaster = null;
}
