public List <RMPlanningModel> GetAllRMPlanning()
{
List <RMPlanningModel> objRMList = new List <RMPlanningModel>();
try
{
string sqlstr = "ssmsp_Get_AllRMByGradeOfMaterial";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
RMPlanningModel objtemp = new RMPlanningModel();
objtemp.GradeOfMaterial = sdr["GradeOfMaterial"].ToString();
objtemp.HeatCode = sdr["HeatCode"].ToString();
objtemp.Section = sdr["Section"].ToString();
var qty = (sdr["Quntity"].ToString());
objtemp.Qty = qty == "" ? "0" : qty;
var Unit = sdr["RMUnit"].ToString();
objtemp.Unit = Unit == "" ? "NA" : Unit;
objRMList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objRMList);
}
public List <RMPlanningModel> GetAllRMPlanning(string gradeOfMaterial, string wono, string section, string heatcode)
{
List <RMPlanningModel> objRMAllocateList = new List <RMPlanningModel>();
try
{
var gof = gradeOfMaterial.Trim();
string sqlstr = "ssmsp_Get_AllWorkorder";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "GetWoDataByGofHtSec");
cmd.Parameters.AddWithValue("@GradeOfMaterial", gof);
cmd.Parameters.AddWithValue("@section", section);
cmd.Parameters.AddWithValue("@heatcode", heatcode);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
RMPlanningModel objtemp = new RMPlanningModel();
objtemp.WorkorderNo = wono;
objtemp.GradeOfMaterial = sdr["GradeOfMaterial"].ToString();
objtemp.HeatCode = sdr["HeatCode"].ToString();
objtemp.Section = sdr["Section"].ToString();
var qty = (sdr["Quntity"].ToString());
objtemp.Qty = qty == "" ? "0" : qty;
var Unit = sdr["RMUnit"].ToString();
objtemp.Unit = Unit == "" ? "NA" : Unit;
objRMAllocateList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objRMAllocateList);
}
