public string AddMusicDirector(string FirstName, string LastName) { if (ModelState.IsValid) { AdminAlbumDAL DalObj = new AdminAlbumDAL(); AddAlbumMusicDirectorSongViewModel DirObject = new AddAlbumMusicDirectorSongViewModel(); DirObject = DalObj.AddMusicDirectors(FirstName, LastName); if (DirObject.MusicDirctorID != -1) { ViewBag.Message = "DirectorId" + DirObject.MusicDirctorID; } else { ViewBag.Messgae = "-1"; } return DirObject.MusicDirctorID.ToString(); } return "false"; }
public AddAlbumMusicDirectorSongViewModel AddMusicDirectors(string FirstName, string LastName) { //bool status = false; string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString; SqlConnection conn = new SqlConnection(conStr); AddAlbumMusicDirectorSongViewModel DirObj = null; try { conn.Open(); SqlCommand check = new SqlCommand("select count(*) from MusicDirectors where FirstName=@firstname and LastName=@lastname", conn); check.Parameters.AddWithValue("firstname", FirstName); check.Parameters.AddWithValue("lastname", LastName); int num = (int)check.ExecuteScalar(); if (num == 0) { SqlCommand cmd = new SqlCommand("insert into MusicDirectors values (@firstname,@lastname)", conn); cmd.Parameters.AddWithValue("firstname", FirstName); cmd.Parameters.AddWithValue("lastname", LastName); int res = cmd.ExecuteNonQuery(); //status = true; SqlCommand id = new SqlCommand("select Id,FirstName,LastName from MusicDirectors where FirstName=@firstname and LastName=@lastname", conn); id.Parameters.AddWithValue("firstname", FirstName); id.Parameters.AddWithValue("lastname", LastName); var reader = id.ExecuteReader(); if (reader.HasRows) { reader.Read(); DirObj = new AddAlbumMusicDirectorSongViewModel(); DirObj.MusicDirctorID = reader.GetInt32(reader.GetOrdinal("Id")); DirObj.DataError = null; } } else { DirObj = new AddAlbumMusicDirectorSongViewModel(); DirObj.MusicDirctorID = -1; } } catch (Exception exc) { HttpContext.Current.Session["ErrorMessage"] = exc.Message; } conn.Close(); return DirObj; }