public void CanReturnACRsByACRName() { ACR testACR = this._acrRepository.FindByACRName("ACR1"); //Assert.IsNotNull(testACR); Assert.AreEqual(1, testACR.ACRID); }
public void InsertOrUpdate(ACR acr) { if (acr.ACRID == default(int)) { _context.ACR.Add(acr); } else { _context.Entry(acr).State = EntityState.Modified; } }
public HttpResponseMessage Put(int Id, ACR acr) { _acrRepository.InsertOrUpdate(acr); _acrRepository.Save(); var response = Request.CreateResponse <ACR>(HttpStatusCode.Accepted, acr); string uri = "/Tracker/ACR?acrName=" + acr.ACR_Name; response.Headers.Location = new Uri(Request.RequestUri, uri); return(response); }
public void CanSaveAnyChangesAfterUpdates() { // Try Updating an existing ACR ACR testACR = this._acrRepository.FindByACRName("ACR3"); testACR.Summary = "This is to test for Saving Changes after any Updates for ACR3"; // Update the Changes this._acrRepository.InsertOrUpdate(testACR); var updates = this._acrRepository.FindByACRName("ACR3").Summary; Assert.AreEqual("This is to test for Saving Changes after any Updates for ACR3", updates); }
//pruebas clientes desde prinergy public List <ACR> Cliente_Prinergy(DateTime FechaIni, DateTime FechaTer) { List <ValorACR> valores = ListadoValoresACR("", "", 0, 0, DateTime.Now, 2); List <ACR> lista = new List <ACR>(); try { string ini = FechaIni.ToString("yyyy-MM-dd"); string ter = FechaTer.ToString("yyyy-MM-dd 23:59:59"); string cCon = "Server=192.168.1.74;UserID=root;Database=Worldcolor_chile;Password=pacc3059;"; MySqlConnection cnn = new MySqlConnection(); cnn.ConnectionString = cCon; cnn.Open(); string consulta = "select op.ot2,pro.centro,sum(op.cantidad) as Cantidad, op.registrado from operaciones op" + " inner join procesos pro on op.proceso = pro.proceso inner join centros_costos co on pro.centro = co.centro" + //" where op.registrado between '"+ini+"' and '"+ter +"' and op.ot2 != 'BBBBBBB' and pro.centro in ('Imposición','Improof','Prueba de Color')" + " where op.registrado between '" + ini.ToString() + "' and '" + ter.ToString() + "' and op.ot2 != 'BBBBBBB' and pro.centro in ('Imposición','Improof','Prueba de Color')" + " group by op.ot2,pro.centro,op.registrado order by op.ot2,op.registrado"; MySqlCommand ncc = new MySqlCommand(); ncc.Connection = cnn; ncc.CommandText = consulta; MySqlDataReader myr = ncc.ExecuteReader(); while (myr.Read()) { ACR ac = new ACR(); ac.OT = myr["OT2"].ToString(); lista.Add(ac); } } catch (Exception ex) { } return(lista); }
public HttpResponseMessage PostNewACR(ACR acr) { try { _acrRepository.InsertOrUpdate(acr); _acrRepository.Save(); } catch (HttpResponseException ex) { return(Request.CreateResponse(HttpStatusCode.Conflict, acr)); } var response = Request.CreateResponse <ACR>(HttpStatusCode.Created, acr); string uri = "/Tracker/ACR?acrName=" + acr.ACR_Name; response.Headers.Location = new Uri(Request.RequestUri, uri); return(response); }
public void CanSaveAnyChangesAfterInsert() { // Try to save after inserting a new ACR ACR newACR = new ACR { ACR_Name = "ACR5", Summary = "This is to test ACR5", ApplicationId = 15, StatusId = 2, ApprovedBy = "Team4", CreatedBy = 4, CreatedDate = DateTime.Now, EndDate = DateTime.UtcNow.Add(TimeSpan.FromDays(30.00)), isActive = true, RaisedBy = 4 }; int _intACRCount = this._acrRepository.FindAll().Count; Assert.AreEqual(4, _intACRCount); // Verify pre-insert count value this._acrRepository.InsertOrUpdate(newACR); // Recounting _intACRCount = this._acrRepository.FindAll().Count; // Verify post-insert count value Assert.AreEqual(5, _intACRCount); // Verify foe SAVE after INSERT ACR testACR = this._acrRepository.FindByACRName("ACR5"); Assert.AreEqual(5, testACR.ACRID); }
// Use this for initialization void Start() { cName.text = character._characterName; race.text = character._characterRace.ToString(); HP.text = "" + character.GetCurrentHealth() + " / " + character.GetMaxHealth(); STR = character.GetAbilityScore(AbilityID.Strength); DEX = character.GetAbilityScore(AbilityID.Dexterity); CON = character.GetAbilityScore(AbilityID.Constitution); INT = character.GetAbilityScore(AbilityID.Intelligence); WIS = character.GetAbilityScore(AbilityID.Wisdom); CHA = character.GetAbilityScore(AbilityID.Charisma); ATH = character.GetSkill(SkillID.Athletics); ACR = character.GetSkill(SkillID.Acrobatics); STE = character.GetSkill(SkillID.Stealth); THI = character.GetSkill(SkillID.Thievery); END = character.GetSkill(SkillID.Endurance); ARC = character.GetSkill(SkillID.Arcana); HIS = character.GetSkill(SkillID.History); REL = character.GetSkill(SkillID.Religion); DUN = character.GetSkill(SkillID.Dungeoneering); HEA = character.GetSkill(SkillID.Heal); INS = character.GetSkill(SkillID.Insight); NAT = character.GetSkill(SkillID.Nature); PER = character.GetSkill(SkillID.Perception); BLU = character.GetSkill(SkillID.Bluff); DIP = character.GetSkill(SkillID.Diplomacy); INTI = character.GetSkill(SkillID.Intimidate); STRE = character.GetSkill(SkillID.Streetwise); tSTR.text = STR + " +" + character.GetModifier(AbilityID.Strength); tDEX.text = DEX + " +" + character.GetModifier(AbilityID.Dexterity); tCON.text = CON + " +" + character.GetModifier(AbilityID.Constitution); tINT.text = INT + " +" + character.GetModifier(AbilityID.Intelligence); tWIS.text = WIS + " +" + character.GetModifier(AbilityID.Wisdom); tCHA.text = CHA + " +" + character.GetModifier(AbilityID.Charisma); tAC.text = character.GetDefence(DefenceID.ArmorClass).ToString(); tFO.text = character.GetDefence(DefenceID.Fortitude).ToString(); tRE.text = character.GetDefence(DefenceID.Reflex).ToString(); tWI.text = character.GetDefence(DefenceID.Will).ToString(); tATH.text = ATH.ToString(); tACR.text = ACR.ToString(); tSTE.text = STE.ToString(); tTHI.text = THI.ToString(); tEND.text = END.ToString(); tARC.text = ARC.ToString(); tHIS.text = HIS.ToString(); tREL.text = REL.ToString(); tDUN.text = DUN.ToString(); tHEA.text = HEA.ToString(); tINS.text = INS.ToString(); tNAT.text = NAT.ToString(); tPER.text = PER.ToString(); tBLU.text = BLU.ToString(); tDIP.text = DIP.ToString(); tINTI.text = INTI.ToString(); tSTRE.text = STRE.ToString(); }