/// <summary> /// /// </summary> /// <param name="infoAccountGroup"></param> /// <returns></returns> public decimal AccountGroupAddWithIdentity(AccountGroupInfo infoAccountGroup) { decimal decAccountGroupId = 0; try { decAccountGroupId = spAccountGroup.AccountGroupAddWithIdentity(infoAccountGroup); } catch (Exception ex) { MessageBox.Show("AG4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decAccountGroupId; }
/// <summary> /// Function to insert values to account group Table /// </summary> /// <param name="accountgroupinfo"></param> public void AccountGroupAdd(AccountGroupInfo accountgroupinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountGroupAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@accountGroupId", SqlDbType.Decimal); sprmparam.Value = accountgroupinfo.AccountGroupId; sprmparam = sccmd.Parameters.Add("@accountGroupName", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.AccountGroupName; sprmparam = sccmd.Parameters.Add("@groupUnder", SqlDbType.Decimal); sprmparam.Value = accountgroupinfo.GroupUnder; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Narration; sprmparam = sccmd.Parameters.Add("@isDefault", SqlDbType.Bit); sprmparam.Value = accountgroupinfo.IsDefault; sprmparam = sccmd.Parameters.Add("@nature", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Nature; sprmparam = sccmd.Parameters.Add("@affectGrossProfit", SqlDbType.Bit); sprmparam.Value = accountgroupinfo.AffectGrossProfit; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = accountgroupinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// /// </summary> /// <param name="decAccountGroupId"></param> /// <returns></returns> public AccountGroupInfo AccountGroupViewForUpdate(decimal decAccountGroupId) { AccountGroupInfo AccountGroupinfo = new AccountGroupInfo(); try { AccountGroupinfo = spAccountGroup.AccountGroupViewForUpdate(decAccountGroupId); } catch (Exception ex) { MessageBox.Show("AG7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return AccountGroupinfo; }
/// <summary> /// /// </summary> /// <param name="AccountGroupId"></param> /// <returns></returns> public AccountGroupInfo AccountGroupView(decimal AccountGroupId) { AccountGroupInfo infoAccountGroup = new AccountGroupInfo(); try { infoAccountGroup = spAccountGroup.AccountGroupView(AccountGroupId); } catch (Exception ex) { MessageBox.Show("AG10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoAccountGroup; }
/// <summary> /// /// </summary> /// <param name="infoAccountGroup"></param> /// <returns></returns> public bool AccountGroupUpdate(AccountGroupInfo infoAccountGroup) { bool isEdit = false; try { isEdit = spAccountGroup.AccountGroupUpdate(infoAccountGroup); } catch (Exception ex) { MessageBox.Show("AG5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isEdit; }
/// <summary> /// Function to insert values to account group table and return the Curresponding row's Id /// </summary> /// <param name="accountgroupinfo"></param> /// <returns></returns> public decimal AccountGroupAddWithIdentity(AccountGroupInfo accountgroupinfo) { decimal decAccountGroupId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountGroupAddWithIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@accountGroupName", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.AccountGroupName; sprmparam = sccmd.Parameters.Add("@groupUnder", SqlDbType.Decimal); sprmparam.Value = accountgroupinfo.GroupUnder; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Narration; sprmparam = sccmd.Parameters.Add("@isDefault", SqlDbType.Bit); sprmparam.Value = accountgroupinfo.IsDefault; sprmparam = sccmd.Parameters.Add("@nature", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Nature; sprmparam = sccmd.Parameters.Add("@affectGrossProfit", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.AffectGrossProfit; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra2; object obj = sccmd.ExecuteScalar(); if (obj != null) { decAccountGroupId = decimal.Parse(obj.ToString()); } else { decAccountGroupId = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decAccountGroupId; }
/// <summary> /// Function to get particular values from account group table based on the parameter for update /// </summary> /// <param name="decAccountGroupId"></param> /// <returns></returns> public AccountGroupInfo AccountGroupViewForUpdate(decimal decAccountGroupId) { AccountGroupInfo accountgroupinfo = new AccountGroupInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountGroupViewForUpdate", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; sccmd.Parameters.Add("@accountGroupId", SqlDbType.Decimal).Value = decAccountGroupId; sqldr = sccmd.ExecuteReader(); while (sqldr.Read()) { accountgroupinfo.AccountGroupId = decimal.Parse(sqldr["accountGroupId"].ToString()); accountgroupinfo.AccountGroupName = sqldr["accountGroupName"].ToString(); accountgroupinfo.GroupUnder = decimal.Parse(sqldr["groupUnder"].ToString()); accountgroupinfo.Narration = sqldr["narration"].ToString(); accountgroupinfo.IsDefault = bool.Parse(sqldr["isDefault"].ToString()); accountgroupinfo.Nature = sqldr["nature"].ToString(); accountgroupinfo.AffectGrossProfit = sqldr["affectGrossProfit"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqldr.Close(); sqlcon.Close(); } return accountgroupinfo; }
/// <summary> /// Function to get particular values from account group table based on the parameter /// </summary> /// <param name="accountGroupId"></param> /// <returns></returns> public AccountGroupInfo AccountGroupView(decimal accountGroupId) { AccountGroupInfo accountgroupinfo = new AccountGroupInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountGroupView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@accountGroupId", SqlDbType.Decimal); sprmparam.Value = accountGroupId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { accountgroupinfo.AccountGroupId = decimal.Parse(sdrreader[0].ToString()); accountgroupinfo.AccountGroupName = sdrreader[1].ToString(); accountgroupinfo.GroupUnder = decimal.Parse(sdrreader[2].ToString()); accountgroupinfo.Narration = sdrreader[3].ToString(); accountgroupinfo.IsDefault = bool.Parse(sdrreader[4].ToString()); accountgroupinfo.Nature = sdrreader[5].ToString(); accountgroupinfo.AffectGrossProfit = sdrreader[6].ToString(); accountgroupinfo.ExtraDate = DateTime.Parse(sdrreader[7].ToString()); accountgroupinfo.Extra1 = sdrreader[8].ToString(); accountgroupinfo.Extra2 = sdrreader[9].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return accountgroupinfo; }
/// <summary> /// Account group Update based on the condition /// </summary> /// <param name="accountgroupinfo"></param> /// <returns></returns> public bool AccountGroupUpdate(AccountGroupInfo accountgroupinfo) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountGroupEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@accountGroupId", SqlDbType.Decimal); sprmparam.Value = accountgroupinfo.AccountGroupId; sprmparam = sccmd.Parameters.Add("@accountGroupName", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.AccountGroupName; sprmparam = sccmd.Parameters.Add("@groupUnder", SqlDbType.Decimal); sprmparam.Value = accountgroupinfo.GroupUnder; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Narration; sprmparam = sccmd.Parameters.Add("@isDefault", SqlDbType.Bit); sprmparam.Value = accountgroupinfo.IsDefault; sprmparam = sccmd.Parameters.Add("@nature", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Nature; sprmparam = sccmd.Parameters.Add("@affectGrossProfit", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.AffectGrossProfit; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = accountgroupinfo.Extra2; int inAffectedRows = sccmd.ExecuteNonQuery(); if (inAffectedRows > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }