public ChurchReview Create(ChurchReview model) { var churchReview = new ChurchReview(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spInsertChurchReview", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", model.UserId); cmd.Parameters.AddWithValue("@simbahanID", model.SimbahanId); cmd.Parameters.AddWithValue("@name", model.Name); cmd.Parameters.AddWithValue("@title", ""); cmd.Parameters.AddWithValue("@rate", model.StarCount); cmd.Parameters.AddWithValue("@content", model.Comment); var reader = cmd.ExecuteReader(); while (reader.Read()) { churchReview = _churchReviewTransformer.Transform(reader); if (churchReview.UserId != 0) { churchReview.User = _userTransformer.Transform(reader); } churchReview.Simbahan = _churchTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(churchReview); }
public DailyReflectionReflection Create(DailyReflectionReflection model) { var dailyReflectionReflection = new DailyReflectionReflection(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spInsertUserDailyReflectionReflection", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", model.UserId); cmd.Parameters.AddWithValue("@reflectionID", model.DailyReflectionId); cmd.Parameters.AddWithValue("@title", model.Title); cmd.Parameters.AddWithValue("@content", model.ReflectionContent); var reader = cmd.ExecuteReader(); while (reader.Read()) { dailyReflectionReflection = _reflectionReflectionTransformer.Transform(reader); dailyReflectionReflection.DailyReflection = _dailyReflectionTransformer.Transform(reader); dailyReflectionReflection.User = _userTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(dailyReflectionReflection); }
public Models.VisitaIglesia Create(Models.VisitaIglesia model) { var visitaIglesia = new Models.VisitaIglesia(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spInsertVisitaIglesia", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", model.UserId); cmd.Parameters.AddWithValue("@simbahanID", model.SimbahanId); cmd.Parameters.AddWithValue("@statusID", model.StatusId); var reader = cmd.ExecuteReader(); while (reader.Read()) { visitaIglesia = _visitaIglesiaTransformer.Transform(reader); visitaIglesia.Church = _churchTransformer.Transform(reader); visitaIglesia.User = _userTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(visitaIglesia); }
public Notification Create(Notification notification) { var createdNotification = new Notification(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spCreateNotification", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@title", notification.Title); cmd.Parameters.AddWithValue("@comment", notification.Description); cmd.Parameters.AddWithValue("@userID", notification.UserId); cmd.Parameters.AddWithValue("@action", notification.Action); var reader = cmd.ExecuteReader(); while (reader.Read()) { createdNotification = _notificationTransformer.Transform(reader); createdNotification.User = _userTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(createdNotification); }
public OrganizationReview Create(OrganizationReview model) { var organizationReview = new OrganizationReview(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) dbconn.Close(); dbconn.Open(); using (var cmd = new SqlCommand("spInsertOrganizationReview", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", model.UserId); cmd.Parameters.AddWithValue("@organizationID", model.OrganizationId); cmd.Parameters.AddWithValue("@title", model.Title); cmd.Parameters.AddWithValue("@rate", model.StarCount); cmd.Parameters.AddWithValue("@content", model.Comment); var reader = cmd.ExecuteReader(); while (reader.Read()) { organizationReview = _organizationReviewTransformer.Transform(reader); organizationReview.User = _userTransformer.Transform(reader); organizationReview.Organization = _organizationTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return organizationReview; }
public Notification Create(Notification notification) { var createdNotification = new Notification(); using (var sp = new StoredProcedure("spCreateNotification")) { sp.SqlCommand.Parameters.AddWithValue("@title", notification.Title); sp.SqlCommand.Parameters.AddWithValue("@comment", notification.Description); sp.SqlCommand.Parameters.AddWithValue("@userID", notification.UserId); sp.SqlCommand.Parameters.AddWithValue("@action", notification.Action); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { createdNotification = _notificationTransformer.Transform(reader); createdNotification.User = _userTransformer.Transform(reader); } } return(createdNotification); }
public VisitaIglesia Create(VisitaIglesia model) { var visitaIglesia = new VisitaIglesia(); using (var sp = new StoredProcedure("spInsertVisitaIglesia")) { sp.SqlCommand.Parameters.AddWithValue("@userID", model.UserId); sp.SqlCommand.Parameters.AddWithValue("@simbahanID", model.SimbahanId); sp.SqlCommand.Parameters.AddWithValue("@statusID", model.StatusId); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { visitaIglesia = _visitaIglesiaTransformer.Transform(reader); visitaIglesia.Church = _churchTransformer.Transform(reader); visitaIglesia.User = _userTransformer.Transform(reader); } } return(visitaIglesia); }
public CSUser GetUser(string email) { CSUser user = null; using (var db = new ManagementToolEntities()) { var resp = new UsersRepository(db); var dbUser = resp.GetFirstOrDefault(u => u.Email.Trim().ToLower() == email.Trim().ToLower()); UserTransformer transformer = new UserTransformer(); user = transformer.Transform(dbUser); } return(user); }
public ChurchReview Create(ChurchReview model) { var churchReview = new ChurchReview(); using (var sp = new StoredProcedure("spInsertChurchReview")) { sp.SqlCommand.Parameters.AddWithValue("@userID", model.UserId); sp.SqlCommand.Parameters.AddWithValue("@simbahanID", model.SimbahanId); sp.SqlCommand.Parameters.AddWithValue("@title", model.Title); sp.SqlCommand.Parameters.AddWithValue("@rate", model.StarCount); sp.SqlCommand.Parameters.AddWithValue("@content", model.Comment); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { churchReview = _churchReviewTransformer.Transform(reader); churchReview.User = _userTransformer.Transform(reader); churchReview.Simbahan = _churchTransformer.Transform(reader); } } return(churchReview); }
public List <CSUser> GetUsersByCompanyId(int companyId) { List <CSUser> users = null; using (var db = new ManagementToolEntities()) { var resp = new UsersRepository(db); var dbUsers = resp.GetAllUsersInCompany(companyId); if (dbUsers != null && dbUsers.Count() > 0) { UserTransformer transformer = new UserTransformer(); users = transformer.Transform(dbUsers); } } return(users); }
public List <Tuple <ChurchInfo, User> > GetChurchFollowers(int churchId) { var churchTransformer = new ChurchTransformer(); var userTransformer = new UserTransformer(); var followers = new List <Tuple <ChurchInfo, User> >(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetChurchFollowers", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@churchID", churchId); var reader = cmd.ExecuteReader(); while (reader.Read()) { var church = churchTransformer.Transform(reader); var user = userTransformer.Transform(reader); var follower = new Tuple <ChurchInfo, User>(church, user); followers.Add(follower); } } catch (Exception) { // ignored } } } return(followers); }
public User Update(int id, User model) { var user = new User(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spUpdateUserInformation", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userId", id); cmd.Parameters.AddWithValue("@firstName", model.FirstName); cmd.Parameters.AddWithValue("@lastName", model.LastName); cmd.Parameters.AddWithValue("@gender", model.Gender); cmd.Parameters.AddWithValue("@birthday", model.DateOfBirth); var reader = cmd.ExecuteReader(); while (reader.Read()) { user = _userTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(user); }
public User Update(int id, User model) { var user = new User(); using (var sp = new StoredProcedure("spUpdateUserInformation")) { sp.SqlCommand.Parameters.AddWithValue("@userId", id); sp.SqlCommand.Parameters.AddWithValue("@firstName", model.FirstName); sp.SqlCommand.Parameters.AddWithValue("@lastName", model.LastName); sp.SqlCommand.Parameters.AddWithValue("@gender", model.Gender); sp.SqlCommand.Parameters.AddWithValue("@birthday", model.DateOfBirth); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { user = _userTransformer.Transform(reader); } } return(user); }
public List <Tuple <Church, User> > GetChurchFollowers(int churchId) { var churchTransformer = new ChurchTransformer(); var userTransformer = new UserTransformer(); var followers = new List <Tuple <Church, User> >(); using (var sp = new StoredProcedure("")) { sp.SqlCommand.Parameters.AddWithValue("@churchID", churchId); var reader = sp.SqlCommand.ExecuteReader(); while (reader.Read()) { var church = churchTransformer.Transform(reader); var user = userTransformer.Transform(reader); var follower = new Tuple <Church, User>(church, user); followers.Add(follower); } } return(followers); }
public SaintReflection GetUserReflection(int userId, int saintId) { var saintReflection = new SaintReflection(); using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString)) { if (dbconn.State == ConnectionState.Open) { dbconn.Close(); } dbconn.Open(); using (var cmd = new SqlCommand("spGetUserDailySaintReflection", dbconn)) { try { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", userId); cmd.Parameters.AddWithValue("@saintID", saintId); var reader = cmd.ExecuteReader(); while (reader.Read()) { saintReflection = _saintReflectionTransformer.Transform(reader); saintReflection.Saint = _saintTransformer.Transform(reader); saintReflection.User = _userTransformer.Transform(reader); } } catch (Exception) { // ignored } } } return(saintReflection); }