public JsonResult GetCoffeShopDiary([FromBody] CoffeeShopDiaryViewModel data)
{
try
{
List <DiárioCafetariaRefeitório> CoffeeShopDiaryList;
if (data != null)
{
CoffeeShopDiaryList = DBCoffeeShopsDiary.GetByIdsList((int)data.ProdutiveUnityNo, (int)data.CoffeShopCode, User.Identity.Name);
List <CoffeeShopDiaryViewModel> result = new List <CoffeeShopDiaryViewModel>();
CoffeeShopDiaryList.ForEach(x => result.Add(DBCoffeeShopsDiary.ParseToViewModel(x)));
foreach (var res in result)
{
if (res.MealType > 0)
{
res.DescriptionTypeMeal = DBMealTypes.GetById((int)res.MealType).Descrição;
}
}
return(Json(result));
}
return(Json(false));
}
catch (Exception ex)
{
return(null);
}
}
public JsonResult GetSimplifiedRequisitionLinesData([FromBody] SimplifiedRequisitionLineViewModel item)
{
List <SimplifiedRequisitionLineViewModel> result = new List <SimplifiedRequisitionLineViewModel>();
if (item != null)
{
result = DBSimplifiedRequisitionLines.ParseToViewModel(DBSimplifiedRequisitionLines.GetById(item.RequisitionNo));
if (result.Count() != 0 && result[0].MealType > 0)
{
TiposRefeição typeMeal = DBMealTypes.GetById(result[0].MealType ?? 0);
result.ForEach(x =>
x.DescriptionMeal = typeMeal.Descrição
);
}
}
return(Json(result));
}
public static async Task <WSCreatePreInvoiceLine.CreateMultiple_Result> CreatePreInvoiceLineListProject(List <SPInvoiceListViewModel> LinesList, String HeaderNo, string OptionInvoice, NAVWSConfigurations WSConfigurations)
{
int counter = 0;
int array = 0;
WSCreatePreInvoiceLine.WsPreInvoiceLine[] parsedList = new WSCreatePreInvoiceLine.WsPreInvoiceLine[LinesList.Count];
foreach (var x in LinesList)
{
TiposRefeição refeicao = DBMealTypes.GetById(x.MealType ?? 0);
WSCreatePreInvoiceLine.WsPreInvoiceLine line = new WSCreatePreInvoiceLine.WsPreInvoiceLine();
line.Document_Type = OptionInvoice.Replace(" ", String.Empty) == "4" ? WSCreatePreInvoiceLine.Document_Type.Credit_Memo : WSCreatePreInvoiceLine.Document_Type.Invoice;
line.Document_TypeSpecified = true;
line.Document_No = HeaderNo;
line.Type = ConvertInvoiceLineType(x.Type.ToString());
line.No = x.Code;
line.Description100 = x.Description;
line.QuantitySpecified = true;
line.Quantity = x.Quantity.HasValue ? x.Quantity.Value : 0;
line.TypeSpecified = true;
line.Unit_of_Measure = x.MeasurementUnitCode;
//line.Unit_of_Measure_Code = x.MeasurementUnitCode;
line.Location_Code = x.LocationCode;
line.Unit_Price = x.UnitPrice.HasValue ? x.UnitPrice.Value : 0;
line.Unit_PriceSpecified = true;
line.Unit_Cost_LCY = x.UnitCost.HasValue ? x.UnitCost.Value : 0;
line.Unit_Cost_LCYSpecified = true;
line.Line_No = counter += 10000;
line.Line_NoSpecified = true;
line.Job_No = x.ProjectNo;
line.gJobDimension = x.ProjectDimension;
line.Service_Contract_No = x.ContractNo;
line.Contract_No_Portal = x.ContractNo;
line.Contract_No = x.ContractNo;
line.Tipo_Refeicao = x.MealType.HasValue ? x.MealType.Value.ToString() : string.Empty;// (refeicao!=null) ? refeicao.Código.ToString() : "";
line.Gen_Prod_Posting_Group = (refeicao != null) ? refeicao.GrupoContabProduto : x.ProjectContabGroup;
line.Cod_Serv_Cliente = x.ServiceClientCode;
line.Consumption_Date = !string.IsNullOrEmpty(x.ConsumptionDate) ? DateTime.Parse(x.ConsumptionDate) : DateTime.MinValue;
line.Consumption_DateSpecified = !string.IsNullOrEmpty(x.ConsumptionDate);
line.Grupo_Serviço = !string.IsNullOrEmpty(x.ServiceGroupCode) ? x.ServiceGroupCode : "";
line.Service_Group_Description = !string.IsNullOrEmpty(x.ServiceGroupCode) && DBServices.GetById(x.ServiceGroupCode) != null?DBServices.GetById(x.ServiceGroupCode).Descrição : "";
line.Nº_Guia_Externa = x.ExternalGuideNo;
line.Nº_Guia_Resíduos_GAR = x.WasteGuideNo_GAR;
line.RegionCode20 = x.RegionCode;
line.FunctionAreaCode20 = x.FunctionalAreaCode;
line.ResponsabilityCenterCode20 = x.ResponsabilityCenterCode;
line.Des_Serv_Cliente = !string.IsNullOrEmpty(x.ServiceClientCode) ? DBServices.GetById(x.ServiceClientCode) != null?DBServices.GetById(x.ServiceClientCode).Descrição : "" : "";
line.Data_Registo_Diario = !string.IsNullOrEmpty(x.ConsumptionDate) ? DateTime.Parse(x.ConsumptionDate) : DateTime.MinValue;
line.Data_Registo_DiarioSpecified = !string.IsNullOrEmpty(x.ConsumptionDate);
if (x.ResourceType.HasValue)
{
line.Tipo_Recurso = (WSCreatePreInvoiceLine.Tipo_Recurso)x.ResourceType.Value;
line.Tipo_RecursoSpecified = true;
}
parsedList[array] = line;
array++;
//Job_Journal_Line_No_Portal = x.LineNo,
//Job_Journal_Line_No_PortalSpecified = true,
}
;
WSCreatePreInvoiceLine.CreateMultiple NAVCreate = new WSCreatePreInvoiceLine.CreateMultiple(parsedList);
//Configure NAV Client
EndpointAddress WS_URL = new EndpointAddress(WSConfigurations.WS_PreInvoiceLine_URL.Replace("Company", WSConfigurations.WS_User_Company));
WSCreatePreInvoiceLine.WsPreInvoiceLine_PortClient WS_Client = new WSCreatePreInvoiceLine.WsPreInvoiceLine_PortClient(navWSBinding, WS_URL);
WS_Client.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Delegation;
WS_Client.ClientCredentials.Windows.ClientCredential = new NetworkCredential(WSConfigurations.WS_User_Login, WSConfigurations.WS_User_Password, WSConfigurations.WS_User_Domain);
//try
//{
return(await WS_Client.CreateMultipleAsync(NAVCreate));
//}
//catch (Exception ex)
//{
// return null;
//}
}
