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