public DTO.EditFormData GetData(int userId, int id, int clientID, int factoryID, string season, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.EditFormData data = new DTO.EditFormData(); data.Data = new DTO.FactoryProformaInvoice(); data.DeliveryTerms = new List <Support.DTO.DeliveryTerm>(); data.PaymentTerms = new List <Support.DTO.PaymentTerm>(); data.Data.FactoryProformaInvoiceDetails = new List <DTO.FactoryProformaInvoiceDetail>(); //try to get data try { // check permission if (id <= 0 && fwFactory.CheckFactoryPermission(userId, factoryID) == 0) { throw new Exception("Current user don't have access permission for the selected factory data"); } if (id > 0 && fwFactory.CheckFactoryProformaInvoicePermission(userId, id) == 0) { throw new Exception("Current user don't have access permission for the selected proforma invoice data"); } using (FactoryProformaInvoice2MngEntities context = CreateContext()) { if (id <= 0) { data.Data.Season = season; data.Data.InvoiceDate = DateTime.Now.ToString("dd/MM/yyyy"); data.Data.ClientID = clientID; data.Data.FactoryID = factoryID; data.Data.ClientUD = supportFactory.GetClient().FirstOrDefault(o => o.ClientID == clientID).ClientUD; data.Data.FactoryUD = supportFactory.GetFactory().FirstOrDefault(o => o.FactoryID == factoryID).FactoryUD; } else { data.Data = converter.DB2DTO_FactoryProformaInvoice(context.FactoryProformaInvoice2Mng_FactoryProformaInvoice_View.Include("FactoryProformaInvoice2Mng_FactoryProformaInvoiceDetail_View").FirstOrDefault(o => o.FactoryProformaInvoiceID == id)); } } data.DeliveryTerms = supportFactory.GetDeliveryTerm(); data.PaymentTerms = supportFactory.GetPaymentTerm(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public DTO.InitDTO GetInitDataReport(int userId, out Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; Support.DAL.DataFactory spF = new Support.DAL.DataFactory(); DTO.InitDTO data = new InitDTO(); int?companyID = fw_factory.GetCompanyID(userId); try { using (var context = CreateContext()) { data.productionTeams = AutoMapper.Mapper.Map <List <SupportMng_ProductionTeam_View>, List <Support.DTO.ProductionTeam> >(context.SupportMng_ProductionTeam_View.ToList()).ToList(); } data.clients = spF.GetClient().ToList(); return(data); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; return(data); } }
public DTO.EditFormData GetData(int userId, int id, int clientId, string season, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; var data = new DTO.EditFormData { Data = new DTO.ClientComplaint() }; try { using (var context = CreateContext()) { if (id <= 0) { // create new data.Data.YearSeason = season; data.Data.ClientID = clientId; data.Data.ReceivedDate = DateTime.Now.ToShortDateString(); data.Data.ClientComplaintItems = new List <DTO.ClientComplaintItem>(); data.Data.ClientComplaintUsers = new List <DTO.ClientComplaintUser>(); var client = _supportFactory.GetClient().FirstOrDefault(o => o.ClientID == clientId); if (client != null) { data.Data.ClientUD = client.ClientUD; data.Data.ClientNM = client.ClientNM; var saleMn = _supportFactory.GetSaler().FirstOrDefault(s => s.SaleID == client.SaleID); if (saleMn != null) { data.Data.SaleNM = saleMn.SaleNM; } } } else { // access data from db var item = context.ClientComplaint_ClientComplaint_View.FirstOrDefault(o => o.ClientComplaintID == id); data.Data = _converter.DB2DTO_ClientComplaint(item); } } data.Employees = _supportFactory.GetEmployee().ToList(); data.ComplaintStatuses = _supportFactory.GetConstantEntries(EntryGroupType.ComplaintStatus); data.ComplaintTypes = _supportFactory.GetConstantEntries(EntryGroupType.ComplaintType); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public string GetExcelReportData(int clientId, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; ReportDataObject ds = new ReportDataObject(); try { SqlDataAdapter adap = new SqlDataAdapter(); adap.SelectCommand = new SqlCommand("ClientPaymentOverviewRpt_function_GetReport", new SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@ClientID", clientId); adap.TableMappings.Add("Table", "ClientPaymentOverviewRpt_DownPayment_View"); adap.TableMappings.Add("Table1", "ClientPaymentOverviewRpt_Invoice_View"); adap.Fill(ds); // add report param ReportDataObject.ReportHeaderRow pRow = ds.ReportHeader.NewReportHeaderRow(); pRow.Season = string.Empty; pRow.ClientNM = supportFactory.GetClient().FirstOrDefault(o => o.ClientID == clientId).ClientNM; pRow.ExRate = Convert.ToDecimal(supportFactory.GetSettingValue(Library.OMSHelper.Helper.GetCurrentSeason(), "ExRate-EUR-USD"), new System.Globalization.CultureInfo("en-US")); ds.ReportHeader.AddReportHeaderRow(pRow); // dev //Library.Helper.DevCreateReportXMLSource(ds, "ClientPaymentOverview"); // generate xml file //return Library.Helper.CreateCOMReportFile(ds, "ClientPaymentOverview"); return(Library.Helper.CreateReportFiles(ds, "ClientPaymentOverview")); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message)) { notification.DetailMessage.Add(ex.InnerException.Message); } return(string.Empty); } }
public DTO.InitFormData GetInit(out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.InitFormData result = new DTO.InitFormData(); result.Clients = new List <Support.DTO.Client>(); result.ClientPaymentMethods = new List <Support.DTO.ClientPaymentMethod>(); try { result.Clients = supportFactory.GetClient(); result.ClientPaymentMethods = supportFactory.GetClientPaymentMethod(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(result); }
public SearchFormData GetDataWithFilter(int userID, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Notification notification) { // Define. SearchFormData searchFormData = new SearchFormData { SearchData = new List <SampleProductLocationSearchResultData>(), Seasons = new List <Support.DTO.Season>(), Locations = new List <SupportFactoryLocationData>(), Factories = new List <Support.DTO.Factory>(), Clients = new List <Support.DTO.Client>(), Statuses = new List <Support.DTO.SampleProductStatus>() }; notification = new Notification { Type = NotificationType.Success }; totalRows = 0; // Main. try { string season = null; string sampleProductItemUD = null; string articleDescription = null; string factoryUD = null; string locationUD = null; string clientUD = null; int? quantity = null; int? statusID = null; if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString().Replace("'", "''"))) { season = filters["Season"].ToString().Trim(); } if (filters.ContainsKey("Code") && filters["Code"] != null && !string.IsNullOrEmpty(filters["Code"].ToString().Replace("'", "''"))) { sampleProductItemUD = filters["Code"].ToString().Trim(); } if (filters.ContainsKey("ArticleDescription") && filters["ArticleDescription"] != null && !string.IsNullOrEmpty(filters["ArticleDescription"].ToString().Replace("'", "''"))) { articleDescription = filters["ArticleDescription"].ToString().Trim(); } if (filters.ContainsKey("Factory") && filters["Factory"] != null && !string.IsNullOrEmpty(filters["Factory"].ToString().Replace("'", "''"))) { factoryUD = filters["Factory"].ToString().Trim(); } if (filters.ContainsKey("Location") && filters["Location"] != null && !string.IsNullOrEmpty(filters["Location"].ToString().Replace("'", "''"))) { locationUD = filters["Location"].ToString().Trim(); } if (filters.ContainsKey("Client") && filters["Client"] != null && !string.IsNullOrEmpty(filters["Client"].ToString().Replace("'", "''"))) { clientUD = filters["Client"].ToString().Trim(); } if (filters.ContainsKey("Quantity") && filters["Quantity"] != null && !string.IsNullOrEmpty(filters["Quantity"].ToString().Replace("'", "''"))) { quantity = Convert.ToInt32(filters["Quantity"].ToString().Trim()); } if (filters.ContainsKey("Status") && filters["Status"] != null && !string.IsNullOrEmpty(filters["Status"].ToString().Replace("'", "''"))) { statusID = Convert.ToInt32(filters["Status"].ToString().Trim()); } using (var context = CreateContext()) { totalRows = context.SampleProductLocationMng_function_SampleProductLocationSearchResult(season, sampleProductItemUD, articleDescription, factoryUD, locationUD, clientUD, quantity, statusID, userID, orderBy, orderDirection).Count(); var results = context.SampleProductLocationMng_function_SampleProductLocationSearchResult(season, sampleProductItemUD, articleDescription, factoryUD, locationUD, clientUD, quantity, statusID, userID, orderBy, orderDirection); searchFormData.SearchData = converter.DB2DTO_SampleLocationSearch(results.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); var factoryResult = context.SampleProductLocationMng_function_SupportFactoryLocation(userID.ToString()); searchFormData.Locations = converter.DB2DTO_SampleFactory(factoryResult.ToList()); } searchFormData.Seasons = supportFactory.GetSeason().ToList(); searchFormData.Clients = supportFactory.GetClient().ToList(); searchFormData.Factories = supportFactory.GetFactory(userID).ToList(); searchFormData.Statuses = supportFactory.GetSampleProductStatus().ToList(); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; searchFormData = null; } // Result. return(searchFormData); }
public override DTO.SearchFormData GetDataWithFilter(Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { DTO.SearchFormData searchFormData = new DTO.SearchFormData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; totalRows = 0; try { string clientNM = null; string validFrom = null; string validTo = null; string description = null; string updatedDate = null; string updatorName = null; int? clientID = null; if (filters.ContainsKey("clientNM") && !string.IsNullOrEmpty(filters["clientNM"].ToString())) { clientNM = filters["clientNM"].ToString().Replace("'", "''"); } if (filters.ContainsKey("validFrom") && !string.IsNullOrEmpty(filters["validFrom"].ToString())) { validFrom = filters["validFrom"].ToString().Replace("'", "''"); } if (filters.ContainsKey("validTo") && !string.IsNullOrEmpty(filters["validTo"].ToString())) { validTo = filters["validTo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("description") && !string.IsNullOrEmpty(filters["description"].ToString())) { description = filters["description"].ToString().Replace("'", "''"); } if (filters.ContainsKey("updatorName") && !string.IsNullOrEmpty(filters["updatorName"].ToString())) { updatorName = filters["updatorName"].ToString().Replace("'", "''"); } if (filters.ContainsKey("updatedDate") && !string.IsNullOrEmpty(filters["updatedDate"].ToString())) { updatedDate = filters["updatedDate"].ToString().Replace("'", "''"); } if (filters.ContainsKey("clientID") && filters["clientID"] != null) { clientID = Convert.ToInt32(filters["clientID"]); } using (ClientOfferMngEntities context = CreateContext()) { totalRows = context.ClientOfferMng_function_SearchClientOffer(orderBy, orderDirection, clientID, clientNM, validFrom, validTo, description, updatedDate, updatorName).Count(); var result = context.ClientOfferMng_function_SearchClientOffer(orderBy, orderDirection, clientID, clientNM, validFrom, validTo, description, updatedDate, updatorName); searchFormData.Data = converter.DB2DTO_ClientOfferSearch(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); } searchFormData.Clients = supportFactory.GetClient(); return(searchFormData); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(searchFormData); } }