/// <summary> /// To get the records to show in the grid /// </summary> /// <param name="search">search criteria</param> /// <returns>matching data</returns> public ActionResult GridData(SearchFilter search) { try { int RecCount = 0; string whoType = (Convert.ToString(Session["WHOTYPE"]) == "") ? Convert.ToString(Session["BeneWHOType"]) : Convert.ToString(Session["WHOTYPE"]); string stateCode = Convert.ToString(Session["UserState"]); string distCode = Convert.ToString(Session["UserDistrict"]); string BeneType = Session["BeneType"].ToString(); var items = _bussProj.Get(search, stateCode, distCode, whoType, BeneType, Session["DashMonth"].ToString(), Session["DashYear"].ToString()); //if (items.Count == 0) return null; var total = (int)Math.Ceiling(RecCount / (float)search.rows); // get page count var jsonData = new { total = total, page = (total < search.page ? 1 : search.page), // set the current page records = items.Count, rows = items, }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Content(ex.InnerException.Message)); } }
private void FormControlsLoad() { _pBuss = new ProjectBusiness(_user); if (_projectId > 0) { try { _project = _pBuss.Get(_projectId); } catch (Exception ex) { MessageBox.Show(ex.Message); } txtName.Text = _project.Name; dtpEndDate.Value = _project.EndDate; dtpStartDate.Value = _project.StartDate; } CustomerBusiness custBuss = new CustomerBusiness(_user); cmbCustomer.DataSource = null; cmbCustomer.DataSource = custBuss.GetAll(); cmbCustomer.DisplayMember = "CompanyName"; cmbCustomer.ValueMember = "ID"; if (_projectId > 0) { cmbCustomer.SelectedValue = _project.Customer.ID; } }
private void miDeleteProject_Click(object sender, EventArgs e) { if (dgvProject.SelectedRows.Count > 0) { int projectId = (int)dgvProject.SelectedRows[0].Cells["ID"].Value; string projectName = (string)dgvProject.SelectedRows[0].Cells["Name"].Value; DialogResult result = MessageBox.Show(string.Format("{0} isimli projeyi silmek istediğinize emin misiniz?", projectName), "Dikkat!", MessageBoxButtons.YesNo); bool removeResult = false; if (result == DialogResult.Yes) { ProjectBusiness projectBuss = new ProjectBusiness(_user); try { removeResult = projectBuss.Remove(projectBuss.Get(projectId)); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show(removeResult ? "Silme işlemi başarıyla gerçekleşti." : "Silme işlemi başarısız!"); } } }
private void RequestEditForm_Load(object sender, EventArgs e) { MainForm mainForm = (MainForm)this.MdiParent; _user = mainForm.GetUser(); _reqTypeBLL = new RequestTypeBusiness(_user); _projectBLL = new ProjectBusiness(_user); Project project = _projectBLL.Get(_projectId); txtProject.Text = project.Name; List <RequestType> reqType = _reqTypeBLL.GetAll(); cmbRequestType.DataSource = null; cmbRequestType.DataSource = reqType; cmbRequestType.ValueMember = "ID"; cmbRequestType.DisplayMember = "Name"; }
public IEnumerable<Project> GetProjects(int indexFirstElement, int numberOfResults) { IReaderLimit<Project> business = new ProjectBusiness(); return business.Get(indexFirstElement, numberOfResults); }
public Project GetProject(int code) { IReader<Project> business = new ProjectBusiness(); return business.Get(code); }
public IEnumerable<Project> GetProjectsByCampusLimited(Campus campus, int indexFirstElement, int numberOfResults) { IReader1Filter<Project, Campus> business = new ProjectBusiness(); return business.Get(campus, indexFirstElement, numberOfResults); }
public IEnumerable<Project> GetProjectsByCampus(Campus campus) { IReader1Filter<Project, Campus> business = new ProjectBusiness(); return business.Get(campus); }
public IEnumerable<Project> GetProjects() { IReader<Project> business = new ProjectBusiness(); return business.Get(); }