public IEnumerable <RulesIndexAmendment> GetRulesIndexAmendment(RulesIndexAmendment indexAmendment)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var indexAmendments = dataContext.RulesIndexAmendmentGet(indexAmendment.RulesIndexAmendmentId, indexAmendment.RulesId, Utility.TrimString(indexAmendment.SearchText), indexAmendment.IsActive, indexAmendment.PageNumber, indexAmendment.PageSize, indexAmendment.IsPagingRequired, Utility.TrimString(indexAmendment.OrderBy), Utility.TrimString(indexAmendment.OrderByDirection), totalPageCount, totalRecord).ToList();
var indexAmendmentList = new List <RulesIndexAmendment>();
foreach (var indexAmendmentDetail in indexAmendments)
{
indexAmendmentList.Add(new RulesIndexAmendment()
{
RulesIndexAmendmentId = indexAmendmentDetail.RulesIndexAmendmentId,
RulesId = indexAmendmentDetail.RulesId,
GSRNotificationIds = indexAmendmentDetail.GSRNotificationIds,
GSRNotifications = indexAmendmentDetail.GSRNotifications,
IndexId = indexAmendmentDetail.IndexId,
IndexNo = indexAmendmentDetail.IndexNo,
IndexName = indexAmendmentDetail.Indexname,
SubIndexId = indexAmendmentDetail.SubIndexId,
SubIndexNo = indexAmendmentDetail.RuleSubIndexNo,
SubIndexName = indexAmendmentDetail.RuleSubIndexName,
IndexAmendmentContent = indexAmendmentDetail.IndexAmendmentContent,
IsActive = indexAmendmentDetail.IsActive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(indexAmendmentList);
}
}
public IHttpActionResult UpdateRulesIndexAmendment(UpdateRulesIndexAmendmentRequest updateRulesIndexAmendmentRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var rulesIndexAmendment = new RulesIndexAmendment()
{
RulesIndexAmendmentId = updateRulesIndexAmendmentRequest.RulesIndexAmendmentId,
RulesId = updateRulesIndexAmendmentRequest.RulesId,
GSRNotificationIds = updateRulesIndexAmendmentRequest.GSRNotificationIds,
IndexId = updateRulesIndexAmendmentRequest.IndexId,
SubIndexId = updateRulesIndexAmendmentRequest.SubIndexId,
IndexAmendmentContent = updateRulesIndexAmendmentRequest.IndexAmendmentContent,
ModifiedBy = Utility.UserId
};
int result = iRulesIndexAmendment.UpdateRulesIndexAmendment(rulesIndexAmendment);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating index amendment.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating index amendment.";
Utility.WriteLog("UpdateRulesIndexAmendment", updateRulesIndexAmendmentRequest, "Error while updating index amendment. (RulesIndexAmendmentAdminController)", ex.ToString());
}
return(Ok(responses));
}
public int DeleteRulesIndexAmendment(RulesIndexAmendment indexAmendment)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RulesIndexAmendmentDelete(indexAmendment.RulesIndexAmendmentId, indexAmendment.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateRulesIndexAmendment(RulesIndexAmendment indexAmendment)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RulesIndexAmendmentUpdate(indexAmendment.RulesIndexAmendmentId, indexAmendment.RulesId, indexAmendment.GSRNotificationIds, indexAmendment.IndexId, indexAmendment.SubIndexId, Utility.TrimString(indexAmendment.IndexAmendmentContent), indexAmendment.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult AddRulesIndexAmendment(AddRulesIndexAmendmentRequest addRulesIndexAmendmentRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var rulesIndexAmendment = new RulesIndexAmendment()
{
RulesId = addRulesIndexAmendmentRequest.RulesId,
GSRNotificationIds = addRulesIndexAmendmentRequest.GSRNotificationIds,
IndexId = addRulesIndexAmendmentRequest.IndexId,
SubIndexId = addRulesIndexAmendmentRequest.SubIndexId,
IndexAmendmentContent = addRulesIndexAmendmentRequest.IndexAmendmentContent
};
int result = iRulesIndexAmendment.AddRulesIndexAmendment(rulesIndexAmendment);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding index amendment.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding index amendment.";
Utility.WriteLog("AddRulesIndexAmendment", addRulesIndexAmendmentRequest, "Error while adding index amendment. (RulesIndexAmendmentAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult GetRulesIndexAmendment([FromUri] GetRulesIndexAmendmentRequest getRulesIndexAmendmentRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getRulesIndexAmendmentRequest == null)
{
getRulesIndexAmendmentRequest = new GetRulesIndexAmendmentRequest();
}
if (getRulesIndexAmendmentRequest.PageSize == null)
{
getRulesIndexAmendmentRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var rulesIndexAmendment = new RulesIndexAmendment()
{
RulesIndexAmendmentId = getRulesIndexAmendmentRequest.RulesIndexAmendmentId,
RulesId = getRulesIndexAmendmentRequest.RulesId,
SearchText = getRulesIndexAmendmentRequest.SearchText,
IsActive = getRulesIndexAmendmentRequest.IsActive,
PageNumber = getRulesIndexAmendmentRequest.PageNumber,
PageSize = Convert.ToInt32(getRulesIndexAmendmentRequest.PageSize),
IsPagingRequired = (getRulesIndexAmendmentRequest.PageNumber != null) ? true : false,
OrderBy = getRulesIndexAmendmentRequest.OrderBy,
OrderByDirection = getRulesIndexAmendmentRequest.OrderByDirection
};
var rulesIndexAmendments = iRulesIndexAmendment.GetRulesIndexAmendment(rulesIndexAmendment);
var rulesIndexAmendmentList = new List <GetRulesIndexAmendmentResponse>();
foreach (var rulesIndexAmendmentDetail in rulesIndexAmendments)
{
rulesIndexAmendmentList.Add(new GetRulesIndexAmendmentResponse()
{
RulesIndexAmendmentId = rulesIndexAmendmentDetail.RulesIndexAmendmentId,
RulesId = rulesIndexAmendmentDetail.RulesId,
GSRNotifications = rulesIndexAmendmentDetail.GSRNotifications,
IndexId = rulesIndexAmendmentDetail.IndexId,
IndexNo = rulesIndexAmendmentDetail.IndexNo,
IndexName = rulesIndexAmendmentDetail.IndexName,
SubIndexId = rulesIndexAmendmentDetail.SubIndexId,
SubIndexNo = rulesIndexAmendmentDetail.SubIndexNo,
SubIndexName = rulesIndexAmendmentDetail.SubIndexName,
IndexAmendmentContent = rulesIndexAmendmentDetail.IndexAmendmentContent,
IsActive = Convert.ToBoolean(rulesIndexAmendmentDetail.IsActive),
CreatedBy = rulesIndexAmendmentDetail.CreatedBy,
TotalPageCount = rulesIndexAmendmentDetail.TotalPageCount,
TotalRecord = rulesIndexAmendmentDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndexAmendment retrieved successfully";
responses.Response = rulesIndexAmendmentList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving index amendment.";
Utility.WriteLog("GetRulesIndexAmendment", getRulesIndexAmendmentRequest, "Error while retrieving index amendment. (RulesOfFEMASubModuleDetailUserController)", ex.ToString());
}
return(Ok(responses));
}
