public IEnumerable <FemaSubIndex> GetFemaSubIndex(FemaSubIndex femaSubIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var femaSubIndexes = dataContext.FemaSubIndexGet(femaSubIndex.SubIndexId, femaSubIndex.IndexId, femaSubIndex.RegulationId, Utility.TrimString(femaSubIndex.SearchText), femaSubIndex.IsActive, femaSubIndex.PageNumber, femaSubIndex.PageSize, femaSubIndex.IsPagingRequired, Utility.TrimString(femaSubIndex.OrderBy), Utility.TrimString(femaSubIndex.OrderByDirection), totalPageCount, totalRecord).ToList();
var femaSubIndexList = new List <FemaSubIndex>();
foreach (var femaSubIndexDetail in femaSubIndexes)
{
femaSubIndexList.Add(new FemaSubIndex()
{
SubIndexId = femaSubIndexDetail.FemaSubIndexId,
IndexId = femaSubIndexDetail.IndexId,
SubIndexNo = femaSubIndexDetail.SubIndexNumber,
SubIndexName = femaSubIndexDetail.SubIndexName,
SubIndexContent = femaSubIndexDetail.SubIndexContent,
SortId = femaSubIndexDetail.SortId,
IsActive = femaSubIndexDetail.Isactive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(femaSubIndexList);
}
}
public IHttpActionResult UpdateFemaSubIndex(UpdateFemaSubIndexRequest updateFemaSubIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var femaSubIndex = new FemaSubIndex()
{
SubIndexId = updateFemaSubIndexRequest.SubIndexId,
IndexId = updateFemaSubIndexRequest.IndexId,
SubIndexNo = updateFemaSubIndexRequest.SubIndexNo,
SubIndexName = updateFemaSubIndexRequest.SubIndexName,
SubIndexContent = updateFemaSubIndexRequest.SubIndexContent,
SaveAfterSubIndexId = updateFemaSubIndexRequest.SaveAfterSubIndexId,
ModifiedBy = Utility.UserId
};
int result = iFemaSubIndex.UpdateFemaSubIndex(femaSubIndex);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FemaSubIndex updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FemaSubIndex already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FemaSubIndex doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating fema subindex.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating fema subindex.";
Utility.WriteLog("UpdateFemaSubIndex", updateFemaSubIndexRequest, "Error while updating fema subindex. (FemaSubIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public int DeleteFemaSubIndex(FemaSubIndex femaSubIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FemaSubIndexDelete(femaSubIndex.SubIndexId, femaSubIndex.IndexId, femaSubIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateFemaSubIndex(FemaSubIndex femaSubIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FemaSubIndexUpdate(femaSubIndex.SubIndexId, femaSubIndex.IndexId, Utility.TrimString(femaSubIndex.SubIndexNo), Utility.TrimString(femaSubIndex.SubIndexName), Utility.TrimString(femaSubIndex.SubIndexContent), femaSubIndex.SaveAfterSubIndexId, femaSubIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult AddFemaSubIndex(AddFemaSubIndexRequest addFemaSubIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var femaSubIndex = new FemaSubIndex()
{
IndexId = addFemaSubIndexRequest.IndexId,
SubIndexNo = addFemaSubIndexRequest.SubIndexNo,
SubIndexName = addFemaSubIndexRequest.SubIndexName,
SubIndexContent = addFemaSubIndexRequest.SubIndexContent,
SaveAfterSubIndexId = addFemaSubIndexRequest.SaveAfterSubIndexId
};
int result = iFemaSubIndex.AddFemaSubIndex(femaSubIndex);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FemaSubIndex added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FemaSubIndex alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding fema subindex.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding fema subindex.";
Utility.WriteLog("AddFemaSubIndex", addFemaSubIndexRequest, "Error while adding fema subindex. (FemaSubIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult GetFemaSubIndex([FromUri] GetFemaSubIndexRequest getFemaSubIndexRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getFemaSubIndexRequest == null)
{
getFemaSubIndexRequest = new GetFemaSubIndexRequest();
}
if (getFemaSubIndexRequest.PageSize == null)
{
getFemaSubIndexRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var femaSubIndex = new FemaSubIndex()
{
SubIndexId = getFemaSubIndexRequest.SubIndexId,
IndexId = getFemaSubIndexRequest.IndexId,
RegulationId = getFemaSubIndexRequest.RegulationId,
SearchText = getFemaSubIndexRequest.SearchText,
IsActive = getFemaSubIndexRequest.IsActive,
PageNumber = getFemaSubIndexRequest.PageNumber,
PageSize = Convert.ToInt32(getFemaSubIndexRequest.PageSize),
IsPagingRequired = (getFemaSubIndexRequest.PageNumber != null) ? true : false,
OrderBy = getFemaSubIndexRequest.OrderBy,
OrderByDirection = getFemaSubIndexRequest.OrderByDirection
};
var femaSubIndexes = iFemaSubIndex.GetFemaSubIndex(femaSubIndex).OrderBy(x => x.SortId).ToList();
var femaSubIndexList = new List <GetFemaSubIndexResponse>();
foreach (var femaSubIndexDetail in femaSubIndexes)
{
femaSubIndexList.Add(new GetFemaSubIndexResponse()
{
SubIndexId = Convert.ToInt32(femaSubIndexDetail.SubIndexId),
IndexId = Convert.ToInt32(femaSubIndexDetail.IndexId),
SubIndexNo = femaSubIndexDetail.SubIndexNo,
SubIndexName = femaSubIndexDetail.SubIndexName,
SubIndexContent = femaSubIndexDetail.SubIndexContent,
SortId = femaSubIndexDetail.SortId,
IsActive = Convert.ToBoolean(femaSubIndexDetail.IsActive),
CreatedBy = femaSubIndexDetail.CreatedBy,
TotalPageCount = femaSubIndexDetail.TotalPageCount,
TotalRecord = femaSubIndexDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FemaSubIndex retrieved successfully";
responses.Response = femaSubIndexList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving fema subindex.";
Utility.WriteLog("GetFemaSubIndex", getFemaSubIndexRequest, "Error while retrieving fema subindex. (FEMASubModuleDetailUserController)", ex.ToString());
}
return(Ok(responses));
}
