/// <summary>
/// Function to add new standard rate for the purticular product
/// </summary>
/// <param name="decProductId"></param>
/// <param name="frmStandardRate"></param>
public void CallFromStandardRate(decimal decProductId, frmStandardRate frmStandardRate)
{
try
{
base.Show();
StandardrateObj = frmStandardRate;
StandardrateObj.Enabled = false;
ProductInfo infoProduct = new ProductInfo();
ProductCreationBll BllProductCreation = new ProductCreationBll();
UnitBll bllUnit = new UnitBll();
UnitInfo infoUnit = new UnitInfo();
infoProduct = BllProductCreation.ProductViewForStandardRate(decProductId);
txtProductCode.Text = infoProduct.ProductCode;
txtProductName.Text = infoProduct.ProductName;
decProduct = infoProduct.ProductId;
infoUnit = bllUnit.unitVieWForStandardRate(decProductId);
decUnitId = infoUnit.UnitId;
txtUnitName.Text = infoUnit.UnitName;
txtProductName.ReadOnly = true;
txtProductCode.ReadOnly = true;
txtUnitName.ReadOnly = true;
BatchUnderProductComboFill(decProductId);
GridFill(decProductId);
}
catch (Exception ex)
{
MessageBox.Show("SRP2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// update function
/// </summary>
public void EditFunction()
{
try
{
UnitBll bllUnit = new UnitBll();
UnitInfo infoUnit = new UnitInfo();
infoUnit.UnitName = txtUnitname.Text.Trim();
infoUnit.noOfDecimalplaces = Convert.ToDecimal(txtDecimalPlaces.Text.ToString());
infoUnit.Narration = txtNarration.Text.Trim();
infoUnit.formalName = txtFormalName.Text.Trim();
infoUnit.UnitId = decUnitid;
infoUnit.Extra1 = string.Empty;
infoUnit.Extra2 = string.Empty;
if (CheckExistenceOfUnitName() == false)
{
if (bllUnit.UnitEdit(infoUnit))
{
Messages.UpdatedMessage();
Clear();
}
}
else
{
Messages.InformationMessage("Already exists");
txtUnitname.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("U4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// save function
/// </summary>
public void SaveFunction()
{
try
{
UnitBll bllUnit = new UnitBll();
UnitInfo infoUnit = new UnitInfo();
infoUnit.UnitName = txtUnitname.Text.Trim();
infoUnit.noOfDecimalplaces = Convert.ToDecimal(txtDecimalPlaces.Text.ToString());
infoUnit.Narration = txtNarration.Text.Trim();
infoUnit.formalName = txtFormalName.Text.Trim();
infoUnit.Extra1 = string.Empty;
infoUnit.Extra2 = string.Empty;
infoUnit.ExtraDate = DateTime.Now;
if (bllUnit.UnitCheckExistence(txtUnitname.Text.Trim(), 0) == false)
{
decUnit = bllUnit.UnitAdd(infoUnit);
if (decUnit > 0)
{
Messages.SavedMessage();
GridFill();
Clear();
}
}
else
{
Messages.InformationMessage(" Unit name already exist");
txtUnitname.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("U3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// grid fill function
/// </summary>
public void GridFill()
{
try
{
UnitBll bllUnit = new UnitBll();
List <DataTable> ListObj = new List <DataTable>();
ListObj = bllUnit.UnitSearch(txtUnitSearch.Text.Trim());
dgvUnitSearch.DataSource = ListObj[0];
}
catch (Exception ex)
{
MessageBox.Show("U1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cell begin edit of dgvMultipleUnit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvMultipleUnit_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
UnitBll bllUnit = new UnitBll();
List <DataTable> ListObj = new List <DataTable>();
if (dgvMultipleUnit.CurrentCell.ColumnIndex == dgvMultipleUnit.Columns["dgvcmbmultipleunit"].Index)
{
ListObj = bllUnit.UnitViewAllWithoutPerticularId(decUnitIdExcludeToFillCombo);
if (ListObj[0].Rows.Count > 0)
{
if (dgvMultipleUnit.RowCount > 1)
{
int inGridRowCount = dgvMultipleUnit.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 (dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value != null && dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value.ToString() != "")
{
if (ListObj[0].Rows[inJ]["unitId"].ToString() == dgvMultipleUnit.Rows[inI].Cells["dgvcmbmultipleunit"].Value.ToString())
{
ListObj[0].Rows.RemoveAt(inJ);
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvccProductMultipleUnit = (DataGridViewComboBoxCell)dgvMultipleUnit[dgvMultipleUnit.Columns["dgvcmbmultipleunit"].Index, e.RowIndex];
DataRow drow = ListObj[0].NewRow();
drow["unitName"] = string.Empty;
drow["unitId"] = 0;
ListObj[0].Rows.InsertAt(drow, 0);
dgvccProductMultipleUnit.DataSource = ListObj[0];
dgvccProductMultipleUnit.ValueMember = "unitId";
dgvccProductMultipleUnit.DisplayMember = "unitName";
}
}
}
catch (Exception ex)
{
MessageBox.Show("PMU:29" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cell end edit of dgvMultipleUnit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvMultipleUnit_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvMultipleUnit.Columns[e.ColumnIndex].Name == "dgvcmbmultipleunit")
{
UnitBll bllUnit = new UnitBll();
dgvMultipleUnit.Rows[e.RowIndex].Cells["dgvtxtunitname"].Value = bllUnit.UnitName(Convert.ToDecimal(dgvMultipleUnit.Rows[e.RowIndex].Cells["dgvcmbmultipleunit"].Value));
}
}
catch (Exception ex)
{
MessageBox.Show("PMU:30" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// grid cell double click event for editing purpose
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvUnitSearch_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvUnitSearch.CurrentRow != null)
{
if (dgvUnitSearch.Rows.Count > 0 && e.ColumnIndex > -1)
{
if (dgvUnitSearch.CurrentRow.Cells["dgvtxtUnitId"].Value != null)
{
if (dgvUnitSearch.CurrentRow.Cells["dgvtxtUnitId"].Value.ToString() != string.Empty)
{
if (Convert.ToDecimal(dgvUnitSearch.CurrentRow.Cells["dgvtxtUnitId"].Value) != 1)
{
UnitBll bllUnit = new UnitBll();
UnitInfo infoUnit = new UnitInfo();
decUnitid = decimal.Parse(dgvUnitSearch.CurrentRow.Cells["dgvtxtUnitId"].Value.ToString());
infoUnit = bllUnit.UnitView(decUnitid);
txtFormalName.Text = infoUnit.formalName;
txtDecimalPlaces.Text = infoUnit.noOfDecimalplaces.ToString();
txtNarration.Text = infoUnit.Narration;
txtUnitSearch.Text = string.Empty;
txtUnitname.Text = infoUnit.UnitName;
strUnitName = infoUnit.UnitName;
btnSave.Text = "Update";
txtUnitname.Focus();
btnDelete.Enabled = true;
}
else
{
Messages.InformationMessage("Default unit cannot update or delete");
Clear();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("U14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the unit combobox
/// </summary>
/// <param name="decId"></param>
public void UnitComboFill(decimal decId)
{
try
{
List <DataTable> ListObj = new List <DataTable>();
UnitBll bllUnit = new UnitBll();
ListObj = bllUnit.UnitViewAllWithoutPerticularId(decId);
dgvcmbmultipleunit.DataSource = ListObj[0];
DataRow drow = ListObj[0].NewRow();
drow["unitName"] = string.Empty;
drow["unitId"] = 0;
ListObj[0].Rows.InsertAt(drow, 0);
dgvcmbmultipleunit.DisplayMember = "unitName";
dgvcmbmultipleunit.ValueMember = "unitId";
}
catch (Exception ex)
{
MessageBox.Show("PMU:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// checking references fro delete
/// </summary>
public void DeleteFunction()
{
try
{
UnitBll bllUnit = new UnitBll();
if (bllUnit.UnitDeleteCheck(decUnitid) <= 0)
{
Messages.ReferenceExistsMessage();
}
else
{
Clear();
btnSave.Text = "Save";
Messages.DeletedMessage();
}
}
catch (Exception ex)
{
MessageBox.Show("U7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// fill Items into the purticular controls for Update or delete
/// </summary>
public void FillControls()
{
try
{
StandardRateInfo infoStandardRate = new StandardRateInfo();
standardRateBll BllStandaredRate = new standardRateBll();
infoStandardRate = BllStandaredRate.StandardRateView(decStandardRate);
dtpFromDate.Value = Convert.ToDateTime(infoStandardRate.ApplicableFrom.ToString());
dtpToDate.Value = Convert.ToDateTime(infoStandardRate.ApplicableTo.ToString());
dtpFromDate.Text = infoStandardRate.ApplicableFrom.ToString();
dtpToDate.Text = infoStandardRate.ApplicableTo.ToString();
txtRate.Text = infoStandardRate.Rate.ToString();
decProduct = infoStandardRate.ProductId;
decUnitId = infoStandardRate.UnitId;
ProductCreationBll BllProductCreation = new ProductCreationBll();
ProductInfo infoProduct = new ProductInfo();
infoProduct = BllProductCreation.ProductViewForStandardRate(decProductId);
txtProductCode.Text = infoProduct.ProductCode;
txtProductName.Text = infoProduct.ProductName;
decStandardRateId = infoStandardRate.StandardRateId;
UnitInfo infoUnit = new UnitInfo();
UnitBll bllUnit = new UnitBll();
infoUnit = bllUnit.UnitView(decUnit);
txtUnitName.Text = infoUnit.UnitName;
txtProductName.ReadOnly = true;
txtProductCode.ReadOnly = true;
txtUnitName.ReadOnly = true;
BatchInfo infoBatch = new BatchInfo();
BatchBll BllBatch = new BatchBll();
decBatchId = infoStandardRate.BatchId;
infoBatch = BllBatch.BatchView(decBatchId);
cmbBatch.SelectedValue = infoBatch.BatchId;
}
catch (Exception ex)
{
MessageBox.Show("SRP5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// here checking the unit name if already exists for create new unit
/// </summary>
/// <returns></returns>
public bool CheckExistenceOfUnitName()
{
bool isExist = false;
try
{
UnitBll bllUnit = new UnitBll();
isExist = bllUnit.UnitCheckExistence(txtUnitname.Text.Trim(), 0);
if (isExist)
{
string strUnitNames = txtUnitname.Text.Trim();
if (strUnitNames.ToLower() == strUnitName.ToLower())
{
isExist = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("U2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(isExist);
}
