protected void grdCompany_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = int.Parse(e.CommandArgument.ToString()); Session.Add("rowIndex", rowIndex); ManageCompany companyObj = new ManageCompany(); DataTable dt = companyObj.getACompany(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtCompanyName.Value = DBUtility.readDBString(dr, "Company_Name"); txtCompanyAddress.Value = DBUtility.readDBString(dr, "Address_Line_1"); txtCompanyAddressLine2.Value = DBUtility.readDBString(dr, "Address_Line_2"); txtCompanyCity.Value = DBUtility.readDBString(dr, "City"); txtCompanyCode.Value = DBUtility.readDBString(dr, "Code"); txtCompanyTelephone.Value = DBUtility.readDBString(dr, "telephone_1"); txtCompanyTelephone2.Value = DBUtility.readDBString(dr, "telephone_2"); txtCompanyFax.Value = DBUtility.readDBString(dr, "fax"); txtCompanyEmail.Value = DBUtility.readDBString(dr, "email"); txtCompanyWebsite.Value = DBUtility.readDBString(dr, "website"); txtCompanyVATNumbwer.Value = DBUtility.readDBString(dr, "VAT_Number"); txtCompanyVATPercentage.Value = DBUtility.readDBString(dr, "VAT_percentage"); if (dr["Disable"] != null && !dr.IsNull("Disable")) { chkBoxCompanyDisable.Checked = Convert.ToBoolean(dr["Disable"]); } } }
// Gaat naar de usercontrols voor het bewerken/verwijderen van data private void buttonManageEdit_Click(object sender, EventArgs e) { if (ListViewActors.FocusedItem != null) { if (CurrentChoice == tableToDisplay.company) { ManageCompany ManageCompany = new ManageCompany(ref CompanyList, ref ContactpersonList, ref ContactpersonPeriodList, ListViewActors.FocusedItem, "Wijzigen"); ManageCompany.Size = new Size(908, 616); ManageCompany.Location = new Point(0, 86); this.Controls.Add(ManageCompany); ManageCompany.BringToFront(); } else if (CurrentChoice == tableToDisplay.user) { ManageUser ManageUser = new ManageUser(ref UserList, ref ContactpersonList, ref ContactpersonPeriodList, ListViewActors.FocusedItem, "Wijzigen"); ManageUser.Size = new Size(908, 616); ManageUser.Location = new Point(0, 86); this.Controls.Add(ManageUser); ManageUser.BringToFront(); } else if (CurrentChoice == tableToDisplay.contactperson) { ManageContactperson ManageContactperson = new ManageContactperson(ref UserList, ref CompanyList, ref ContactpersonList, ref ContactpersonPeriodList, ActivePerson, ListViewActors.FocusedItem, "Wijzigen"); ManageContactperson.Size = new Size(908, 616); ManageContactperson.Location = new Point(0, 86); this.Controls.Add(ManageContactperson); ManageContactperson.BringToFront(); } else if (CurrentChoice == tableToDisplay.contactperson_period) { ManageContactpersonPeriod ManageContactpersonPeriod = new ManageContactpersonPeriod(ref ContactpersonPeriodList, ref ContactpersonList, ref PeriodList, ListViewActors.FocusedItem); ManageContactpersonPeriod.buttonContactpersonPeriodDelete_Click(); } } }
public async Task SaveManageCompany(ManageCompany manageCompany) { var manageConfig = new ManageConfig(); await Connection.OpenAsync(); using var cmd = Connection.CreateCommand(); cmd.CommandText = @"INSERT INTO managecompanies (Id, Name, Identifier) VALUES (@Id, @Name, @Identifier) ON DUPLICATE KEY UPDATE Id = @Id, Name = @Name, Identifier = @Identifier;"; cmd.Parameters.Add(new MySqlParameter { ParameterName = "@Id", DbType = DbType.String, Value = manageCompany.Id }); cmd.Parameters.Add(new MySqlParameter { ParameterName = "@Name", DbType = DbType.String, Value = manageCompany.Name }); cmd.Parameters.Add(new MySqlParameter { ParameterName = "@Identifier", DbType = DbType.String, Value = manageCompany.Identifier }); await cmd.ExecuteNonQueryAsync(); cmd.Connection.Close(); }
public ActionResult ViewJob() { ManageCompany dbhandle = new ManageCompany(); ModelState.Clear(); return(View(dbhandle.ViewJob())); }
public ActionResult AddManageCompany(ManageCompanyModel mc) { var categoryList = dbEnt.ManageCompany.Select(s => s.Category); var nameList = dbEnt.ManageCompany.Select(s => s.Name); var emailList = dbEnt.Users.Select(s => s.Email); if (!categoryList.Contains(mc.Category) && !nameList.Contains(mc.Name) && !emailList.Contains(mc.Email)) { ManageCompany _mcObj = new ManageCompany { Name = mc.Name, Category = mc.Category, Street = mc.Street, HouseNumber = mc.HouseNumber }; dbEnt.ManageCompany.Add(_mcObj); dbEnt.SaveChanges(); Users _usrObj = new Users { FirstName = mc.FirstName, SecondName = mc.SecondName, ThirdName = mc.ThirdName, Email = mc.Email, EmailConfirm = false, manageCompany_id = _mcObj.id }; dbEnt.Users.Add(_usrObj); dbEnt.SaveChanges(); var roleList = dbEnt.Roles.Select(r => r.Name); Roles _rlobj; if (!roleList.Contains("ManageCompany")) { _rlobj = new Roles { Name = "ManageCompany" }; dbEnt.Roles.Add(_rlobj); dbEnt.SaveChanges(); } else { _rlobj = dbEnt.Roles.Where(r => r.Name == "ManageCompany").Select(r => r).FirstOrDefault(); } dbEnt.Accounts.Add(new Accounts { user_id = _usrObj.id, password = ISCityFramework.GetPass(rnd) }); dbEnt.SaveChanges(); dbEnt.UserRoles.Add(new UserRoles { user_id = _usrObj.id, role_id = _rlobj.id }); dbEnt.SaveChanges(); ISCityFramework.SendMail(_usrObj, dbEnt); return(RedirectToAction("Index", "Admin", null)); } else { ModelState.AddModelError("", "Организация с таким Наименованием, Категорией или Email уже существует."); } return(View(mc)); }
public ActionResult Edit(int id, Companyadd smodel) { try { ManageCompany sdb = new ManageCompany(); sdb.UPDATECOMPANYS(smodel); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult DeleteJob(int id) { try { ManageCompany sdb = new ManageCompany(); if (sdb.DeleteJob(id)) { ViewBag.AlertMsg = "Student Deleted Successfully"; } return(RedirectToAction("Index", "Admin")); } catch { return(View()); } }
public async Task <List <ManageCompany> > GetManageCompaniesAsync() { var manageCompanies = new List <ManageCompany>(); await Connection.OpenAsync(); using (var cmd = new MySqlCommand("SELECT Id, Name, Identifier FROM managecompanies", Connection)) using (var reader = await cmd.ExecuteReaderAsync()) while (await reader.ReadAsync()) { var manageCompany = new ManageCompany() { Id = reader.GetInt32(0), Name = reader.GetString(1), Identifier = reader.GetString(2), }; manageCompanies.Add(manageCompany); } Connection.Close(); return(manageCompanies); }
public ActionResult Create(Companyadd regi, string ReturnUrl = "") { if (ModelState.IsValid) { ManageCompany jm = new ManageCompany(); if (jm.Add_Company1(regi)) { ViewBag.Message = "You Have Done Registration"; ModelState.Clear(); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { return(RedirectToAction("Index", "Company")); } } } return(View()); }
public ActionResult UpdadeJob(int id) { ManageCompany sdb = new ManageCompany(); return(View(sdb.ViewJob().Find(smodel => smodel.J_Id == id))); }
public ActionResult Edit(int id) { ManageCompany sdb = new ManageCompany(); return(View(sdb.ViewC_Regi().Find(smodel => smodel.C_Id == id))); }