}//end method GetSelectedRow
// Delete a given service
public void DeleteService(ServiceVO service)
{
String serviceID = service.ID;
int selectedrow = gridViewServices.FocusedRowHandle;
try
{
int result = serviceBUS.DeleteService(service);
if (result != -1)
{
LoadData();
SelectRow(selectedrow - 1);
//ShowMessage("Xóa dịch vụ thành công");
} // end if
} //end try
catch (SqlException ex)
{
if (ex.Number == 547)
{
ShowError("Dịch vụ đã được sử dụng ở dữ liệu khác. Vui lòng dùng \"Tắt dịch vụ\"");
} //end case: error 547
} //end catch SqlException
catch (Exception ex)
{
ShowError(ex.Message);
} //end catch Exception
} //end method DeleteSelected
}//end method SetData
public ServiceVO GetData()
{
Double price;
try
{
price = Double.Parse(textBoxServicePrice.Text);
}//end try
catch (Exception e)
{
if (e is ArgumentNullException || e is FormatException)
{
price = data.Price;
}
else
{
throw;
}
}//end catch
String id = data.ID;
String name = textBoxServiceName.Text;
bool state = GetCheckedState();
data = new ServiceVO(id, name, price, state);
return(data);
}//end method GetData
} // end method GetAllServices
public int DeleteService(ServiceVO service)
{
try {
return(serviceDAO.DeleteService(service));
}// end try
catch (SqlException e) {
throw e;
} // end catch
} // end method DeleteServiceByID
} // end method DeleteServiceByID
public int InsertService(ServiceVO service)
{
try
{
return(this.serviceDAO.InsertService(service));
}// end try
catch (SqlException e)
{
throw e;
} // end catch
} // end method InsertService
}//end constructor
#endregion //end region Constructors
#region Methods
public void InsertService()
{
ServiceVO service = inputAddUI.Data;
try
{
gridViewUI.InsertNewService(service);
}//end try
catch (Exception e)
{
MessageBox.Show(e.Message);
} //end catch
} //end method Insert
} // end method getAllServices
public int DeleteService(ServiceVO service)
{
try {
// build delete query
String delete = "DELETE FROM DICH_VU WHERE MA_DICH_VU=@MA_DICH_VU";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@MA_DICH_VU", service.ID);
int result = Connection.ExecuteNonQuery(delete, param);
return(result);
}// end try
catch (SqlException e) {
throw e;
} // end catch
} // end method DeleteService
}//end constructor
#endregion //end region Constructor
#region Methods
public ServiceVO GetData()
{
ServiceVO service = null;
try
{
String name = textBoxName.Text;
Double price = Double.Parse(textBoxPrice.Text);
service = new ServiceVO(null, name, price, true);
}//end try
catch (FormatException e)
{
throw e;
} //end catch
return(service);
} //end method GetData
}//end method SetCheckedState
public void SetData(ServiceVO service)
{
if (service == null)
{
SetMode(Mode.Empty);
}//end if service is null
else
{
SetMode(Mode.Active);
textBoxServiceName.Text = service.Name;
textBoxServicePrice.Text = service.Price.ToString();
SetCheckedState(service.State);
}//end else
// Update data
data = service;
}//end method SetData
} // end method DeleteService
public int InsertService(ServiceVO service)
{
try
{
// build insert query
String insert = "INSERT INTO DICH_VU(TEN_DICH_VU, DON_GIA) " +
"VALUES(@TEN_DICH_VU, @DON_GIA)";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@TEN_DICH_VU", service.Name);
param[1] = new SqlParameter("@DON_GIA", service.Price);
int result = Connection.ExecuteNonQuery(insert, param);
return(result);
}// end try
catch (SqlException e)
{
throw e;
} // end catch
} // end method InsertService
} // end method InsertService
public int UpdateService(ServiceVO service)
{
try {
//build query
String update = "UPDATE DICH_VU " +
"SET TEN_DICH_VU=@TEN_DICH_VU, DON_GIA=@DON_GIA, HIEU_LUC=@HIEU_LUC " +
"WHERE MA_DICH_VU=@MA_DICH_VU";
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@MA_DICH_VU", service.ID);
param[1] = new SqlParameter("@TEN_DICH_VU", service.Name);
param[2] = new SqlParameter("@DON_GIA", service.Price);
param[3] = new SqlParameter("@HIEU_LUC", service.State);
int result = Connection.ExecuteNonQuery(update, param);
return(result);
}//end try
catch (SqlException e) {
throw e;
} //end catch
} //end method UpdateService
} //end method DeleteSelected
// Insert a new service
public void InsertNewService(ServiceVO service)
{
try
{
int result = serviceBUS.InsertService(service);
if (result == -1)
{
ShowError("Không thể thêm dịch vụ mới");
}// end if
else
{
LoadData();
SelectRow(gridViewServices.RowCount - 1);
}
}//end try
catch (Exception exp)
{
ShowError(exp.Message);
} //end catch
} //end method InsertNewService
} //end method InsertNewService
// Update a service
public void UpdateSevice(ServiceVO service)
{
int selectedrow = gridViewServices.FocusedRowHandle;
try {
int result = serviceBUS.UpdateService(service);
if (result == -1)
{
ShowError("Không thể cập nhật dịch vụ");
}//end if
else
{
LoadData();
SelectRow(selectedrow);
} //end else
} //end try
catch (Exception e) {
ShowError(e.Message);
} //end catch
} //end method UpdateService
}//end method LoadControls
// Load data from grid view to updating panel
public void LoadUpdatePanel()
{
ServiceVO service = gridViewUI.GetSelectedService();
inputUpdateUI.SetData(service);
}//end method LoadUpdatePanel
}//end method DeleteService
public void UpdateService()
{
ServiceVO service = inputUpdateUI.GetData();
gridViewUI.UpdateSevice(service);
}//end method UpdateService
} // end method InsertService
public int UpdateService(ServiceVO service)
{
return(serviceDAO.UpdateService(service));
}//end method UpdateService
