public DataTable RetrieveCustomersGrid(string strCompanyCode) { try { DataAccess dataAccess = new DataAccess(Global.AllVisions_Sys); DataTable dt = new DataTable(); objCompanyInformation = RetrieveCompanyInformationByCode(strCompanyCode); string sqlstring = ""; if (objCompanyInformation.CompanyCode == objCompanyInformation.ParentCompanyCode) { sqlstring = "Select CompanyCode FROM CompanyInformation WITH (NOLOCK) where ParentCompanyCode = '" + strCompanyCode + "'"; } else { sqlstring = "Select CompanyCode FROM CompanyInformation WITH (NOLOCK) where CompanyCode = '" + strCompanyCode + "'"; } //string sqlstring = "exec spCustomersList"; dt = dataAccess.RetrieveDataTable(sqlstring); return(dt); } catch (Exception ex) { strError = ex.Message; return(new DataTable()); } }
protected void btnSearch_OnClick(object sender, EventArgs e) { objReportBiz = new ReportBiz(); ReportDocument rd = new ReportDocument(); CompanyInformation objClass = new CompanyInformation(); DataTable dt = new DataTable(); dt = objReportBiz.InvoicewisePurchaseDetails(txtInvoiceNumber.Text.Trim()); rd.Load(Server.MapPath("InvoicewisePurchaseDetail.rpt")); //Property for Header And Footer - Start TextObject txtCompanyName = rd.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject; txtCompanyName.Text = objClass.txtCompanyName; TextObject txtTradeLicense = rd.ReportDefinition.ReportObjects["txtTradeLicence"] as TextObject; txtTradeLicense.Text = objClass.txtTradeLicense; TextObject txtCompanyAddress = rd.ReportDefinition.ReportObjects["txtCompanyAddress"] as TextObject; txtCompanyAddress.Text = objClass.txtCompanyAddress; //Property for Header And Footer - End rd.SetDataSource(dt); Session["CrystalReport"] = rd; ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('../ReportViewer.aspx');", true); }
public static EmailTemplateModel BuildForInvitation(UserInformation user, CompanyInformation company, string link, string reciver) { var emailTemplate = new EmailTemplateModel(); try { var body = string.Format( "<table><tbody>" + "<tr><td>Title</td><td>{0}</td></tr>" + "<tr><td>Description</td><td>{1}</td></tr>" + "<tr><td>Registration Link</td><td>{2}</td></tr>" + "</tbody></table>", user.Name + " " + user.SurName + " invites you for working in " + company.Name, "If you have some questions please write your employer :" + user.Email, "To accept invitation pls follow this link an register : " + link); emailTemplate.Reciver = reciver; emailTemplate.Body = body; emailTemplate.Subject = "Invitation for WorkFlow time tracking system"; } catch (Exception ex) { var a = ex.Message; throw; } return(emailTemplate); }
/// <summary> /// Mapping User Activity Log DTO to Action /// </summary> /// <param name=></param> /// <param name=></param> /// <returns></returns> public CompanyInformation MappingCompanyInformationupdateDTOToCompanyInformation(CompanyInformation companyInformation, CompanyInformationUpdateDTO CompanyInformationUpdateDTO) { #region Declare Return Var with Intial Value CompanyInformation CompanyInformation = companyInformation; #endregion try { if (CompanyInformationUpdateDTO.CompanyInformationId > default(int)) { CompanyInformation.CompanyInformationId = CompanyInformationUpdateDTO.CompanyInformationId; CompanyInformation.CompanyName = CompanyInformationUpdateDTO.CompanyName; CompanyInformation.CompanyPhone = CompanyInformationUpdateDTO.CompanyPhone; CompanyInformation.CompanyProfile = CompanyInformationUpdateDTO.CompanyProfile; CompanyInformation.CompanySizeId = CompanyInformationUpdateDTO.CompanySizeId; CompanyInformation.CompanyTypeId = (byte)CompanyInformationUpdateDTO.CompanyTypeId; CompanyInformation.CompanyWebsite = CompanyInformationUpdateDTO.CompanyWebsite; CompanyInformation.EmployerId = CompanyInformationUpdateDTO.EmployerId; CompanyInformation.Fax = CompanyInformationUpdateDTO.Fax; CompanyInformation.IsMultinational = (bool)CompanyInformationUpdateDTO.IsMultinational; CompanyInformation.IsStartupCompany = (bool)CompanyInformationUpdateDTO.IsStartupCompany; CompanyInformation.Specialties = CompanyInformationUpdateDTO.Specialties; CompanyInformation.YearFounded = (int)CompanyInformationUpdateDTO.YearFounded; CompanyInformation.Logo = CompanyInformationUpdateDTO.Logo; } } catch (Exception exception) { } return(CompanyInformation); }
public Applicant GenerateApplicant(CompanyInformation info, String type) { Applicant applicant = new Applicant(); applicant.GenerateRandom(type, 0, info); return(applicant); }
protected override void MapAddress(CompanyInformation companyInformation, string address) { var addressParts = address.Split(new[] { "\n" }, StringSplitOptions.None); companyInformation.Address = addressParts.Length > 0 ? addressParts[0] : null; companyInformation.City = addressParts.Length > 1 ? addressParts[1] : null; }
public IHttpActionResult PutCompanyInformation(int id, CompanyInformation companyInformation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != companyInformation.CompanyId) { return(BadRequest()); } db.Entry(companyInformation).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CompanyInformationExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public static CompanyInformationModel ToModel(this CompanyInformation entity, int languageId) { if (entity == null) { throw new ArgumentNullException("company"); } var model = new CompanyInformationModel() { CompanyName = entity.CompanyName, CompanyDescription = entity.CompanyDescription, AccountNumbers = entity.AccountNumbers, BankAddress = entity.BankAddress, BankName = entity.BankName, LegalAddress = entity.LegalAddress, SWIFT = entity.SWIFT, TaxRegistrationNumber = entity.TaxRegistrationNumber, TopExecutiveName = entity.TopExecutiveName, SeName = entity.GetSeName(languageId, returnDefaultValue: true), }; var customer = entity.Customers.FirstOrDefault(); model.CustomerId = customer.Id; if (customer.IsSeller()) { model.Seller = true; } return(model); }
public override void UpdateDatabaseAfterUpdateSchema() { base.UpdateDatabaseAfterUpdateSchema(); CompanyInformation.GetInstance(ObjectSpace); LoadDefaultUsersAndRolesData(); }
public Applicant GenerateApplicant(CompanyInformation info, JobLibrary.JobType type) { Applicant applicant = new Applicant(); applicant.GenerateRandom(JobLibrary.Classes[type], 0, info); return(applicant); }
/// <summary> /// Delete User Action Activity Log /// </summary> /// <param name=></param> /// <returns>bool</returns> public async Task <bool> DeleteCompanyInformation(int CompanyInformationId) { #region Declare a return type with initial value. bool isCompanyInformationDeleted = default(bool); #endregion try { if (CompanyInformationId > default(int)) { #region Vars CompanyInformation CompanyInformation = null; #endregion #region Get CompanyInformation by id CompanyInformation = await UnitOfWork.CompanyInformationRepository.GetById(CompanyInformationId); #endregion #region check if object is not null if (CompanyInformation != null) { CompanyInformation.IsDeleted = (byte)DeleteStatusEnum.Deleted; #region Apply the changes to the database UnitOfWork.CompanyInformationRepository.Update(CompanyInformation); isCompanyInformationDeleted = await UnitOfWork.Commit() > default(int); #endregion } #endregion } } catch (Exception exception) { } return(isCompanyInformationDeleted); }
public void AddCompanyInformation(CompanyInformation companyInformation) { using (MySqlConnection connection = new MySqlConnection(this.connectionString)) { connection.Execute("INSERT INTO Company_information (Name, Phone, Email, Adress, Zipcode, City, Province, Country) VALUES(@Name, @Phone, @Email, @Adress, @Zipcode, @City, @Province, @Country)", companyInformation); } }
/// <summary> /// Mapping user Action Actitvity Log /// </summary> /// <param name=></ param > /// <returns>Task<CompanyInformation></returns> public CompanyInformation MappingCompanyInformationAddDTOToCompanyInformation(CompanyInformationAddDTO CompanyInformationAddDTO) { #region Declare a return type with initial value. CompanyInformation CompanyInformation = null; #endregion try { CompanyInformation = new CompanyInformation { CompanyName = CompanyInformationAddDTO.CompanyName, CompanyPhone = CompanyInformationAddDTO.CompanyPhone, CompanyProfile = CompanyInformationAddDTO.CompanyProfile, CompanySizeId = CompanyInformationAddDTO.CompanySizeId, CompanyTypeId = (byte)CompanyInformationAddDTO.CompanyTypeId, CompanyWebsite = CompanyInformationAddDTO.CompanyWebsite, EmployerId = CompanyInformationAddDTO.EmployerId, Fax = CompanyInformationAddDTO.Fax, IsMultinational = (bool)CompanyInformationAddDTO.IsMultinational, IsStartupCompany = (bool)CompanyInformationAddDTO.IsStartupCompany, Specialties = CompanyInformationAddDTO.Specialties, YearFounded = (int)CompanyInformationAddDTO.YearFounded, Logo = CompanyInformationAddDTO.Logo, CreationDate = DateTime.Now, IsDeleted = (byte)DeleteStatusEnum.NotDeleted }; } catch (Exception exception) { } return(CompanyInformation); }
public ActionResult DeleteConfirmed(int id) { CompanyInformation companyInformation = db.CompanyInformation.Find(id); db.CompanyInformation.Remove(companyInformation); db.SaveChanges(); return(RedirectToAction("Details")); }
/// <summary> /// Saves the fields bound to the UI related elements as text files /// </summary> /// <param name="fileHandler">File Handler object used to call the method that writes to text files</param> public void SaveFieldsAsTextFiles(IFileHandler fileHandler) { string pathToSaveFiles = fileHandler.GetFolderPathToHandleFiles(); if (pathToSaveFiles != "") { if (CompanyInformation != string.Empty) { fileHandler.WriteToFile(CompanyInformation.Split('\r', '\n'), $"{nameof(CompanyInformation)}Text", pathToSaveFiles); } if (BuyerInformation != string.Empty) { fileHandler.WriteToFile(BuyerInformation.Split('\r', '\n'), $"{nameof(BuyerInformation)}Text", pathToSaveFiles); } if (ExporterStatementTitle != string.Empty) { fileHandler.WriteToFile(new string[] { ExporterStatementTitle }, $"{nameof(ExporterStatementTitle)}Text", pathToSaveFiles); } if (AffidavitTitle != string.Empty) { fileHandler.WriteToFile(new string[] { AffidavitTitle }, $"{nameof(AffidavitTitle)}Text", pathToSaveFiles); } if (ExporterStatementPart1 != string.Empty) { fileHandler.WriteToFile(ExporterStatementPart1.Split('\r', '\n'), $"{nameof(ExporterStatementPart1)}Text", pathToSaveFiles); } if (ExporterStatementPart2 != string.Empty) { fileHandler.WriteToFile(ExporterStatementPart2.Split('\r', '\n'), $"{nameof(ExporterStatementPart2)}Text", pathToSaveFiles); } if (ExporterStatementPart3 != string.Empty) { fileHandler.WriteToFile(ExporterStatementPart3.Split('\r', '\n'), $"{nameof(ExporterStatementPart3)}Text", pathToSaveFiles); } if (AffidavitContent != string.Empty) { fileHandler.WriteToFile(AffidavitContent.Split('\r', '\n'), $"{nameof(AffidavitContent)}Text", pathToSaveFiles); } if (SalesAgentName != string.Empty) { fileHandler.WriteToFile(new string[] { SalesAgentName }, $"{nameof(SalesAgentName)}Text", pathToSaveFiles); } if (PathToStampAndSignature != string.Empty) { fileHandler.WriteToFile(new string[] { PathToStampAndSignature }, $"{nameof(PathToStampAndSignature)}Text", pathToSaveFiles); } } }
public async void Example() { #pragma warning disable 0168 using (Client client = GetClient()) { Address billingAddress = new Address(); billingAddress.AdditionalInfo = "Suite II"; billingAddress.City = "Monument Valley"; billingAddress.CountryCode = "US"; billingAddress.HouseNumber = "1"; billingAddress.State = "Utah"; billingAddress.Street = "Desertroad"; billingAddress.Zip = "84536"; CompanyInformation companyInformation = new CompanyInformation(); companyInformation.Name = "Acme Labs"; PersonalNameToken name = new PersonalNameToken(); name.FirstName = "Wile"; name.Surname = "Coyote"; name.SurnamePrefix = "E."; PersonalInformationToken personalInformation = new PersonalInformationToken(); personalInformation.Name = name; CustomerToken customer = new CustomerToken(); customer.BillingAddress = billingAddress; customer.CompanyInformation = companyInformation; customer.MerchantCustomerId = "1234"; customer.PersonalInformation = personalInformation; BankAccountBban bankAccountBban = new BankAccountBban(); bankAccountBban.AccountNumber = "000000123456"; bankAccountBban.BankCode = "05428"; bankAccountBban.BranchCode = "11101"; bankAccountBban.CheckDigit = "X"; bankAccountBban.CountryCode = "IT"; TokenNonSepaDirectDebitPaymentProduct705SpecificData paymentProduct705SpecificData = new TokenNonSepaDirectDebitPaymentProduct705SpecificData(); paymentProduct705SpecificData.AuthorisationId = "123456"; paymentProduct705SpecificData.BankAccountBban = bankAccountBban; MandateNonSepaDirectDebit mandate = new MandateNonSepaDirectDebit(); mandate.PaymentProduct705SpecificData = paymentProduct705SpecificData; TokenNonSepaDirectDebit nonSepaDirectDebit = new TokenNonSepaDirectDebit(); nonSepaDirectDebit.Customer = customer; nonSepaDirectDebit.Mandate = mandate; CreateTokenRequest body = new CreateTokenRequest(); body.NonSepaDirectDebit = nonSepaDirectDebit; body.PaymentProductId = 705; CreateTokenResponse response = await client.Merchant("merchantId").Tokens().Create(body); } #pragma warning restore 0168 }
public JsonResult UploadCompanyLogo() { HttpPostedFileBase httpPostedFileBase = Request.Files["ImageFile"]; string companyId = Request["companyId"].ToString(); string returnfilename = ""; bool result = false; if (httpPostedFileBase != null && httpPostedFileBase.ContentLength != 0) { string extention = Path.GetExtension(httpPostedFileBase.FileName); string fileName = companyId + "-{0}-" + DateTime.Now.Ticks + "{1}"; string imagefolder = AppConfig.CompanyProfileImageFolder; string profileImageFolderPath = Server.MapPath("~/" + imagefolder + companyId); returnfilename = imagefolder + companyId + "/" + string.Format(fileName, "full", extention); if (FileHelper.CreateFolderIfNeeded(profileImageFolderPath)) { try { Image orgImg = Bitmap.FromStream(httpPostedFileBase.InputStream); foreach (var prop in orgImg.PropertyItems) { if (prop.Id == 0x0112) //value of EXIF { int orientationValue = orgImg.GetPropertyItem(prop.Id).Value[0]; RotateFlipType rotateFlipType = ImageHelper.GetOrientationToFlipType(orientationValue); orgImg.RotateFlip(rotateFlipType); break; } } if (orgImg.Height > 300 || orgImg.Width > 300) { orgImg = ImageHelper.GetImageResize(300, 300, orgImg); } var qualityEncoder = Encoder.Quality; var quality = (long)80; var ratio = new EncoderParameter(qualityEncoder, quality); var codecParams = new EncoderParameters(1); codecParams.Param[0] = ratio; var jpegCodecInfo = ImageCodecInfo.GetImageEncoders(); CompanyInformation _CompanyInformation = _Util.Facade.CompanyRegistrationFacade.GetCompanyInfoByCompanyId(companyId); _CompanyInformation.CompanyLogo = "/" + returnfilename; _Util.Facade.CompanyRegistrationFacade.UpdateCompany(_CompanyInformation, out _error); orgImg.Save(Path.Combine(profileImageFolderPath, string.Format(fileName, "full", extention)), GetEncoder(ImageFormat.Jpeg), codecParams); result = true; } catch (Exception ex) { result = false; } } } return(Json(new { success = result, filename = returnfilename })); }
public ActionResult Edit([Bind(Include = "Id,Name,Address,Phone,Web,Email,ContactPerson")] CompanyInformation companyInformation) { if (ModelState.IsValid) { db.Entry(companyInformation).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details")); } return(View(companyInformation)); }
public ActionResult Create([Bind(Include = "Id,Name,Address,Phone,Web,Email,ContactPerson")] CompanyInformation companyInformation) { if (ModelState.IsValid) { db.CompanyInformation.Add(companyInformation); db.SaveChanges(); return(RedirectToAction("Details")); } return(View(companyInformation)); }
public IActionResult AddCompanyInformation([FromBody] CompanyInformation companyInformation) { var result = this._companyInformationService.AddCompanyInformation(companyInformation); if (!result) { return(BadRequest()); } return(Ok()); }
public IHttpActionResult GetCompanyInformation(int id) { CompanyInformation companyInformation = db.CompanyInformations.Find(id); if (companyInformation == null) { return(NotFound()); } return(Ok(companyInformation)); }
public IActionResult EditCompanyInformation([FromBody] CompanyInformation companyInformation, string key) { var result = this._companyInformationService.EditCompanyInformation(companyInformation, key); if (!result) { return(BadRequest()); } return(Ok()); }
public void LoadDataFromDatabase() { using (var ctx = new AssistantContext()) CompanyInformation = ctx.CompanyInformation.FirstOrDefault(); // Create new it does not exist if (CompanyInformation == null) { CompanyInformation = new CompanyInformation(); } }
/// <summary> /// Update company information /// </summary> /// <param name="company">company to update</param> public void UpdateCompany(CompanyInformation company) { if (company == null) { throw new ArgumentNullException("content"); } _companyRepository.Update(company); //event notification _eventPublisher.EntityUpdated(company); }
public async void Example() { #pragma warning disable 0168 using (Client client = GetClient()) { Address billingAddress = new Address(); billingAddress.AdditionalInfo = "b"; billingAddress.City = "Monument Valley"; billingAddress.CountryCode = "US"; billingAddress.HouseNumber = "13"; billingAddress.State = "Utah"; billingAddress.Street = "Desertroad"; billingAddress.Zip = "84536"; CompanyInformation companyInformation = new CompanyInformation(); companyInformation.Name = "Acme Labs"; PersonalNameToken name = new PersonalNameToken(); name.FirstName = "Wile"; name.Surname = "Coyote"; name.SurnamePrefix = "E."; PersonalInformationToken personalInformation = new PersonalInformationToken(); personalInformation.Name = name; CustomerToken customer = new CustomerToken(); customer.BillingAddress = billingAddress; customer.CompanyInformation = companyInformation; customer.MerchantCustomerId = "1234"; customer.PersonalInformation = personalInformation; CardWithoutCvv cardWithoutCvv = new CardWithoutCvv(); cardWithoutCvv.CardNumber = "4567350000427977"; cardWithoutCvv.CardholderName = "Wile E. Coyote"; cardWithoutCvv.ExpiryDate = "1299"; cardWithoutCvv.IssueNumber = "12"; TokenCardData data = new TokenCardData(); data.CardWithoutCvv = cardWithoutCvv; TokenCard card = new TokenCard(); card.Customer = customer; card.Data = data; UpdateTokenRequest body = new UpdateTokenRequest(); body.Card = card; body.PaymentProductId = 1; await client.Merchant("merchantId").Tokens().Update("tokenId", body); } #pragma warning restore 0168 }
protected override void MapAddress(CompanyInformation companyInformation, string address) { var addressParts = address.Split(new[] { "\n" }, StringSplitOptions.None); companyInformation.Address = addressParts.Length > 0 ? addressParts[0] : null; if (addressParts.Length > 1) { companyInformation.City = GetCity(addressParts[1]); companyInformation.PostalCode = GetPostalCode(addressParts[1]); companyInformation.Province = GetProvince(addressParts[1]); } }
public ActionResult Create([Bind(Include = "Id,Name,Address,Phone,Web,Email,ContactPerson,IsAuth,OpBy,OpOn,AuthBy,AuthOn")] CompanyInformation companyInformation) { if (ModelState.IsValid) { companyInformation.OpBy = 1; companyInformation.OpOn = DateTime.Now; db.CompanyInformations.Add(companyInformation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(companyInformation)); }
public IHttpActionResult DeleteCompanyInformation(int id) { CompanyInformation companyInformation = db.CompanyInformations.Find(id); if (companyInformation == null) { return(NotFound()); } db.CompanyInformations.Remove(companyInformation); db.SaveChanges(); return(Ok(companyInformation)); }
// GET: CompanyInformations/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyInformation companyInformation = db.CompanyInformation.Find(id); if (companyInformation == null) { return(HttpNotFound()); } return(View(companyInformation)); }
public async Task ShouldSearchForCompanyUsingCompanyHouseService() { //Arrange var reference = "12345678"; var info = new CompanyInformation(); _verificationService.Setup(x => x.GetInformation(It.IsAny <string>())).ReturnsAsync(info); //Act await _searchService.Search(reference); //Assert _verificationService.Verify(x => x.GetInformation(reference), Times.Once); }
public ActionResult CreateCompanyInformation(CompanyInformation type) { type.LanguageId = Int16.Parse(this.Request.Form.Get("LanguageList")); if (ModelState.IsValid) { Company company =db.Companies.Find(type.CompanyId); company.Revision++; db.Entry(company).State = EntityState.Modified; db.CompanyInformation.Add(type); db.SaveChanges(); return RedirectToAction("Details", new { id=type.CompanyId }); } return View(type); }
internal CompanyRepresentativeInformation mapFromDomain(Domain.Models.CompanyRepresentativeInformation poco) { //This mapping could be done by another object or third-party library. //Updating current state, could have treated immutably. Id = poco.Id; Name = poco.Name; Title = poco.Title; PhoneNumber = poco.PhoneNumber; Company = new CompanyInformation { City = poco.City, Id = poco.Id, Name = poco.Name, StreetName = poco.StreetName, StreetNumber = poco.StreetNumber }; StreetName = poco.StreetName; StreetNumber = poco.StreetNumber; return this; }
public ActionResult CreateCompanyInformation(int companyid = 0) { Company company = db.Companies.Find(companyid); if (company == null) throw new HttpException(404, "Company not found"); CompanyInformation compinfo = new CompanyInformation(); compinfo.CompanyId = companyid; var langs = from c in db.Language where !(from o in db.CompanyInformation where o.CompanyId == companyid select o.Language.LanguageId) .Contains(c.LanguageId) select c; ViewBag.LanguageList = new SelectList(langs.ToList(), "LanguageId", "Title"); return View(compinfo); }
public List<BillInformation> GetAssociatedBills(CompanyInformation company, ClientInformation client) { List<BillInformation> bills = new List<BillInformation>(); DataTable results = database.Select("SELECT * FROM bill WHERE company=@company AND client=@client", new Dictionary<string, object>() { {"company", company.ID}, {"client", client.ID} }); foreach (DataRow result in results.Rows) { BillInformation bill = new BillInformation(); bill.Fill(result); bills.Add(bill); } return bills; }
public List<CompanyInformation> GetCompanyInformations() { List<CompanyInformation> companies = new List<CompanyInformation>(); database.Open(); DataTable table = database.Select("select * from company"); foreach (DataRow row in table.Rows) { CompanyInformation c = new CompanyInformation(); c.Fill(row); companies.Add(c); } database.Close(); return companies; }
public ActionResult EditCompanyInformation(CompanyInformation type) { if (ModelState.IsValid) { Company company = db.Companies.Find(type.CompanyId); company.Revision++; db.Entry(company).State = EntityState.Modified; db.Entry(type).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Details", new { id = company.CompanyId }); } return View("CreateCompanyInformation", type); }