public IEnumerable <FDICircularIndex> GetFDICircularIndex(FDICircularIndex fDICircularIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var fDICircularIndexes = dataContext.FDICircularIndexGet(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDICircularId, fDICircularIndex.FDIChapterId, Utility.TrimString(fDICircularIndex.SearchText), fDICircularIndex.IsActive, fDICircularIndex.PageNumber, fDICircularIndex.PageSize, fDICircularIndex.IsPagingRequired, Utility.TrimString(fDICircularIndex.OrderBy), Utility.TrimString(fDICircularIndex.OrderByDirection), totalPageCount, totalRecord).ToList();
var fDICircularIndexList = new List <FDICircularIndex>();
foreach (var fDICircularIndexDetail in fDICircularIndexes)
{
fDICircularIndexList.Add(new FDICircularIndex()
{
FDICircularIndexId = fDICircularIndexDetail.FDICircularIndexId,
FDIChapterId = fDICircularIndexDetail.FDIChapterId,
IndexNo = fDICircularIndexDetail.IndexNo,
IndexName = fDICircularIndexDetail.IndexName,
IndexContent = fDICircularIndexDetail.IndexContent,
SortId = fDICircularIndexDetail.SortId,
IsActive = fDICircularIndexDetail.IsActive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(fDICircularIndexList);
}
}
public IHttpActionResult UpdateFDICircularIndex(UpdateFDICircularIndexRequest updateFDICircularIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var fDICircularIndex = new FDICircularIndex()
{
FDICircularIndexId = updateFDICircularIndexRequest.FDICircularIndexId,
FDIChapterId = updateFDICircularIndexRequest.FDIChapterId,
IndexNo = updateFDICircularIndexRequest.IndexNo,
IndexName = updateFDICircularIndexRequest.IndexName,
IndexContent = updateFDICircularIndexRequest.IndexContent,
SaveAfterIndexId = updateFDICircularIndexRequest.SaveAfterIndexId,
ModifiedBy = Utility.UserId
};
int result = iFDICircularIndex.UpdateFDICircularIndex(fDICircularIndex);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FDICircularIndex updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FDICircularIndex already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FDICircularIndex doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating FDICircularIndex.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating FDICircularIndex.";
Utility.WriteLog("UpdateFDICircularIndex", updateFDICircularIndexRequest, "Error while updating FDICircularIndex. (FDICircularIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public int DeleteFDICircularIndex(FDICircularIndex fDICircularIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FDICircularIndexDelete(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, fDICircularIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateFDICircularIndex(FDICircularIndex fDICircularIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FDICircularIndexUpdate(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, Utility.TrimString(fDICircularIndex.IndexNo), Utility.TrimString(fDICircularIndex.IndexName), Utility.TrimString(fDICircularIndex.IndexContent), fDICircularIndex.SaveAfterIndexId, fDICircularIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult AddFDICircularIndex(AddFDICircularIndexRequest addFDICircularIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var fDICircularIndex = new FDICircularIndex()
{
FDIChapterId = addFDICircularIndexRequest.FDIChapterId,
IndexNo = addFDICircularIndexRequest.IndexNo,
IndexName = addFDICircularIndexRequest.IndexName,
IndexContent = addFDICircularIndexRequest.IndexContent,
SaveAfterIndexId = addFDICircularIndexRequest.SaveAfterIndexId
};
int result = iFDICircularIndex.AddFDICircularIndex(fDICircularIndex);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FDICircularIndex added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FDICircularIndex alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding FDICircularIndex.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding FDICircularIndex.";
Utility.WriteLog("AddFDICircularIndex", addFDICircularIndexRequest, "Error while adding FDICircularIndex. (FDICircularIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult GetFDICircularIndex([FromUri] GetFDICircularIndexRequest getFDICircularIndexRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getFDICircularIndexRequest == null)
{
getFDICircularIndexRequest = new GetFDICircularIndexRequest();
}
if (getFDICircularIndexRequest.PageSize == null)
{
getFDICircularIndexRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var fDICircularIndex = new FDICircularIndex()
{
FDICircularIndexId = getFDICircularIndexRequest.FDICircularIndexId,
FDICircularId = getFDICircularIndexRequest.FDICircularId,
FDIChapterId = getFDICircularIndexRequest.FDIChapterId,
SearchText = getFDICircularIndexRequest.SearchText,
IsActive = getFDICircularIndexRequest.IsActive,
PageNumber = getFDICircularIndexRequest.PageNumber,
PageSize = Convert.ToInt32(getFDICircularIndexRequest.PageSize),
IsPagingRequired = (getFDICircularIndexRequest.PageNumber != null) ? true : false,
OrderBy = getFDICircularIndexRequest.OrderBy,
OrderByDirection = getFDICircularIndexRequest.OrderByDirection
};
var fDICircularIndexes = iFDICircularIndex.GetFDICircularIndex(fDICircularIndex).OrderBy(x => x.SortId).ToList();
var fDICircularIndexList = new List <GetFDICircularIndexResponse>();
foreach (var fDICircularIndexDetail in fDICircularIndexes)
{
fDICircularIndexList.Add(new GetFDICircularIndexResponse()
{
FDICircularIndexId = Convert.ToInt32(fDICircularIndexDetail.FDICircularIndexId),
FDIChapterId = Convert.ToInt32(fDICircularIndexDetail.FDIChapterId),
IndexNo = fDICircularIndexDetail.IndexNo,
IndexName = fDICircularIndexDetail.IndexName,
IndexContent = fDICircularIndexDetail.IndexContent,
SortId = fDICircularIndexDetail.SortId,
IsActive = Convert.ToBoolean(fDICircularIndexDetail.IsActive),
CreatedBy = fDICircularIndexDetail.CreatedBy,
TotalPageCount = fDICircularIndexDetail.TotalPageCount,
TotalRecord = fDICircularIndexDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FDICircularIndex retrieved successfully";
responses.Response = fDICircularIndexList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving FDICircularIndex.";
Utility.WriteLog("GetFDICircularIndex", getFDICircularIndexRequest, "Error while retrieving FDICircularIndex. (FDICircularUserController)", ex.ToString());
}
return(Ok(responses));
}
