public ssmtbl_CuutingCalculationModel GetOneCutingCalculation(long section)
{
var connection = gConnection.Connection();
ssmtbl_CuutingCalculationModel model = new ssmtbl_CuutingCalculationModel();
try
{
sqlstr = "select * from LKP_CuutingCalculation_Tb where id=@id";
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@id", section);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
model.cuttingrateperpc = Convert.ToDecimal(sdr["cuttingrateperpc"]);
model.formula = sdr["cuttingrateperpc"].ToString();
model.id = Convert.ToInt32(sdr["id"]);
model.qty = Convert.ToDecimal(sdr["cuttingrateperpc"]);
model.rate = Convert.ToDecimal(sdr["cuttingrateperpc"]);
model.sqin = Convert.ToDecimal(sdr["cuttingrateperpc"]);
model.totalcost = Convert.ToDecimal(sdr["cuttingrateperpc"]);
model.xsection = sdr["cuttingrateperpc"].ToString();
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
connection.Close();
}
return(model);
}
public List <ssmtbl_CuutingCalculationModel> GetAllSection()
{
List <ssmtbl_CuutingCalculationModel> objSecList = new List <ssmtbl_CuutingCalculationModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_SectionMaster";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Select");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_CuutingCalculationModel objtemp = new ssmtbl_CuutingCalculationModel();
objtemp.id = Convert.ToInt64(sdr["id"].ToString());
objtemp.xsection = sdr["XSection"].ToString();
objSecList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objSecList);
}
