public ChangePassWordBO GetEmailAddress(int iUserId)
{
DataSet objDataSet = null;
ChangePassWordBO objChangePassWordBO = null;
List <ProcParameterBO> objListProcParameterBo = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objListProcParameterBo.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcGetEmailAddress, ref objListProcParameterBo);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objChangePassWordBO = new ChangePassWordBO();
objChangePassWordBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objChangePassWordBO.EmailAddress = objDataSet.Tables[0].Rows[0][1].ToString();
}
}
catch (Exception EX)
{
ExceptionError.Error_Log(EX, "GetEmailAddress");
throw EX;
}
return(objChangePassWordBO);
}
public List <HRInteractionBO> getHRInteractionList()
{
DataSet objDataSet = null;
HRInteractionBO objHRInteractionBO = null;
List <HRInteractionBO> objHRInteractionBOList = new List <HRInteractionBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcHRInteractionList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objHRInteractionBO = new HRInteractionBO();
objHRInteractionBO.RequestId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objHRInteractionBO.ApplicantName = objDataSet.Tables[0].Rows[i][1].ToString();
objHRInteractionBO.Subject = objDataSet.Tables[0].Rows[i][2].ToString();
objHRInteractionBO.RequestDate = objDataSet.Tables[0].Rows[i][3].ToString();
objHRInteractionBO.ResponseDate = objDataSet.Tables[0].Rows[i][4].ToString();
objHRInteractionBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objHRInteractionBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString();
objHRInteractionBOList.Add(objHRInteractionBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getHRInteractionList");
throw ex;
}
return(objHRInteractionBOList);
}
private Either <DomainError, IImmutableList <string> > Mapper(IEnumerable <TitlesStorage> source)
{
try
{
if (!source.Any())
{
return(ImmutableList <string> .Empty);
}
var item = source.Single();
if (item == null || string.IsNullOrWhiteSpace(item.Titles))
{
return(BasicError.Create(nameof(FeedTitlesRepository), "Title source contains more than one record"));
}
return(item
.Titles
.Split(',')
.Select(x => x.Trim())
.ToImmutableList());
}
catch (Exception e)
{
return(ExceptionError.FromException(e));
}
}
public List <JobsReportBO> getApprovedJobsReportList()
{
DataSet objDataSet = null;
JobsReportBO objJobsReportBO = null;
List <JobsReportBO> objJobsReportBOList = new List <JobsReportBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApprovedJobsReportList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objJobsReportBO = new JobsReportBO();
objJobsReportBO.JobName = objDataSet.Tables[0].Rows[i][0].ToString();
objJobsReportBO.JobDescription = objDataSet.Tables[0].Rows[i][1].ToString();
objJobsReportBO.NoOfPositions = objDataSet.Tables[0].Rows[i][2].ToString();
objJobsReportBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString();
objJobsReportBO.DonorProgramName = objDataSet.Tables[0].Rows[i][4].ToString();
objJobsReportBO.RequiredStaffLevel = objDataSet.Tables[0].Rows[i][5].ToString();
objJobsReportBO.CurrentStaffLevel = objDataSet.Tables[0].Rows[i][6].ToString();
objJobsReportBO.Gaps = objDataSet.Tables[0].Rows[i][7].ToString();
objJobsReportBO.Status = objDataSet.Tables[0].Rows[i][8].ToString();
objJobsReportBOList.Add(objJobsReportBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApprovedJobsReportList");
throw ex;
}
return(objJobsReportBOList);
}
public List <CommonDropDownBO> getDonorProgramList(int iUserId)
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objParameterBO = new ProcParameterBO();
objParameterBO.Direction = ParameterDirection.Input;
objParameterBO.ParameterName = "@iUserId";
objParameterBO.dbType = DbType.Int32;
objParameterBO.ParameterValue = iUserId;
objProcParameterBOList.Add(objParameterBO);
objDataSet = objDBAccess.execuitDataSet(ProcDonorDropDown, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getDonorProgramList");
throw ex;
}
return(objCommonDropDownBOList);
}
public List <IdTypeMasterBO> GetIdTypeMasterList()
{
DataSet objDataSet = null;
IdTypeMasterBO objIdTypeMasterBO = null;
List <IdTypeMasterBO> objIdTypeMasterBOList = new List <IdTypeMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetIdTypeMasterList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objIdTypeMasterBO = new IdTypeMasterBO();
objIdTypeMasterBO.IdTypeMasterId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objIdTypeMasterBO.IdType = objDataSet.Tables[0].Rows[i][1].ToString();
objIdTypeMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][2].ToString());
objIdTypeMasterBOList.Add(objIdTypeMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetIdTypeMasterList");
throw ex;
}
return(objIdTypeMasterBOList);
}
public async Task WhenAnUnexpectedExceptionIsRaised_AnExceptionErrorWillBeReturned_WithInternalServerErrorHttpStatus()
{
// Arrange
var thrownException = new Exception("Exception with a parameter: {Param1}");
ExceptionError expectedResponse = new ExceptionError(System.Net.HttpStatusCode.InternalServerError, thrownException, string.Empty);
var middleware = new ExceptionHandlerMiddleware((innerHttpContext) =>
{
throw thrownException;
}, _logger);
var context = new DefaultHttpContext();
context.Response.Body = new MemoryStream();
//Act
await middleware.Invoke(context);
context.Response.Body.Seek(0, SeekOrigin.Begin);
var reader = new StreamReader(context.Response.Body);
var streamText = reader.ReadToEnd();
var actualResponse = JsonConvert.DeserializeObject <ExceptionError>(streamText);
//Assert
Assert.Equal(expectedResponse.StatusCode, actualResponse.StatusCode);
Assert.Equal(expectedResponse.StatusCode, context.Response.StatusCode);
Assert.Equal(expectedResponse.StatusMessage, actualResponse.StatusMessage);
Assert.Equal(expectedResponse.ErrorMessage, actualResponse.ErrorMessage);
}
public List <MenuMasterBO> getMenuList()
{
DataSet objDataSet = null;
MenuMasterBO objMenuMasterBO = null;
List <MenuMasterBO> objMenuMasterBOList = new List <MenuMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDbAcess.execuitDataSet(ProcGetMenuList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objMenuMasterBO = new MenuMasterBO();
objMenuMasterBO.MenuId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objMenuMasterBO.MenuName = objDataSet.Tables[0].Rows[i][1].ToString();
objMenuMasterBO.DisplayOrder = Convert.ToInt32(objDataSet.Tables[0].Rows[i][2].ToString());
objMenuMasterBO.MenuKey = objDataSet.Tables[0].Rows[i][3].ToString();
objMenuMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][4].ToString());
objMenuMasterBO.CreatedOn = objDataSet.Tables[0].Rows[i][5].ToString();
objMenuMasterBOList.Add(objMenuMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getMenuList");
throw ex;
}
return(objMenuMasterBOList);
}
public List <BranchMasterBO> selectBranchList()
{
DataSet objDataSet = null;
BranchMasterBO objBranchMasterBO = null;
List <BranchMasterBO> objListBranchMasterBO = new List <BranchMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcselectBranchList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objBranchMasterBO = new BranchMasterBO();
objBranchMasterBO.BranchId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objBranchMasterBO.OrganizationName = objDataSet.Tables[0].Rows[i][1].ToString();
objBranchMasterBO.BranchName = objDataSet.Tables[0].Rows[i][2].ToString();
objBranchMasterBO.Details = objDataSet.Tables[0].Rows[i][3].ToString();
objBranchMasterBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objBranchMasterBO.CellNumber = objDataSet.Tables[0].Rows[i][5].ToString();
objBranchMasterBO.LandNumber = objDataSet.Tables[0].Rows[i][6].ToString();
objBranchMasterBO.EmailId = objDataSet.Tables[0].Rows[i][7].ToString();
objBranchMasterBO.Website = objDataSet.Tables[0].Rows[i][8].ToString();
objListBranchMasterBO.Add(objBranchMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "selectBranchList");
throw ex;
}
return(objListBranchMasterBO);
}
public List <ApplicantRegistrationBO> getApplicantsList()
{
DataSet objDataSet = null;
ApplicantRegistrationBO objApplicantRegistrationBO = null;
List <ApplicantRegistrationBO> objApplicantRegistrationBOList = new List <ApplicantRegistrationBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApplicantList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplicantRegistrationBO = new ApplicantRegistrationBO();
objApplicantRegistrationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplicantRegistrationBO.FirstName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplicantRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[i][2].ToString();
objApplicantRegistrationBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString();
objApplicantRegistrationBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objApplicantRegistrationBOList.Add(objApplicantRegistrationBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApplicantsList");
throw ex;
}
return(objApplicantRegistrationBOList);
}
public ActionResult Create([Bind(Include = "ID,CODE,DESCRIPTION")] PRODUCT pRODUCT)
{
if (ModelState.IsValid)
{
var exception = new ExceptionError();
try
{
db.PRODUCT.Add(pRODUCT);
db.SaveChanges();
exception.Result = true;
}
catch (DbEntityValidationException e)
{
exception.Name = string.Format("Entity has the following validation errors: {0} {1}\n", e.Message, e.InnerException);
foreach (var x in e.EntityValidationErrors)
{
exception.Name += string.Format("Property name: {0}, Message {1}\n", x.ValidationErrors.FirstOrDefault().PropertyName, x.ValidationErrors.FirstOrDefault().ErrorMessage);
}
exception.Result = false;
}
if (exception.Result)
{
SharedHelp.CommonFunctions.CreateLog("CREATE", "PRODUCT", db.PRODUCT.Max(x => x.ID), null, string.Concat(pRODUCT.CODE, " / ", pRODUCT.DESCRIPTION), User.Identity.Name);
}
return(RedirectToAction("Index"));
}
return(View(pRODUCT));
}
public string GetPasswordData(string strEmailAddress, string strPassword)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
string strResult = "";
try
{
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@strEmailAddress";
objDbParameter.dbType = DbType.String;
objDbParameter.ParameterValue = strEmailAddress;
objProcParameterBOList.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@strPassword";
objDbParameter.dbType = DbType.String;
objDbParameter.ParameterValue = strPassword;
objProcParameterBOList.Add(objDbParameter);
strResult = objDBAccess.executeScalar(ProcGetPasswordData, ref objProcParameterBOList).ToString();
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetPasswordData");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public async Task <Either <DomainError, ImmutableList <AnimeInfo> > > GetLibrary()
{
try
{
var web = new HtmlWeb();
var doc = await web.LoadFromWebAsync(AniChartLibrary);
var
seasonInfoString =
HttpUtility.HtmlDecode(GetInnerTextOrEmpty(doc.DocumentNode, "//h1[@class='calendar']"));
var(season, year, yearStr) = GetSeasonInformation(seasonInfoString);
var feeTitles = await GetFeedTitles();
return(doc.DocumentNode
.SelectNodes("//div[contains(@class,'g_bubblewrap') and contains(@class,'container')]/div[contains(@class,'g_bubble') and contains(@class,'box')]")
.Select(n => MapFromCard(n, yearStr))
.Select(aic => new AnimeInfo(
NonEmptyString.FromString(IdHelpers.GenerateAnimeId(season.Value, yearStr, aic.Title)),
NonEmptyString.FromString(aic.Title),
NonEmptyString.FromString(aic.Synopsis),
NonEmptyString.FromString(Helpers.TryGetFeedTitle(feeTitles, aic.Title)),
new SeasonInformation(season, year),
aic.Date,
false))
.ToImmutableList());
}
catch (Exception e)
{
return(ExceptionError.FromException(e, "AnichartLibrary"));
}
}
public string CheckApplicantExist(int iApplicantId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
string strResult = "";
try
{
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantId;
objProcParameterBOList.Add(objDbParameter);
strResult = objDBAccess.executeScalar(ProcGetCheckApplicantExist, ref objProcParameterBOList).ToString();
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "CheckApplicantExist");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public override void OnException(ExceptionContext context)
{
var exc = new ExceptionError();
exc.Error = context.Exception.GetBaseException().Message;
context.HttpContext.Response.StatusCode = 400;
if (context.Exception is DomainException)
{
var ex = context.Exception as DomainException;
context.Exception = ex;
exc.Message = "Houve um erro de negócio";
}
else
{
#if !DEBUG
string stack = null;
#else
string stack = context.Exception.StackTrace;
#endif
exc.Message = "Erro inesperado no sistema";
exc.Detail = stack;
context.HttpContext.Response.StatusCode = 500;
}
context.Result = new JsonResult(exc);
base.OnException(context);
}
public void ExceptionReturnsCorrectObject()
{
var exception = new Exception();
var error = new ExceptionError(exception);
Assert.Equal(exception, error.Exception);
}
public IdTypeMasterBO EditIdTypeMaster(int iIdTypeMasterId)
{
DataSet objDataSet = null;
IdTypeMasterBO objIdTypeMasterBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iIdTypeMasterId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iIdTypeMasterId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditIdTypeMaster, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objIdTypeMasterBO = new IdTypeMasterBO();
objIdTypeMasterBO.IdTypeMasterId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objIdTypeMasterBO.IdType = objDataSet.Tables[0].Rows[0][1].ToString();
objIdTypeMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][2].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditIdTypeMaster");
throw ex;
}
return(objIdTypeMasterBO);
}
public void ExceptionErrorForwardsExceptionMessageByDefault()
{
var exception = new Exception("Wooga");
var error = new ExceptionError(exception);
Assert.Equal(exception.Message, error.Message);
}
public async Task WhenAnApiBaseExceptionIsRaised_AExceptionErrorWillBeReturned_WithAProvidedHttpStatus()
{
// Arrange
ApiBaseException thrownException = new ApiBaseException(System.Net.HttpStatusCode.GatewayTimeout, "A Test Exception");
ExceptionError expectedResponse = new ExceptionError(System.Net.HttpStatusCode.GatewayTimeout, thrownException, string.Empty);
var middleware = new ExceptionHandlerMiddleware((innerHttpContext) =>
{
throw thrownException;
}, _logger);
var context = new DefaultHttpContext();
context.Response.Body = new MemoryStream();
//Act
await middleware.Invoke(context);
context.Response.Body.Seek(0, SeekOrigin.Begin);
var reader = new StreamReader(context.Response.Body);
var streamText = reader.ReadToEnd();
var actualResponse = JsonConvert.DeserializeObject <ExceptionError>(streamText);
//Assert
Assert.Equal(expectedResponse.StatusCode, actualResponse.StatusCode);
Assert.Equal(expectedResponse.StatusCode, context.Response.StatusCode);
Assert.Equal(expectedResponse.StatusMessage, actualResponse.StatusMessage);
Assert.Equal(expectedResponse.ErrorMessage, actualResponse.ErrorMessage);
}
public void ExceptionErrorUsesProvidedMessageIfAvailable()
{
var exception = new Exception("Wooga");
var error = new ExceptionError(exception, "Booga");
Assert.NotEqual(exception.Message, error.Message);
}
public List <string> getHRofficeUsersList()
{
DataSet objDataSet = null;
string strEmailAddress = "";
List <string> objUsersList = new List <string>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetHRofficeUsersList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
strEmailAddress = objDataSet.Tables[0].Rows[i][0].ToString();
objUsersList.Add(strEmailAddress);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getHRofficeUsersList");
throw ex;
}
return(objUsersList);
}
public Either <DomainError, ImmutableList <FeedInfo> > GetFeed(Resolution resolution)
{
try
{
var sources = new List <LinkType> {
LinkType.TorrentFile, LinkType.Magnet
}
.SelectMany(type => GetFeedInformation(Resolution.Hd, type))
.Where(f => f.PublicationDate >= DateTime.Today)
.GroupBy(i => i.AnimeTitle);
var resultList =
from source in sources
let links = source.Select(x => new TorrentLink(x.Type, x.Link)).ToImmutableList()
let baseElement = source.First()
select new FeedInfo(
NonEmptyString.FromString(baseElement.AnimeTitle),
NonEmptyString.FromString(baseElement.FeedTitle),
baseElement.PublicationDate,
links,
baseElement.EpisodeInfo);
return(resultList.ToImmutableList());
}
catch (Exception e)
{
return(Left <DomainError, ImmutableList <FeedInfo> >(
ExceptionError.FromException(e, $"Erai_Feed_Exception")));
}
}
public List <UserRegistrationBO> getUsersList()
{
DataSet objDataSet = null;
UserRegistrationBO objUserRegistrationBO = null;
List <UserRegistrationBO> objUserRegistrationBOList = new List <UserRegistrationBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetUsersList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objUserRegistrationBO = new UserRegistrationBO();
objUserRegistrationBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objUserRegistrationBO.FirstName = objDataSet.Tables[0].Rows[i][1].ToString();
objUserRegistrationBO.LastName = objDataSet.Tables[0].Rows[i][2].ToString();
objUserRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString();
objUserRegistrationBO.MobileNumber = objDataSet.Tables[0].Rows[i][4].ToString();
objUserRegistrationBO.Department = objDataSet.Tables[0].Rows[i][5].ToString();
objUserRegistrationBO.City = objDataSet.Tables[0].Rows[i][6].ToString();
objUserRegistrationBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][7].ToString());
objUserRegistrationBOList.Add(objUserRegistrationBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getUsersList");
throw ex;
}
return(objUserRegistrationBOList);
}
public List <OrganizationMasterBO> selectOrganisationList()
{
DataSet objDataSet = null;
OrganizationMasterBO objOrganizationMasterBO = null;
List <OrganizationMasterBO> objListOrganizationMasterBO = new List <OrganizationMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcselectOrganizationList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objOrganizationMasterBO = new OrganizationMasterBO();
objOrganizationMasterBO.OrganisationId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objOrganizationMasterBO.OrganisationName = objDataSet.Tables[0].Rows[i][1].ToString();
objOrganizationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][3].ToString());
objListOrganizationMasterBO.Add(objOrganizationMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "selectOrganisationList");
throw ex;
}
return(objListOrganizationMasterBO);
}
async Task InvokeAsync(HttpContext context)
{
try
{
await request(context);
}
catch (Exception exception)
{
string traceID = Guid.NewGuid().ToString();
ExceptionError apiException = new ExceptionError(exception, traceID);
if (!env.IsDevelopment())
{
apiException.StackTrace = string.Empty;
}
// Log validation errors with this specific traceID:
logger.LogError(exception, exception.Message + " ({traceId})", traceID);
//var httpStatusCode = ConfigurateExceptionTypes(exception);
var httpStatusCode = apiException.StatusCode;
// Set HTTP status code and content type
context.Response.StatusCode = httpStatusCode;
context.Response.ContentType = JsonContentType;
// Writes / Returns error model to the response (in camelCase format)
await context.Response.WriteAsync(JsonConvert.SerializeObject(
apiException,
new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
}));
}
}
internal static async Task <Either <DomainError, Unit> > BatchDelete <T>(CloudTable tableClient, IImmutableList <T> entities) where T : TableEntity
{
try
{
var offset = 0;
while (offset < entities.Count)
{
var batch = new TableBatchOperation();
var rows = entities.Skip(offset).Take(100).ToList();
foreach (var row in rows)
{
batch.Delete(row);
}
await tableClient.ExecuteBatchAsync(batch);
offset += rows.Count;
}
return(Right(unit));
}
catch (Exception e)
{
return(Left <DomainError, Unit>(ExceptionError.FromException(e, "BatchDelete")));
}
}
public List <ApprovedJobsListBO> getApprovedJobsList()
{
DataSet objDataSet = null;
ApprovedJobsListBO objApprovedJobsListBO = null;
List <ApprovedJobsListBO> objApprovedJobsBOList = new List <ApprovedJobsListBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApprovedJobsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApprovedJobsListBO = new ApprovedJobsListBO();
objApprovedJobsListBO.JobName = objDataSet.Tables[0].Rows[i][0].ToString();
objApprovedJobsListBO.JobDescription = objDataSet.Tables[0].Rows[i][1].ToString();
objApprovedJobsListBO.JobLocation = objDataSet.Tables[0].Rows[i][2].ToString();
objApprovedJobsListBO.NoOfPositions = Convert.ToInt32(objDataSet.Tables[0].Rows[i][3].ToString());
objApprovedJobsListBO.ApprovedDate = objDataSet.Tables[0].Rows[i][4].ToString();
objApprovedJobsListBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objApprovedJobsListBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString();
objApprovedJobsBOList.Add(objApprovedJobsListBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApprovedJobsList");
throw ex;
}
return(objApprovedJobsBOList);
}
public string deleteUser(int iUserId)
{
string strResult = "";
try
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDbParameter);
objDBAccess.executeNonQuery(ProcDeleteUser, ref objProcParameterBOList);
strResult = "DELETED";
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "deleteUser");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public List <CommonDropDownBO> CountriesList()
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcCountriesList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "CountriesList");
throw ex;
}
return(objCommonDropDownBOList);
}
public UserRegistrationBO EditUserDetails(int iUserId)
{
DataSet objDataSet = null;
UserRegistrationBO objUserRegistrationBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iuserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditUser, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objUserRegistrationBO = new UserRegistrationBO();
objUserRegistrationBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objUserRegistrationBO.FirstName = objDataSet.Tables[0].Rows[0][1].ToString();
objUserRegistrationBO.MiddleName = objDataSet.Tables[0].Rows[0][2].ToString();
objUserRegistrationBO.LastName = objDataSet.Tables[0].Rows[0][3].ToString();
objUserRegistrationBO.Photo = objDataSet.Tables[0].Rows[0][4].ToString();
objUserRegistrationBO.Password = objDataSet.Tables[0].Rows[0][5].ToString();
//objUserRegistrationBO.ConfirmPassword = objDataSet.Tables[0].Rows[0][6].ToString();
objUserRegistrationBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objUserRegistrationBO.MobileNumber = objDataSet.Tables[0].Rows[0][7].ToString();
objUserRegistrationBO.AlternateMobileNumber = objDataSet.Tables[0].Rows[0][8].ToString();
objUserRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[0][9].ToString();
objUserRegistrationBO.Language = objDataSet.Tables[0].Rows[0][10].ToString();
objUserRegistrationBO.Qualification = objDataSet.Tables[0].Rows[0][11].ToString();
objUserRegistrationBO.College = objDataSet.Tables[0].Rows[0][12].ToString();
objUserRegistrationBO.University = objDataSet.Tables[0].Rows[0][13].ToString();
objUserRegistrationBO.AggregatePercentage = objDataSet.Tables[0].Rows[0][14].ToString();
objUserRegistrationBO.JoiningDate = objDataSet.Tables[0].Rows[0][15].ToString();
objUserRegistrationBO.CountryId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][16].ToString());
objUserRegistrationBO.StateId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][17].ToString());
objUserRegistrationBO.City = objDataSet.Tables[0].Rows[0][18].ToString();
objUserRegistrationBO.UserType = objDataSet.Tables[0].Rows[0][19].ToString();
objUserRegistrationBO.UserRole = objDataSet.Tables[0].Rows[0][20].ToString();
objUserRegistrationBO.DonorProgram = objDataSet.Tables[0].Rows[0][21].ToString();
objUserRegistrationBO.Department = objDataSet.Tables[0].Rows[0][22].ToString();
objUserRegistrationBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objUserRegistrationBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][24].ToString());
objUserRegistrationBO.DateOfBirth = objDataSet.Tables[0].Rows[0][25].ToString();
objUserRegistrationBO.FileSavedName = objDataSet.Tables[0].Rows[0][26].ToString();
objUserRegistrationBO.LocationId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][27].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditUserDetails");
throw ex;
}
return(objUserRegistrationBO);
}