//-- 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 MTNMaterialCollc GetByNo(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);
for (int i = 0; i < dt.Rows.Count; i++)
{
MTNMaterial objMTNMaterial = new MTNMaterial();
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"]);
objMTNMaterialCollc.Add(objMTNMaterial);
}
return(objMTNMaterialCollc);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
