public ActionResult CreateOrEditPurchaseRequestPusat()
{
PurchaseRequestPusatResponse _response = new PurchaseRequestPusatResponse();
if (Request.QueryString["id"] != null)
{
var request = new PurchaseRequestPusatRequest
{
Data = new PurchaseRequestPusatModel
{
Id = long.Parse(Request.QueryString["id"].ToString())
}
};
PurchaseRequestPusatResponse resp = new PurchaseRequestPusatHandler(_unitOfWork).GetDetail(request);
PurchaseRequestPusatModel _model = resp.Entity;
ViewBag.Response = _response;
return(View(_model));
}
else
{
ViewBag.Response = _response;
ViewBag.ActionType = ClinicEnums.Action.Add;
return(View());
}
}
public JsonResult CreateOrEditPurchaseRequestPusat(PurchaseRequestPusatModel _purchaserequestpusat, List <PurchaseRequestPusatDetailModel> purchaserequestpusatDetailModels)
{
if (Session["UserLogon"] != null)
{
_purchaserequestpusat.Account = (AccountModel)Session["UserLogon"];
}
_purchaserequestpusat.Id = Convert.ToInt32(_purchaserequestpusat.Id) > 0 ? _purchaserequestpusat.Id : 0;
_purchaserequestpusat.GudangId = OneLoginSession.Account.GudangID > 0 ? OneLoginSession.Account.GudangID : 0;
var request = new PurchaseRequestPusatRequest
{
Data = _purchaserequestpusat
};
PurchaseRequestPusatResponse _response = new PurchaseRequestPusatResponse();
new PurchaseRequestPusatValidator(_unitOfWork).Validate(request, out _response);
if (purchaserequestpusatDetailModels != null)
{
foreach (var item in purchaserequestpusatDetailModels)
{
var purchaserequestpusatdetailrequest = new PurchaseRequestPusatDetailRequest
{
Data = item
};
purchaserequestpusatdetailrequest.Data.PurchaseRequestPusatId = Convert.ToInt32(_response.Entity.Id);
purchaserequestpusatdetailrequest.Data.Account = (AccountModel)Session["UserLogon"];
//
var requestnamabarang = new ProductRequest
{
Data = new ProductModel
{
Id = item.ProductId
}
};
var requestnamavendor = new VendorRequest
{
Data = new VendorModel
{
Id = item.VendorId
}
};
ProductResponse namabarang = new ProductHandler(_unitOfWork).GetDetail(requestnamabarang);
VendorResponse namavendor = new VendorHandler(_unitOfWork).GetDetail(requestnamavendor);
purchaserequestpusatdetailrequest.Data.namabarang = namabarang.Entity.Name;
purchaserequestpusatdetailrequest.Data.namavendor = namavendor.Entity.namavendor;
PurchaseRequestPusatDetailResponse _purchaserequestpusatdetailresponse = new PurchaseRequestPusatDetailResponse();
new PurchaseRequestPusatDetailValidator(_unitOfWork).Validate(purchaserequestpusatdetailrequest, out _purchaserequestpusatdetailresponse);
}
}
return(Json(new { data = _response.Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateOrEditPurchaseRequest()
{
var lastprnumber = _context.PurchaseRequestPusats.OrderByDescending(x => x.CreatedDate).Select(a => a.prnumber).FirstOrDefault();
DateTime?getmonth = _context.PurchaseRequestPusats.OrderByDescending(x => x.CreatedDate).Select(a => a.CreatedDate).FirstOrDefault();
DateTime?month = getmonth != null ? getmonth : DateTime.Now;
string prnumber = lastprnumber != null?GeneralHandler.stringincrement(lastprnumber, Convert.ToDateTime(month)) : "00001";
PurchaseRequestPusatResponse _response = new PurchaseRequestPusatResponse();
if (Request.QueryString["id"] != null)
{
var request = new PurchaseRequestPusatRequest
{
Data = new PurchaseRequestPusatModel
{
Id = long.Parse(Request.QueryString["id"].ToString())
}
};
PurchaseRequestPusatResponse resp = new PurchaseRequestPusatHandler(_unitOfWork).GetDetail(request);
PurchaseRequestPusatModel _model = resp.Entity;
ViewBag.Response = _response;
return(View(_model));
}
else
{
if ((GeneralHandler.authorized("ADD_M_PURCHASEREQUESTPUSAT") == "false"))
{
return(RedirectToAction("PurchaseRequestList"));
}
ViewBag.Response = _response;
ViewBag.ActionType = ClinicEnums.Action.Add;
ViewBag.prnumber = "PR" + ((AccountModel)Session["UserLogon"]).Organization + DateTime.Now.Year + DateTime.Now.Month + prnumber;
return(View());
}
}
public ActionResult PrintPurchaseRequestPusat(int id)
{
PurchaseRequestPusatResponse _response = new PurchaseRequestPusatResponse();
var request = new PurchaseRequestPusatRequest
{
Data = new PurchaseRequestPusatModel
{
Id = id
}
};
PurchaseRequestPusatResponse resp = new PurchaseRequestPusatHandler(_unitOfWork).GetDetail(request);
PurchaseRequestPusatModel _model = resp.Entity;
ViewBag.Response = _response;
return(new PartialViewAsPdf(_model)
{
PageOrientation = Orientation.Portrait,
PageSize = Size.Folio,
FileName = "PurchaseRequestPusat" + _model.prnumber + ".pdf"
});
}
public PurchaseRequestPusatResponse GetListData(PurchaseRequestPusatRequest request)
{
List <PurchaseRequestPusatModel> lists = new List <PurchaseRequestPusatModel>();
dynamic qry = null;
var searchPredicate = PredicateBuilder.New <Data.DataRepository.PurchaseRequestPusat>(true);
// add default filter to show the active data only
searchPredicate = searchPredicate.And(x => x.RowStatus == 0);
if ((GeneralHandler.authorized("APPROVE_M_PURCHASEREQUESTPUSAT") == "false"))
{
searchPredicate.And(x => x.approve >= 1);
}
if (!String.IsNullOrEmpty(request.SearchValue) && !String.IsNullOrWhiteSpace(request.SearchValue))
{
searchPredicate = searchPredicate.And(p => p.prnumber.Contains(request.SearchValue));
}
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
if (request.SortColumnDir == "asc")
{
switch (request.SortColumn.ToLower())
{
case "prnumber":
qry = _unitOfWork.PurchaseRequestPusatRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.prnumber));
break;
default:
qry = _unitOfWork.PurchaseRequestPusatRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.id));
break;
}
}
else
{
switch (request.SortColumn.ToLower())
{
case "prnumber":
qry = _unitOfWork.PurchaseRequestPusatRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.prnumber));
break;
default:
qry = _unitOfWork.PurchaseRequestPusatRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.id));
break;
}
}
}
else
{
qry = _unitOfWork.PurchaseRequestPusatRepository.Get(searchPredicate, null);
}
List <Data.DataRepository.PurchaseRequestPusat> purchaseRequests = new List <Data.DataRepository.PurchaseRequestPusat>();
purchaseRequests = qry;
foreach (var item in purchaseRequests)
{
var prData = new PurchaseRequestPusatModel
{
Id = item.id,
prnumber = item.prnumber,
prdate = item.prdate,
approve_by = item.approve_by,
approve = item.approve,
request_by = item.request_by,
ModifiedBy = item.ModifiedBy,
CreatedBy = item.CreatedBy,
ModifiedDate = item.ModifiedDate,
createformat = GeneralHandler.FormatDate(Convert.ToDateTime(item.CreatedDate)),
Validasi = item.Validasi,
poid = item.PurchaseOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().id : 0,
ponumber = item.PurchaseOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().ponumber : "",
createpo = item.PurchaseOrderPusats.Count > 0 ? GeneralHandler.FormatDate(Convert.ToDateTime(item.PurchaseOrderPusats.FirstOrDefault().podate)) : null,
doid = item.PurchaseOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.FirstOrDefault().id : 0 : 0,
donumber = item.PurchaseOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.FirstOrDefault().donumber : "" : "",
createdo = item.PurchaseOrderPusats.Count > 0 ? item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.Count > 0 ? GeneralHandler.FormatDate(Convert.ToDateTime(item.PurchaseOrderPusats.FirstOrDefault().DeliveryOrderPusats.FirstOrDefault().dodate)) : null : null,
status = GeneralHandler.PurchaseRequestPusatStatus(item.id),
};
lists.Add(prData);
}
int totalRequest = lists.Count();
var data = lists.Skip(request.Skip).Take(request.PageSize).ToList();
var response = new PurchaseRequestPusatResponse
{
Draw = request.Draw,
RecordsFiltered = totalRequest,
RecordsTotal = totalRequest,
Data = data
};
return(response);
}
