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