public HttpResponseMessage Get(string id) { if (string.IsNullOrEmpty(id)) { return new HttpResponseMessage() { StatusCode = HttpStatusCode.BadRequest } } ; ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; Register register = RegisterDA.GetRegister(Convert.ToInt32(id), p.Claims); if (register == null) { return new HttpResponseMessage() { StatusCode = HttpStatusCode.NotFound } } ; HttpResponseMessage response = new HttpResponseMessage(); HttpContent content = new ObjectContent(typeof(Register), register, new JsonMediaTypeFormatter()); response.Content = content; response.StatusCode = HttpStatusCode.OK; return(response); }
public ActionResult ShowAssignedRegisters() { List <Organisation> oList = OrganisationDA.GetOrganisations(); List <RegistersOrganisation> orList = Register_OrganisationDA.GetOrganisation_Registers(); List <Register> registers = new List <Register>(); List <Register>[] rList = new List <Register> [oList.Count]; int i = 0; for (i = 0; i < rList.Length; i++) { rList[i] = new List <Register>(); } i = 0; foreach (Organisation o in oList) { foreach (RegistersOrganisation or in orList) { if (or.Organisationid == o.ID) { rList[i].Add(RegisterDA.GetRegisters(or.RegisterId)); } } i++; } ViewBag.Organisations = oList; ViewBag.Registers = rList; return(View()); }
public ActionResult Create(OrganisationRegister organisationRegister) { //hier kan ik niet werken met ModelState.IsValid doordat ik in niet alle waarden ophaal van het model OrganisationRegister if (organisationRegister.Organisation.ID != 0 && !string.IsNullOrEmpty(organisationRegister.Register.RegisterName) && !string.IsNullOrEmpty(organisationRegister.Register.Device) && organisationRegister.Register.PurchaseDate != null && organisationRegister.Register.ExpiresDate != null) { //als er geen organisatie is toegekend, een record plaatsen in de tussentabel met "default" datums if (organisationRegister.Organisation.ID == -1) { organisationRegister.FromDate = new DateTime(1970, 1, 1, 12, 0, 0); organisationRegister.UntilDate = new DateTime(1970, 1, 1, 12, 0, 0); } //indien er wel een organisatie is toegekend, dag van en tot datum instellen //dag van vandaag nemen voor "van" datum en niet gekocht op datum: kassa kan bv. gisteren aangekocht zijn en vandaag pas toegekend zijn //voor "tot" datum vervaldag nemen: wanneer kassa vervalt, is de kassa ook niet meer in het bedrijf else { organisationRegister.FromDate = DateTime.Today; organisationRegister.UntilDate = organisationRegister.Register.ExpiresDate; } int registerID = RegisterDA.CreateRegister(organisationRegister.Register); RegisterDA.CreateRegisterOrganisation(organisationRegister, registerID); } return(RedirectToAction("Index")); }
public ActionResult New(Register r) { if (ModelState.IsValid) { RegisterDA.InsertRegister(r); return(RedirectToAction("Index")); } return(View("New")); }
public HttpResponseMessage Post(EmployeeRegister er) { int id = RegisterDA.InsertEmployeeRegister(er); HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK); message.Content = new StringContent(id.ToString()); return(message); }
public ActionResult ShowAvailableRegisters() { List <Register> lijst = RegisterDA.GetRegisters(); if (lijst.Count > 0) { return(View(lijst)); } else { return(View("Error")); } }
public HttpResponseMessage Delete(int id) { try { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; RegisterDA.DeleteRegister(id, p.Claims); return(new HttpResponseMessage(HttpStatusCode.OK)); } catch { return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }
public ActionResult Create(PMOrganisationRegister reg) { reg.Organisations = GetOrganisations(); if (ModelState.IsValid) { reg.DataOrganisationRegister.Organisation = OrganisationDA.GetOrganisation(reg.DataOrganisationRegister.OrganisationID); int id = RegisterDA.Save(reg.DataOrganisationRegister); return(RedirectToAction("Index")); } return(View(reg)); }
public ActionResult Edit(int?id) { if (!id.HasValue) { return(RedirectToAction("Index")); } OrganisationRegister organisationRegister = RegisterDA.GetRegisterByID(id.Value); if (organisationRegister.ID == 0) { return(RedirectToAction("Index")); } ViewBag.Organisations = OrganisationDA.GetOrganisations(); return(View(organisationRegister)); }
public ActionResult Edit(OrganisationRegister organisationRegister) { //nog extra controle: geldig id if (organisationRegister.ID == 0) { return(RedirectToAction("Index")); } //bestaand record ophalen OrganisationRegister orOud = RegisterDA.GetRegisterByID(organisationRegister.ID); //controle of organisatie wel bestaat if (orOud.Organisation == null) { return(RedirectToAction("Index")); } //van beschikbaar (geen organisatie) naar niet beschikbaar (wel een organisatie) if (orOud.Organisation.ID == -1 && organisationRegister.Organisation.ID != -1) { organisationRegister.FromDate = DateTime.Today; organisationRegister.UntilDate = orOud.Register.ExpiresDate; } //van niet beschikbaar (wel een organisatie) naar beschikbaar (geen organisatie) else if (orOud.Organisation.ID != -1 && organisationRegister.Organisation.ID == -1) { organisationRegister.FromDate = new DateTime(1970, 1, 1, 12, 0, 0); organisationRegister.UntilDate = new DateTime(1970, 1, 1, 12, 0, 0); } //bv. veranderen van organisatie: van en tot datum behouden else { organisationRegister.FromDate = orOud.FromDate; organisationRegister.UntilDate = orOud.UntilDate; } RegisterDA.UpdateRegisterOrganisation(organisationRegister); return(RedirectToAction("Index")); }
public ActionResult AssignToOrganisation(int regid, int orgid) { RegistersOrganisation ro = new RegistersOrganisation() { RegisterId = regid, Organisationid = orgid, From = DateTime.Now.Date, Untill = DateTime.Now.Date.AddYears(10) }; Register_OrganisationDA.InsertOrganisation_Register(ro); Register_OrganisationDA.ModifyRegisterAssignValue(regid); Organisation o = OrganisationDA.GetOrganisations(orgid); Register r = RegisterDA.GetRegisters(regid); RegisterClientDAcs.ChangeConnectionString("System.Data.SqlClient", "MCT-NIELS" + @"\DATAMANAGEMENT", Cryptography.Decrypt(o.DbName), Cryptography.Decrypt(o.DbLogin), Cryptography.Decrypt(o.DbPassword)); RegisterClientDAcs.InsertRegister(r); return(View("Succeeded")); }
public HttpResponseMessage Put(Register updateRegister) { try { if (updateRegister == null) { throw new HttpResponseException(AddRequest(HttpStatusCode.BadRequest, "parameter is empty")); } ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; int id = RegisterDA.ModifyRegister(updateRegister, p.Claims); HttpResponseMessage response = new HttpResponseMessage(); string url = string.Format("{0}{1}", HttpContext.Current.Request.Url.ToString(), id); response.Headers.Location = new Uri(url); response.StatusCode = HttpStatusCode.Created; return(response); } catch { return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }
//geen httpget of httppost bijzetten --> eerste keer laden: get, inladen met dropdownlist --> post public ActionResult Index(string sort) { List <OrganisationRegister> organisationsRegisters = new List <OrganisationRegister>(); organisationsRegisters = RegisterDA.GetOrganisationsWithRegisters(); //vereniging die geen vereniging is niet in viewbag plaatsen //--> wordt handmatig in dropdownlist (view) geplaatst voor beter naamgeving ViewBag.Organisations = OrganisationDA.GetOrganisations().Where(r => r.ID != -1); //bij het opstarten en bij het klikken op alle kassa's --> alles weergeven if (sort == null || sort == "allRegisters") { ViewBag.titleRegisters = "Alle kassa's"; return(View(organisationsRegisters)); //bij het klikken op beschikbare kassa's --> enkel records weergeven zonder organisatie } else if (sort == "availableRegisters") { ViewBag.titleRegisters = "Beschikbare kassa's"; return(View(organisationsRegisters.Where(or => or.Organisation.ID == -1))); //standaard sorteren op de aangeklikte organisatie } else { Organisation organisation = OrganisationDA.GetOrganisationByID(Convert.ToInt32(sort)); if (organisation == null) { return(RedirectToAction("Index")); } ViewBag.titleRegisters = "Kassa's van vereniging " + organisation.OrganisationName; return(View(organisationsRegisters.Where(or => or.Organisation.ID == Convert.ToInt32(sort)))); } }
// GET: api/Register/5 public Register Get(int id) { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; return(RegisterDA.GetRegister(id, p.Claims)); }
public static RMARegisterInfo LoadRegisterByRegisterSysNo(int sysNo) { return(RegisterDA.LoadRegisterByRegisterSysNo(sysNo)); }
public static string CreateRMARequest(RMARequestInfo request) { OrderInfo result = CustomerDA.GetQuerySODetailInfo(request.CustomerSysNo.Value, request.SOSysNo.Value); //检查是否重复创建 Dictionary <int, int> master = new Dictionary <int, int>(); request.Registers.ForEach(r => { if (r.SOItemType.Value == SOProductType.Product) { if (master.ContainsKey(r.ProductSysNo.Value)) { master[r.ProductSysNo.Value] += r.Quantity.Value; } else { master.Add(r.ProductSysNo.Value, r.Quantity.Value); } } }); // verify master so items foreach (KeyValuePair <int, int> pair in master) { var soitem = result.SOItemList.Find(s => s.ProductSysNo == pair.Key && s.ProductType == SOItemType.ForSale); int regQty = RegisterDA.GetRegisterQty( pair.Key, (int)SOProductType.Product, request.SOSysNo.Value); if (soitem.Quantity < regQty + pair.Value) { throw new BusinessException("商品【{0}】的售后申请正在处理中,请不要重复申请", soitem.ProductTitle); } } using (TransactionScope ts = new TransactionScope()) { request.SysNo = RequestDA.CreateSysNo(); request.RequestID = GenerateId(request.SysNo.Value); //创建申请单初始状态为【待审核】 request.Status = RMARequestStatus.WaitingAudit; request.ShippingType = DeliveryType.SELF;//request.ShippingType.Trim(); request.InvoiceType = InvoiceType.SELF; request.StockType = StockType.SELF; request.MerchantSysNo = result.SellerSysNo; RequestDA.Create(request); request.Registers.ForEach(register => { var soitem = result.SOItemList.Find(s => s.ProductSysNo == register.ProductSysNo && (int)s.ProductType == (int)register.SOItemType); register.ProductID = soitem.ProductID; register.ProductName = soitem.ProductName; register.CustomerDesc = register.RMAReasonDesc; register.Status = RMARequestStatus.WaitingAudit; register.OwnBy = RMAOwnBy.Origin; register.Location = RMALocation.Origin; register.RevertStatus = null; register.ShippedWarehouse = result.StockSysNo; register.IsWithin7Days = false; register.IsRecommendRefund = false; register.NewProductStatus = RMANewProductStatus.Origin; register.NextHandler = RMANextHandler.RMA; register.SOItemType = (SOProductType)soitem.ProductType; for (int i = 0; i < register.Quantity; i++) { register.SysNo = RegisterDA.CreateSysNo(); RegisterDA.Create(register); RegisterDA.InsertRequestItem(request.SysNo.Value, register.SysNo.Value); } }); ts.Complete(); } return(request.RequestID); }
public ActionResult Index() { List <OrganisationRegister> registers = RegisterDA.GetRegisters(); return(View(registers)); }
public Registers Get(int id) { return(RegisterDA.GetRegister(id)); }
public List <Registers> Get() { return(RegisterDA.GetRegisters()); }
public List <EmployeeRegister> Get(int id) { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; return(RegisterDA.GetRegisterEmployee(id, p.Claims)); }
public List <RegisterClient> Get() { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; return(RegisterDA.GetRegisters(p.Claims)); }
public List <Register_Employee> Get() { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; return(RegisterDA.GetListRegisters(p.Claims)); }
public List <Employee> GetEmployees(int registerid) { ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal; return(RegisterDA.GetEmployeesFromRegister(registerid, p.Claims)); }