public MTNMaterial Get(long MTNNO, String MaterialCode)
{
Material_DL objMaterial_DL = new Material_DL(Connection);
MTN_DL objMTN_DL = new MTN_DL(Connection);
MTNMaterial objMTNMaterial = new MTNMaterial();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_MTNNO", MTNNO),
new SqlParameter("@Original_MTNMaterialCode", MaterialCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPDELETE_MTNMaterial", paramList);
objMTNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MTNMaterialCode"]));
objMTNMaterial.Batch = "No";
objMTNMaterial.Description = Convert.ToString(dt.Rows[0]["MTNDescription"]);
objMTNMaterial.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"]));
objMTNMaterial.TransferQty = Convert.ToDecimal(dt.Rows[0]["MTNTransferQty"]);
objMTNMaterial.UnitRate = Convert.ToDecimal(dt.Rows[0]["MTNUnitRate"]);
objMTNMaterial.ReceivedQty = Convert.ToDecimal(dt.Rows[0]["ReceivedQty"]);
return(objMTNMaterial);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MaterialCollec Get(string MatMainType, string MatCategory)
{
try
{
Material_DL objMaterial_DL = new Material_DL(ConnectionStringClass.GetConnection());
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MatMainType", MatMainType),
new SqlParameter("@MatMainCategory", MatCategory)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MaterialByCategories");
MaterialCollec objMatCollec = new MaterialCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
Material objMaterial = new Material();
objMaterial.IsExport = Convert.ToBoolean(dt.Rows[i]["Export"]);
objMaterial.IsLocal = Convert.ToBoolean(dt.Rows[i]["Local"]);
objMaterial.IsSeasanal = Convert.ToBoolean(dt.Rows[i]["Seasanal"]);
if (dt.Rows[i]["BasicMaterialCode"] != dt.Rows[i]["MaterialCode"])
{
objMaterial.MatBasicMaterial = dt.Rows[i]["BasicMaterialCode"].ToString();
}
objMaterial.MatBasicQty = Convert.ToDecimal(dt.Rows[i]["BasicQty"]);
objMaterial.MatCost = Convert.ToDecimal(dt.Rows[i]["AVGCost"]);
objMaterial.MateialType = objMaterialType_DL.Get(Convert.ToString(dt.Rows[i]["MatTypeID"]));
objMaterial.MaterialMainType = Convert.ToString(dt.Rows[i]["MatMainType"]);
objMaterial.MaterialCode = Convert.ToString(dt.Rows[i]["MaterialCode"]);
objMaterial.MaterialDescription = Convert.ToString(dt.Rows[i]["MaterialDescription"]);
objMaterial.MaterialStatus = Convert.ToInt32(dt.Rows[i]["Status"]);
objMaterial.MaterialCategory = Convert.ToString(dt.Rows[i]["MatCatID"]);
objMaterial.MatForm = objForm_DL.Get(Convert.ToInt64(dt.Rows[i]["ItemFormID"]));
objMaterial.MatParticleSize = Convert.ToString(dt.Rows[i]["ParticalSize"]);
objMaterial.MatSeasonFrom = Convert.ToString(dt.Rows[i]["SeasanFrom"]);
objMaterial.MatSeasonTo = Convert.ToString(dt.Rows[i]["SeasanTo"]);
objMaterial.MatUnit = objUnit_DL.Get(Convert.ToInt64(dt.Rows[i]["UnitID"]));
objMatCollec.Add(objMaterial);
}
return(objMatCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public Material GetDryMaterial(String BasicMaterialCode)
{
try
{
Material_DL objMaterial_DL = new Material_DL(ConnectionStringClass.GetConnection());
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MaterialCode", BasicMaterialCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Material_Green_By_MaterialCode", paramList);
Material objMaterial = new Material();
if (dt.Rows.Count > 0)
{
objMaterial.IsExport = Convert.ToBoolean(dt.Rows[0]["Export"]);
objMaterial.IsLocal = Convert.ToBoolean(dt.Rows[0]["Local"]);
objMaterial.IsSeasanal = Convert.ToBoolean(dt.Rows[0]["Seasanal"]);
if (dt.Rows[0]["BasicMaterialCode"] != dt.Rows[0]["MaterialCode"])
{
objMaterial.MatBasicMaterial = dt.Rows[0]["BasicMaterialCode"].ToString();
}
objMaterial.MatBasicQty = Convert.ToDecimal(dt.Rows[0]["BasicQty"]);
objMaterial.MatCost = Convert.ToDecimal(dt.Rows[0]["AVGCost"]);
objMaterial.MateialType = objMaterialType_DL.Get(Convert.ToString(dt.Rows[0]["MatType"]));
objMaterial.MaterialMainType = Convert.ToString(dt.Rows[0]["MatMainType"]);
objMaterial.MaterialCode = Convert.ToString(dt.Rows[0]["MaterialCode"]);
objMaterial.MaterialDescription = Convert.ToString(dt.Rows[0]["MaterialDescription"]);
objMaterial.MaterialStatus = Convert.ToInt32(dt.Rows[0]["Status"]);
objMaterial.MaterialCategory = Convert.ToString(dt.Rows[0]["MatCatID"]);
objMaterial.MatForm = objForm_DL.Get(Convert.ToInt64(dt.Rows[0]["FormID"]));
objMaterial.MatParticleSize = Convert.ToString(dt.Rows[0]["ParticalSize"]);
objMaterial.MatSeasonFrom = Convert.ToString(dt.Rows[0]["SeasanFrom"]);
objMaterial.MatSeasonTo = Convert.ToString(dt.Rows[0]["SeasanTo"]);
objMaterial.MatUnit = objUnit_DL.Get(Convert.ToInt64(dt.Rows[0]["UnitID"]));
objMaterial.MaterialCategory = Convert.ToString(dt.Rows[0]["UnitID"]);
}
return(objMaterial);;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
//-- New - -
public System.Data.DataTable GetDataViewByMTNNO(long MTNNO)
{
MTNMaterialCollc objMTNMaterialCollc = new MTNMaterialCollc();
Material_DL objMaterial_DL = new Material_DL(Connection);
MTN_DL objMTN_DL = new MTN_DL(Connection);
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_MTNNO", MTNNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPDELETE_MTNMaterial", paramList);
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public Stock Get(long StockID)
{
Store_DL objStore_DL = new Store_DL(Connection);
Material_DL objMaterial_DL = new Material_DL(Connection);
BasicProduct_DL objBasicProduct_DL = new BasicProduct_DL(Connection);
FinishProduct_DL objFinishProduct_DL = new FinishProduct_DL(Connection);
Stock objStock = new Stock();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@StockID", StockID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_StockByID", paramList);
objStock.StockBasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["StockBasicProduct"]));
objStock.StockEconomicalQty = Convert.ToDecimal(dt.Rows[0]["StockEconomicalQty"]);
objStock.StockFinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[0]["StockFinishProduct"]));
objStock.StockID = Convert.ToInt64(dt.Rows[0]["StockID"]);
objStock.StockMaterial = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["StockMaterialID"]));
objStock.StockMaximumQty = Convert.ToDecimal(dt.Rows[0]["StockMaximumQty"]);
objStock.StockMinimumQty = Convert.ToDecimal(dt.Rows[0]["StockMinimumQty"]);
objStock.StockQty = Convert.ToDecimal(dt.Rows[0]["StockQty"]);
objStock.StockReorderLevel = Convert.ToDecimal(dt.Rows[0]["StockReorderLevel"]);
objStock.StockReservedQty = Convert.ToDecimal(dt.Rows[0]["StockReservedQty"]);
objStock.StockStatus = (Stock.Status)(dt.Rows[0]["StockStatus"]);
objStock.StockStore = objStore_DL.Get(Convert.ToString(dt.Rows[0]["StoreID"]));
objStock.StockType = (Stock.Type)(dt.Rows[0]["StockType"]);
return(objStock);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
