private void LoadData()
{
ServiceCharge service = new ServiceCharge();
service = ServiceChargeBLL.GetServiceChargeByID(Request.QueryString["ServiceID"].ToString())[0];
lblServiceName.Text = service.Name;
ltrDescription.Text = service.Description;
}
public ServiceCharge ServiceChargeIDatareader(IDataReader dr)
{
ServiceCharge obj = new ServiceCharge();
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<ServiceCharge> GetAllServiceCharge()
{
List<ServiceCharge> list = new List<ServiceCharge>();
using (SqlCommand cmd = GetCommand("getAllServiceCharge", CommandType.StoredProcedure))
{
ServiceCharge serviceCharge = new ServiceCharge();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(serviceCharge.ServiceChargeIDatareader(dr));
}
}
}
serviceCharge = null;
}
return list;
}
public List<ServiceCharge> GetServiceChargeByID(string id)
{
List<ServiceCharge> list = new List<ServiceCharge>();
using (SqlCommand cmd = GetCommand("getServiceChargeByID", CommandType.StoredProcedure))
{
AddParameter(cmd, "@ID", Convert.ToInt32(id));
ServiceCharge serviceCharge = new ServiceCharge();
using (SqlDataReader dr = ExeDataReader(cmd))
{
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(serviceCharge.ServiceChargeIDatareader(dr));
}
}
}
serviceCharge = null;
}
return list;
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (checkName() && checkChargeFormat() && Page.IsValid)
{
ServiceCharge serviceCharge = new ServiceCharge();
serviceCharge.Name = txtName.Text;
serviceCharge.Charge = txtCharge.Text;
serviceCharge.Description = txtDescription.Text;
bool result = ServiceChargeBLL.InsertServiceCharge(serviceCharge);
if (result)
{
lblStatusCreate.Text = "Create Service successful!";
Response.AddHeader("REFRESH", "2;URL=ServiceManagement.aspx");
}
else
{
lblStatusCreate.Text = "Can not create new Service!";
return;
}
}
}
public static bool UpdateServiceCharge(ServiceCharge serviceCharge)
{
return db.UpdateServiceCharge(serviceCharge);
}
public static bool InsertServiceCharge(ServiceCharge serviceCharge)
{
return db.InsertServiceCharge(serviceCharge);
}
public bool InsertServiceCharge(ServiceCharge serviceCharge)
{
using (SqlCommand cmd = GetCommand("insertServiceCharge", CommandType.StoredProcedure))
{
AddParameter(cmd, "@Name", serviceCharge.Name);
AddParameter(cmd, "@Charge", serviceCharge.Charge);
AddParameter(cmd, "@Description", serviceCharge.Description);
int result = ExeNonQuery(cmd);
return result > 0;
}
}
private void LoadService()
{
ServiceCharge serviceCharge = new ServiceCharge();
serviceCharge = ServiceChargeBLL.GetServiceChargeByID(serviceChargeID)[0];
txtName.Text = serviceCharge.Name;
txtCharge.Text = Convert.ToDecimal(serviceCharge.Charge).ToString("F");
txtDescription.Text = serviceCharge.Description;
}