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 { } }