public static List <clsProductSize> EditData(clsProductSize clsProductSize)
{
List <clsProductSize> details = new List <clsProductSize>();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@SizeID", clsProductSize.SizeID);
dt = clsCURD.GetData("[IMIS_ProSizeSelectByID]", p);
foreach (DataRow dtrow in dt.Rows)
{
clsProductSize obj = new clsProductSize();
obj.SizeID = int.Parse(dtrow["SizeID"].ToString());
obj.SizeName = dtrow["SizeName"].ToString();
obj.SizeShortName = dtrow["SizeShortName"].ToString();
details.Add(obj);
}
return(details);
}
public static void InsertSize(clsProductSize clsProductSize)
{
try
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@SizeName", clsProductSize.SizeName);
p[1] = new SqlParameter("@SizeShortName", clsProductSize.SizeShortName);
p[2] = new SqlParameter("@UserID", clsProductSize.UserID);
clsCURD.ExecuteStoreProcedure("IMIS_ProSizeInsert", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
public static void UpdateSize(clsProductSize clsProductSize)
{
try
{
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@SizeID", clsProductSize.SizeID);
p[1] = new SqlParameter("@SizeName", clsProductSize.SizeName);
p[2] = new SqlParameter("@SizeShortName", clsProductSize.SizeShortName);
p[3] = new SqlParameter("@LastUpdatedBy", clsProductSize.LastUpdatedBy);
clsCURD.ExecuteStoreProcedure("IMIS_ProSizeUpdate", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
