//When user lands on the Update page (not submitting form)
public ActionResult Update(int id)
{
//Debug Purpose to see if we are getting the id
Debug.WriteLine("I'm pulling data of " + id.ToString());
//Query statement to select the specific Card
string query = "SELECT * FROM cards WHERE CardID = @CardID";
SqlParameter sqlparam = new SqlParameter("@CardID", id);
//The query is returning a list, so we only want the first one
Card selectedCard = db.Cards.SqlQuery(query, sqlparam).FirstOrDefault();
UpdateCard viewModel = new UpdateCard();
viewModel.card = selectedCard;
List <Series> allSeries = db.Series.SqlQuery("SELECT * FROM Series").ToList();
List <Trait> allTraits = db.Traits.SqlQuery("SELECT * FROM Traits").ToList();
viewModel.allSeries = allSeries;
viewModel.allTraits = allTraits;
//Get the all the trait that the card has
string aside_query = "SELECT * FROM Traits INNER JOIN TraitCards ON Traits.TraitID = TraitCards.Trait_TraitID WHERE TraitCards.Card_CardID=@id";
var fk_parameter = new SqlParameter("@id", id);
List <Trait> traits = db.Traits.SqlQuery(aside_query, fk_parameter).ToList();
viewModel.traits = traits;
//read the view model data
return(View(viewModel));
}
public async void PickUpUnChecked(int cardId)
{
if (AuthorizedEmployee.Id == 1)
{
this.UpdateCard = AllCards.Find(al => cardId == al.Id);
this.UpdateCard.PickUp = false;
Card card = await UpdateCard.PutCardAsync(this.UpdateCard);
}
}
private void Add(UpdateCard updateCard)
{
var systemCard = updateCard.CreateSystemCard();
using (var defaultContext = new DefaultContext())
{
defaultContext.SystemCards.Add(systemCard);
defaultContext.SaveChanges();
}
Flag = true;
}
public async void PickUpCheck(int cardId)
{
if (AuthorizedEmployee.Id == 1)
{
this.UpdateCard = AllCards.Find(al => cardId == al.Id);
this.UpdateCard.PickUp = true;
Card card = await UpdateCard.PutCardAsync(this.UpdateCard);
//this.AllCards = await UpdateCard.GetCardsAsync();
}
}
public void Update(UpdateCard updateCard)
{
if (updateCard.ID == 0)
{
Add(updateCard);
}
else
{
Edit(updateCard);
}
}
public async Task <JsonResult> UpdateCard(UpdateCard card, string tenantUid)
{
var origin = TenantHelper.GetCurrentTenantUrl(_contentService, tenantUid);
var token = Request.Cookies["token"].Value;
var response = await _cardService.UpdateCard(tenantUid, token, origin, card);
AppCaches _appCaches = new AppCaches();
var cacheName = "CustomerActiveCards" + $"_tenantUid:{tenantUid}_token:{token}_origin:{origin}";
_appCaches.RuntimeCache.ClearByKey(cacheName);
return(Json(response));
}
// GET: Submarine/Card/Create
public ActionResult Create(int? id)
{
var branchServices = ServiceLocator.Instance.GetService<IBranchServices>();
var branchList = branchServices.GetFirstBranches();
ViewBag.Branchs = new HtmlString(branchList.ToJson());
var cardServices = ServiceLocator.Instance.GetService<ICardServices>();
var updateCard = new UpdateCard();
if (id.HasValue)
{
updateCard = cardServices.GetCard(id.GetValueOrDefault());
}
ViewBag.UpdateSystemCard = new HtmlString(updateCard.ToJson());
return PartialView();
}
public UpdateCard GetCard(int cardId)
{
var updateCard = new UpdateCard();
using (var defaultContext = new DefaultContext())
{
var systemCard = defaultContext.SystemCards.FirstOrDefault(x => x.ID == cardId);
if (systemCard.Null())
{
Message = "未找到要修改的配置";
return updateCard;
}
updateCard = UpdateCard.CreateUpdateCard(systemCard);
Flag = true;
return updateCard;
}
}
private void Edit(UpdateCard updateCard)
{
using (var defaultContext = new DefaultContext())
{
var systemCard = defaultContext.SystemCards.FirstOrDefault(x => x.ID == updateCard.ID);
if (systemCard.Null())
{
Message = "请选择要修改的服务器";
return;
}
systemCard.Action = updateCard.Action;
systemCard.CardName = updateCard.CardName;
systemCard.BranchId = updateCard.BranchId;
defaultContext.ModifiedModel(systemCard);
defaultContext.SaveChanges();
}
Flag = true;
}
public ActionResult Edit(UpdateCard updateCard)
{
try
{
var cardServices = ServiceLocator.Instance.GetService<ICardServices>();
if (updateCard.Null())
{
var failure = cardServices.GetResult();
return Json(failure);
}
cardServices.Update(updateCard);
var result = cardServices.GetResult();
return Json(result);
}
catch
{
return Json(1);
}
}
public async void FavoriteUnChecked(int cardId)
{
this.UpdateCard = AllCards.Find(al => cardId == al.Id);
//this.UpdateCard.Favorite = false;
Card card = await UpdateCard.PutCardAsync(this.UpdateCard);
Favorite favorite = new Favorite();
this.Favorites = await favorite.GetFavoritesAsync();
this.DeleteFavorite = new Favorite();
this.Favorite.EmployeeId = AuthorizedEmployee.Id;
this.Favorite.CardId = cardId;
this.DeleteFavorite = Favorites.Find(f => Favorite.EmployeeId == f.EmployeeId && Favorite.CardId == f.CardId);
Favorite deletefavorite = await Favorite.DeleteFavoriteAsync(DeleteFavorite.Id);
}
public async Task <bool> CreateAsync(MeasureModel measure)
{
measure.date = DateTime.Now;
measure.status = eStatus.inProsses;
var addedId = await _measureRepository.CreateAsync(measure);
if (addedId > 0)
{
UpdateCard updateCard = new UpdateCard()
{
cardId = measure.cardId,
measureId = addedId,
weight = measure.weight
};
await _messageSession.Send(updateCard);
return(true);
}
return(false);
}
public async Task Handle(UpdateCard message, IMessageHandlerContext context)
{
_log.Error($"Received UpdateCard in subscriber saga, weight = {message.weight} ...");
UpdateBMI updateBMI = new UpdateBMI()
{
measureId = message.measureId,
cardId = message.cardId,
weight = message.weight
};
await context.SendLocal(updateBMI);
AddTrack addTrack = new AddTrack()
{
MeasureId = message.measureId,
CardId = message.cardId,
Weight = message.weight
};
await context.Send(addTrack);
}
public void Card_Update_Success()
{
// Create
var title = "Test Card " + DateTime.Now.ToShortDateString();
var dict = testConfig.GetDefaultActivityArguments();
dict["PipeID"] = pipe.Id;
dict["Title"] = title;
dict["DueDate"] = DateTime.Now.AddDays(6);
PipefyQueryActivity act = new CreateCard();
var result = WorkflowInvoker.Invoke(act, dict);
Assert.IsTrue((bool)result["Success"]);
var cardId = (long)result["CardID"];
// Get
dict = testConfig.GetDefaultActivityArguments();
dict["CardID"] = cardId;
act = new GetCard();
result = WorkflowInvoker.Invoke(act, dict);
Assert.IsTrue((bool)result["Success"]);
var cardJson = (JObject)result["Card"];
Assert.AreEqual(title, cardJson.Value <string>("title"));
// Update
title = "Updated Card " + DateTime.Now.ToShortDateString();
dict = testConfig.GetDefaultActivityArguments();
dict["CardID"] = cardId;
dict["Title"] = title;
act = new UpdateCard();
result = WorkflowInvoker.Invoke(act, dict);
Assert.IsTrue((bool)result["Success"]);
// Get
dict = testConfig.GetDefaultActivityArguments();
dict["CardID"] = cardId;
act = new GetCard();
result = WorkflowInvoker.Invoke(act, dict);
Assert.IsTrue((bool)result["Success"]);
cardJson = (JObject)result["Card"];
Assert.AreEqual(title, cardJson.Value <string>("title"));
// Delete
dict = testConfig.GetDefaultActivityArguments();
dict["CardID"] = cardId;
act = new DeleteCard();
result = WorkflowInvoker.Invoke(act, dict);
Assert.IsTrue((bool)result["Success"]);
}
public async Task <IResponseContent> UpdateCard(string tenantUid, string token, string origin, UpdateCard card)
{
var customerGuid = DecodeJwt(token).CustomerGuid;
card.CustomerGuid = customerGuid.ToString();
card.Response = new UpdateCard.UpdateCardResponse()
{
Action = "Approve",
Comment = "approved by dilek",
OperationUserId = 0
};
var response = await SubmitPostAsync(URL_API_EDIT_CARD, origin, card, token, tenantUid);
var responseContent = AssertResponseContent <UpdateCardResponseContent>(response);
return(responseContent);
}
