/// <summary>
/// Delete a service.
/// </summary>
/// <param name="serviceId">Id of the service.</param>
/// <returns>Return the number of rows affected or return -1 if occur exception.</returns>
public void DeleteService(Guid serviceId)
{
try
{
OrderBusiness OB = new OrderBusiness();
List<OrderOfServiceDetail> listDetail = OB.GetOrderDetailsByServiceId(serviceId, false);
if (listDetail.Count == 0)
{
List<OrderOfServiceDetail> listDetailRemoved = OB.GetOrderDetailsByServiceId(serviceId, true);
if (listDetailRemoved.Count > 0)
OB.DeleteOrderDetail(null, serviceId.ToString());
int result = SD.Delete(serviceId);
if (result == -1)
{
throw new Exception("An error occurred while executing this operation.");
}
}
else
{
throw new Exception("This service's data is also related to some other data. It could be not deleted.");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
OB = new OrderBusiness();
EB = new EmployeeBusiness();
CB = new CompanyBLL();
loadData();
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
protected void Page_Load(object sender, EventArgs e)
{
OB = new OrderBusiness();
CB = new CompanyBLL();
DataTable dtCompany = CB.Company_ShowAllDisplay("");
dtCompany.Columns.Add("Payment", typeof(double));
foreach (DataRow item in dtCompany.Rows)
{
Guid comId = new Guid(item["Company_Id"].ToString());
double companyPayment = 0;
List<Order> listOrder = OB.GetOrdersByCompanyId(comId, false);
foreach (Order order in listOrder)
{
companyPayment += Double.Parse(order.Total_Charge);
}
listOrder = OB.GetOrdersByCompanyId(comId, true);
foreach (Order order in listOrder)
{
companyPayment += Double.Parse(order.Total_Charge);
}
item["Payment"] = companyPayment;
}
DataView dv = dtCompany.DefaultView;
dv.Sort = "Payment DESC";
dtCompany = dv.Table;
//for (int i = 0; i < newDataTable.Rows.Count; i++)// change 'newDataTable.Rows.Count' by a prametter.
//{
//}
DataRow dr = dtCompany.Rows[0];
imgCompany1.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
lnkCompanyName1.Text = dr["Company_Name"].ToString();
lblAddress1.Text = dr["Company_Address"].ToString();
dr = dtCompany.Rows[1];
imgCompany2.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
lnkCompanyName2.Text = dr["Company_Name"].ToString();
lblAddress2.Text = dr["Company_Address"].ToString();
dr = dtCompany.Rows[2];
imgCompany3.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
lnkCompanyName3.Text = dr["Company_Name"].ToString();
lblAddress3.Text = dr["Company_Address"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
pnlRed.Visible = false;
pnlGreen.Visible = false;
pnlYellow.Visible = false;
pnlBlue.Visible = false;
OB = new OrderBusiness();
GetRouteData();
if (!IsPostBack)
loadData();
else
{
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
}
/// <summary>
/// Delete permanently an employee.
/// </summary>
/// <param name="emId">Id of the employee that you want to delete.</param>
public void DeleteEmployee(Guid emId)
{
try
{
Employee employee = ED.GetEmployee(emId);
// Check related datas
OrderBusiness OB = new OrderBusiness();
List <Order> list = OB.GetOrdersByEmployeeId(emId, false);
if (list.Count == 0)
{
// Delete account of this employee first.
AccountBusiness AB = new AccountBusiness();
Account account = AB.GetAccountOfEmployee(emId);
if (account != null)
{
AB.DeleteAccount(account.Account_Id);
}
// Then delete orders of this employee
foreach (Order item in list)
{
OB.DeleteOrder(item.OrderOfService_Id);
}
int result = ED.DeleteEmployee(employee);
if (result == -1)
{
throw new Exception("An error occurred while executing this operation.");
}
}
else
{
throw new Exception("This employee's data is also related to some other data. It could be not deleted.");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
pnlRed.Visible = false;
pnlGreen.Visible = false;
pnlYellow.Visible = false;
pnlBlue.Visible = false;
OB = new OrderBusiness();
SB = new ServiceBusiness();
if (IsPostBack)
{
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
else
{
List<Service> listService = SB.GetServices();
ddlService.Items.Clear();
ListItem item = new ListItem("All", "");
ddlService.Items.Add(item);
foreach (Service service in listService)
{
item = new ListItem();
item.Text = service.Service_Name;
item.Value = service.Service_Id.ToString();
ddlService.Items.Add(item);
}
ddlService.SelectedIndex = 0;
ddlStatus.Items.Clear();
ListItem itemStatus = new ListItem("All", "");
ddlStatus.Items.Add(itemStatus);
itemStatus = new ListItem("Pending", "0");
ddlStatus.Items.Add(itemStatus);
itemStatus = new ListItem("In Progress", "99");
ddlStatus.Items.Add(itemStatus);
itemStatus = new ListItem("Resolved", "1");
ddlStatus.Items.Add(itemStatus);
ddlStatus.SelectedIndex = 0;
}
loadData();
}
/// <summary>
/// Delete permanently an employee.
/// </summary>
/// <param name="emId">Id of the employee that you want to delete.</param>
public void DeleteEmployee(Guid emId)
{
try
{
Employee employee = ED.GetEmployee(emId);
// Check related datas
OrderBusiness OB = new OrderBusiness();
List<Order> list = OB.GetOrdersByEmployeeId(emId, false);
if (list.Count == 0)
{
// Delete account of this employee first.
AccountBusiness AB = new AccountBusiness();
Account account = AB.GetAccountOfEmployee(emId);
if (account != null)
AB.DeleteAccount(account.Account_Id);
// Then delete orders of this employee
foreach (Order item in list)
{
OB.DeleteOrder(item.OrderOfService_Id);
}
int result = ED.DeleteEmployee(employee);
if (result == -1)
{
throw new Exception("An error occurred while executing this operation.");
}
}
else
{
throw new Exception("This employee's data is also related to some other data. It could be not deleted.");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
pnlRed.Visible = false;
pnlGreen.Visible = false;
pnlYellow.Visible = false;
pnlBlue.Visible = false;
SB = new ServiceBusiness();
AB = new AccountBusiness();
EB = new EmployeeBusiness();
DB = new DepartmentBusiness();
CB = new CompanyBLL();
OB = new OrderBusiness();
GetRouteData();
cvBillDate.ValueToCompare = DateTime.Now.Date.ToShortDateString();
if (!IsPostBack)
loadData();
else
{
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
}
