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));
}
