public int DeleteFormSummaryDocumentationDetail(FormSummaryDocumentationDetail formSummaryDocumentationDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FormSummaryDocumentationDetailDelete(formSummaryDocumentationDetail.FormSummaryDocumentationDetailId, formSummaryDocumentationDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateFormSummaryDocumentationDetail(FormSummaryDocumentationDetail formSummaryDocumentationDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FormSummaryDocumentationDetailUpdate(formSummaryDocumentationDetail.FormSummaryDocumentationDetailId, formSummaryDocumentationDetail.FormSummaryDocumentationId, Utility.TrimString(formSummaryDocumentationDetail.FormName), Utility.TrimString(formSummaryDocumentationDetail.WordFileName), Utility.TrimString(formSummaryDocumentationDetail.ExcelFileName), Utility.TrimString(formSummaryDocumentationDetail.PDFFileName), Utility.TrimString(formSummaryDocumentationDetail.SubMenuName), formSummaryDocumentationDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult DeleteFormSummaryDocumentationDetail(DeleteFormSummaryDocumentationDetailRequest deleteFormSummaryDocumentationDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var formSummaryDocumentationDetail = new FormSummaryDocumentationDetail()
{
FormSummaryDocumentationDetailId = deleteFormSummaryDocumentationDetailRequest.FormSummaryDocumentationDetailId,
ModifiedBy = Utility.UserId
};
int result = iFormSummaryDocumentationDetail.DeleteFormSummaryDocumentationDetail(formSummaryDocumentationDetail);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = deleteFormSummaryDocumentationDetailRequest.SubMenuName + "Detail deleted successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = deleteFormSummaryDocumentationDetailRequest.SubMenuName + "Detail doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting " + deleteFormSummaryDocumentationDetailRequest.SubMenuName + "Detail.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting " + deleteFormSummaryDocumentationDetailRequest.SubMenuName + "Detail.";
Utility.WriteLog("DeleteFormSummaryDocumentationDetail", deleteFormSummaryDocumentationDetailRequest, "Error while deleting " + deleteFormSummaryDocumentationDetailRequest.SubMenuName + "Detail. (FormSummaryDocumentationDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult AddFormSummaryDocumentationDetail(AddFormSummaryDocumentationDetailRequest addFormSummaryDocumentationDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var formSummaryDocumentationDetail = new FormSummaryDocumentationDetail()
{
FormSummaryDocumentationId = addFormSummaryDocumentationDetailRequest.FormSummaryDocumentationId,
FormName = addFormSummaryDocumentationDetailRequest.FormName,
WordFileName = addFormSummaryDocumentationDetailRequest.WordFileName,
ExcelFileName = addFormSummaryDocumentationDetailRequest.ExcelFileName,
PDFFileName = addFormSummaryDocumentationDetailRequest.PDFFileName,
SubMenuName = addFormSummaryDocumentationDetailRequest.SubMenuName,
CreatedBy = Utility.UserId
};
int result = iFormSummaryDocumentationDetail.AddFormSummaryDocumentationDetail(formSummaryDocumentationDetail);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = addFormSummaryDocumentationDetailRequest.SubMenuName + "Detail added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = addFormSummaryDocumentationDetailRequest.SubMenuName + "Detail alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding " + addFormSummaryDocumentationDetailRequest.SubMenuName + " Detail";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding " + addFormSummaryDocumentationDetailRequest.SubMenuName + " Detail";
Utility.WriteLog("AddFormSummaryDocumentationDetail", addFormSummaryDocumentationDetailRequest, "Error while adding " + addFormSummaryDocumentationDetailRequest.SubMenuName + "Detail (FormSummaryDocumentationDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IEnumerable <FormSummaryDocumentationDetail> GetFormSummaryDocumentationDetail(FormSummaryDocumentationDetail formSummaryDocumentationDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var formSummaryDocumentationDetails = dataContext.FormSummaryDocumentationDetailGet(formSummaryDocumentationDetail.FormSummaryDocumentationDetailId, formSummaryDocumentationDetail.FormSummaryDocumentationId, Utility.TrimString(formSummaryDocumentationDetail.SubMenuName), Utility.TrimString(formSummaryDocumentationDetail.SearchText), formSummaryDocumentationDetail.IsActive, formSummaryDocumentationDetail.PageNumber, formSummaryDocumentationDetail.PageSize, formSummaryDocumentationDetail.IsPagingRequired, Utility.TrimString(formSummaryDocumentationDetail.OrderBy), Utility.TrimString(formSummaryDocumentationDetail.OrderByDirection), totalPageCount, totalRecord).ToList();
var formSummaryDocumentationDetailList = new List <FormSummaryDocumentationDetail>();
foreach (var formSummaryDocumentationDetailDetail in formSummaryDocumentationDetails)
{
formSummaryDocumentationDetailList.Add(new FormSummaryDocumentationDetail()
{
FormSummaryDocumentationDetailId = formSummaryDocumentationDetailDetail.FormSummaryDocumentationDetailId,
FormSummaryDocumentationId = formSummaryDocumentationDetailDetail.FormSummaryDocumentationId,
FormName = formSummaryDocumentationDetailDetail.FormName,
WordFileName = formSummaryDocumentationDetailDetail.WordFileName,
ExcelFileName = formSummaryDocumentationDetailDetail.ExcelFileName,
PDFFileName = formSummaryDocumentationDetailDetail.PDFFileName,
IsActive = formSummaryDocumentationDetailDetail.IsActive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(formSummaryDocumentationDetailList);
}
}
public IHttpActionResult GetFormSummaryDocumentationDetail([FromUri] GetFormSummaryDocumentationDetailRequest getFormSummaryDocumentationDetailRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getFormSummaryDocumentationDetailRequest == null)
{
getFormSummaryDocumentationDetailRequest = new GetFormSummaryDocumentationDetailRequest();
}
if (getFormSummaryDocumentationDetailRequest.PageSize == null)
{
getFormSummaryDocumentationDetailRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var formSummaryDocumentationDetail = new FormSummaryDocumentationDetail()
{
FormSummaryDocumentationDetailId = getFormSummaryDocumentationDetailRequest.FormSummaryDocumentationDetailId,
FormSummaryDocumentationId = getFormSummaryDocumentationDetailRequest.FormSummaryDocumentationId,
SubMenuName = getFormSummaryDocumentationDetailRequest.SubMenuName,
SearchText = getFormSummaryDocumentationDetailRequest.SearchText,
IsActive = getFormSummaryDocumentationDetailRequest.IsActive,
PageNumber = getFormSummaryDocumentationDetailRequest.PageNumber,
PageSize = Convert.ToInt32(getFormSummaryDocumentationDetailRequest.PageSize),
IsPagingRequired = (getFormSummaryDocumentationDetailRequest.PageNumber != null) ? true : false,
OrderBy = getFormSummaryDocumentationDetailRequest.OrderBy,
OrderByDirection = getFormSummaryDocumentationDetailRequest.OrderByDirection
};
var formSummaryDocumentationDetails = iFormSummaryDocumentationDetail.GetFormSummaryDocumentationDetail(formSummaryDocumentationDetail);
var formSummaryDocumentationDetailList = new List <GetFormSummaryDocumentationDetailResponse>();
foreach (var formSummaryDocumentationDetailDetail in formSummaryDocumentationDetails)
{
formSummaryDocumentationDetailList.Add(new GetFormSummaryDocumentationDetailResponse()
{
FormSummaryDocumentationDetailId = Convert.ToInt32(formSummaryDocumentationDetailDetail.FormSummaryDocumentationDetailId),
FormSummaryDocumentationId = Convert.ToInt32(formSummaryDocumentationDetailDetail.FormSummaryDocumentationId),
FormName = formSummaryDocumentationDetailDetail.FormName,
WordFileName = formSummaryDocumentationDetailDetail.WordFileName,
ExcelFileName = formSummaryDocumentationDetailDetail.ExcelFileName,
PDFFileName = formSummaryDocumentationDetailDetail.PDFFileName,
IsActive = Convert.ToBoolean(formSummaryDocumentationDetailDetail.IsActive),
CreatedBy = formSummaryDocumentationDetailDetail.CreatedBy,
TotalPageCount = formSummaryDocumentationDetailDetail.TotalPageCount,
TotalRecord = formSummaryDocumentationDetailDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = getFormSummaryDocumentationDetailRequest.SubMenuName + "Detail retrieved successfully";
responses.Response = formSummaryDocumentationDetailList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving " + getFormSummaryDocumentationDetailRequest.SubMenuName + "Detail";
Utility.WriteLog("GetFormSummaryDocumentationDetail", getFormSummaryDocumentationDetailRequest, "Error while retrieving " + getFormSummaryDocumentationDetailRequest.SubMenuName + "Detail (FormSummaryDocumentationDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
