public clsSizeCodes GetSizeCodeInfoByProjectandSizeCode(string Project, string SizeCode)
{
clsSizeCodes info = new clsSizeCodes();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_UnitIDByProjectandSizeCode"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ProjectID", Project);
cmd.Parameters.AddWithValue("@SizeCodeID", SizeCode);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
info.strUnitSizeCode = reader["Project"].ToString();
info.strUnitSizeCode = reader["UnitSizeCode"].ToString();
info.strUnitSizeDescription = reader["UnitSizeDescription"].ToString();
info.decArea = Convert.ToDecimal(reader["Area"]);
info.UoMID = reader["UoMID"].ToString();
info.UoMDescription = reader["UoMDescription"].ToString();
info.strPrefix = reader["Prefix"].ToString();
info.strCurrentNumber = reader["CurrentNumber"].ToString();
info.ID = Convert.ToInt32(reader["ID"]);
}
conn.Close();
}
}
return(info);
}
public bool AddSizeCode(clsSizeCodes info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddSizeCode"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@Project", info.strProject);
cmd.Parameters.AddWithValue("@UnitSizeCode", info.strUnitSizeCode);
cmd.Parameters.AddWithValue("@UnitSizeDescription", info.strUnitSizeDescription);
cmd.Parameters.AddWithValue("@Area", info.decArea);
cmd.Parameters.AddWithValue("@UnitID", info.UoMID);
cmd.Parameters.AddWithValue("@UnitDescription", info.UoMDescription);
cmd.Parameters.AddWithValue("@Prefix", info.strPrefix);
cmd.Parameters.AddWithValue("@CurrentNumber", info.strCurrentNumber);
cmd.Parameters.AddWithValue("@ID", info.ID);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <clsSizeCodes> GetAllSizeCodeInfoByProject(string strProject)
{
List <clsSizeCodes> lst = new List <clsSizeCodes>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetSizeCodeByProject"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ProjectID", strProject);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var info = new clsSizeCodes();
info.strProject = reader["Project"].ToString();
info.strUnitSizeCode = reader["UnitSizeCode"].ToString();
info.strUnitSizeDescription = reader["UnitSizeDescription"].ToString();
info.decArea = Convert.ToDecimal(reader["Area"]);
info.UoMID = reader["UoMID"].ToString();
info.UoMDescription = reader["UoMDescription"].ToString();
info.strPrefix = reader["Prefix"].ToString();
info.strCurrentNumber = reader["CurrentNumber"].ToString();
info.ID = Convert.ToInt32(reader["ID"]);
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}