public bool AddNewAppointment(AppointmentDE mod) { bool retVal = true; SqlConnection con = new SqlConnection(_conStr); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ManageAppointment"; if (mod.Id == 0) { cmd.Parameters.AddWithValue("@Query", 1); cmd.Parameters.AddWithValue("@AppointmentId", -1); cmd.Parameters.Add("@PostCode", SqlDbType.VarChar, 10).Value = mod.PostCode; cmd.Parameters.Add("@Address", SqlDbType.VarChar, 200).Value = mod.Address; cmd.Parameters.Add("@NoOfBedrooms", SqlDbType.VarChar, 100).Value = mod.NoOfBedrooms; cmd.Parameters.Add("@PropertyTypeId", SqlDbType.Int).Value = mod.PropertyTypeId; cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 200).Value = mod.FirstName; cmd.Parameters.Add("@SurName", SqlDbType.VarChar, 200).Value = mod.SurName; cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = mod.Email; cmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = mod.MobileNo; cmd.Parameters.Add("@AppointmentDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Connection = con; } else { cmd.Parameters.AddWithValue("@Query", 2); cmd.Parameters.Add("@AppointmentId", SqlDbType.Int).Value = mod.Id; cmd.Parameters.Add("@PostCode", SqlDbType.VarChar, 10).Value = mod.PostCode; cmd.Parameters.Add("@Address", SqlDbType.VarChar, 200).Value = mod.Address; cmd.Parameters.Add("@NoOfBedrooms", SqlDbType.VarChar, 100).Value = mod.NoOfBedrooms; cmd.Parameters.Add("@PropertyTypeId", SqlDbType.Int).Value = mod.PropertyTypeId; cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 200).Value = mod.FirstName; cmd.Parameters.Add("@SurName", SqlDbType.VarChar, 200).Value = mod.SurName; cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = mod.Email; cmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = mod.MobileNo; cmd.Parameters.Add("@AppointmentDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Connection = con; } try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { retVal = false; } finally { con.Close(); con.Dispose(); } return(retVal); }
public List <AppointmentDE> GetAllAppointments() { List <AppointmentDE> list = new List <AppointmentDE>(); SqlConnection con = new SqlConnection(); con.ConnectionString = _conStr; try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ManageAppointment"; cmd.Parameters.AddWithValue("@Query", 5); cmd.Parameters.AddWithValue("@AppointmentId", -1); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { AppointmentDE appointment = new AppointmentDE(); appointment.Id = rdr["Id"] != DBNull.Value ? (int)rdr["Id"] : -1; appointment.AppointmentDate = rdr["AppointmentDate"] != DBNull.Value ? (DateTime)rdr["AppointmentDate"] : DateTime.Now; appointment.FirstName = rdr["FirstName"] != DBNull.Value ? (string)rdr["FirstName"] : string.Empty; appointment.SurName = rdr["SurName"] != DBNull.Value ? (string)rdr["SurName"] : string.Empty; appointment.Email = rdr["Email"] != DBNull.Value ? (string)rdr["Email"] : string.Empty; appointment.MobileNo = rdr["MobileNo"] != DBNull.Value ? (string)rdr["MobileNo"] : string.Empty; appointment.PropertyType = rdr["PropertyType"] != DBNull.Value ? (string)rdr["PropertyType"] : string.Empty; appointment.PostCode = rdr["PostCode"] != DBNull.Value ? (string)rdr["PostCode"] : string.Empty; appointment.Address = rdr["Address"] != DBNull.Value ? (string)rdr["Address"] : string.Empty; appointment.NoOfBedrooms = rdr["NoOfBedrooms"] != DBNull.Value ? (string)rdr["NoOfBedrooms"] : string.Empty; appointment.PropertyTypeId = rdr["PropertyTypeId"] != DBNull.Value ? (int)rdr["PropertyTypeId"] : -1; list.Add(appointment); } } } catch (Exception ex) { list = null; } finally { con.Close(); } return(list); }
public static AppointmentDE TranslateAppointmentModel(this AppointmentModel from) { AppointmentDE to = new AppointmentDE(); to.Id = from.Id; to.AppointmentDate = from.AppointmentDate; to.FirstName = from.FirstName; to.SurName = from.SurName; to.Email = from.Email; to.MobileNo = from.MobileNo; to.PropertyType = from.PropertyType; to.PostCode = from.PostCode; to.Address = from.Address; to.NoOfBedrooms = from.NoOfBedrooms; to.PropertyTypeId = from.PropertyTypeId; return(to); }
public AppointmentController() { _appoDal = new AppointmentDAL(); _appDE = new AppointmentDE(); }