protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e) { try { GridDataItem item = (GridDataItem)e.Item; string id = item["colId"].Text; switch (e.CommandName) { case "btnSelect": Response.Redirect("CompanyInfo.aspx?id=" + id, true); break; case "btnDelete": int delete = new Company().DeleteCompanyByCompanyId(int.Parse(id)); long addressid = GetAddressID(int.Parse(id)); int deleteAddress = new Addresses().DeleteAddressesByAddressId(addressid); if (delete == 0) Alert.Show("Data was not deleted"); else { this.LoadCompanyListTable(); } break; } } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { bool chk = false; Supplier aSupply = new Supplier(); List<Supplier> aSuppierList = aSupply.GetAllSupplier(_company.CompanyId); long id; if (aSuppierList.Count > 0) { aSupply = aSuppierList[aSuppierList.Count - 1]; id = aSupply.SupplierId + 1; } else id = 1; Supplier newSupply = new Supplier(); newSupply.SupplierId = id; newSupply.SupplierName = txtSupplierName.Value; newSupply.IsActive = true; newSupply.CompanyId = _company.CompanyId; newSupply.UpdateBy = user.UserId; newSupply.UpdateDate = DateTime.Now; newSupply.TotalDebit = int.Parse(txtTotalDebit.Value); newSupply.TotalCredit = int.Parse(txtTotalCredit.Value); newSupply.Balance = newSupply.TotalCredit - newSupply.TotalDebit; Addresses aAddresses = new Addresses(); aAddresses.SourceType = "Supplier"; aAddresses.SourceId = id; aAddresses.AddressType = "Main Address"; aAddresses.AddressLine1 = txtAddressLine1.Value; aAddresses.AddressLine2 = txtAddressLine2.Value; aAddresses.CountryId = int.Parse(countryDropDownList.SelectedIndex.ToString()); aAddresses.City = txtCity.Value; aAddresses.ZipCode = txtZipCode.Value; aAddresses.CompanyId = _company.CompanyId; int chk1 = newSupply.InsertSupplier(); int chk2 = aAddresses.InsertAddresses(); if (chk1 > 0 && chk2 > 0) { Session["savedSupplicerMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting supplier information,please check the input data again. Don't use special character in Debit or Credit Section . Use the amount number there."); } } catch (Exception exp) { Alert.Show(exp.Message); } }
private long GetAddressID(int parse) { long p = 0; Addresses newAddress = new Addresses(); List<Addresses> liAddress = newAddress.GetAllAddresses(_company.CompanyId); foreach (Addresses addressese in liAddress) { if (addressese.SourceType == "Company" && addressese.SourceId == parse) { p = addressese.AddressId; break; } } return p; }
protected void btnSave_Click(object sender, EventArgs e) { Customer objCustomer = new Customer(); List<Customer> myList = objCustomer.GetAllCustomer(_company.CompanyId); objCustomer.CustomerId = myList.Count; objCustomer.CustomerName = txtCustomerName.Value; objCustomer.CustomerCategoryId =int.Parse(txtCustomerCategory.Value); objCustomer.SalesPersonId = int.Parse(salesPersonDropDownList.SelectedItem.Value); objCustomer.IsActive = chkIsActive.Checked; objCustomer.CompanyId = _company.CompanyId; objCustomer.CreditLimit = int.Parse(txtCreditLimit.Value); objCustomer.UpdateBy = _user.UserId; objCustomer.UpdateDate=DateTime.Now; Addresses address = new Addresses(); List<Addresses> addresseses = address.GetAllAddresses(_company.CompanyId); address.AddressId = addresseses.Count; address.SourceType = "Customer"; address.SourceId = _user.UserId; address.AddressType = "Main Address"; address.AddressLine1 = txtAddressLine1.Value; address.AddressLine2 = txtAddressLine2.Value; address.CountryId = countryDropDownList.SelectedIndex; address.City = txtCity.Value; address.ZipCode = txtZipCode.Value; address.Phone = txtPhoneNo.Value; address.Mobile = txtPhoneNo.Value; address.Email = txtEmail.Value; address.Web = txtWeb.Value; address.CompanyId = _company.CompanyId; int chk1 = objCustomer.InsertCustomer(); int chk2=address.InsertAddresses(); if (chk1 > 0 && chk2 > 0) { Session["savedCutomerMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting customer information"); } }
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e) { try { GridDataItem item = (GridDataItem) e.Item; string id = item["colId"].Text; switch (e.CommandName) { case "btnSelect": { Response.Redirect("SupplierInfo.aspx?id="+id); break; } case "btnDelete": { int del = new Supplier().DeleteSupplierBySupplierId(int.Parse(id)); long addId = GetAddressID(int.Parse(id)); int del2 = new Addresses().DeleteAddressesByAddressId(addId); if (del2 == 0 && del == 0) { Alert.Show("Data is not deleted"); } else { this.LoadSupplierTable(); } break; } } } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { _company = (Company)Session["Company"]; user = (Users)Session["user"]; this.LoadCountryDropDownList(); this.LoadDepartmentDropDownList(); if (!isValidSession()) { string str = Request.QueryString.ToString(); if (str == string.Empty) { Response.Redirect("LogIn.aspx?refPage=index.aspx"); } else { Response.Redirect("LogIn.aspx?regPage=index.aspx"+str); } } if (!IsPostBack) { if (Request.QueryString["id"] != null) { string id = Request.QueryString["id"].ToString(); Employee tempEmployee= new Employee().GetEmployeeByEmployeeId(int.Parse(id),_company.CompanyId); if (tempEmployee != null || tempEmployee.EmployeeId != 0) { List<string> countryList = Country.CountryList(); List<Addresses> addressList = new Addresses().GetAllAddresses(_company.CompanyId); Designation designation = new Designation().GetDesignationByDesignationId(tempEmployee.DesignationId, _company.CompanyId); Department department; if (tempEmployee.DepartmentId != 0) { department = new Department().GetDepartmentByDepartmentId(tempEmployee.DepartmentId, _company.CompanyId); SetIndex(departmentDropDownList, department.DepartmentId.ToString()); LoadDesignationDropDownList(tempEmployee.DepartmentId); } else { department = new Department(); departmentDropDownList.SelectedIndex = -1; LoadDesignationDropDownList(0); } SetIndex(designationDropDownList,tempEmployee.DesignationId.ToString()); lblId.Text = tempEmployee.EmployeeId.ToString(); txtEmployeeCode.Value = tempEmployee.EmployeeCode; txtEmployeeName.Value = tempEmployee.EmployeeName; JoinRadDatePicker.SelectedDate = DateTime.Parse(tempEmployee.JoinDate); RadDatePicker1.SelectedDate = DateTime.Parse(tempEmployee.DOB); chkIsActive.Checked = tempEmployee.IsActive; //SetIndex(designationDropDownList,designation.DesignationId.ToString()); foreach (Addresses tAddress in addressList) { if (tAddress.SourceType == "Employee" && tAddress.SourceId == tempEmployee.EmployeeId) { addlblId.Text = tAddress.AddressId.ToString(); txtAddressLine1.Value = tAddress.AddressLine1; txtAddressLine2.Value = tAddress.AddressLine2; txtCity.Value = tAddress.City; txtEmail.Value = tAddress.Email; txtZipCode.Value = tAddress.ZipCode; txtPhoneNo.Value = tAddress.Phone; countryDropDownList.SelectedIndex = tAddress.CountryId; break; } } } } } if (Session["empMessage"] != null) { string message = Session["empMessage"].ToString(); Session["empMessage"] = null; Alert.Show(message); } }
private void LoadCompanyListTable() { try { Company objCompany = new Company(); List<string> countryList = Country.CountryList(); List<Company> objCompanyList= new Company().GetAllCompany(); if (objCompanyList.Count == 0) { objCompanyList.Add(new Company()); } foreach (Company objCst in objCompanyList) { Addresses address= new Addresses().GetAddressesBySourceTypeAndId("Company",objCst.CompanyId); objCst.AddressId = address.AddressId; objCst.AddressLine1 = address.AddressLine1; objCst.AddressLine2 = address.AddressLine2; objCst.AddressType = address.AddressType; objCst.City = address.City; objCst.ZipCode = address.ZipCode; objCst.Phone = address.Phone; objCst.Mobile = address.Mobile; objCst.Email = address.Email; objCst.Web = address.Web; objCst.CountryName = countryList[address.CountryId]; } RadGrid1.DataSource = objCompanyList; RadGrid1.Rebind(); } catch (Exception ex) { Alert.Show(ex.Message); } }
private void LoadSupplierTable() { try { Supplier newSupplier= new Supplier(); objSupplierList = newSupplier.GetAllSupplier(_company.CompanyId); List<string> countryList = Country.CountryList(); List<Addresses> addresses=new Addresses().GetAllAddresses(_company.CompanyId); foreach (Supplier supplier in objSupplierList) { foreach (Addresses aAddress in addresses) { if (aAddress.SourceType == "Supplier" && aAddress.SourceId == supplier.SupplierId) { supplier.AddressLine1 = aAddress.AddressLine1; supplier.AddressLine2 = aAddress.AddressLine2; supplier.City = aAddress.City; supplier.ZipCode = aAddress.ZipCode; supplier.Phone = aAddress.Phone; supplier.Email = aAddress.Email; supplier.Web = aAddress.Web; supplier.Mobile = aAddress.Mobile; supplier.CountryName = countryList[aAddress.CountryId]; } } } RadGrid1.DataSource = objSupplierList; RadGrid1.Rebind(); } catch (Exception ex) { Alert.Show(ex.Message); } }
private long GetAddressID(int parse) { Addresses newAddress = new Addresses(); List<Addresses> liAddress = newAddress.GetAllAddresses(_company.CompanyId); return (from addressese in liAddress where addressese.SourceType == "Employee" && addressese.SourceId == parse select addressese.AddressId).FirstOrDefault(); }
protected void Page_Load(object sender, EventArgs e) { _company = (Company) Session["Company"]; this.LoadAllCompany(); this.LoadCountryDropdown(); if (!isValidSession()) { string str = Request.QueryString.ToString(); if (str == string.Empty) Response.Redirect("LogIn.aspx?refPage=default.aspx"); else Response.Redirect("LogIn.aspx?refPage=default.aspx?" + str); } if (!IsPostBack) { if (Request.QueryString["id"] != null) { string companyId = Request.QueryString["id"].ToString(); Company tempCompany= new Company().GetCompanyByCompanyId(int.Parse(companyId)); if (tempCompany != null || tempCompany.CompanyId != 0) { Addresses tempAddress = new Addresses(); List<Addresses> listAdddress = tempAddress.GetAllAddresses(_company.CompanyId); foreach (Addresses addressese in listAdddress.Where(addressese => addressese.SourceId == tempCompany.CompanyId && addressese.SourceType == "Company")) { tempAddress = addressese; break; } lblId.Text = tempCompany.CompanyId.ToString(); addlblId.Text = tempAddress.AddressId.ToString(); txtCompanyName.Value=tempCompany.CompanyName; txtPhoneNo.Value=tempAddress.Phone; txtEmail.Value=tempAddress.Email; txtWeb.Value=tempAddress.Web; txtLogoPath.Value=tempCompany.LogoPath; // newCompany.UpdateBy = user.UserId; chkIsActive.Checked=tempCompany.IsActive; txtAddressLine1.Value=tempAddress.AddressLine1; txtAddressLine2.Value=tempAddress.AddressLine2; countryDropDownList.SelectedIndex=tempAddress.CountryId; txtCity.Value=tempAddress.City; txtZipCode.Value=tempAddress.ZipCode; } } } }
protected void btnSave_Click(object sender, EventArgs e) { //try //{ if (txtCompanyName.Value == string.Empty) { Alert.Show("Please enter the company name."); txtCompanyName.Focus(); return; } Company newCompany = new Company(); newCompany.CompanyName = txtCompanyName.Value; newCompany.Address = txtAddress.Value; newCompany.Phone = txtPhoneNo.Value; newCompany.Email = txtEmail.Value; newCompany.Web = txtWeb.Value; newCompany.LogoPath = txtLogoPath.Value; // newCompany.UpdateBy = user.UserId; newCompany.UpdateBy = _user.UserId; newCompany.UpdateDate = DateTime.Now; newCompany.IsActive = chkIsActive.Checked; Addresses address = new Addresses(); address.SourceType = "Company"; address.SourceId = _user.CompanyId; address.AddressType = "Main Address"; address.AddressLine1 = txtAddressLine1.Value; address.AddressLine2 = txtAddressLine2.Value; address.CountryId = countryDropDownList.SelectedIndex; address.City = txtCity.Value; address.ZipCode = txtZipCode.Value; address.Phone = txtPhoneNo.Value; address.Mobile = txtPhoneNo.Value; address.Email = txtEmail.Value; address.Web = txtWeb.Value; address.CompanyId = _user.CompanyId; int success = newCompany.InsertCompany(); //address.InsertAddresses(); if (success > 0) { Alert.Show("Saved Company Information Successfully!"); this.LoadAllCompany(); this.Clear(); this.LoadCompanyTable(); } else { Alert.Show("Error occured !"); } //} //catch (Exception ex) //{ // Alert.Show(ex.Message); //} }
protected void btnSave_Click(object sender, EventArgs e) { Customer objCustomer = new Customer(); objCustomer.CustomerName = txtCustomerName.Value; objCustomer.CustomerCategoryId = int.Parse(txtCustomerCategory.Value); objCustomer.SalesPersonId = int.Parse(salesPersonDropDownList.SelectedItem.Value); objCustomer.IsActive = chkIsActive.Checked; objCustomer.CompanyId = _company.CompanyId; objCustomer.CreditLimit = int.Parse(txtCreditLimit.Value); objCustomer.UpdateBy = _user.UserId; objCustomer.UpdateDate = DateTime.Now; Addresses address = new Addresses(); address.SourceType = "Customer"; address.AddressType = "Main Address"; address.AddressLine1 = txtAddressLine1.Value; address.AddressLine2 = txtAddressLine2.Value; address.CountryId = countryDropDownList.SelectedIndex; address.City = txtCity.Value; address.ZipCode = txtZipCode.Value; address.Phone = txtPhoneNo.Value; address.Mobile = txtMobile.Value; address.Email = txtEmail.Value; address.Web = txtWeb.Value; address.CompanyId = _company.CompanyId; if ((lblId.Text == "" || lblId.Text == "0") && (addlblId.Text == "" || addlblId.Text == "0")) { objCustomer.CustomerId = new Customer().GetMaxCustomerID() + 1; address.SourceId = objCustomer.CustomerId; address.AddressId = new Addresses().GetMaxAddressId() + 1; int chk1 = objCustomer.InsertCustomer(); int chk2 = address.InsertAddresses(); if (chk1 > 0 && chk2 > 0) { Session["savedCutomerMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting customer information"); } } else { address.AddressId =long.Parse( addlblId.Text); objCustomer.CustomerId = long.Parse(lblId.Text); int check = address.UpdateAddresses(); check = objCustomer.UpdateCustomer(); if (check > 0) { Response.Redirect("CustomerList.aspx", true); } } }
protected void Page_Load(object sender, EventArgs e) { _company = (Company)Session["Company"]; if (Session["savedCutomerMessage"] != null) { string msg = Session["savedCutomerMessage"].ToString(); Alert.Show(msg); Session["savedCutomerMessage"] = null; } if (!isValidSession()) { string str = Request.QueryString.ToString(); if (str == string.Empty) Response.Redirect("LogIn.aspx?refPage=index.aspx"); else Response.Redirect("LogIn.aspx?refPage=index.aspx?" + str); } this.LoadCountryDropdown(); this.LoadSalesPersonDropDown(); if (!IsPostBack) { if (Request.QueryString["id"] != null) { string customerID = Request.QueryString["id"].ToString(); Customer objCustomer = new Customer().GetCustomerByCustomerId(int.Parse(customerID), _company.CompanyId); if (objCustomer != null || objCustomer.CustomerId != 0) { Addresses tempAddress = new Addresses(); List<Addresses> listAdddress = tempAddress.GetAllAddresses(_company.CompanyId); foreach (Addresses addressese in listAdddress.Where(addressese => addressese.SourceId == objCustomer.CustomerId && addressese.SourceType == "Customer")) { tempAddress = addressese; break; } addlblId.Text = tempAddress.AddressId.ToString(); lblId.Text = objCustomer.CustomerId.ToString(); txtCustomerName.Value = objCustomer.CustomerName; txtCustomerCategory.Value = objCustomer.CustomerCategoryId.ToString(); SetIndex(salesPersonDropDownList, objCustomer.SalesPersonId.ToString()); countryDropDownList.SelectedIndex = tempAddress.CountryId; chkIsActive.Checked = objCustomer.IsActive; txtCreditLimit.Value = objCustomer.CreditLimit.ToString(); txtAddressLine1.Value = tempAddress.AddressLine1; txtAddressLine2.Value = tempAddress.AddressLine2; txtCity.Value = tempAddress.City; txtZipCode.Value = tempAddress.ZipCode; txtPhoneNo.Value = tempAddress.Phone; txtMobile.Value = tempAddress.Mobile; txtEmail.Value = tempAddress.Email; txtWeb.Value = tempAddress.Web; } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { bool chk = false; Supplier aSupply = new Supplier(); List<Supplier> aSuppierList = aSupply.GetAllSupplier(_company.CompanyId); long id; Supplier newSupply = new Supplier(); newSupply.SupplierName = txtSupplierName.Value; newSupply.IsActive = true; newSupply.CompanyId = _company.CompanyId; newSupply.UpdateBy = user.UserId; newSupply.UpdateDate = DateTime.Now; newSupply.TotalDebit = decimal.Parse(txtTotalDebit.Value); newSupply.TotalCredit = decimal.Parse(txtTotalCredit.Value); Addresses address = new Addresses(); address.SourceType = "Supplier"; address.AddressType = "Main Address"; address.AddressLine1 = txtAddressLine1.Value; address.AddressLine2 = txtAddressLine2.Value; address.CountryId = int.Parse(countryDropDownList.SelectedIndex.ToString()); address.City = txtCity.Value; address.Email = txtEmail.Value; address.Phone = txtPhone.Value; address.Web = txtWeb.Value; address.Mobile = txtMobile.Value; address.ZipCode = txtZipCode.Value; address.CompanyId = _company.CompanyId; if (lblId.Text == "" || lblId.Text == "0") { newSupply.SupplierId = new Supplier().GetMaxSupplierID() + 1; address.SourceId = newSupply.SupplierId; address.AddressId = new Addresses().GetMaxAddressId() + 1; int chk1 = newSupply.InsertSupplier(); int chk2 = address.InsertAddresses(); if (chk1 > 0 && chk2 > 0) { Session["savedSupplicerMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting supplier information,please check the input data again. Don't use special character in Debit or Credit Section . Use the amount number there."); } } else { address.AddressId = long.Parse(addlblId.Text); newSupply.SupplierId = int.Parse(lblId.Text); address.SourceId = newSupply.SupplierId; int chk1 = newSupply.UpdateSupplier(); int chk2 = address.UpdateAddresses(); if(chk1>0&&chk2>0) Response.Redirect("SupplierList.aspx"); } } catch (Exception exp) { Alert.Show(exp.Message); } }
protected void Page_Load(object sender, EventArgs e) { _company = (Company)Session["Company"]; user = (Users)Session["user"]; this.LoadCountryDropDownList(); if (Session["savedSupplicerMessage"] != null) { string msg = Session["savedSupplicerMessage"].ToString(); Alert.Show(msg); Session["savedSupplicerMessage"] = null; } if (!isValidSession()) { string str = Request.QueryString.ToString(); if (str == string.Empty) { Response.Redirect("LogIn.aspx?refPage=index.aspx"); } else { Response.Redirect("LogIn.aspx?refPage=index.aspx?"+str); } } if (!IsPostBack) { if (Request.QueryString["id"] != null) { string id = Request.QueryString["id"].ToString(); Supplier tempSupplier= new Supplier().GetSupplierBySupplierId(int.Parse(id),_company.CompanyId); if (tempSupplier != null || tempSupplier.SupplierId != 0) { List<Addresses> addressList = new Addresses().GetAllAddresses(_company.CompanyId); Addresses tempAddress = new Addresses(); foreach (Addresses address in addressList) { if (address.SourceType == "Supplier" && address.SourceId == int.Parse(id)) { tempAddress = address; break; } } lblId.Text = id; addlblId.Text = tempAddress.AddressId.ToString(); txtSupplierName.Value = tempSupplier.SupplierName; txtAddressLine1.Value = tempAddress.AddressLine1; txtAddressLine2.Value = tempAddress.AddressLine2; txtCity.Value = tempAddress.City; txtZipCode.Value = tempAddress.ZipCode; txtEmail.Value = tempAddress.Email; txtPhone.Value = tempAddress.Phone; txtMobile.Value = tempAddress.Mobile; txtWeb.Value = tempAddress.Web; txtTotalCredit.Value = tempSupplier.TotalCredit.ToString(); txtTotalDebit.Value = tempSupplier.TotalDebit.ToString(); chkIsActive.Checked = tempSupplier.IsActive; countryDropDownList.SelectedIndex = tempAddress.CountryId; } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { bool chk = false; Employee aEmployee = new Employee(); Addresses aAddresses=new Addresses(); List<Employee> employeeListC =aEmployee.GetAllEmployee(_company.CompanyId); foreach (Employee anEmployee in employeeListC) { if (anEmployee.EmployeeCode == txtEmployeeCode.Value) { Session["empMessage"] = "Employee Code is exist! Try Again"; chk = true; break; } } if (chk == true) { Response.Redirect(Request.RawUrl); } Employee tempEmployee = new Employee(); int id; if (employeeListC.Count > 0) { tempEmployee = (employeeListC[employeeListC.Count - 1]); id= tempEmployee.EmployeeId + 1; } else { id = 0; } aEmployee.EmployeeId = id; aEmployee.EmployeeCode = txtEmployeeCode.Value; aEmployee.EmployeeName = txtEmployeeName.Value; aEmployee.DOB = RadDatePicker1.SelectedDate.ToString(); aEmployee.JoinDate = JoinRadDatePicker.SelectedDate.ToString(); aEmployee.DesignationId = int.Parse(designationDropDownList.SelectedItem.ToString()); aEmployee.DepartmentId = int.Parse(departmentDropDownList.SelectedItem.ToString()); aAddresses.SourceId = id; aEmployee.Address = "Main Address"; aAddresses.SourceType = "Employee"; aAddresses.AddressLine1 = txtAddressLine1.Value; aAddresses.AddressLine2 = txtAddressLine2.Value; aAddresses.AddressType = "Main Address"; aAddresses.CountryId = int.Parse(countryDropDownList.SelectedIndex.ToString()); aAddresses.City = txtCity.Value; aAddresses.ZipCode = txtZipCode.Value; aAddresses.Email = txtEmail.Value; aAddresses.CompanyId = _company.CompanyId; aEmployee.CompanyId = _company.CompanyId; aEmployee.IsActive = true; aEmployee.UpdateBy = user.UserId; aEmployee.UpdateDate = DateTime.Now; int chkEmployee = aEmployee.InsertEmployee(); int chkAddress = aAddresses.InsertAddresses(); if (chkAddress > 0 && chkEmployee > 0) { Session["empMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting employee information"); } } catch (Exception exp) { Alert.Show(exp.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (txtCompanyName.Value == string.Empty) { Alert.Show("Please enter the company name."); txtCompanyName.Focus(); return; } Company newCompany = new Company(); newCompany.CompanyName = txtCompanyName.Value; newCompany.Address = ""; newCompany.Phone = ""; newCompany.Email = ""; newCompany.Web = ""; newCompany.LogoPath = txtLogoPath.Value; // newCompany.UpdateBy = user.UserId; newCompany.UpdateBy = _user.UserId; newCompany.UpdateDate = DateTime.Now; newCompany.IsActive = chkIsActive.Checked; Addresses address = new Addresses(); address.SourceType = "Company"; address.AddressType = "Main Address"; address.AddressLine1 = txtAddressLine1.Value; address.AddressLine2 = txtAddressLine2.Value; address.CountryId = countryDropDownList.SelectedIndex; address.City = txtCity.Value; address.ZipCode = txtZipCode.Value; address.Phone = txtPhoneNo.Value; address.Mobile = txtPhoneNo.Value; address.Email = txtEmail.Value; address.Web = txtWeb.Value; address.CompanyId = _user.CompanyId; if (lblId.Text == "" || lblId.Text == "0") { newCompany.CompanyId = new Company().GetMaxCompanyId() + 1; address.SourceId = newCompany.CompanyId; address.AddressId = new Addresses().GetMaxAddressId() + 1; int success = newCompany.InsertCompany(); address.InsertAddresses(); if (success > 0) { Alert.Show("Saved Company Information Successfully!"); this.LoadAllCompany(); this.Clear(); } else { Alert.Show("Error occured !"); } } else { newCompany.CompanyId = int.Parse(lblId.Text); address.SourceId = newCompany.CompanyId; address.AddressId = long.Parse(addlblId.Text); int chk1 = newCompany.UpdateCompany(); int chk2 = address.UpdateAddresses(); if (chk1 > 0||chk2>0) { Response.Redirect("CompanyList.aspx", true); } } } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { Designation newDesignation = new Designation(); bool chk = false; Employee aEmployee = new Employee(); Addresses aAddresses=new Addresses(); List<Employee> employeeListC =aEmployee.GetAllEmployee(_company.CompanyId); if (lblId.Text == "" || lblId.Text == "0") foreach (Employee anEmployee in employeeListC) { if (anEmployee.EmployeeCode == txtEmployeeCode.Value) { Session["empMessage"] = "Employee Code is exist! Try Again"; chk = true; break; } } if (chk == true) { Response.Redirect(Request.RawUrl); } Employee tempEmployee = new Employee(); aEmployee.EmployeeCode = txtEmployeeCode.Value; aEmployee.EmployeeName = txtEmployeeName.Value; aEmployee.DOB = RadDatePicker1.SelectedDate.ToString(); aEmployee.JoinDate = JoinRadDatePicker.SelectedDate.ToString(); aEmployee.DepartmentId = int.Parse(departmentDropDownList.SelectedIndex>-1?departmentDropDownList.SelectedItem.Value:"0"); aEmployee.DesignationId = int.Parse(designationDropDownList.SelectedItem.Value); aEmployee.Address = "Main Address"; aAddresses.SourceType = "Employee"; aAddresses.AddressLine1 = txtAddressLine1.Value; aAddresses.AddressLine2 = txtAddressLine2.Value; aAddresses.AddressType = "Main Address"; aAddresses.CountryId = int.Parse(countryDropDownList.SelectedIndex.ToString()); aAddresses.City = txtCity.Value; aAddresses.ZipCode = txtZipCode.Value; aAddresses.Email = txtEmail.Value; aAddresses.Web = ""; aAddresses.Phone = txtPhoneNo.Value; aAddresses.Mobile = txtMobile.Value; aAddresses.CompanyId = _company.CompanyId; aEmployee.CompanyId = _company.CompanyId; aEmployee.IsActive = true; aEmployee.UpdateBy = user.UserId; aEmployee.UpdateDate = DateTime.Now; if (lblId.Text == "" || lblId.Text == "0") { aEmployee.EmployeeId = new Employee().GetMaxEmployeeId() + 1; aAddresses.SourceId = aEmployee.EmployeeId; aAddresses.AddressId = new Addresses().GetMaxAddressId() + 1; int chkEmployee = aEmployee.InsertEmployee(); int chkAddress = aAddresses.InsertAddresses(); if (chkAddress > 0 && chkEmployee > 0) { Session["empMessage"] = "Saved Successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error occured while inserting employee information"); } } else { aEmployee.EmployeeId = int.Parse(lblId.Text); aAddresses.SourceId = aEmployee.EmployeeId; aAddresses.AddressId = long.Parse(addlblId.Text); int chk3= aEmployee.UpdateEmployee(); int chk1=aAddresses.UpdateAddresses(); if(chk3>0&&chk1>0) Response.Redirect("EmployeeList.aspx",true); } } catch (Exception exp) { Alert.Show(exp.Message); } }
private void LoadEmployeeListTable() { try { Addresses tempAddres = new Addresses(); Designation tempDesignation = new Designation(); Department tempDepartment = new Department(); Employee objEmployee = new Employee(); List<Employee> objEmployeeList = objEmployee.GetAllEmployee(_company.CompanyId); foreach (Employee employee in objEmployeeList) { List<Addresses> objAddressList = tempAddres.GetAllAddresses(_company.CompanyId); Designation aDesignation = tempDesignation.GetDesignationByDesignationId(employee.DesignationId,_company.CompanyId); Department aDepartment = tempDepartment.GetDepartmentByDepartmentId(employee.DepartmentId, _company.CompanyId); employee.DepartmentName = aDepartment.DepartmentName; employee.DesignationName = aDesignation.Designation; employee.DOB = DateTime.Parse(employee.DOB).ToShortDateString(); employee.JoinDate = DateTime.Parse(employee.JoinDate).ToShortDateString(); List<string> countrList = Country.CountryList(); foreach (Addresses anAddresses in objAddressList) { if (anAddresses.SourceType == "Employee" && anAddresses.SourceId == employee.EmployeeId) { employee.AddressLine1 = anAddresses.AddressLine1; employee.AddressLine2 = anAddresses.AddressLine2; employee.City = anAddresses.City; employee.ZipCode = anAddresses.ZipCode; employee.Phone = anAddresses.Phone; employee.Mobile = anAddresses.Mobile; employee.Email = anAddresses.Email; employee.CountryName = countrList[anAddresses.CountryId]; break; } } RadGrid1.DataSource = objEmployeeList; RadGrid1.Rebind(); } } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void btnShippingInformationSave_Click(object sender, EventArgs e) { try { Addresses shippingAddress = new Addresses(); List<Addresses> addressList = shippingAddress.GetAllAddresses(_company.CompanyId); Addresses tempAddress = addressList[addressList.Count - 1]; long id = tempAddress.AddressId + 1; shippingAddress.AddressId = id; shippingAddress.SourceId = user.UserId; shippingAddress.SourceType = "Company"; shippingAddress.AddressType = "Shipping Address"; shippingAddress.AddressLine1 = txtShippingaddressLine1.Value; shippingAddress.AddressLine2 = txtShippingaddressLine2.Value; shippingAddress.City = txtShippingCity.Value; shippingAddress.ZipCode = txtShippingZipCode.Value; shippingAddress.CountryId = int.Parse(shippingCountryDropDownList.SelectedIndex.ToString()); shippingAddress.Phone = txtShippingPhone.Value; shippingAddress.Mobile = txtShippingMobile.Value; shippingAddress.Email = txtShippingEmail.Value; shippingAddress.Web = txtShippingWeb.Value; shippingAddress.CompanyId = _company.CompanyId; int save = shippingAddress.InsertAddresses(); if (save > 0) { Session["savedAddressMessage"] = "Address saved successfully"; Response.Redirect(Request.RawUrl); } else { Alert.Show("Error Occured while inserting a new user"); } } catch (Exception exp) { Alert.Show(exp.Message); } }
private void LoadCustomerTable() { try { Customer objCustomer = new Customer(); objCustomerList = objCustomer.GetAllCustomer(_company.CompanyId); if (objCustomerList.Count == 0) { objCustomerList.Add(new Customer()); } foreach (Customer objCst in objCustomerList) { List<string> countryList = Country.CountryList(); List<Addresses> addressList =new Addresses().GetAllAddresses(_company.CompanyId); foreach (Addresses address in addressList) { if (address.SourceType == "Customer" && address.SourceId == objCst.CustomerId) { objCst.AddressId = address.AddressId; objCst.AddressLine1 = address.AddressLine1; objCst.AddressLine2 = address.AddressLine2; objCst.AddressType = address.AddressType; objCst.City = address.City; objCst.ZipCode = address.ZipCode; objCst.Phone = address.Phone; objCst.Mobile = address.Mobile; objCst.Email = address.Email; objCst.Web = address.Web; objCst.CountryName = countryList[address.CountryId]; break; } } } RadGrid1.DataSource = objCustomerList; RadGrid1.Rebind(); } catch (Exception ex) { Alert.Show(ex.Message); } }