public bool UnitEdit(UnitInfo infoUnit) { bool isCheck = false; try { isCheck = spUnit.UnitEdit(infoUnit); } catch (Exception ex) { MessageBox.Show("UBLL4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isCheck; }
public decimal UnitAdd(UnitInfo infoUnit) { decimal decIdentity = 0; try { decIdentity = spUnit.UnitAdd(infoUnit); } catch (Exception ex) { MessageBox.Show("UBLL3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decIdentity; }
/// <summary> /// Function for unit VieW For StandardRate based on parameter /// </summary> /// <param name="decProductId"></param> /// <returns></returns> public UnitInfo unitVieWForStandardRate(decimal decProductId) { UnitInfo infoUnit = new UnitInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("unitVieWForStandardRate", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@productId", SqlDbType.Decimal).Value = decProductId; sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoUnit.UnitId = Convert.ToDecimal(sqldr["unitId"].ToString()); infoUnit.UnitName = (sqldr["unitName"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); sqldr.Close(); } return infoUnit; }
/// <summary> /// Function to get particular values from account group table based on the parameter /// </summary> /// <param name="unitId"></param> /// <returns></returns> public UnitInfo UnitView(decimal unitId) { UnitInfo unitinfo = new UnitInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("UnitView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam.Value = unitId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { unitinfo.UnitId = Convert.ToDecimal(sdrreader["unitId"]); unitinfo.UnitName = sdrreader["unitName"].ToString(); unitinfo.Narration = sdrreader["narration"].ToString(); unitinfo.noOfDecimalplaces = Convert.ToDecimal(sdrreader["noOfDecimalplaces"].ToString()); unitinfo.formalName = sdrreader["formalName"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return unitinfo; }
/// <summary> /// Function to Update values in account group Table /// </summary> /// <param name="unitinfo"></param> /// <returns></returns> public bool UnitEdit(UnitInfo unitinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("UnitEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam.Value = unitinfo.UnitId; sprmparam = sccmd.Parameters.Add("@unitName", SqlDbType.VarChar); sprmparam.Value = unitinfo.UnitName; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = unitinfo.Narration; sprmparam = sccmd.Parameters.Add("@noOfDecimalplaces", SqlDbType.Decimal); sprmparam.Value = unitinfo.noOfDecimalplaces; sprmparam = sccmd.Parameters.Add("@formalName", SqlDbType.VarChar); sprmparam.Value = unitinfo.formalName; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = unitinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = unitinfo.Extra2; int inEffectedRow = sccmd.ExecuteNonQuery(); if (inEffectedRow > 0) { return true; } else { return false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return false; } finally { sqlcon.Close(); } }
/// <summary> /// Function to insert values to account group Table /// </summary> /// <param name="unitinfo"></param> /// <returns></returns> public decimal UnitAdd(UnitInfo unitinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("UnitAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@unitName", SqlDbType.VarChar); sprmparam.Value = unitinfo.UnitName; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = unitinfo.Narration; sprmparam = sccmd.Parameters.Add("@noOfDecimalplaces", SqlDbType.Decimal); sprmparam.Value = unitinfo.noOfDecimalplaces; sprmparam = sccmd.Parameters.Add("@formalName", SqlDbType.VarChar); sprmparam.Value = unitinfo.formalName; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = unitinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = unitinfo.Extra2; decIdentity = decimal.Parse(sccmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decIdentity; }
public UnitInfo unitVieWForStandardRate(decimal decProductId) { UnitInfo infoUnit = new UnitInfo(); try { infoUnit = spUnit.unitVieWForStandardRate(decProductId); } catch (Exception ex) { MessageBox.Show("UBLL9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoUnit; }
public UnitInfo UnitViewForPriceListPopUp(decimal decProductId) { UnitInfo infoUnit = new UnitInfo(); try { infoUnit = spUnit.UnitViewForPriceListPopUp(decProductId); } catch (Exception ex) { MessageBox.Show("UBLL7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoUnit; }
public UnitInfo UnitView(decimal unitId) { UnitInfo infoUnit = new UnitInfo(); try { infoUnit = spUnit.UnitView(unitId); } catch (Exception ex) { MessageBox.Show("UBLL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoUnit; }