public ActionResult AddRso(CreateRsoModel model) { SaveRsoRequest request = PrepareSaveRsoRequest(model); RsoConnection conn = new RsoConnection(); conn.SaveRso(request); return(RedirectToAction("Home")); }
private SaveRsoRequest PrepareSaveRsoRequest(CreateRsoModel model) { string username = Session["Username"].ToString(); SaveRsoRequest request = new SaveRsoRequest() { AdminEmail = username, Description = model.Description, Name = model.Name, University = model.SelectedUniversity }; if (ValidateMembers(model)) { request.Members = new List <string>(); request.Members.Add(model.Member1); request.Members.Add(model.Member2); request.Members.Add(model.Member3); request.Members.Add(model.Member4); request.Members.Add(model.Member5); } return(request); }
public void SaveRso(SaveRsoRequest request) { ConnectionHelper conn = new ConnectionHelper(); SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@Name", request.Name), new SqlParameter("@Description", request.Description) }; int res = conn.ExecuteNonQuery("CreateRso", sqlParams); if (res > 0) { SqlParameter[] sqlParams2 = new SqlParameter[] { new SqlParameter("@RsoName", request.Name), }; int rsoId = -1; string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetRsoId"; command.Connection = connection; command.Parameters.AddRange(sqlParams2); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { rsoId = reader.GetInt32(0); } } } catch (Exception ex) { } finally { connection.Close(); } } if (rsoId != -1) { SqlParameter[] sqlParams3 = new SqlParameter[] { new SqlParameter("@RsoId", rsoId), new SqlParameter("@StudentEmail", request.AdminEmail), new SqlParameter("@IsAdmin", 1) }; conn.ExecuteNonQuery("AddMemberToRso", sqlParams3); foreach (string m in request.Members) { SqlParameter[] sqlParams4 = new SqlParameter[] { new SqlParameter("@RsoId", rsoId), new SqlParameter("@StudentEmail", m), new SqlParameter("@IsAdmin", 0) }; conn.ExecuteNonQuery("AddMemberToRso", sqlParams4); } } } }