/// <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;
}
