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