public async System.Threading.Tasks.Task <IActionResult> Info(int idi) { Models.Companies s = null; try { using (var con = new SqlConnection(configuration.GetConnectionString("DefaultConnection"))) { con.Open(); SqlCommand CompaniesQuery = new SqlCommand("SELECT Name,CreateDate,CreatorName,companies.id,worker,former From Companies INNER JOIN Worker ON worker.CompanyID=Companies.id WHERE companies.id = " + idi + ";", con); var Read = CompaniesQuery.ExecuteReader(); List <string> employ = new List <string>(); while (Read.Read()) { s = new Models.Companies(Read.GetInt32(3), Read[0].ToString(), employ, Read[1].ToString(), Read[2].ToString(), Read.GetInt32(5)); if (Read[4] != null) { s.workers.Add(Read[4].ToString()); } } Read.Close(); CompaniesQuery.Dispose(); con.Close(); } } catch (IOException) { } return(View(s)); }
public async System.Threading.Tasks.Task <IActionResult> MCompanyAsync(int id) { Models.Companies s = null; using (var con = new SqlConnection(configuration.GetConnectionString("DefaultConnection"))) { con.Open(); SqlCommand CompaniesQuery = new SqlCommand("SELECT companies.id,worker,former From Companies INNER JOIN Worker ON worker.CompanyID=Companies.id WHERE companies.id = " + id + "AND Worker ='" + User.Identity.Name + "';", con); var Read = CompaniesQuery.ExecuteReader(); List <string> employ = new List <string>(); while (Read.Read()) { if (Read.GetInt32(0) == null) { return(View("You do not have permission")); } else if (Read.GetInt32(2) == 0) { return(RedirectToAction("Info", "InfoCompany", new { idi = id }, null)); } } Read.Close(); CompaniesQuery.Dispose(); con.Close(); } try { using (var con = new SqlConnection(configuration.GetConnectionString("DefaultConnection"))) { con.Open(); SqlCommand CompaniesQuery = new SqlCommand("SELECT Name,CreateDate,CreatorName,companies.id,worker,former From Companies INNER JOIN Worker ON worker.CompanyID=Companies.id WHERE companies.id = " + id + ";", con); var Read = CompaniesQuery.ExecuteReader(); List <string> employ = new List <string>(); while (Read.Read()) { s = new Models.Companies(Read.GetInt32(3), Read[0].ToString(), employ, Read[1].ToString(), Read[2].ToString(), Read.GetInt32(5)); if (Read[4] != null) { s.workers.Add(Read[4].ToString()); } } Read.Close(); CompaniesQuery.Dispose(); con.Close(); } } catch (IOException) { } return(View(s)); }
public ActionResult NewCompany(CompaniesNew formData) { var newComp = new Models.Companies(); var currentUser = Database.Session.Query <Models.User>() .FirstOrDefault(u => u.Username == HttpContext.User.Identity.Name); newComp.Companyname = formData.companyMame; newComp.Address = formData.address; newComp.belongsToUser = currentUser; newComp.Faxnumber = formData.faxNumber; newComp.Phonenumber = formData.phoneNumber; newComp.Iban = formData.IBAN; newComp.Taxadministration = formData.TaxAdministration; newComp.inBalance = formData.inBalance; newComp.outBalance = formData.outBalance; Database.Session.Save(newComp); Database.Session.Flush(); return(RedirectToRoute("Firmalar", new { id = currentUser.Id })); }
public IHttpActionResult PostCompanies(int id) { var compInDb = _context.Companies.SingleOrDefault(t => t.CompanyId == id); if (compInDb != null) { compInDb.CompanyName = HttpContext.Current.Request.Params["CompanyName"]; compInDb.Email = HttpContext.Current.Request.Params["Email"]; compInDb.Phone = HttpContext.Current.Request.Params["Phone"]; } else { var companies = new Models.Companies(); companies.CompanyName = HttpContext.Current.Request.Params["CompanyName"]; companies.Email = HttpContext.Current.Request.Params["Email"]; companies.Phone = HttpContext.Current.Request.Params["Phone"]; _context.Companies.Add(companies); } _context.SaveChanges(); return(Ok()); }