public static bool getActToXML(Company myCompany) { if (myCompany != null && myCompany.Connected) { //metodo precedente all'introduzione del CRM in sap ActivitiesService acts = myCompany.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService) as ActivitiesService; Activity myAct = acts.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity); //get dei dati string TodayDateQuery = DateTime.Now.ToString("yyyy-MM-dd"); Recordset RecSet = myCompany.GetBusinessObject(BoObjectTypes.BoRecordset); RecSet.DoQuery("select * from \"OCLG\",\"DUMMY\" WHERE \"CntctDate\"= TO_TIMESTAMP ('" + TodayDateQuery + " 00:00:00', 'YYYY-MM-DD HH24:MI:SS')"); string pathToXml = Path.GetDirectoryName(Application.ExecutablePath); string TodayDate = DateTime.Now.ToString("dd-MM-yyyy"); RecSet.SaveXML(TodayDate + "_activities.xml"); MessageBox.Show("File saved in '" + pathToXml + "' ", "Export to XML", MessageBoxButtons.OK, MessageBoxIcon.Information); /* * var o = RecSet.RecordCount; * while (!RecSet.EoF) * { * var CardCode = RecSet.Fields.Item("CardCode"); * RecSet.MoveNext(); * } */ return(true); } else { return(false); } }
public async Task <IActionResult> CreateVotingHeader(VotingHeaderVM VH) { SAPEntity.Instance.InitializeCompany(); if (SAPEntity.Company.Connected) { ActivitiesService oActSrv = (ActivitiesService)SAPEntity.Company.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService); Activity oAct = (Activity)oActSrv.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity); ActivityParams oParams; oAct.CardCode = VH.cardcode; oAct.Activity = BoActivities.cn_Task; oAct.ActivityType = 1; oAct.PreviousActivity = VH.prevactvty; //oAct.Subject = VH.subject; DateTime StartDate = DateTime.ParseExact(VH.str_startdate, "dd/MM/yyyy", null).Date; DateTime CloseDate = DateTime.ParseExact(VH.str_enddate, "dd/MM/yyyy", null).Date; oAct.ActivityDate = StartDate.Date; //oAct.EndDuedate = CloseDate; oAct.Duration = (CloseDate - StartDate).TotalDays; oAct.DurationType = BoDurations.du_Days; if (!String.IsNullOrEmpty(VH.time)) { oAct.UserFields.Item("U_Time").Value = VH.time; } if (!String.IsNullOrEmpty(VH.opentime)) { oAct.UserFields.Item("U_OpenTime").Value = VH.opentime; } oAct.UserFields.Item("U_AddedBy").Value = User.Identity.Name; oAct.Notes = VH.remark; oParams = oActSrv.AddActivity(oAct); long singleActCode = oParams.ActivityCode; if (singleActCode > 0) { //-----Email Notification var VOTERS = await _UserManager.GetUsersInRoleAsync("VOTER"); string[] VOTERStr = VOTERS.Select(t => t.Email).Distinct().ToArray(); string voteremails = String.Join(",", VOTERStr); var VOTINGMANAGERS = await _UserManager.GetUsersInRoleAsync("VOTINGMANAGER"); VOTERStr = VOTINGMANAGERS.Select(t => t.Email).Distinct().ToArray(); voteremails = voteremails + "," + String.Join(",", VOTERStr); _EmailRepo.SaveEmailLog(singleActCode, oAct.CardCode, StartDate.Date, CloseDate, voteremails, User.Identity.Name, VH.prevactvty); //-----Email Notification return(StatusCode(201)); } } else { return(BadRequest("SAP connection failed.")); } return(BadRequest("incorrect inputs provided.")); }
public async Task <IActionResult> CreateBoardMeeting(MeetingVM VM) { int IsAttchInserted = -1; string strMessage = "incorrect inputs provided."; SAPEntity.Instance.InitializeCompany(); if (SAPEntity.Company.Connected) { ActivitiesService oActSrv = (ActivitiesService)SAPEntity.Company.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService); Activity oAct = (Activity)oActSrv.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity); ActivityParams oParams; oAct.CardCode = VM.cardcode; oAct.Activity = BoActivities.cn_Task; oAct.ActivityType = 2; if (VM.cntctcode > 0) { oAct.ContactPersonCode = VM.cntctcode; } DateTime StartDate = DateTime.ParseExact(VM.str_startdate, "dd/MM/yyyy", null); DateTime CloseDate = DateTime.ParseExact(VM.str_enddate, "dd/MM/yyyy", null); oAct.ActivityDate = StartDate; oAct.Duration = (CloseDate - StartDate).TotalDays; oAct.DurationType = BoDurations.du_Days; if (!String.IsNullOrEmpty(VM.time)) { oAct.UserFields.Item("U_Time").Value = VM.time; } if (VM.assignesto.HasValue && VM.assignesto.Value > 0) { oAct.HandledBy = VM.assignesto.Value; } oAct.Notes = VM.notes; oAct.Details = VM.details; if (VM.files != null && VM.files.Count() > 0) { SAPbobsCOM.Attachments2 SAPAttachment = (SAPbobsCOM.Attachments2)SAPEntity.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oAttachments2); foreach (var FL in VM.files) { if (!string.IsNullOrEmpty(FL)) { SAPAttachment.Lines.SetCurrentLine((SAPAttachment.Lines.Count) - 1); string FileName = System.IO.Path.GetFileName(FL); string FileExt = System.IO.Path.GetExtension(FileName); FileExt = FileExt.Replace('.', ' ').Trim(); SAPAttachment.Lines.SourcePath = @"H:\Upload"; SAPAttachment.Lines.FileName = FileName; SAPAttachment.Lines.FileExtension = Path.GetExtension(FileExt); SAPAttachment.Lines.Add(); } } if (VM.files.Count() > 0) { IsAttchInserted = SAPAttachment.Add(); if (IsAttchInserted == 0) { string ObjCode; SAPEntity.Company.GetNewObjectCode(out ObjCode); oAct.AttachmentEntry = Convert.ToInt32(ObjCode); } else { strMessage = SAPEntity.Company.GetLastErrorDescription(); } } } oParams = oActSrv.AddActivity(oAct); long singleActCode = oParams.ActivityCode; if (singleActCode > 0) { return(StatusCode(201)); } } return(BadRequest("incorrect inputs provided.")); }
public async Task <IActionResult> CreateSingleActivity(singlecomplianceviewmodel VM) { string strMessage = "incorrect inputs provided."; bool IsCreate = true; try { int IsAttchInserted = -1; SAPEntity.Instance.InitializeCompany(); if (SAPEntity.Company.Connected) { ActivitiesService oActSrv = (ActivitiesService)SAPEntity.Company.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService); Activity oAct = (Activity)oActSrv.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity); ActivityParams oParams; if (VM.clgcode > 0) { IsCreate = false; oParams = (ActivityParams)oActSrv.GetDataInterface(ActivitiesServiceDataInterfaces.asActivityParams); oParams.ActivityCode = VM.clgcode; oAct = oActSrv.GetActivity(oParams); } oAct.CardCode = VM.cardcode; if (VM.cntctcode > 0) { oAct.ContactPersonCode = VM.cntctcode; } oAct.Activity = BoActivities.cn_Task; oAct.ActivityType = VM.type; oAct.Subject = VM.subject; if (VM.assignesto.HasValue && VM.assignesto.Value > 0) { oAct.HandledBy = VM.assignesto.Value; } oAct.Status = VM.status; oAct.Priority = VM.prcode == "0" ? BoMsgPriorities.pr_Low : VM.prcode == "1" ? BoMsgPriorities.pr_Normal : BoMsgPriorities.pr_High; oAct.Details = VM.details; oAct.Notes = VM.notes; if (!string.IsNullOrEmpty(VM.str_startdate)) { DateTime StartDate = DateTime.ParseExact(VM.str_startdate, "dd/MM/yyyy", null); DateTime CloseDate = DateTime.ParseExact(VM.str_enddate, "dd/MM/yyyy", null); oAct.ActivityDate = StartDate; oAct.Duration = (CloseDate - StartDate).TotalDays; oAct.DurationType = BoDurations.du_Days; } if (VM.files != null && VM.files.Count() > 0) { SAPbobsCOM.Attachments2 SAPAttachment = (SAPbobsCOM.Attachments2)SAPEntity.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oAttachments2); foreach (var FL in VM.files) { if (!string.IsNullOrEmpty(FL)) { SAPAttachment.Lines.SetCurrentLine((SAPAttachment.Lines.Count) - 1); string FileName = System.IO.Path.GetFileName(FL); string FileExt = System.IO.Path.GetExtension(FileName); FileExt = FileExt.Replace('.', ' ').Trim(); SAPAttachment.Lines.SourcePath = @"H:\Upload"; SAPAttachment.Lines.FileName = FileName; SAPAttachment.Lines.FileExtension = Path.GetExtension(FileExt); SAPAttachment.Lines.Add(); } } if (VM.files.Count() > 0) { IsAttchInserted = SAPAttachment.Add(); if (IsAttchInserted == 0) { string ObjCode; SAPEntity.Company.GetNewObjectCode(out ObjCode); oAct.AttachmentEntry = Convert.ToInt32(ObjCode); } else { strMessage = SAPEntity.Company.GetLastErrorDescription(); } } } if (IsCreate) { oAct.UserFields.Item("U_AddedBy").Value = User.Identity.Name; oParams = oActSrv.AddActivity(oAct); long singleActCode = oParams.ActivityCode; if (singleActCode > 0) { return(StatusCode(201)); } else { strMessage = SAPEntity.Company.GetLastErrorDescription(); } } else { oAct.UserFields.Item("U_UpdatedBy").Value = User.Identity.Name; oActSrv.UpdateActivity(oAct); strMessage = SAPEntity.Company.GetLastErrorDescription(); if (!string.IsNullOrWhiteSpace(strMessage)) { return(BadRequest(strMessage)); } else { return(StatusCode(201)); } } } } catch (Exception E) { var tt = E.Message; } return(BadRequest(strMessage)); }