public IHttpActionResult GetRequestsByUserIDForConfirm(string userID) { List <Client_Request3> client_Requests = new List <Client_Request3>(); IssuingDAO issuingDAO = new IssuingDAO(); try { List <Request> requests = (from re in db.Requests where re.UserID == userID && re.IsIssued == true && re.IsConfirmed == false select re).ToList(); foreach (var request in requests) { Demand demand = db.Demands.Find(request.DemandPK); Conception conception = db.Conceptions.Find(demand.ConceptionPK); IssuingSession issuingSession = (from Iss in db.IssuingSessions where Iss.RequestPK == request.RequestPK select Iss).FirstOrDefault(); SystemUser systemUser = db.SystemUsers.Find(issuingSession.UserID); client_Requests.Add(new Client_Request3(request, demand, conception, issuingSession, systemUser)); } } catch (Exception e) { return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage())); } return(Content(HttpStatusCode.OK, client_Requests)); }
public IHttpActionResult CreateDemand(int customerPK, int conceptionPK, double totalDemand, string receiveDevision, string userID, [FromBody] List <Client_Accessory_DemandedQuantity_Comment> list) { if (new ValidationBeforeCommandDAO().IsValidUser(userID, "Merchandiser")) { IssuingDAO issuingDAO = new IssuingDAO(); Demand demand = null; try { // kiểm khi chạy lệnh Conception conception = db.Conceptions.Find(conceptionPK); if (conception.CustomerPK != customerPK) { return(Content(HttpStatusCode.Conflict, "KHÔNG ĐÚNG KHÁCH HÀNG")); } demand = issuingDAO.CreateDemand(customerPK, conception.ConceptionPK, totalDemand, receiveDevision, userID); issuingDAO.CreateDemandedItems(demand, list, conception.ConceptionPK); } catch (Exception e) { if (demand != null) { issuingDAO.DeleteDemand(demand.DemandPK); } return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage())); } return(Content(HttpStatusCode.OK, "TẠO YÊU CẦU XUẤT THÀNH CÔNG!")); } else { return(Content(HttpStatusCode.Conflict, "BẠN KHÔNG CÓ QUYỀN ĐỂ THỰC HIỆN VIỆC NÀY!")); } }
public void LinkConception(List <int> accessoryPKs, int conceptionPK, string userID) { try { // link conception Conception conception = db.Conceptions.Find(conceptionPK); foreach (var accessoryPK in accessoryPKs) { Accessory accessory = db.Accessories.Find(accessoryPK); if (conception.CustomerPK != accessory.CustomerPK) { throw new Exception("MÃ HÀNG VÀ ACCESSORY KHÔNG CÙNG CUSTOMER!"); } ConceptionAccessory conceptionAccessory = new ConceptionAccessory(conceptionPK, accessoryPK); db.ConceptionAccessories.Add(conceptionAccessory); // lưu activity link Activity activity1 = new Activity("link", conception.ConceptionCode, "Conception", userID); Activity activity2 = new Activity("link", accessory.AccessoryID, "Accessory", userID); db.Activities.Add(activity1); db.Activities.Add(activity2); } db.SaveChanges(); } catch (Exception e) { throw e; } }
public void DeleteConception(int conceptionPK, string userID) { try { ConceptionAccessory conceptionAccessory = (from ca in db.ConceptionAccessories where ca.ConceptionPK == conceptionPK select ca).FirstOrDefault(); if (conceptionAccessory != null) { throw new Exception("MÃ HÀNG ĐÃ CÓ GẮN PHỤ LIỆU, KHÔNG ĐƯỢC XÓA"); } // delete conception Conception conception = db.Conceptions.Find(conceptionPK); db.Conceptions.Remove(conception); // lưu activity delete Activity activity = new Activity("delete", conception.ConceptionCode, "Conception", userID); db.Activities.Add(activity); db.SaveChanges(); } catch (Exception e) { throw e; } }
public void MyTestInitialize() { int conceptionId = 1; string description = "Генератор"; Conception.LanguageId languageId = Conception.LanguageId.Russian; m_Conception = new Conception(conceptionId, description, languageId); }
public Client_Demand(Demand demand, Conception conception) { DemandPK = demand.DemandPK; DemandID = demand.DemandID; StartWeek = demand.StartWeek; EndWeek = demand.EndWeek; ReceiveDivision = demand.ReceiveDivision; ConceptionCode = conception.ConceptionCode; }
private string GetAllDescriptions(Conception conception) { StringBuilder sb = new StringBuilder(); foreach (Conception.LanguageId lang in Enum.GetValues(typeof(Conception.LanguageId))) { sb.AppendLine(GetConceptionDescription(conception, lang)); } return(sb.ToString()); }
private void btnRemoveConception_Click(object sender, RoutedEventArgs e) { Conception conception = (Conception)listConceptions.SelectedItem; if (conception == null) { return; } m_Dictionary.RemoveConception(conception.ConceptionId); listConceptions.SelectedIndex = -1; UpdateAllControls(); }
public Client_Request2(Request request, Demand demand, Conception conception) { RequestPK = request.RequestPK; RequestID = request.RequestID; DateCreated = request.DateCreated; ExpectedDate = request.ExpectedDate; Comment = request.Comment; DemandID = demand.DemandID; StartWeek = demand.StartWeek; EndWeek = demand.EndWeek; ReceiveDivision = demand.ReceiveDivision; ConceptionCode = conception.ConceptionCode; }
private void btnRemoveDescription_Click(object sender, RoutedEventArgs e) { Conception conception = (Conception)listConceptions.SelectedItem; if (conception == null) { return; } Conception.LanguageId languageForEdit = (Conception.LanguageId)cmbChangeforEdit.SelectedIndex; m_Dictionary.RemoveDescriptionFromConception(conception.ConceptionId, languageForEdit); UpdateAllControls(); }
public Conception GetConceptionByConceptionCode(string conceptionCode) { try { Conception conception = (from c in db.Conceptions where c.ConceptionCode == conceptionCode select c).FirstOrDefault(); return(conception); } catch (Exception e) { throw e; } }
public Client_Request3(Request request, Demand demand, Conception conception, IssuingSession issuingSession, SystemUser systemUser) { RequestPK = request.RequestPK; RequestID = request.RequestID; DateCreated = request.DateCreated; ExpectedDate = request.ExpectedDate; Comment = request.Comment; DemandID = demand.DemandID; StartWeek = demand.StartWeek; EndWeek = demand.EndWeek; ReceiveDivision = demand.ReceiveDivision; ConceptionCode = conception.ConceptionCode; UserID = systemUser.UserID; Username = systemUser.Name; ExecutedDate = issuingSession.ExecutedDate; }
public void CreateConception(int customerPK, string conceptionCode, int year, string season, string description, string userID) { try { // create conception Conception conception = new Conception(conceptionCode, description, year, season, customerPK); db.Conceptions.Add(conception); // lưu activity create Activity activity = new Activity("create", conception.ConceptionCode, "Conception", userID); db.Activities.Add(activity); db.SaveChanges(); } catch (Exception e) { throw e; } }
private void UpdateDescription() { Conception conception = (Conception)listConceptions.SelectedItem; if (conception == null) { return; } if (chkAllLanguages.IsChecked == true) { txtDescription.Text = GetAllDescriptions(conception); } else { Conception.LanguageId languageForDescription = (Conception.LanguageId)cmbLanguageForDescription.SelectedIndex; txtDescription.Text = GetConceptionDescription(conception, languageForDescription); } }
public void ActiveConception(int conceptionPK, string userID) { try { // active conception Conception conception = db.Conceptions.Find(conceptionPK); conception.IsActive = true; db.Entry(conception).State = EntityState.Modified; // lưu activity active Activity activity = new Activity("reactive", conception.ConceptionCode, "Conception", userID); db.Activities.Add(activity); db.SaveChanges(); } catch (Exception e) { throw e; } }
public void UnlinkConception(int accessoryPK, int conceptionPK, string userID) { try { // unlink conception Conception conception = db.Conceptions.Find(conceptionPK); Accessory accessory = db.Accessories.Find(accessoryPK); if (conception.CustomerPK != accessory.CustomerPK) { throw new Exception("MÃ HÀNG VÀ PHỤ LIỆU KHÔNG CÙNG KHÁCH HÀNG!"); } List <DemandedItem> demandedItems = (from dI in db.DemandedItems where dI.AccessoryPK == accessoryPK select dI).ToList(); foreach (var item in demandedItems) { Demand demand = db.Demands.Find(item.DemandPK); if (demand.ConceptionPK == conception.ConceptionPK) { throw new Exception("MÃ HÀNG VÀ PHỤ LIỆU ĐÃ ĐƯỢC LIÊN KẾT VÀ SỬ DỤNG!"); } } ConceptionAccessory conceptionAccessory = (from ca in db.ConceptionAccessories where ca.AccessoryPK == accessoryPK && ca.ConceptionPK == conceptionPK select ca).FirstOrDefault(); db.ConceptionAccessories.Remove(conceptionAccessory); // lưu activity unlink Activity activity1 = new Activity("unlink", conception.ConceptionCode, "Conception", userID); Activity activity2 = new Activity("unlink", accessory.AccessoryID, "Accessory", userID); db.Activities.Add(activity1); db.Activities.Add(activity2); db.SaveChanges(); } catch (Exception e) { throw e; } }
private void btnSearch_Click(object sender, RoutedEventArgs e) { string textToSearch = txtSearch.Text; bool isFound = false; for (int i = listConceptions.SelectedIndex + 1; i < listConceptions.Items.Count; i++) { Conception conception = (Conception)listConceptions.Items[i]; isFound = conception.Find(textToSearch); if (isFound) { ScrollToItem(i); break; } } if (!isFound) { MessageBox.Show(string.Format(Properties.Resources.fmtSearchMessage, textToSearch)); } }
public IHttpActionResult GetAllDemand() { List <Client_Demand> client_Demands = new List <Client_Demand>(); IssuingDAO issuingDAO = new IssuingDAO(); try { List <Demand> demands = (from d in db.Demands where d.IsOpened == true select d).ToList(); foreach (var demand in demands) { Conception conception = db.Conceptions.Find(demand.ConceptionPK); client_Demands.Add(new Client_Demand(demand, conception)); } } catch (Exception e) { return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage())); } return(Content(HttpStatusCode.OK, client_Demands)); }
public void CreateDemandedItems(Demand demand, List <Client_Accessory_DemandedQuantity_Comment> list, int conceptionPK) { try { foreach (var item in list) { Accessory accessory = (from a in db.Accessories where a.AccessoryID == item.AccessoryID select a).FirstOrDefault(); Conception conception = db.Conceptions.Find(conceptionPK); ConceptionAccessory conceptionAccessory = (from ca in db.ConceptionAccessories where ca.AccessoryPK == accessory.AccessoryPK && ca.ConceptionPK == conception.ConceptionPK select ca).FirstOrDefault(); if (accessory == null) { throw new Exception("PHỤ LIỆU " + accessory.AccessoryID + " KHÔNG TỒN TẠI!"); } if (conception == null) { throw new Exception("MÃ HÀNG " + conception.ConceptionCode + " KHÔNG TỒN TẠI!"); } if (conceptionAccessory == null) { throw new Exception("PHỤ LIỆU " + accessory.AccessoryID + " CHƯA ĐƯỢC GẮN CC!"); } DemandedItem demandedItem = new DemandedItem(item.DemandedQuantity, item.Comment, demand.DemandPK, accessory.AccessoryPK); db.DemandedItems.Add(demandedItem); } db.SaveChanges(); } catch (Exception e) { throw e; } }
public IHttpActionResult GetRequestByUserID(string userID) { List <Client_Request> client_Requests = new List <Client_Request>(); IssuingDAO issuingDAO = new IssuingDAO(); try { List <Request> requests = (from re in db.Requests where re.UserID == userID select re).ToList(); foreach (var request in requests) { Demand demand = db.Demands.Find(request.DemandPK); Conception conception = db.Conceptions.Find(demand.ConceptionPK); client_Requests.Add(new Client_Request(request, demand, conception)); } } catch (Exception e) { return(Content(HttpStatusCode.Conflict, new Content_InnerException(e).InnerMessage())); } return(Content(HttpStatusCode.OK, client_Requests)); }
private void UpdateEditDescription() { Conception conception = (Conception)listConceptions.SelectedItem; if (conception == null) { if (btnRemoveConception != null) { btnRemoveConception.IsEnabled = false; } return; } Conception.LanguageId languageForEdit = (Conception.LanguageId)cmbChangeforEdit.SelectedIndex; txtEditDescription.Text = GetConceptionDescription(conception, languageForEdit); bool isDescriptionExists = !string.IsNullOrWhiteSpace(txtEditDescription.Text); btnAddDescription.IsEnabled = !isDescriptionExists; btnChangeDescription.IsEnabled = isDescriptionExists; btnRemoveDescription.IsEnabled = isDescriptionExists; btnRemoveConception.IsEnabled = true; }
private void ButtonClicked() { #region recup données /*SansHUD.data.AppendLine("Tour " + Partie.Tour); * SansHUD.data.AppendLine("Joueur;Dimension;Loco;Conduite;Equi1;Equi2;Equi3");*/ currentTurnData = "J " + Partie.JoueurCourant + ";" + Partie.Joueurs[Partie.JoueurCourant - 1].Dim.name + ";" + Partie.Joueurs[Partie.JoueurCourant - 1].Loco.name + ";"; currentTurnData += autonomie + ";"; string equi1 = ""; string equi2 = ""; string equi3 = ""; if (manualEquipmentCards != null) { foreach (string s in manualEquipmentCards) { if (equi1 == "") { equi1 = "M " + s + ";"; continue; } if (equi2 == "") { equi2 = "M " + s + ";"; continue; } if (equi3 == "") { equi3 = "M " + s + ";"; } } } if (programmableEquipmentCards != null) { foreach (string s in programmableEquipmentCards) { if (equi1 == "") { equi1 = "P " + s + ";"; continue; } if (equi2 == "") { equi2 = "P " + s + ";"; continue; } if (equi3 == "") { equi3 = "P " + s + ";"; } } } if (autoEquipmentCards != null) { foreach (string s in autoEquipmentCards) { if (equi1 == "") { equi1 = "A " + s + ";"; continue; } if (equi2 == "") { equi2 = "A " + s + ";"; continue; } if (equi3 == "") { equi3 = "A " + s + ";"; } } } Conception conception = new Conception { Joueur = Partie.JoueurCourant, Dimension = Partie.Joueurs[Partie.JoueurCourant - 1].Dim.name, Locomotion = Partie.Joueurs[Partie.JoueurCourant - 1].Loco.name, Conduite = autonomie, Equipement1 = equi1, Equipement2 = equi2, Equipement3 = equi3, }; print("saved"); SansHUD.playerInfos[Partie.JoueurCourant].conception = conception; string json = JsonUtility.ToJson(SansHUD.playerInfos[Partie.JoueurCourant]); print(json); //File.WriteAllText(Application.dataPath + "/conception," + DateTime.Now.ToString("dd-MM-yyyy") + "_a_" + DateTime.Now.ToString("hh") + "h" + DateTime.Now.ToString("mm") + "m" + DateTime.Now.ToString("ss") + "s" + ".json", json); // suppression du dernier point-virgule //currentTurnData = currentTurnData.Remove(currentTurnData.Length - 1); //SansHUD.data.AppendLine(currentTurnData); if (manualEquipmentCards != null) { manualEquipmentCards.Clear(); } if (programmableEquipmentCards != null) { programmableEquipmentCards.Clear(); } if (autoEquipmentCards != null) { autoEquipmentCards.Clear(); } // string filePath = "donnees\\cartes_rejetees_le_" + DateTime.Now.ToString("dd-MM-yyyy") + "_a_" + DateTime.Now.ToString("hh") + "h" + DateTime.Now.ToString("mm") + "m" + DateTime.Now.ToString("ss") + "s" + ".csv"; // File.AppendAllText(filePath, SansHUD.data.ToString()); #endregion MyNetworkMessage msg = new MyNetworkMessage(); msg.message = Partie.JoueurCourant; NetworkServer.SendToAll(presID, msg); canvas_plateau_vehicule.SetActive(false); canvas_pres_persos.SetActive(true); }
private string GetConceptionDescription(Conception conception, Conception.LanguageId languageForDescription) { return(conception.GetConceptionDescription(languageForDescription).ConceptionRegistryDescription); }
public Client_IssuingSession(IssuingSession issuingSession, Demand demand, Request request, Conception conception) { IssuingSessionPK = issuingSession.IssuingSessionPK; ExecutedDate = issuingSession.ExecutedDate; DemandID = demand.DemandID; StartWeek = demand.StartWeek; EndWeek = demand.EndWeek; ReceiveDivision = demand.ReceiveDivision; ConceptionCode = conception.ConceptionCode; RequestID = request.RequestID; IsConfirmed = request.IsConfirmed; }