public List <Entities.AccountHead> GetAllAccountHeads()
{
var accountHeads = new List <Entities.AccountHead>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllAccountHeads))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var accountHead = new Entities.AccountHead
{
AccountHeadId = DRE.GetNullableInt32(reader, "account_head_id", 0),
AccountHeadName = DRE.GetNullableString(reader, "account_head_name", null)
};
accountHeads.Add(accountHead);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(accountHeads);
}
/// <summary>
///
/// </summary>
/// <param name="accountHead"></param>
/// <returns></returns>
private Int32 UpdateAccountHead(Entities.AccountHead accountHead)
{
var accountHeadId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.UpdatetAccountHead))
{
database.AddInParameter(dbCommand, "@account_head_id", DbType.Int32, accountHead.AccountHeadId);
database.AddInParameter(dbCommand, "@account_head_name", DbType.String, accountHead.AccountHeadName);
database.AddInParameter(dbCommand, "@modified_by", DbType.Int32, accountHead.ModifiedBy);
database.AddInParameter(dbCommand, "@modified_by_ip", DbType.String, accountHead.ModifiedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
accountHeadId = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
accountHeadId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(accountHeadId);
}
/// <summary>
///
/// </summary>
/// <param name="accountHead"></param>
/// <returns></returns>
private bool DeleteAccountHead(Entities.AccountHead accountHead)
{
var isDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteAccountHead))
{
database.AddInParameter(dbCommand, "@account_head_id", DbType.Int32, accountHead.AccountHeadId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, accountHead.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, accountHead.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(isDeleted);
}
/// <summary>
///
/// </summary>
/// <param name="drugGroup"></param>
/// <returns></returns>
public Int32 SaveAccountHead(Entities.AccountHead accountHead)
{
var accountHeadId = 0;
if (accountHead.AccountHeadId == null || accountHead.AccountHeadId == 0)
{
accountHeadId = AddAccountHead(accountHead);
return(accountHeadId);
}
else
{
if (accountHead.IsDeleted == true)
{
var result = DeleteAccountHead(accountHead);
if (result == true)
{
accountHeadId = 1;
}
}
else
{
accountHeadId = UpdateAccountHead(accountHead);
}
}
return(accountHeadId);
}
/// <summary>
///
/// </summary>
/// <param name="accountHeadName></param>
/// <returns></returns>
public Entities.AccountHead GetAccountHeadByName(string accountHeadName)
{
var accountHeadDetails = new Entities.AccountHead();
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAccountHeadById))
{
database.AddInParameter(dbCommand, "@account_head_name", DbType.String, accountHeadName);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var accountHead = new Entities.AccountHead
{
AccountHeadId = DRE.GetNullableInt32(reader, "account_head_id", 0),
AccountHeadName = DRE.GetNullableString(reader, "account_head_name", null)
};
accountHeadDetails = accountHead;
}
}
}
return(accountHeadDetails);
}
public Int32 SaveAccountHead(Entities.AccountHead accountHead)
{
return(_accountHead.SaveAccountHead(accountHead));
}
