public ActionResult GetMyTransferNotes(JQueryDataTableParamModel param)
{
try
{
var userInfo = GetSignedOnUser();
if (userInfo == null || userInfo.UserProfile.Id < 1)
{
return(Json(new List <TransferNoteObject>(), JsonRequestBehavior.AllowGet));
}
IEnumerable <TransferNoteObject> filteredTransferNoteObjects;
int countG;
var pagedParentMenuObjects = new TransferNoteServices().GetTransferNotesByEmployee(param.iDisplayLength, param.iDisplayStart, out countG, userInfo.UserProfile.Id);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredTransferNoteObjects = new TransferNoteServices().SearchEmployeeTransferNote(param.sSearch, userInfo.UserProfile.Id);
countG = filteredTransferNoteObjects.Count();
}
else
{
filteredTransferNoteObjects = pagedParentMenuObjects;
}
if (!filteredTransferNoteObjects.Any())
{
return(Json(new List <TransferNoteObject>(), JsonRequestBehavior.AllowGet));
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <TransferNoteObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.TransferNoteNumber : sortColumnIndex == 2 ? c.DateGeneratedStr :
sortColumnIndex == 3 ? c.SourceOutletName : sortColumnIndex == 4 ? c.TargetOutletName : sortColumnIndex == 5 ? c.GeneratedBy : sortColumnIndex == 6 ? c.TotalAmountStr : c.StatusStr);
var sortDirection = Request["sSortDir_0"]; // asc or desc
filteredTransferNoteObjects = sortDirection == "desc" ? filteredTransferNoteObjects.OrderBy(orderingFunction) : filteredTransferNoteObjects.OrderByDescending(orderingFunction);
var displayedPersonnels = filteredTransferNoteObjects;
var result = from c in displayedPersonnels
select new[] { Convert.ToString(c.Id), c.TransferNoteNumber, c.DateGeneratedStr,
c.SourceOutletName, c.TargetOutletName, c.GeneratedBy, c.TotalAmountStr, c.DateTransferdStr, c.StatusStr };
return(Json(new
{
param.sEcho,
iTotalRecords = countG,
iTotalDisplayRecords = countG,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(Json(new List <TransferNoteObject>(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult ConvertTransferNoteToInvoice(string transferNoteNumber)
{
try
{
var selectables = new TransferNoteServices().ConvertTransferNoteToInvoice(transferNoteNumber);
return(Json(selectables, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new StockGenericObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetTransferNoteByRef(string refNumber)
{
try
{
if (string.IsNullOrEmpty(refNumber))
{
return(Json(new TransferNoteObject(), JsonRequestBehavior.AllowGet));
}
var transferNoteDetails = new TransferNoteServices().GetTransferNoteByRef(refNumber);
return(Json(transferNoteDetails, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new TransferNoteObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetTransferNoteDetails(long id)
{
try
{
if (id < 1)
{
return(Json(new TransferNoteObject(), JsonRequestBehavior.AllowGet));
}
var transferNoteDetails = new TransferNoteServices().GetTransferNoteDetails(id);
return(Json(transferNoteDetails, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new TransferNoteObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditTransferNote(TransferNoteObject transferNote)
{
var gVal = new GenericValidator();
try
{
var valStatus = ValidateTransferNote(transferNote);
if (valStatus.Code < 1)
{
gVal.Code = 0;
gVal.Error = valStatus.Error;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var userInfo = GetSignedOnUser();
if (userInfo == null || userInfo.UserProfile.Id < 1)
{
gVal.Code = -1;
gVal.Error = "Your session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var k = new TransferNoteServices().UpdateTransferNote(transferNote);
if (k < 1)
{
gVal.Error = message_Feedback.Update_Failure;
gVal.Code = 0;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = k;
gVal.ReferenceCode = transferNote.TransferNoteNumber;
gVal.Error = message_Feedback.Update_Success;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch
{
gVal.Code = -1;
gVal.Error = message_Feedback.Process_Failed;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteTransferNote(long id)
{
var gVal = new GenericValidator();
try
{
if (id < 1)
{
gVal.Code = -1;
gVal.Error = "Invalid selection!";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var status = new TransferNoteServices().DeleteTransferNote(id);
return(Json(status, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new StockGenericObject(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddTransferNote(TransferNoteObject transferNote)
{
var gVal = new GenericValidator();
try
{
var valStatus = ValidateTransferNote(transferNote);
if (valStatus.Code < 1)
{
gVal.Code = -1;
gVal.Error = valStatus.Error;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
var userInfo = GetSignedOnUser();
if (userInfo == null || userInfo.UserProfile.Id < 1)
{
gVal.Code = -1;
gVal.Error = "Your session has timed out.";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
if (!transferNote.TransferNoteItemObjects.Any())
{
gVal.Code = -1;
gVal.Error = message_Feedback.Sold_Item_List_Error;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
if (transferNote.TransferNoteItemObjects.Any(y => y.TotalQuantityRaised < 1 || y.Rate < 1 || y.TotalAmountRaised < 1))
{
gVal.Code = -1;
gVal.Error = "Please review the selected product(s) and try again";
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
transferNote.Status = (int)TransfereNoteStatus.Pending;
transferNote.GeneratedByUserId = userInfo.UserProfile.Id;
transferNote.DateGenerated = DateTime.Now;
var transferNoteNumber = "";
var k = new TransferNoteServices().AddTransferNote(transferNote, out transferNoteNumber);
if (k < 1)
{
gVal.Error = message_Feedback.Insertion_Failure;
gVal.Code = -1;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = k;
gVal.Error = message_Feedback.Insertion_Success;
gVal.Date = transferNote.DateGenerated.ToString("dd/MM/yyyy");
gVal.ReferenceCode = transferNoteNumber;
gVal.Time = transferNote.DateGenerated.ToString("hh:mm:ss tt");
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
gVal.Code = -1;
gVal.Error = message_Feedback.Process_Failed;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
