public override async Task <List <IWebApiRoleModel> > SelectAllByFilterAsync(IPredicate predicate, CancellationToken cancellationToken, IPageInfo pageInfo = null)
{
string retVal = predicate.Serialize();
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.Predicate, GetParameter(DBObjects.SPParameter.Predicate, ParameterDirection.Input, ((int)SqlDbType.NVarChar), retVal.Length, retVal));
param.Add(DBObjects.SPParameter.CPage, GetParameter(DBObjects.SPParameter.CPage, ParameterDirection.Input, ((int)SqlDbType.Int), 8, pageInfo.CPage));
param.Add(DBObjects.SPParameter.PSize, GetParameter(DBObjects.SPParameter.PSize, ParameterDirection.Input, ((int)SqlDbType.Int), 8, Convert.ToInt32((pageInfo.PSize))));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, pageInfo.UserId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.webApi_pspRoleSelect.ToString(), cancellationToken, param);
List <IWebApiRoleModel> list = new List <IWebApiRoleModel>();
list = (from DataRow dr in dt.Rows
select new WebApiRoleModel
{
WARoleId = Convert.ToInt64(dr[DBObjects.Fields.WARoleId]),
Name = dr[DBObjects.Fields.Name].ToString(),
Description = PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.Description]).ToString(),
IsActive = Convert.ToBoolean(dr[DBObjects.Fields.IsActive]),
Rank = Convert.ToInt32(dr[DBObjects.Fields.Rank]),
IsSystemGenerated = Convert.ToBoolean(PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.IsSystemGenerated])),
TRows = Convert.ToInt32(dr[DBObjects.Fields.TRows]),
CPage = Convert.ToInt32(dr[DBObjects.Fields.CPage]),
PSize = dr[DBObjects.Fields.PSize].ToString()
}).ToList <IWebApiRoleModel>();
return(list);
}
public override async Task <List <IWebApiUser> > SelectAllByFilterAsync(IPredicate predicate, CancellationToken cancellationToken, IPageInfo pageInfo = null)
{
string retVal = predicate.Serialize();
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.Predicate, GetParameter(DBObjects.SPParameter.Predicate, ParameterDirection.Input, ((int)SqlDbType.NVarChar), retVal.Length, retVal));
param.Add(DBObjects.SPParameter.CPage, GetParameter(DBObjects.SPParameter.CPage, ParameterDirection.Input, ((int)SqlDbType.Int), 8, pageInfo.CPage));
param.Add(DBObjects.SPParameter.PSize, GetParameter(DBObjects.SPParameter.PSize, ParameterDirection.Input, ((int)SqlDbType.Int), 8, Convert.ToInt32((pageInfo.PSize))));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, pageInfo.UserId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.webApi_pspUserSearch.ToString(), cancellationToken, param);
List <IWebApiUser> list = new List <IWebApiUser>();
list = (from DataRow dr in dt.Rows
select new WebApiUser
{
WAUserId = Convert.ToString(dr["WAUserId"]),
FirstName = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["FirstName"])),
MiddleName = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["MiddleName"])),
LastName = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["LastName"])),
EmailId = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["EmailId"])),
PhoneNo = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["PhoneNo"])),
Address2 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr["Address2"])),
IsActive = Convert.ToBoolean(PublicFunctions.ConvertDBNullToNull(dr["IsActive"])),
IsSystemGenerated = Convert.ToBoolean(PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.IsSystemGenerated])),
TRows = Convert.ToInt32(dr[DBObjects.Fields.TRows]),
CPage = Convert.ToInt32(dr[DBObjects.Fields.CPage]),
PSize = dr[DBObjects.Fields.PSize].ToString()
}).ToList <IWebApiUser>();
return(list);
}
public override async Task <IWebApiUser> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken)
{
DataTable dt = null;
Dictionary <string, object> param = new Dictionary <string, object>();
IWebApiUser user = null;
param.Add(DBObjects.SPParameter.WAUserId, GetParameter(DBObjects.SPParameter.WAUserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.webApi_pspSelectUserById.ToString(), cancellationToken, param);
if (dt != null && dt.Rows.Count > 0)
{
user = new WebApiUser();
user.SystemId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["SystemId"]));
user.WARoleId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["WARoleId"]));
user.EmailId = Convert.ToString(dt.Rows[0]["EmailId"]);
user.ConfirmEmailId = Convert.ToString(dt.Rows[0]["EmailId"]);
user.UserName = Convert.ToString(dt.Rows[0]["UserName"]);
user.FirstName = Convert.ToString(dt.Rows[0]["FirstName"]);
user.MiddleName = Convert.ToString(dt.Rows[0]["MiddleName"]);
user.LastName = Convert.ToString(dt.Rows[0]["LastName"]);
user.SystemName = Convert.ToString(dt.Rows[0]["SystemName"]);
user.RoleName = Convert.ToString(dt.Rows[0]["RoleName"]);
user.PhoneNo = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["PhoneNo"]));
user.Address1 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address1"]));
user.Address2 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address2"]));
user.Address3 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address3"]));
user.WAUserId = dt.Rows[0]["WAUserId"].ToString();
user.TimeZoneId = Convert.ToInt64(dt.Rows[0]["TimeZoneID"]);
user.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]);
}
return(user);
}
public override async Task <IObjectModel> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken)
{
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.ObjectId, GetParameter(DBObjects.SPParameter.ObjectId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspObjectSelectById.ToString(), cancellationToken, param);
IObjectModel model = new ObjectModel();
model.ObjectId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ObjectId]);
model.ModuleId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ModuleId]);
model.Name = dt.Rows[0][DBObjects.Fields.Name].ToString();
model.Description = PublicFunctions.ConvertNULL(dt.Rows[0][DBObjects.Fields.Description], "");
model.Caption = dt.Rows[0][DBObjects.Fields.Caption].ToString();
model.URL = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0][DBObjects.Fields.URL]));
model.ParentObjectId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.ParentObjectId]);
model.ObjectLevel = Convert.ToInt32(dt.Rows[0][DBObjects.Fields.ObjectLevel]);
model.AllowWrite = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.AllowWrite]);
model.AllowDelete = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.AllowDelete]);
model.IsActive = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.IsActive]);
model.ObjectOrder = Convert.ToByte(PublicFunctions.ConvertDBNullToNull(dt.Rows[0][DBObjects.Fields.ObjectOrder]));
model.ObjectImage = PublicFunctions.ConvertNULL(dt.Rows[0][DBObjects.Fields.ObjectImage], "");
return(model);
}
public override async Task <IEmailServerModel> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken)
{
DataTable dt = null;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.ServerId, GetParameter(DBObjects.SPParameter.ServerId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspEmailServerByID.ToString(), cancellationToken, param);
IEmailServerModel model = new EmailServerModel();
model.ServerId = Convert.ToInt64(dt.Rows[0]["ServerId"]);
model.ServerName = dt.Rows[0]["ServerName"].ToString();
model.ServerIP = dt.Rows[0]["ServerIP"].ToString();
model.EmailPort = Convert.ToInt32(dt.Rows[0]["EmailPort"]);
model.UserName = dt.Rows[0]["UserName"].ToString();
model.UserPswd = dt.Rows[0]["UserPswd"].ToString();
model.UseDefaultCredentials = Convert.ToBoolean(dt.Rows[0]["UseDefaultCredentials"]);
model.EnableSSL = Convert.ToBoolean(dt.Rows[0]["EnableSSL"]);
model.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]);
model.UpdateDate = Convert.ToDateTime(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["UpdateDate"]));
model.UpdateUserID = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["UpdateUserID"]));
model.AddDate = Convert.ToDateTime(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["AddDate"]));
model.AddUserID = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["AddUserID"]));
model.Priority = Convert.ToByte(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Priority"]));
return(model);
}
public override async Task <IWebApiRoleModel> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken)
{
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.WARoleId, GetParameter(DBObjects.SPParameter.WARoleId, ParameterDirection.Input, ((int)SqlDbType.NVarChar), 8, id));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, userId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.webApi_pspRoleSelectById.ToString(), cancellationToken, param);
IWebApiRoleModel model = new WebApiRoleModel();
model.WARoleId = Convert.ToInt64(dt.Rows[0][DBObjects.Fields.WARoleId]);
model.Name = dt.Rows[0][DBObjects.Fields.Name].ToString();
model.Description = PublicFunctions.ConvertDBNullToNull(dt.Rows[0][DBObjects.Fields.Description]).ToString();
model.Rank = Convert.ToInt32(dt.Rows[0][DBObjects.Fields.Rank]);
model.IsActive = Convert.ToBoolean(dt.Rows[0][DBObjects.Fields.IsActive]);
return(model);
}
public async override Task <IHireThingsUser> SelectByIDAsync(long id, long userId, CancellationToken cancellationToken)
{
DataTable dt = null;
Dictionary <string, object> param = new Dictionary <string, object>();
IHireThingsUser user = null;
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, id));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspSelectUserById.ToString(), cancellationToken, param);
if (dt != null && dt.Rows.Count > 0)
{
user = new HireThingsUser();
user.RoleId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["RoleId"]));
user.EmailId = Convert.ToString(dt.Rows[0]["EmailId"]);
user.ConfirmEmailId = Convert.ToString(dt.Rows[0]["EmailId"]);
user.UserName = Convert.ToString(dt.Rows[0]["UserName"]);
user.FirstName = Convert.ToString(dt.Rows[0]["FirstName"]);
user.MiddleName = Convert.ToString(dt.Rows[0]["MiddleName"]);
user.LastName = Convert.ToString(dt.Rows[0]["LastName"]);
user.CountryId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["CountryId"]));
user.LocationId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["LocationId"]));
user.RoleName = Convert.ToString(dt.Rows[0]["RoleName"]);
user.GenderId = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["GenderId"]));
user.DOB = Convert.ToDateTime(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["DOB"]));
user.PhoneNo = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["PhoneNo"]));
user.Address1 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address1"]));
user.Address2 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address2"]));
user.Address3 = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["Address3"]));
user.SecurityQuestionID = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dt.Rows[0]["SecurityQuestionID"]));
user.SecurityAnswer = "***";
user.Id = dt.Rows[0]["UserId"].ToString();
user.RoleId = Convert.ToInt64(dt.Rows[0]["RoleId"]);
user.PINHash = dt.Rows[0]["PINHash"].ToString();
user.IsEmailConfirmed = Convert.ToBoolean(dt.Rows[0]["IsEmailConfirmed"]);
user.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]);
}
return(user);
}
public override async Task <List <IEmailServerModel> > SelectAllByFilterAsync(IPredicate predicate, CancellationToken cancellationToken, IPageInfo pageInfo = null)
{
string retVal = predicate.Serialize();
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.Predicate, GetParameter(DBObjects.SPParameter.Predicate, ParameterDirection.Input, ((int)SqlDbType.NVarChar), retVal.Length, retVal));
param.Add(DBObjects.SPParameter.CPage, GetParameter(DBObjects.SPParameter.CPage, ParameterDirection.Input, ((int)SqlDbType.Int), 8, pageInfo.CPage));
param.Add(DBObjects.SPParameter.PSize, GetParameter(DBObjects.SPParameter.PSize, ParameterDirection.Input, ((int)SqlDbType.Int), 8, Convert.ToInt32((pageInfo.PSize))));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, pageInfo.UserId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspEmailServerSelect.ToString(), cancellationToken, param);
List <IEmailServerModel> list = new List <IEmailServerModel>();
list = (from DataRow dr in dt.Rows
select new EmailServerModel
{
ServerId = Convert.ToInt64(dr["ServerId"]),
ServerName = dr["ServerName"].ToString(),
ServerIP = dr["ServerIP"].ToString(),
EmailPort = Convert.ToInt32(dr["EmailPort"]),
UserName = dr["UserName"].ToString(),
UserPswd = dr["UserPswd"].ToString(),
UseDefaultCredentials = Convert.ToBoolean(dr["UseDefaultCredentials"]),
EnableSSL = Convert.ToBoolean(dr["EnableSSL"]),
IsActive = Convert.ToBoolean(dr["IsActive"]),
UpdateDate = Convert.ToDateTime(PublicFunctions.ConvertDBNullToNull(dr["UpdateDate"])),
UpdateUserID = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dr["UpdateUserID"])),
AddDate = Convert.ToDateTime(PublicFunctions.ConvertDBNullToNull(dr["AddDate"])),
AddUserID = Convert.ToInt64(PublicFunctions.ConvertDBNullToNull(dr["AddUserID"])),
Priority = Convert.ToByte(PublicFunctions.ConvertDBNullToNull(dr["Priority"])),
TRows = Convert.ToInt32(dr[DBObjects.Fields.TRows]),
CPage = Convert.ToInt32(dr[DBObjects.Fields.CPage]),
PSize = dr[DBObjects.Fields.PSize].ToString()
}).ToList <IEmailServerModel>();
return(list);
}
public override async Task <List <IObjectModel> > SelectAllByFilterAsync(IPredicate predicate, CancellationToken cancellationToken, IPageInfo pageInfo = null)
{
string retVal = predicate.Serialize();
DataTable dt;
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add(DBObjects.SPParameter.Predicate, GetParameter(DBObjects.SPParameter.Predicate, ParameterDirection.Input, ((int)SqlDbType.NVarChar), retVal.Length, retVal));
param.Add(DBObjects.SPParameter.CPage, GetParameter(DBObjects.SPParameter.CPage, ParameterDirection.Input, ((int)SqlDbType.Int), 8, pageInfo.CPage));
param.Add(DBObjects.SPParameter.PSize, GetParameter(DBObjects.SPParameter.PSize, ParameterDirection.Input, ((int)SqlDbType.Int), 8, Convert.ToInt32((pageInfo.PSize))));
param.Add(DBObjects.SPParameter.UserId, GetParameter(DBObjects.SPParameter.UserId, ParameterDirection.Input, ((int)SqlDbType.BigInt), 8, pageInfo.UserId));
dt = await this.GetSPDataTableAsync(DBObjects.StoredProcedures.pspObjectSelect.ToString(), cancellationToken, param);
List <IObjectModel> list = new List <IObjectModel>();
list = (from DataRow dr in dt.Rows
select new ObjectModel
{
ObjectId = Convert.ToInt64(dr[DBObjects.Fields.ObjectId]),
ParentObjectId = Convert.ToInt64(dr[DBObjects.Fields.ParentObjectId]),
Name = dr[DBObjects.Fields.Name].ToString(),
ModuleName = dr[DBObjects.Fields.ModuleName].ToString(),
ParentName = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.ParentName])),
Description = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.Description])),
Caption = dr[DBObjects.Fields.Caption].ToString(),
URL = Convert.ToString(PublicFunctions.ConvertDBNullToNull(dr[DBObjects.Fields.URL])),
ObjectOrder = Convert.ToByte(dr[DBObjects.Fields.ObjectOrder]),
AllowDelete = Convert.ToBoolean(dr[DBObjects.Fields.AllowDelete]),
AllowWrite = Convert.ToBoolean(dr[DBObjects.Fields.AllowWrite]),
IsActive = Convert.ToBoolean(dr[DBObjects.Fields.IsActive]),
TRows = Convert.ToInt32(dr[DBObjects.Fields.TRows]),
CPage = Convert.ToInt32(dr[DBObjects.Fields.CPage]),
PSize = dr[DBObjects.Fields.PSize].ToString(),
IsWithoutSearch = Convert.ToBoolean(dr[DBObjects.Fields.IsWithoutSearch]),
}).ToList <IObjectModel>();
return(list);
}
