/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listObj = BllPayHead.PayHeadViewAllForPayHeadReport(cmbPayHead.Text, cmbType.Text);
dgvPayHead.DataSource = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("PHR:2 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill PayHead combobox
/// </summary>
public void PayHeadComboFill()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listPayHead = BllPayHead.PayHeadViewAll();
DataRow dr = listPayHead[0].NewRow();
dr[2] = "All";
listPayHead[0].Rows.InsertAt(dr, 0);
cmbPayHead.DataSource = listPayHead[0];
cmbPayHead.ValueMember = "payHeadId";
cmbPayHead.DisplayMember = "payHeadName";
}
catch (Exception ex)
{
MessageBox.Show("PHR:1 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Print' button click to print
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvPayHead.RowCount > 0)
{
DataSet ds = new DataSet();
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listObj = BllPayHead.PayHeadViewAllForPayHeadReport(cmbPayHead.Text, cmbType.Text);
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
List<DataTable> listObjCompany = bllCompanyCreation.CompanyViewDataTable(1);
frmReport frmreport = new frmReport();
frmreport.MdiParent = formMDI.MDIObj;
ds.Tables.Add(listObj[0]);
ds.Tables.Add(listObjCompany[0]);
frmreport.PayHeadReport(ds);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("PHR:7 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill PayHead combobox
/// </summary>
public void GridPayHeadFill()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllPayHead.PayHeadViewAll();
DataRow drrow = listObj[0].NewRow();
listObj[0].Rows.InsertAt(drrow, 0);
dgvcmbPayHead.DataSource = listObj[0];
dgvcmbPayHead.ValueMember = "payHeadId";
dgvcmbPayHead.DisplayMember = "payHeadName";
}
catch (Exception ex)
{
MessageBox.Show("SPC6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Fills PayHead in datagridview on cell begin edit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvSalaryPackage_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listObj = new List<DataTable>();
if (dgvSalaryPackage.CurrentCell.ColumnIndex == dgvSalaryPackage.Columns["dgvcmbPayHead"].Index)
{
listObj = BllPayHead.PayHeadViewAll();
if (listObj[0].Rows.Count < 2)
{
DataRow dr = listObj[0].NewRow();
dr[0] = 0;
dr[1] = 0;
listObj[0].Rows.InsertAt(dr, 0);
}
if (dgvSalaryPackage.RowCount > 1)
{
int inGridRowCount = dgvSalaryPackage.RowCount;
for (int inI = 0; inI < inGridRowCount - 1; inI++)
{
if (inI != e.RowIndex)
{
int inTableRowcount = listObj[0].Rows.Count;
for (int inJ = 0; inJ < inTableRowcount; inJ++)
{
if (dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty)
{
if (listObj[0].Rows[inJ]["payHeadId"].ToString() == dgvSalaryPackage.Rows[inI].Cells["dgvcmbPayHead"].Value.ToString())
{
listObj[0].Rows.RemoveAt(inJ);
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvccPayHead = (DataGridViewComboBoxCell)dgvSalaryPackage[dgvSalaryPackage.Columns["dgvcmbPayHead"].Index, e.RowIndex];
dgvccPayHead.DataSource = listObj[0];
dgvccPayHead.ValueMember = "payHeadId";
dgvccPayHead.DisplayMember = "payHeadName";
}
}
catch (Exception ex)
{
MessageBox.Show("SPC24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Delete
/// </summary>
public void DeleteFunction()
{
try
{
PayHeadInfo infoPayhead = new PayHeadInfo();
PayHeadBll BllPayHead = new PayHeadBll();
if (BllPayHead.PayHeadDeleteVoucherTypeCheckReference(decPayHeadId))
{
Messages.ReferenceExistsMessage();
txtPayheadName.Focus();
}
else
{
Messages.DeletedMessage();
Clear();
}
GridFill();
}
catch (Exception ex)
{
MessageBox.Show("PH6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Fills controls for updation on cell double click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPayhead_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
PayHeadInfo infoPayhead = new PayHeadInfo();
PayHeadBll BllPayHead = new PayHeadBll();
infoPayhead = BllPayHead.PayHeadView(Convert.ToDecimal(dgvPayhead.CurrentRow.Cells["dgvtxtPayheadId"].Value.ToString()));
txtPayheadName.Text = infoPayhead.PayHeadName;
cmbPayheadType.Text = infoPayhead.Type;
strPayheadType = cmbPayheadType.Text;
txtPayheadNarration.Text = infoPayhead.Narration;
btnPayheadSave.Text = "Update";
btnPayheadDelete.Enabled = true;
strPayHeadName = infoPayhead.PayHeadName;
decPayHeadId = Convert.ToDecimal(dgvPayhead.CurrentRow.Cells["dgvtxtPayheadId"].Value.ToString());
if (BllPayHead.payheadTypeCheckeferences(infoPayhead.PayHeadId, txtPayheadName.Text, cmbPayheadType.Text, txtPayheadNarration.Text))
{
if (e.RowIndex != -1)
{
cmbPayheadType.Enabled = true;
}
}
else
{
cmbPayheadType.Enabled = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("PH14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for save
/// </summary>
public void SaveFunction()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
PayHeadInfo infoPayhead = new PayHeadInfo();
infoPayhead.PayHeadName = txtPayheadName.Text.Trim();
infoPayhead.Type = cmbPayheadType.SelectedItem.ToString();
infoPayhead.Narration = txtPayheadNarration.Text.Trim();
infoPayhead.ExtraDate = DateTime.Parse(DateTime.Now.ToString());
infoPayhead.Extra1 = string.Empty;
infoPayhead.Extra2 = string.Empty;
if (btnPayheadSave.Text == "Save")
{
if (BllPayHead.PayheadCheckExistence(txtPayheadName.Text.Trim(), 0) == false)
{
Messages.SavedMessage();
BllPayHead.PayHeadAdd(infoPayhead);
GridFill();
Clear();
}
else
{
Messages.InformationMessage("Payhead name already exist");
txtPayheadName.Focus();
}
}
}
catch (Exception ex)
{
MessageBox.Show("PH1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
List<DataTable> listPayhead = new List<DataTable>();
listPayhead = BllPayHead.PayHeadSearch(txtPayheadSearch.Text.Trim());
dgvPayhead.DataSource = listPayhead[0];
}
catch (Exception ex)
{
MessageBox.Show("PH4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
PayHeadBll BllPayHead = new PayHeadBll();
PayHeadInfo infoPayhead = new PayHeadInfo();
infoPayhead.PayHeadId = decPayHeadId;
infoPayhead.PayHeadName = txtPayheadName.Text.Trim();
infoPayhead.Type = cmbPayheadType.Text;
infoPayhead.Narration = txtPayheadNarration.Text.Trim();
if (BllPayHead.PayheadCheckExistence(txtPayheadName.Text.Trim(), infoPayhead.PayHeadId) == false)
{
BllPayHead.PayHeadEdit(infoPayhead);
GridFill();
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage("Payhead name already exist");
txtPayheadName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("PH2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
