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