IList <ALRD_OrganizationInfoEntity> IALRD_OrganizationInfoDao.GetAll(ALRD_OrganizationInfoEntity entity)
{
try
{
const string SP = "alrd_organizationinfo_GetAll";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddSortExpressionParameter(cmd, entity.SortExpression);
FillParameters(entity, cmd, Database);
IList <ALRD_OrganizationInfoEntity> itemList = new List <ALRD_OrganizationInfoEntity>();
using (IDataReader reader = Database.ExecuteReader(cmd))
{
while (reader.Read())
{
itemList.Add(new ALRD_OrganizationInfoEntity(reader));
}
}
return(itemList);
}
}
catch (Exception ex)
{
throw GetDataAccessException(ex, SourceOfException("GetAll"));
}
}
private void UpdateItem(ListViewItem insertItem, int dataItemIndex)
{
ALRD_OrganizationInfoEntity item = LocalDataStore[dataItemIndex];
item.DESCRIPT = ((TextBox)insertItem.FindControl("txtDESCRIPT")).Text.Trim();
item.NameOfCEO = ((TextBox)insertItem.FindControl("txtNameOfCEO")).Text.Trim();
item.TelephoneNo = ((TextBox)insertItem.FindControl("txtTelephoneNo")).Text.Trim();
item.MobileNo = ((TextBox)insertItem.FindControl("txtMobileNo")).Text.Trim();
item.Email = ((TextBox)insertItem.FindControl("txtEmail")).Text.Trim();
item.WebSite = ((TextBox)insertItem.FindControl("txtWebSite")).Text.Trim();
item.Fax = ((TextBox)insertItem.FindControl("txtFax")).Text.Trim();
item.Status = ((CheckBox)insertItem.FindControl("chkStatus")).Checked;
item.WebSite = ((TextBox)insertItem.FindControl("txtWebSite")).Text.Trim();
item.CreatedBy = ((TextBox)insertItem.FindControl("txtCreatedBy")).Text.Trim() != string.Empty ? long.Parse(((TextBox)insertItem.FindControl("txtCreatedBy")).Text.Trim()) : (long?)null;
item.CreatedOn = GetDateFromString(((TextBox)insertItem.FindControl("txtCreatedOn")).Text.Trim());
item.UpdatedBy = GlobalClass.UserID;
item.UpdatedOn = DateTime.Now;
long i = SH.Service.ALRD_OrganizationInfoService.GetService().Update(item);
SuccessMessage = "Information Updated Successfully.";
this.lsv_SetupPage.EditIndex = -1;
this.LoadData();
}
long IALRD_OrganizationInfoDao.Update(ALRD_OrganizationInfoEntity entity, bool isPertial = false)
{
long returnCode = -99;
string SP;
if (!isPertial)
{
SP = "alrd_organizationinfo_Update";
}
else
{
SP = "alrd_organizationinfo_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_OrganizationInfoEntity entity, DbCommand cmd, Database Database, bool forDelete = false)
{
if (entity.COMPID.HasValue)
{
Database.AddInParameter(cmd, "@COMPID", DbType.Int64, entity.COMPID);
}
if (forDelete)
{
return;
}
if (!(string.IsNullOrEmpty(entity.DESCRIPT)))
{
Database.AddInParameter(cmd, "@DESCRIPT", DbType.String, entity.DESCRIPT);
}
if (entity.Status.HasValue)
{
Database.AddInParameter(cmd, "@Status", DbType.Boolean, entity.Status);
}
if (!(string.IsNullOrEmpty(entity.NameOfCEO)))
{
Database.AddInParameter(cmd, "@NameOfCEO", DbType.String, entity.NameOfCEO);
}
if (!(string.IsNullOrEmpty(entity.TelephoneNo)))
{
Database.AddInParameter(cmd, "@TelephoneNo", DbType.String, entity.TelephoneNo);
}
if (!(string.IsNullOrEmpty(entity.MobileNo)))
{
Database.AddInParameter(cmd, "@MobileNo", DbType.String, entity.MobileNo);
}
if (!(string.IsNullOrEmpty(entity.Email)))
{
Database.AddInParameter(cmd, "@Email", DbType.String, entity.Email);
}
if (!(string.IsNullOrEmpty(entity.WebSite)))
{
Database.AddInParameter(cmd, "@WebSite", DbType.String, entity.WebSite);
}
if (!(string.IsNullOrEmpty(entity.Fax)))
{
Database.AddInParameter(cmd, "@Fax", DbType.String, entity.Fax);
}
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);
}
}
private void DeleteItem(int dataItemIndex)
{
ALRD_OrganizationInfoEntity item = LocalDataStore[dataItemIndex];
long i = SH.Service.ALRD_OrganizationInfoService.GetService().Delete(item);
SuccessMessage = "Information Deleted Successfully.";
this.LoadData();
}
long IALRD_OrganizationInfoDao.Delete(ALRD_OrganizationInfoEntity entity)
{
long returnCode = -99;
const string SP = "alrd_organizationinfo_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_OrganizationInfoDao.Add(ALRD_OrganizationInfoEntity entity)
{
long returnCode = -99;
const string SP = "alrd_organizationinfo_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);
}
private void InsertItem(ListViewItem insertItem)
{
ALRD_OrganizationInfoEntity item = new ALRD_OrganizationInfoEntity();
item.DESCRIPT = ((TextBox)insertItem.FindControl("txtDESCRIPT")).Text.Trim();
item.NameOfCEO = ((TextBox)insertItem.FindControl("txtNameOfCEO")).Text.Trim();
item.TelephoneNo = ((TextBox)insertItem.FindControl("txtTelephoneNo")).Text.Trim();
item.MobileNo = ((TextBox)insertItem.FindControl("txtMobileNo")).Text.Trim();
item.Email = ((TextBox)insertItem.FindControl("txtEmail")).Text.Trim();
item.WebSite = ((TextBox)insertItem.FindControl("txtWebSite")).Text.Trim();
item.Fax = ((TextBox)insertItem.FindControl("txtFax")).Text.Trim();
item.Status = ((CheckBox)insertItem.FindControl("chkStatus")).Checked;
item.WebSite = ((TextBox)insertItem.FindControl("txtWebSite")).Text.Trim();
item.CreatedBy = GlobalClass.UserID;
item.CreatedOn = DateTime.Now;
long i = SH.Service.ALRD_OrganizationInfoService.GetService().Add(item);
SuccessMessage = "Information Saved Successfully.";
this.CloseInsert();
this.LoadData();
}
