public IHttpActionResult UpdateRBIDataDetail(UpdateRBIDataDetailRequest updateRBIDataDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var rBIDataDetail = new RBIDataDetail()
{
RBIDataDetailId = updateRBIDataDetailRequest.RBIDataDetailId,
RBIDataId = updateRBIDataDetailRequest.RBIDataId,
Month = updateRBIDataDetailRequest.Month,
Year = updateRBIDataDetailRequest.Year,
Excel = updateRBIDataDetailRequest.Excel,
PDF = updateRBIDataDetailRequest.PDF,
ModifiedBy = Utility.UserId
};
int result = iRBIDataDetail.UpdateRBIDataDetail(rBIDataDetail);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RBIDataDetail updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RBIDataDetail already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RBIDataDetail doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating rbidatadetail.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating admin profile.";
Utility.WriteLog("UpdateRBIDataDetail", updateRBIDataDetailRequest, "Error while updating rbidatadetail. (RBIDataDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IEnumerable <RBIDataDetail> GetRBIDataDetail(RBIDataDetail rBIDataDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var rBIDataDetails = dataContext.RBIDataDetailGet(rBIDataDetail.RBIDataDetailId, rBIDataDetail.RBIDataId, rBIDataDetail.Year, rBIDataDetail.Month, Utility.TrimString(rBIDataDetail.SearchText), rBIDataDetail.IsActive, rBIDataDetail.PageNumber, rBIDataDetail.PageSize, rBIDataDetail.IsPagingRequired, Utility.TrimString(rBIDataDetail.OrderBy), Utility.TrimString(rBIDataDetail.OrderByDirection), totalPageCount, totalRecord).ToList();
var rBIDataDetailList = new List <RBIDataDetail>();
foreach (var rBIDataDetailDetail in rBIDataDetails)
{
rBIDataDetailList.Add(new RBIDataDetail()
{
RBIDataDetailId = rBIDataDetailDetail.RBIDataDetailId,
RBIDataId = rBIDataDetailDetail.RBIDataId,
Month = rBIDataDetailDetail.Month,
Year = rBIDataDetailDetail.Year,
Excel = rBIDataDetailDetail.Excel,
PDF = rBIDataDetailDetail.PDF,
IsActive = rBIDataDetailDetail.IsActive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(rBIDataDetailList);
}
}
public int DeleteRBIDataDetail(RBIDataDetail rBIDataDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RBIDataDetailDelete(rBIDataDetail.RBIDataDetailId, rBIDataDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateRBIDataDetail(RBIDataDetail rBIDataDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RBIDataDetailUpdate(rBIDataDetail.RBIDataDetailId, rBIDataDetail.RBIDataId, rBIDataDetail.Month, rBIDataDetail.Year, Utility.TrimString(rBIDataDetail.Excel), Utility.TrimString(rBIDataDetail.PDF), rBIDataDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult DeleteRBIDataDetail(DeleteRBIDataDetailRequest deleteRBIDataDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var rBIDataDetail = new RBIDataDetail()
{
RBIDataDetailId = deleteRBIDataDetailRequest.RBIDataDetailId,
ModifiedBy = Utility.UserId
};
int result = iRBIDataDetail.DeleteRBIDataDetail(rBIDataDetail);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RBIDataDetail deleted successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RBIDataDetail doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting rbidatadetail.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting rbidatadetail.";
Utility.WriteLog("DeleteRBIDataDetail", deleteRBIDataDetailRequest, "Error while deleting rbidatadetail. (RBIDataDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult AddRBIDataDetail(AddRBIDataDetailRequest addRBIDataDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var rBIDataDetail = new RBIDataDetail()
{
RBIDataId = addRBIDataDetailRequest.RBIDataId,
Month = addRBIDataDetailRequest.Month,
Year = addRBIDataDetailRequest.Year,
Excel = addRBIDataDetailRequest.Excel,
PDF = addRBIDataDetailRequest.PDF,
CreatedBy = Utility.UserId
};
int result = iRBIDataDetail.AddRBIDataDetail(rBIDataDetail);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RBIDataDetail added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RBIDataDetail alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding rbidatadetail.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding rbidatadetail.";
Utility.WriteLog("AddRBIDataDetail", addRBIDataDetailRequest, "Error while adding rbidatadetail. (RBIDataDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult GetRBIDataDetail([FromUri] GetRBIDataDetailRequest getRBIDataDetailRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getRBIDataDetailRequest == null)
{
getRBIDataDetailRequest = new GetRBIDataDetailRequest();
}
if (getRBIDataDetailRequest.PageSize == null)
{
getRBIDataDetailRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var rBIDataDetail = new RBIDataDetail()
{
RBIDataDetailId = getRBIDataDetailRequest.RBIDataDetailId,
RBIDataId = getRBIDataDetailRequest.RBIDataId,
Year = getRBIDataDetailRequest.Year,
Month = getRBIDataDetailRequest.Month,
SearchText = getRBIDataDetailRequest.SearchText,
IsActive = getRBIDataDetailRequest.IsActive,
PageNumber = getRBIDataDetailRequest.PageNumber,
PageSize = Convert.ToInt32(getRBIDataDetailRequest.PageSize),
IsPagingRequired = (getRBIDataDetailRequest.PageNumber != null) ? true : false,
OrderBy = getRBIDataDetailRequest.OrderBy,
OrderByDirection = getRBIDataDetailRequest.OrderByDirection
};
var rBIDataDetails = iRBIDataDetail.GetRBIDataDetail(rBIDataDetail);
var rBIDataDetailList = new List <GetRBIDataDetailResponse>();
foreach (var rBIDataDetailDetail in rBIDataDetails)
{
rBIDataDetailList.Add(new GetRBIDataDetailResponse()
{
RBIDataDetailId = Convert.ToInt32(rBIDataDetailDetail.RBIDataDetailId),
RBIDataId = Convert.ToInt32(rBIDataDetailDetail.RBIDataId),
Month = rBIDataDetailDetail.Month,
Year = rBIDataDetailDetail.Year,
Excel = rBIDataDetailDetail.Excel,
PDF = rBIDataDetailDetail.PDF,
IsActive = Convert.ToBoolean(rBIDataDetailDetail.IsActive),
CreatedBy = rBIDataDetailDetail.CreatedBy,
TotalPageCount = rBIDataDetailDetail.TotalPageCount,
TotalRecord = rBIDataDetailDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RBIDataDetail retrieved successfully";
responses.Response = rBIDataDetailList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving rbidatadetail.";
Utility.WriteLog("GetRBIDataDetail", getRBIDataDetailRequest, "Error while retrieving rbidatadetail. (RBIDataDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
