IList <ALRD_SecurityFormEntity> IALRD_SecurityFormDao.GetAll(ALRD_SecurityFormEntity entity)
{
try
{
const string SP = "alrd_securityform_GetAll";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddSortExpressionParameter(cmd, entity.SortExpression);
FillParameters(entity, cmd, Database);
IList <ALRD_SecurityFormEntity> itemList = new List <ALRD_SecurityFormEntity>();
using (IDataReader reader = Database.ExecuteReader(cmd))
{
while (reader.Read())
{
itemList.Add(new ALRD_SecurityFormEntity(reader));
}
}
return(itemList);
}
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("GetAll"));
}
}
long IALRD_SecurityFormDao.Update(ALRD_SecurityFormEntity entity, bool isPertial = false)
{
long returnCode = -99;
string SP;
if (!isPertial)
{
SP = "alrd_securityform_Update";
}
else
{
SP = "alrd_securityform_PertialUpdate";
}
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
FillParameters(entity, cmd, Database);
//FillSequrityParameters(securityCapsule, cmd, OparationType.Update, Database);
AddOutputParameter(cmd);
try
{
returnCode = Database.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("Update"));
}
}
return(returnCode);
}
public static void FillParameters(ALRD_SecurityFormEntity entity, DbCommand cmd, Database Database, bool forDelete = false)
{
if (entity.COMPID.HasValue)
{
Database.AddInParameter(cmd, "@COMPID", DbType.Int64, entity.COMPID);
}
if (forDelete)
{
return;
}
if (entity.MenuID.HasValue)
{
Database.AddInParameter(cmd, "@MenuID", DbType.Int64, entity.MenuID);
}
if (!(string.IsNullOrEmpty(entity.FormName)))
{
Database.AddInParameter(cmd, "@FormName", DbType.String, entity.FormName);
}
if (!(string.IsNullOrEmpty(entity.FormType)))
{
Database.AddInParameter(cmd, "@FormType", DbType.String, entity.FormType);
}
if (!(string.IsNullOrEmpty(entity.FormCaption)))
{
Database.AddInParameter(cmd, "@FormCaption", DbType.String, entity.FormCaption);
}
if (entity.CreatedBy.HasValue)
{
Database.AddInParameter(cmd, "@CreatedBy", DbType.Int64, entity.CreatedBy);
}
if (entity.CreatedOn.HasValue)
{
Database.AddInParameter(cmd, "@CreatedOn", DbType.DateTime, entity.CreatedOn);
}
if (entity.UpdatedBy.HasValue)
{
Database.AddInParameter(cmd, "@UpdatedBy", DbType.Int64, entity.UpdatedBy);
}
if (entity.UpdatedOn.HasValue)
{
Database.AddInParameter(cmd, "@UpdatedOn", DbType.DateTime, entity.UpdatedOn);
}
}
long IALRD_SecurityFormDao.Delete(ALRD_SecurityFormEntity entity)
{
long returnCode = -99;
const string SP = "alrd_securityform_Delete";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
FillParameters(entity, cmd, Database, true);
//FillSequrityParameters(securityCapsule, cmd, OparationType.Update, Database);
AddOutputParameter(cmd);
try
{
returnCode = Database.ExecuteNonQuery(cmd);//Convert.ToInt64(cmd.Parameters["@RETURN_KEY"].Value);
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("Delete"));
}
}
return(returnCode);
}
long IALRD_SecurityFormDao.Add(ALRD_SecurityFormEntity entity)
{
long returnCode = -99;
const string SP = "alrd_securityform_Insert";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
FillParameters(entity, cmd, Database);
//FillSequrityParameters(securityCapsule, cmd, OparationType.Save, Database);
AddOutputParameter(cmd);
try
{
returnCode = Database.ExecuteNonQuery(cmd); // GetReturnCodeFromParameter(cmd);
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("Add"));
}
}
return(returnCode);
}
