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);
}
