public static List <clsProductPaking> EditData(clsProductPaking Obj)
{
List <clsProductPaking> details = new List <clsProductPaking>();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@PackingID", Obj.PackingID);
dt = clsCURD.GetData("[IMIS_ProProductPakingSelectByID]", p);
foreach (DataRow dtrow in dt.Rows)
{
clsProductPaking obj = new clsProductPaking();
obj.PackingID = int.Parse(dtrow["PackingID"].ToString());
obj.PackingName = dtrow["PackingName"].ToString();
details.Add(obj);
}
return(details);
}
public static void Update(clsProductPaking Obj)
{
try
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@PackingName", Obj.PackingName);
p[1] = new SqlParameter("@PackingID", Obj.PackingID);
p[2] = new SqlParameter("@LastUpdatedBy", Obj.LastUpdatedBy);
clsCURD.ExecuteStoreProcedure("IMIS_ProProductPakingUpdate", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
public static void Insert(clsProductPaking Obj)
{
try
{
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@PackingName", Obj.PackingName);
p[1] = new SqlParameter("@UserID", Obj.UserID);
clsCURD.ExecuteStoreProcedure("IMIS_ProProductPakingInsert", p);
}
catch (SqlException Sexp)
{
}
catch (Exception ex)
{
}
finally
{
}
}
