public static List <clsProductColor> EditData(clsProductColor Obj)
{
List <clsProductColor> details = new List <clsProductColor>();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@ColorID", Obj.ColorID);
dt = clsCURD.GetData("[IMIS_ProColorSelectByID]", p);
foreach (DataRow dtrow in dt.Rows)
{
clsProductColor obj = new clsProductColor();
obj.ColorID = int.Parse(dtrow["ColorID"].ToString());
obj.ColorName = dtrow["ColorName"].ToString();
obj.ColorShortName = dtrow["ColorShortName"].ToString();
details.Add(obj);
}
return(details);
}
public static void Update(clsProductColor Obj)
{
try
{
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@ColorName", Obj.ColorName);
p[1] = new SqlParameter("@ColorShortName", Obj.ColorShortName);
p[2] = new SqlParameter("@ColorID", Obj.ColorID);
p[3] = new SqlParameter("@LastUpdatedBy", Obj.LastUpdatedBy);
clsCURD.ExecuteStoreProcedure("IMIS_ProColorUpdate", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
public static void Insert(clsProductColor Obj)
{
try
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@ColorName", Obj.ColorName);
p[1] = new SqlParameter("@ColorShortName", Obj.ColorShortName);
p[2] = new SqlParameter("@UserID", Obj.UserID);
clsCURD.ExecuteStoreProcedure("IMIS_ProColorInsert", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
