public Materiale _InsertMaterial(Materiale entity)
{
db.Materiales.InsertOnSubmit(entity);
db.SubmitChanges();
return(entity);
//return db.VW_Planillas.SingleOrDefault(p => p.PlanillaID == entity.PlanillaID);
}
public HttpResponseMessage Post(Materiale entity)
{
try
{
var result = this._InsertMaterial(entity);
return(Request.CreateResponse <Materiale>(HttpStatusCode.Created, result));
}
catch (SqlException ex)
{
HttpError err = new HttpError("No se pudo actualizar.");
if (ex.Message.Contains("UNIQUE KEY"))
{
return(Request.CreateResponse(HttpStatusCode.Conflict, err));
}
//throw new HttpResponseException(HttpStatusCode.Conflict);
err = new HttpError("Error no controlado.");
return(Request.CreateResponse(HttpStatusCode.Conflict, err));
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateResponse(HttpStatusCode.Conflict, err));
}
}
internal Pacient(CNP_Pacient cnpPacient, PlainText nume)
{
Contract.Requires(cnpPacient != null, "CNP Pacient");
Contract.Requires(nume != null, "nume");
CNP = cnpPacient;
Nume = nume;
MaterialeConsumate = new Materiale();
}
public override void ExecuteOption(OptionReport report)
{
string urlLoginName = _databaseMaterialeBehovAssignment.urlLoginName;
int updateProgressFrequency = _databaseMaterialeBehovAssignment.updateProgressFrequency;
DatabaseUrlLogin login = DatabaseUrlLogin.GetUrlLogin(Connection, urlLoginName);
DynamicsCrmConnection dynamicsCrmConnection = DynamicsCrmConnection.GetConnection(login.Url, login.Username, login.Password);
Materiale materiale = Materiale.ReadCalculationNeed(dynamicsCrmConnection, Config.GetResourcePath);
if (materiale == null)
{
report.Success = true;
return;
}
materiale.FindBehovDefinitioner(Config.GetResourcePath);
int total = CountTotalAccountsToUpdate(dynamicsCrmConnection, materiale);
int staleMaterialeBehovCount = materiale.CountStaleMaterialeBehov(Config.GetResourcePath);
total += staleMaterialeBehovCount;
materiale.new_beregningsstatus = 0;
materiale.Update();
materiale.RemoveStaleMaterialeBehov(Config.GetResourcePath, currentProgress => updateProgress(materiale, currentProgress, total), updateProgressFrequency);
int progress = staleMaterialeBehovCount;
int materialeAddedCurrent = -1;
MaterialeProcessState state = new MaterialeProcessState();
state.pagingInformation = new PagingInformation();
state.owningbusinessunit = materiale.owningbusinessunitGuid.Value;
while (materialeAddedCurrent != 0)
{
materiale.AddMissingMateriale(state, Config.GetResourcePath);
materialeAddedCurrent = state.AccountsProcessed;
progress += materialeAddedCurrent;
updateProgress(materiale, progress, total);
}
materialeAddedCurrent = -1;
materiale.behovsberegning = Materiale.behovsberegningEnum.Afsluttet;
materiale.new_beregningsstatus = null;
materiale.Update();
report.Success = true;
return;
}
public Materiale _UpdateMaterial(Materiale entity)
{
var old = db.Materiales.Single(p => p.MaterialID == entity.MaterialID);
old.ProyectoID = entity.ProyectoID;
old.ActividadID = entity.ActividadID;
old.CodigoMaterial = entity.CodigoMaterial;
old.Descricion = entity.Descricion;
old.Cantidad = entity.Cantidad;
old.PrecioUnitario = entity.PrecioUnitario;
db.SubmitChanges();
return(entity);
}
public HttpResponseMessage Put(Materiale entity)
{
try
{
var data = this._UpdateMaterial(entity);
return(Request.CreateResponse <Materiale>(HttpStatusCode.OK, data));
}
catch (Exception ex)
{
HttpError err = new HttpError(ex.Message);
return(Request.CreateResponse(HttpStatusCode.Conflict, err));
}
}
public void RefreshParameterList(Materiale materiale, MeasureUnit measureUnit)
{
if (materiale == null)
{
return;
}
var parametri = Tool.ParametriUtensile.Where(p => p.MaterialGuid == materiale.MaterialeGuid);
var list = new ObservableCollection <ToolParameterViewModel>();
foreach (var parametroUtensile in parametri)
{
list.Add(ToolParameterViewModel.GetViewModel(Tool));
}
Parametri = list;
}
public void GetIndsamlingsSted()
{
Materiale materiale = Materiale.ReadCalculationNeed(_dynamicsCrmConnection, _config.GetResourcePath);
Guid businessId = materiale.owningbusinessunitGuid.Value;
PagingInformation pagingInformation = new PagingInformation();
int lastAccountCount = -1;
int total = 0;
while (lastAccountCount != 0)
{
List <Account> accounts = Account.GetIndsamlingsSted(_dynamicsCrmConnection, 15, businessId, _config.GetResourcePath, pagingInformation);
lastAccountCount = accounts.Count;
total += lastAccountCount;
accounts.ForEach(account => Console.Out.WriteLine(account.Id));
//Console.Out.Write($" {lastAccountCount} ");
}
Console.Out.WriteLine("-------");
Console.Out.WriteLine(total);
}
private void updateProgress(Materiale materiale, int current, int total)
{
int progress = 0;
if (total != 0)
{
progress = ((current * 100) / total);
}
if (progress < 0)
{
progress = 0;
}
if (progress > 99)
{
progress = 99;
}
materiale.new_beregningsstatus = progress;
materiale.Update();
}
public void SetUp()
{
_contact = CreateTestContact();
_contact.Insert();
_account = new Account(_dynamicsCrmConnection);
_account.name = $"test {Guid.NewGuid()}";
_account.erindsamlingssted = Account.erindsamlingsstedEnum.Ja;
_account.leveringkontaktid = _contact.Id;
_account.Insert();
_materiale = new Materiale(_dynamicsCrmConnection);
_materiale.new_name = $"materiale {Guid.NewGuid()}";
_materiale.behovsberegning = Materiale.behovsberegningEnum.Start;
_materiale.Insert();
_pakke = new MaterialePakke(_dynamicsCrmConnection);
_pakke.new_name = $"test pakke 7 {Guid.NewGuid()}";
_pakke.materialeid = _materiale.Id;
_pakke.new_stoerrelse = 4;
_pakke.Insert();
_definition = new MaterialeBehovDefinition(_dynamicsCrmConnection);
_definition.behovtype = MaterialeBehovDefinition.behovtypeEnum.Indsamlingssted;
_definition.materialeid = _materiale.Id;
_definition.new_antal = 10;
_definition.new_name = $"test definition {Guid.NewGuid()}";
_definition.Insert();
_behov = new MaterialeBehov(_dynamicsCrmConnection);
_behov.materialepakkeid = _pakke.Id;
_behov.modtagerid = _account.Id;
_behov.new_antal = 4;
_behov.new_name = $"test behov {Guid.NewGuid()}";
_behov.Insert();
}
private int CountTotalAccountsToUpdate(DynamicsCrmConnection dynamicsCrmConnection, Materiale materiale)
{
int total = 0;
if (materiale.BehovDefinitioner.Any(definition => definition.behovtype == MaterialeBehovDefinition.behovtypeEnum.ForventetAntalIndsamlere2016))
{
total += Account.CountForventetAntalIndsamlere2016(dynamicsCrmConnection, Config.GetResourcePath);
}
if (materiale.BehovDefinitioner.Any(definition => definition.behovtype == MaterialeBehovDefinition.behovtypeEnum.Indsamlingshjaelper))
{
total += Account.CountIndsamlingshjaelper(dynamicsCrmConnection, Config.GetResourcePath);
}
if (materiale.BehovDefinitioner.Any(definition => definition.behovtype == MaterialeBehovDefinition.behovtypeEnum.Indsamlingssted))
{
total += Account.CountIndsamlingssteder(dynamicsCrmConnection, Config.GetResourcePath);
}
return(total);
}
public MaterialViewModel(Materiale materiale)
{
_materiale = materiale;
}
public void AddMateriale(Materiale materiale)
{
_magazzinoUtensile.AddMateriale(materiale);
}
public void DeleteMaterial(Materiale materialeSelezionato)
{
_magazzinoUtensile.DeleteMaterial(materialeSelezionato);
}
