public ActionResult Add(AddCompanyVM model) { if (Session["UserName"] == null) { return(RedirectToAction("Index", "Account")); } ViewBag.ReportTitle = "Add New Company"; //var selectedRoles = model.Roles.Where(x => x.IsChecked).Select(x => x.ID).ToList(); //var selectedCompanies = model.Companies.Where(x => x.IsChecked).Select(x => x.ID).ToList(); CompanyManager.Add(model); return(RedirectToAction("Index")); }
public ActionResult Add() { // add new user if (Session["UserName"] == null) { return(RedirectToAction("Index", "Account")); } ViewBag.ReportTitle = "Create new company"; AddCompanyVM model = new AddCompanyVM(); model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus); model.AllUser = GetSelectListItems((short)Helpers.Helpers.ListType.allUser); return(View(model)); }
public static void Add(AddCompanyVM model) { using (SqlConnection connection = new SqlConnection(Helpers.Helpers.GetAppConnectionString())) { try { // Create the user record. SqlCommand cmd = new SqlCommand("", connection); connection.Open(); SqlParameter IDParameter = new SqlParameter("@CompanyID", SqlDbType.SmallInt); IDParameter.Direction = ParameterDirection.Output; cmd.Parameters.Add(IDParameter); cmd.CommandText = "insert into tblCompany (CompanyName, StartDate, CompanyPhone, CompanyCellPhone, Address, City, Zip, EIN, BankAccount, RountingNo, AdminID, State,StatusID ) "; cmd.CommandText += " values ('" + model.CompanyName + "', '" + model.StartDate.ToShortDateString() + "', '" + model.CompanyPhone + "', '" + model.CompanyCellPhone + "','" + model.Address + "', '" + model.City + "', '"; cmd.CommandText += model.Zip + "', '" + model.EIN + "', '" + model.BankAccount + "', '" + model.RountingNo + "', '" + model.AdminID + "', '" + model.State + "', 1) SET @CompanyID=SCOPE_IDENTITY();"; cmd.ExecuteNonQuery(); model.CompanyID = (short)IDParameter.Value; //create default admin as hong yang and the default admin cmd.CommandText = " insert into tblCompanyUser(CompanyID, StartDate, RoleID, UserID, Note) values (" + model.CompanyID + ",'" + DateTime.Now + "', 2, 1, 'create by default when company is formed' )"; cmd.ExecuteNonQuery(); cmd.CommandText = " insert into tblCompanyUser(CompanyID, StartDate, RoleID, UserID, Note) values (" + model.CompanyID + ",'" + DateTime.Now + "', 2, " + model.AdminID + ", 'create by default when company is formed' )"; cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { connection.Close(); } } //INSERT ADMIN ROLE List <int> companyId = new List <int>(); companyId.Add(model.CompanyID); UserManager.InsertUserCompany(model.AdminID, companyId, (int)Helpers.Helpers.AdminRole); }