public WeightCharge WeightChargeIDatareader(IDataReader dr)
{
WeightCharge obj = new WeightCharge();
obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Charge = (dr["Charge"] is DBNull) ? string.Empty : dr["Charge"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
return obj;
}
public List<WeightCharge> GetAllWeightCharge()
{
List<WeightCharge> list = new List<WeightCharge>();
using (SqlCommand cmd = GetCommand("getAllWeightCharge", CommandType.StoredProcedure))
{
WeightCharge weightCharge = new WeightCharge();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(weightCharge.WeightChargeIDatareader(dr));
}
}
}
weightCharge = null;
}
return list;
}
public List<WeightCharge> GetWeightChargeByID(string id)
{
List<WeightCharge> list = new List<WeightCharge>();
using (SqlCommand cmd = GetCommand("getWeightChargeByID", CommandType.StoredProcedure))
{
AddParameter(cmd, "@ID", Convert.ToInt32(id));
WeightCharge weightCharge = new WeightCharge();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(weightCharge.WeightChargeIDatareader(dr));
}
}
}
weightCharge = null;
}
return list;
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (checkName() && checkChargeFormat() && Page.IsValid)
{
WeightCharge weightCharge = new WeightCharge();
weightCharge.Name = txtName.Text;
weightCharge.Charge = txtCharge.Text;
weightCharge.Description = txtDescription.Text;
bool result = WeightChargeBLL.InsertWeightCharge(weightCharge);
if (result)
{
lblStatusCreate.Text = "Create Weight Charge successful!";
Response.AddHeader("REFRESH", "2;URL=WeightManagement.aspx");
}
else
{
lblStatusCreate.Text = "Can not create new Weight Charge!";
return;
}
}
}
public static bool UpdateWeightCharge(WeightCharge weightCharge)
{
return db.UpdateWeightCharge(weightCharge);
}
public static bool InsertWeightCharge(WeightCharge weightCharge)
{
return db.InsertWeightCharge(weightCharge);
}
private void LoadWeightCharge()
{
WeightCharge weightCharge = new WeightCharge();
weightCharge = WeightChargeBLL.GetWeightChargeByID(WeightChargeID)[0];
txtName.Text = weightCharge.Name;
txtCharge.Text = Convert.ToDecimal(weightCharge.Charge).ToString("F");
txtDescription.Text = weightCharge.Description;
}
public bool InsertWeightCharge(WeightCharge weightCharge)
{
using (SqlCommand cmd = GetCommand("insertWeightCharge", CommandType.StoredProcedure))
{
AddParameter(cmd, "@Name", weightCharge.Name);
AddParameter(cmd, "@Charge", weightCharge.Charge);
AddParameter(cmd, "@Description", weightCharge.Description);
int result = ExeNonQuery(cmd);
return result > 0;
}
}