/// <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();
}