public IEnumerable <FetersCodeDetail> GetFetersCodeDetail(FetersCodeDetail fetersCodeDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var fetersCodeDetails = dataContext.FetersCodeDetailGet(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.FetersCodeId, Utility.TrimString(fetersCodeDetail.SearchText), fetersCodeDetail.IsActive, fetersCodeDetail.PageNumber, fetersCodeDetail.PageSize, fetersCodeDetail.IsPagingRequired, Utility.TrimString(fetersCodeDetail.OrderBy), Utility.TrimString(fetersCodeDetail.OrderByDirection), totalPageCount, totalRecord).ToList();
var fetersCodeDetailList = new List <FetersCodeDetail>();
foreach (var fetersCodeDetailDetail in fetersCodeDetails)
{
fetersCodeDetailList.Add(new FetersCodeDetail()
{
FetersCodeId = fetersCodeDetailDetail.FetersCodeId,
FetersCodeDetailId = fetersCodeDetailDetail.FetersCodeDetailId,
GroupNo = fetersCodeDetailDetail.GroupNo,
PurposeGroupName = fetersCodeDetailDetail.PurposeGroupName,
SerialNo = fetersCodeDetailDetail.SerialNo,
LRSItem = fetersCodeDetailDetail.LRSItem,
LRSFetersCode = fetersCodeDetailDetail.LRSFetersCode,
IsActive = fetersCodeDetailDetail.IsActive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(fetersCodeDetailList);
}
}
public IHttpActionResult UpdateFetersCodeDetail(UpdateFetersCodeDetailRequest updateFetersCodeDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var fetersCodeDetail = new FetersCodeDetail()
{
FetersCodeDetailId = updateFetersCodeDetailRequest.FetersCodeDetailId,
FetersCodeId = updateFetersCodeDetailRequest.FetersCodeId,
GroupNo = updateFetersCodeDetailRequest.GroupNo,
PurposeGroupName = updateFetersCodeDetailRequest.PurposeGroupName,
LRSItem = updateFetersCodeDetailRequest.LRSItem,
LRSFetersCode = updateFetersCodeDetailRequest.LRSFetersCode,
ModifiedBy = Utility.UserId
};
int result = iFetersCodeDetail.UpdateFetersCodeDetail(fetersCodeDetail);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating all definition.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating FetersCodeDetail.";
Utility.WriteLog("UpdateFetersCodeDetail", updateFetersCodeDetailRequest, "Error while updating FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public int DeleteFetersCodeDetail(FetersCodeDetail fetersCodeDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FetersCodeDetailDelete(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateFetersCodeDetail(FetersCodeDetail fetersCodeDetail)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.FetersCodeDetailUpdate(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.FetersCodeId, Utility.TrimString(fetersCodeDetail.GroupNo), Utility.TrimString(fetersCodeDetail.PurposeGroupName), Utility.TrimString(fetersCodeDetail.LRSItem), Utility.TrimString(fetersCodeDetail.LRSFetersCode), fetersCodeDetail.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult DeleteFetersCodeDetail(DeleteFetersCodeDetailRequest deleteFetersCodeDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var fetersCodeDetail = new FetersCodeDetail()
{
FetersCodeDetailId = deleteFetersCodeDetailRequest.FetersCodeDetailId,
ModifiedBy = Utility.UserId
};
int result = iFetersCodeDetail.DeleteFetersCodeDetail(fetersCodeDetail);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail deleted successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting FetersCodeDetail.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while deleting FetersCodeDetail.";
Utility.WriteLog("DeleteFetersCodeDetail", deleteFetersCodeDetailRequest, "Error while deleting FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult AddFetersCodeDetail(AddFetersCodeDetailRequest addFetersCodeDetailRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var fetersCodeDetail = new FetersCodeDetail()
{
FetersCodeId = addFetersCodeDetailRequest.FetersCodeId,
GroupNo = addFetersCodeDetailRequest.GroupNo,
PurposeGroupName = addFetersCodeDetailRequest.PurposeGroupName,
LRSItem = addFetersCodeDetailRequest.LRSItem,
LRSFetersCode = addFetersCodeDetailRequest.LRSFetersCode,
CreatedBy = Utility.UserId
};
int result = iFetersCodeDetail.AddFetersCodeDetail(fetersCodeDetail);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding FetersCodeDetail.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding FetersCodeDetail.";
Utility.WriteLog("AddFetersCodeDetail", addFetersCodeDetailRequest, "Error while adding FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult GetFetersCodeDetail([FromUri] GetFetersCodeDetailRequest getFetersCodeDetailRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getFetersCodeDetailRequest == null)
{
getFetersCodeDetailRequest = new GetFetersCodeDetailRequest();
}
if (getFetersCodeDetailRequest.PageSize == null)
{
getFetersCodeDetailRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var fetersCodeDetail = new FetersCodeDetail()
{
FetersCodeDetailId = getFetersCodeDetailRequest.FetersCodeDetailId,
FetersCodeId = getFetersCodeDetailRequest.FetersCodeId,
SearchText = getFetersCodeDetailRequest.SearchText,
IsActive = getFetersCodeDetailRequest.IsActive,
PageNumber = getFetersCodeDetailRequest.PageNumber,
PageSize = Convert.ToInt32(getFetersCodeDetailRequest.PageSize),
IsPagingRequired = (getFetersCodeDetailRequest.PageNumber != null) ? true : false,
OrderBy = getFetersCodeDetailRequest.OrderBy,
OrderByDirection = getFetersCodeDetailRequest.OrderByDirection
};
var fetersCodeDetails = iFetersCodeDetail.GetFetersCodeDetail(fetersCodeDetail);
var fetersCodeDetailList = new List <GetFetersCodeDetailResponse>();
foreach (var fetersCodeDetailDetail in fetersCodeDetails)
{
fetersCodeDetailList.Add(new GetFetersCodeDetailResponse()
{
FetersCodeDetailId = Convert.ToInt32(fetersCodeDetailDetail.FetersCodeDetailId),
FetersCodeId = Convert.ToInt32(fetersCodeDetailDetail.FetersCodeId),
GroupNo = fetersCodeDetailDetail.GroupNo,
PurposeGroupName = fetersCodeDetailDetail.PurposeGroupName,
SerialNo = fetersCodeDetailDetail.SerialNo,
LRSItem = fetersCodeDetailDetail.LRSItem,
LRSFetersCode = fetersCodeDetailDetail.LRSFetersCode,
IsActive = Convert.ToBoolean(fetersCodeDetailDetail.IsActive),
CreatedBy = fetersCodeDetailDetail.CreatedBy,
TotalPageCount = fetersCodeDetailDetail.TotalPageCount,
TotalRecord = fetersCodeDetailDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "FetersCodeDetail retrieved successfully";
responses.Response = fetersCodeDetailList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving FetersCodeDetail.";
Utility.WriteLog("GetFetersCodeDetail", getFetersCodeDetailRequest, "Error while retrieving FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString());
}
return(Ok(responses));
}
