/// <summary> /// Edit function /// </summary> public void EditFunction() { try { StandardRateInfo infoStandardRate = new StandardRateInfo(); StandardRateSP spStandardRate = new StandardRateSP(); infoStandardRate.StandardRateId = decStandardRate; infoStandardRate.ApplicableFrom = Convert.ToDateTime(txtFromDate.Text.ToString()); infoStandardRate.ApplicableTo = Convert.ToDateTime(txtToDate.Text.ToString()); infoStandardRate.ProductId = decProduct; infoStandardRate.UnitId = decUnitId; infoStandardRate.BatchId = Convert.ToDecimal(cmbBatch.SelectedValue); infoStandardRate.Rate = Convert.ToDecimal(txtRate.Text.ToString()); infoStandardRate.Extra1 = string.Empty; infoStandardRate.Extra2 = string.Empty; if (spStandardRate.StandardrateCheckExistence(decStandardRateId, Convert.ToDateTime(txtFromDate.Text.ToString()), Convert.ToDateTime(txtToDate.Text.ToString()), decProduct, infoStandardRate.BatchId) == false) { spStandardRate.StandardRateEdit(infoStandardRate); Messages.UpdatedMessage(); GridFill(decProduct); Clear(); } else { Messages.InformationMessage("Standard rate already exist for selected product and dates"); } } catch (Exception ex) { MessageBox.Show("SRP6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Update values in StandardRate Table /// </summary> /// <param name="standardrateinfo"></param> public void StandardRateEdit(StandardRateInfo standardrateinfo) { try { spStandaredRate.StandardRateEdit(standardrateinfo); } catch (Exception ex) { MessageBox.Show("AL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from StandardRate table based on the parameter /// </summary> /// <param name="standardRateId"></param> /// <returns></returns> public StandardRateInfo StandardRateView(decimal standardRateId) { StandardRateInfo standardrateinfo = new StandardRateInfo(); try { standardrateinfo = spStandaredRate.StandardRateView(standardRateId); } catch (Exception ex) { MessageBox.Show("AL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(standardrateinfo); }
/// <summary> /// Function to insert values to StandardRate Table and return the Curresponding row's Id /// </summary> /// <param name="standardrateinfo"></param> /// <returns></returns> public decimal StandardRateAddParticularfields(StandardRateInfo standardrateinfo) { decimal decStandardRateId = 0; try { decStandardRateId = spStandaredRate.StandardRateAddParticularfields(standardrateinfo); } catch (Exception ex) { MessageBox.Show("AL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decStandardRateId); }
/// <summary> /// Function to insert values to StandardRate Table and return the Curresponding row's Id /// </summary> /// <param name="standardrateinfo"></param> /// <returns></returns> public decimal StandardRateAddParticularfields(StandardRateInfo standardrateinfo) { decimal decStandardRateId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("StandardRateAddParticularfields", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@applicableFrom", SqlDbType.DateTime); sprmparam.Value = standardrateinfo.ApplicableFrom; sprmparam = sccmd.Parameters.Add("@applicableTo", SqlDbType.DateTime); sprmparam.Value = standardrateinfo.ApplicableTo; sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal); sprmparam.Value = standardrateinfo.ProductId; sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam.Value = standardrateinfo.UnitId; sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal); sprmparam.Value = standardrateinfo.BatchId; sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal); sprmparam.Value = standardrateinfo.Rate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = standardrateinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = standardrateinfo.Extra2; object ObjStandardRateId = sccmd.ExecuteScalar(); if (ObjStandardRateId != null) { decStandardRateId = Convert.ToDecimal(ObjStandardRateId.ToString()); } else { decStandardRateId = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(decStandardRateId); }
public StandardRateInfo StandardRateView(decimal standardRateId) { StandardRateInfo standardrateinfo = new StandardRateInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("StandardRateView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@standardRateId", SqlDbType.Decimal); sprmparam2.Value = standardRateId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { standardrateinfo.StandardRateId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString()); standardrateinfo.ApplicableFrom = DateTime.Parse(((DbDataReader)sdrreader)[1].ToString()); standardrateinfo.ApplicableTo = DateTime.Parse(((DbDataReader)sdrreader)[2].ToString()); standardrateinfo.ProductId = decimal.Parse(((DbDataReader)sdrreader)[3].ToString()); standardrateinfo.UnitId = decimal.Parse(((DbDataReader)sdrreader)[4].ToString()); standardrateinfo.BatchId = decimal.Parse(((DbDataReader)sdrreader)[5].ToString()); standardrateinfo.Rate = decimal.Parse(((DbDataReader)sdrreader)[6].ToString()); standardrateinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[7].ToString()); standardrateinfo.Extra1 = ((DbDataReader)sdrreader)[8].ToString(); standardrateinfo.Extra2 = ((DbDataReader)sdrreader)[9].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(standardrateinfo); }
public void StandardRateAdd(StandardRateInfo standardrateinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("StandardRateAdd", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam11 = new SqlParameter(); sprmparam11 = sccmd.Parameters.Add("@standardRateId", SqlDbType.Decimal); sprmparam11.Value = standardrateinfo.StandardRateId; sprmparam11 = sccmd.Parameters.Add("@applicableFrom", SqlDbType.DateTime); sprmparam11.Value = standardrateinfo.ApplicableFrom; sprmparam11 = sccmd.Parameters.Add("@applicableTo", SqlDbType.DateTime); sprmparam11.Value = standardrateinfo.ApplicableTo; sprmparam11 = sccmd.Parameters.Add("@productId", SqlDbType.Decimal); sprmparam11.Value = standardrateinfo.ProductId; sprmparam11 = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam11.Value = standardrateinfo.UnitId; sprmparam11 = sccmd.Parameters.Add("@rate", SqlDbType.Decimal); sprmparam11.Value = standardrateinfo.Rate; sprmparam11 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam11.Value = standardrateinfo.ExtraDate; sprmparam11 = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal); sprmparam11.Value = standardrateinfo.BatchId; sprmparam11 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam11.Value = standardrateinfo.Extra1; sprmparam11 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam11.Value = standardrateinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
/// <summary> /// fill Items into the purticular controls for Update or delete /// </summary> public void FillControls() { try { StandardRateInfo infoStandardRate = new StandardRateInfo(); StandardRateSP spStandardRate = new StandardRateSP(); infoStandardRate = spStandardRate.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; ProductSP spProduct = new ProductSP(); ProductInfo infoProduct = new ProductInfo(); infoProduct = spProduct.ProductViewForStandardRate(decProductId); txtProductCode.Text = infoProduct.ProductCode; txtProductName.Text = infoProduct.ProductName; decStandardRateId = infoStandardRate.StandardRateId; UnitInfo infoUnit = new UnitInfo(); UnitSP spUnit = new UnitSP(); infoUnit = spUnit.UnitView(decUnit); txtUnitName.Text = infoUnit.UnitName; txtProductName.ReadOnly = true; txtProductCode.ReadOnly = true; txtUnitName.ReadOnly = true; BatchInfo infoBatch = new BatchInfo(); BatchSP spBatch = new BatchSP(); decBatchId = infoStandardRate.BatchId; infoBatch = spBatch.BatchView(decBatchId); cmbBatch.SelectedValue = infoBatch.BatchId; } catch (Exception ex) { MessageBox.Show("SRP5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// save function /// </summary> public void SaveFunction() { decimal decBatchId = 0; try { StandardRateInfo infoStandardRate = new StandardRateInfo(); standardRateBll BllStandaredRate = new standardRateBll(); infoStandardRate.ApplicableFrom = Convert.ToDateTime(txtFromDate.Text.ToString()); infoStandardRate.ApplicableTo = Convert.ToDateTime(txtToDate.Text.ToString()); infoStandardRate.ProductId = decProduct; infoStandardRate.UnitId = decUnitId; decBatchId = Convert.ToDecimal(cmbBatch.SelectedValue.ToString()); infoStandardRate.BatchId = decBatchId; infoStandardRate.Rate = Convert.ToDecimal(txtRate.Text.ToString()); infoStandardRate.Extra1 = string.Empty; infoStandardRate.Extra2 = string.Empty; if (BllStandaredRate.StandardrateCheckExistence(0, Convert.ToDateTime(txtFromDate.Text.ToString()), Convert.ToDateTime(txtToDate.Text.ToString()), decProduct, decBatchId) == false) { BllStandaredRate.StandardRateAddParticularfields(infoStandardRate); Messages.SavedMessage(); GridFill(decProduct); Clear(); } else { Messages.InformationMessage("Standard rate already exist for selected product,Batch and dates"); Clear(); } } catch (Exception ex) { MessageBox.Show("SRP4:" + 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); } }