Exemplo n.º 1
0
 public static void EditCompany(CompanyMVCModel company)
 {
     using (IDbConnection cnn = new SqlConnection(GlobalConfig.CnnString()))
     {
         if (company != null)
         {
             List <CompanyMVCModel> companies = LoadCompanies();
             if (companies.Where(x => x.Id == company.Id).FirstOrDefault() != null)
             {
                 var obj = new
                 {
                     PhoneNumber  = company.PhoneNumber,
                     EmailAddress = company.EmailAddress,
                     Street       = company.Street,
                     City         = company.City,
                     PostalCode   = company.PostalCode,
                     NIP          = company.NIP,
                     CompanyName  = company.CompanyName,
                     REGON        = company.REGON,
                     Id           = company.Id
                 };
                 cnn.Execute("UPDATE Companies SET " +
                             "NIP = @NIP, PostalCode = @PostalCode, " +
                             "Street = @Street, City = @City, " +
                             "PhoneNumber = @PhoneNumber, EmailAddress = @EmailAddress, " +
                             "CompanyName = @CompanyName, REGON = @REGON " +
                             "WHERE Id = @Id", obj);
             }
         }
     }
 }
Exemplo n.º 2
0
 public static CompanyModel ConvertToCompanyModel(this CompanyMVCModel model)
 {
     if (model == null)
     {
         return(new CompanyModel());
     }
     return(new CompanyModel(model.Id, model.NIP, model.PostalCode, model.City, model.Street, model.EmailAddress, model.CompanyName, model.PhoneNumber, model.REGON));
 }
        // GET: Company/Edit/5
        public ActionResult Edit(int id)
        {
            CompanyMVCModel model = SQLiteDataAccess.LoadCompanies().Where(x => x.Id == id).FirstOrDefault();

            if (model != null)
            {
                return(View(model));
            }
            return(RedirectToAction("Index"));
        }
        private CompanyMVCModel GetCompanyInformation(CompanyMVCModel creationCompany, int selectedCompany)
        {
            CompanyMVCModel result = new CompanyMVCModel();

            if (creationCompany.CompanyName != null)
            {
                SQLiteDataAccess.SaveCompany(creationCompany);
                result = creationCompany;
            }
            else
            {
                result = SQLiteDataAccess.LoadCompanies().Where(x => x.Id == selectedCompany).FirstOrDefault();
            }
            return(result);
        }
 public ActionResult Edit(int id, CompanyMVCModel company)
 {
     try
     {
         if (ModelState.IsValid)
         {
             SQLiteDataAccess.EditCompany(company);
         }
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(RedirectToAction("Edit", id));
     }
 }
        public ActionResult Create(CompanyMVCModel company)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    SQLiteDataAccess.SaveCompany(company);
                }

                return(RedirectToAction("Index"));
            }
            catch
            {
                return(RedirectToAction("Create"));
            }
        }
        public ActionResult Delete(int id, CompanyMVCModel company)
        {
            try
            {
                if (company != null)
                {
                    SQLiteDataAccess.RemoveCompany(company.Id);
                }

                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View(company));
            }
        }
        private CompanyMVCModel ConvertCompanyToMVCModel(CompanyModel company)
        {
            CompanyMVCModel output = new CompanyMVCModel
            {
                PostalCode   = $"{ company.Address.PostalCode.Number }",
                City         = $"{ company.Address.City }",
                Street       = $"{ company.Address.Street }",
                EmailAddress = $"{ company.EmailAddress.Address }",
                PhoneNumber  = $"{ company.PhoneNumber.Number }",
                NIP          = $"{ company.NIP.Number}",
                REGON        = $"{ company.REGON.Number }",
                CompanyName  = $"{ company.CompanyName}",
                Id           = company.Id
            };

            return(output);
        }
Exemplo n.º 9
0
        public static void SaveCompany(CompanyMVCModel company)
        {
            using (IDbConnection cnn = new SqlConnection(GlobalConfig.CnnString()))
            {
                if (company != null)
                {
                    var o = cnn.Query <object>($"SELECT * FROM Companies WHERE " +
                                               $"(NIP='{company.NIP}' AND NIP!='') OR " +
                                               $"(REGON='{company.REGON}' AND REGON!='') OR " +
                                               $"CompanyName='{company.CompanyName}' AND " +
                                               $"((EmailAddress='{company.EmailAddress}' AND EmailAddress!='') OR " +
                                               $"(Street='{company.Street}' AND City='{company.City}') OR " +
                                               $"(PhoneNumber='{company.PhoneNumber}' AND PhoneNumber!=''))",
                                               new DynamicParameters());
                    if (!o.Any())
                    {
                        var obj = new
                        {
                            PhoneNumber  = company.PhoneNumber,
                            EmailAddress = company.EmailAddress,
                            Street       = company.Street,
                            City         = company.City,
                            PostalCode   = company.PostalCode,
                            NIP          = company.NIP,
                            CompanyName  = company.CompanyName,
                            REGON        = company.REGON,
                        };


                        cnn.Execute("insert into Companies (NIP, PostalCode, Street, City, PhoneNumber, EmailAddress, CompanyName, REGON)" +
                                    " values (@NIP, @PostalCode, @Street, @City, @PhoneNumber, @EmailAddress, @CompanyName, @REGON)", obj);

                        //If storing company into db was succesful, return new record's Id
                        company.Id = cnn.Query <int>("select Id from Companies").OrderBy(x => x).Last();
                    }
                }
            }
        }
        public ActionResult Create(CommissionMVCCreateModel commissionModel)
        {
            try
            {
                string zipFolderPath  = $"{ Server.MapPath("~") }GeneratedZips";
                string docsFolderPath = $"{ Server.MapPath("~") }GeneratedDocuments";

                string documentsStorageFolder = Server.MapPath("~") + "GeneratedDocuments\\";
                string zipPath = $"{ Server.MapPath("~") }GeneratedZips\\result.zip";

                string uploadsFolderPath    = $"{ Server.MapPath("~") }Uploads";
                string uploadsStorageFolder = $"{uploadsFolderPath}\\";

                if (!Directory.Exists(uploadsFolderPath))
                {
                    Directory.CreateDirectory(uploadsFolderPath);
                }



                if (!Directory.Exists(docsFolderPath))
                {
                    Directory.CreateDirectory(docsFolderPath);
                }
                if (!Directory.Exists(zipFolderPath))
                {
                    Directory.CreateDirectory(zipFolderPath);
                }

                // Get Company information
                CompanyMVCModel documentCompany = GetCompanyInformation(commissionModel.CreationCompany, commissionModel.SelectedCompany);

                //Get Clients information
                List <ClientMVCModel> documentClients = GetClientsInformation(commissionModel.CreationClient, commissionModel.SelectedClients);


                //Get Products information
                List <ItemMVCModel> documentProducts = GetProductsInformation(commissionModel.SelectedProducts, commissionModel.ProductPrices, commissionModel.ProductQuantities);


                //Get Creator information
                CreatorMVCModel documentCreator = GetCreatorInformation(commissionModel.CommissionCreator, commissionModel.SelectedCreator);

                if (documentCompany == null || documentClients.Count == 0 || documentProducts.Count == 0 || documentCreator == null)
                {
                    return(RedirectToAction("Create", "Commission"));
                }


                string fileName;
                // Saving uploaded file
                if (commissionModel.PostedFile != null)
                {
                    fileName = Path.GetFileName(commissionModel.PostedFile.FileName);
                    commissionModel.PostedFile.SaveAs(Server.MapPath("~") + "Uploads\\" + fileName);
                }

                if (documentClients.Count > 1)
                {
                    foreach (var item in documentClients)
                    {
                        PersonalData personalData = new PersonalData(documentCompany.ConvertToCompanyModel(), item.ConvertToClientModel(), documentCreator.ConvertToCommissionCreatorModel());

                        string path = $"{documentsStorageFolder}{ documentCompany.CompanyName }_{ item.FullName.Replace("\"", "") }_{ DateTime.Today.ToShortDateString() }.docx";
                        path.Trim();
                        if (commissionModel.PostedFile != null)
                        {
                            DocumentHelper.GenerateDocumentFromTemplate($"{Server.MapPath("~")}\\Uploads\\{Path.GetFileName(commissionModel.PostedFile.FileName)}",
                                                                        path, personalData, documentProducts.ConvertToItemModel(), true);
                        }
                        else
                        {
                            DocumentHelper.GenerateNewDocument(path,
                                                               personalData, documentProducts.ConvertToItemModel());
                        }
                    }

                    ZipFile.CreateFromDirectory(docsFolderPath, zipPath);

                    // Append headers
                    Response.AppendHeader("content-disposition", $"attachment; filename={ documentCompany.CompanyName }_{ DateTime.Today.ToShortDateString() }.zip");
                    // Open/Save dialog
                    Response.ContentType = "application/octet-stream";
                    // Push it!
                    Response.TransmitFile(zipPath);
                    Response.End();
                }
                else
                {
                    PersonalData personalData = new PersonalData(documentCompany.ConvertToCompanyModel(), documentClients.First().ConvertToClientModel(), documentCreator.ConvertToCommissionCreatorModel());
                    string       path         = $"{documentsStorageFolder}{ documentCompany.CompanyName }_{ documentClients.First().FullName.Replace("\"", "") }_{ DateTime.Today.ToShortDateString() }.docx";

                    path.Trim();
                    if (commissionModel.PostedFile != null)
                    {
                        DocumentHelper.GenerateDocumentFromTemplate(uploadsStorageFolder + Path.GetFileName(commissionModel.PostedFile.FileName),
                                                                    path, personalData, documentProducts.ConvertToItemModel(), true);
                    }
                    else
                    {
                        DocumentHelper.GenerateNewDocument(path,
                                                           personalData, documentProducts.ConvertToItemModel());
                    }
                    // Append headers
                    Response.AppendHeader("content-disposition", $"attachment; filename={ documentCompany.CompanyName }_{ documentClients.First().FullName.Replace("\"", "") }_{ DateTime.Today.ToShortDateString() }.docx");
                    // Open/Save dialog
                    Response.ContentType = "application/octet-stream";
                    // Push it!
                    Response.TransmitFile(path);
                    Response.End();
                }



                DeleteFiles();



                return(RedirectToAction("Index", "Home"));
            }
            catch (Exception e)
            {
                DeleteFiles();
                string msg = e.Message;

                return(RedirectToAction("Create", "Commission"));
            }
        }
        // GET: Company/Create
        public ActionResult Create()
        {
            CompanyMVCModel input = new CompanyMVCModel();

            return(View(input));
        }