public List <DTO_CORE_GigAlert> FindAlertByID(DTO_CORE_GigAlert request) { List <DTO_CORE_GigAlert> results = new List <DTO_CORE_GigAlert>(); using (GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection()) { if (request != null) { var alertList = context.CORE_GigAlerts.Where(ga => ga.AlertID == request.AlertID).ToList(); foreach (var alert in alertList) { DTO_CORE_GigAlert result = new DTO_CORE_GigAlert { Active = (bool)alert.Active, AlertID = alert.AlertID, ClientID = alert.ClientID, Comment = alert.Comment, DateCreated = alert.DateCreated, Lat = alert.Lat, Long = alert.Long, PaymentAmt = alert.PaymentAmt, Title = alert.Title, TypeID = alert.TypeID }; results.Add(result); } } } return(results); }
public List <DTO_CORE_Gig> CreateGig(DTO_CORE_Gig request) { using (DB_connection context = new GigALoan_DAL.DB_connection()) { CORE_Gigs newgig = new CORE_Gigs { AlertID = request.AlertID, StudentID = request.StudentID, ClientComments = request.ClientComments, StudentRating = 0, ClientRating = 0 }; if (context.CORE_GigAlerts.Where(ga => ga.AlertID == request.AlertID).Single().Active == true) { context.CORE_Gigs.Add(newgig); var alert = (from a in context.CORE_GigAlerts where a.AlertID == request.AlertID select a).Single(); alert.Active = false; context.SaveChanges(); } //string insertString = "IF ((SELECT Active FROM CORE_GigAlerts WHERE AlertID = " + request.AlertID + ") = 1) " + // "INSERT INTO CORE_Gigs(AlertID, DateAccepted, StudentID, ClientComments, StudentRating, ClientRating) VALUES(" + // request.AlertID + ", " + request.DateAccepted.ToString("yyyy-mm-dd") + ", " + request.StudentID + ", '" + request.ClientComments + "', 0, 0) " + // "UPDATE CORE_GigAlerts SET Active = 0 FROM CORE_GigAlerts WHERE AlertID = " + request.AlertID; //SqlConnection connection = new SqlConnection(); //connection.ConnectionString = "Server=tcp:s05.winhost.com;Database=DB_42039_gig;User ID=DB_42039_gig_user;Password=gigaloan"; //SqlCommand cmd = new SqlCommand(insertString, connection); //connection.Open(); //cmd.ExecuteNonQuery(); //connection.Close(); //var result = context.CORE_Gigs.Where(g => g.AlertID == request.AlertID).Single(); DTO_CORE_Gig gigToBeReturned = new DTO_CORE_Gig { AlertID = newgig.AlertID, ClientComments = newgig.ClientComments, ClientRating = 0.0, DateAccepted = newgig.DateAccepted, DateClosed = Convert.ToDateTime(null), GigID = newgig.GigID, StudentComments = "", StudentID = newgig.StudentID, StudentRating = 0.0 }; var returnObject = new List <DTO_CORE_Gig>(); returnObject.Add(gigToBeReturned); return(returnObject); } }
}//end method GetClientById //method used to get a client by their name public List <DTO_CORE_Client> GetClientByName(DTO_CORE_Client request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var resultList = context.CORE_Clients.Where(client => client.FirstName == request.FirstName && client.LastName == request.LastName).ToList();//FirstOrDefault(); List <DTO_CORE_Client> result = new List <DTO_CORE_Client>(); foreach (CORE_Clients client in resultList) { DTO_CORE_Client clientByName = new DTO_CORE_Client { ClientID = client.ClientID, FirstName = client.FirstName, LastName = client.LastName, //DateJoined = client.DateJoined, DateJoined is killed currently due to weird issues Email = client.Email, Pass = client.Pass, Gender = client.Gender, PhoneNumber = client.PhoneNumber, Active = (bool)client.Active }; result.Add(clientByName); } return(result); }//end method GetClientByEmail
public List <DTO_CORE_GigAlert> FindAlertsByType(DTO_CORE_GigAlert request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); List <DTO_CORE_GigAlert> results = new List <DTO_CORE_GigAlert>(); var alertList = context.CORE_GigAlerts.Where(ga => ga.SPRT_GigTypes.TypeID == request.TypeID); foreach (CORE_GigAlerts alert in alertList) { DTO_CORE_GigAlert result = new DTO_CORE_GigAlert { AlertID = alert.AlertID, TypeID = alert.TypeID, Title = alert.Title, Comment = alert.Comment, Active = (bool)alert.Active, ClientID = alert.ClientID, DateCreated = alert.DateCreated, Lat = alert.Lat, Long = alert.Long, PaymentAmt = alert.PaymentAmt /*TODO: Get Alert images(or at least the first) loaded as well*/ }; results.Add(result); } return(results); }
public List <DTO_CORE_GigAlert> FindAlertsByPay(DTO_CORE_GigAlert request) { using (DB_connection context = new GigALoan_DAL.DB_connection()) { List <DTO_CORE_GigAlert> results = new List <DTO_CORE_GigAlert>(); var alertList = context.CORE_GigAlerts.Where(ga => ga.PaymentAmt >= request.PaymentAmt); foreach (CORE_GigAlerts alert in alertList) { DTO_CORE_GigAlert result = new DTO_CORE_GigAlert { AlertID = alert.AlertID, TypeID = alert.TypeID, Title = alert.Title, Comment = alert.Comment, Active = (bool)alert.Active, ClientID = alert.ClientID, DateCreated = alert.DateCreated, Lat = alert.Lat, Long = alert.Long, PaymentAmt = alert.PaymentAmt /*TODO: Get Alert images(or at least the first) loaded as well*/ }; results.Add(result); } if (request == null) { return new List <DTO_CORE_GigAlert> { new DTO_CORE_GigAlert { Comment = "empty request" } } } ; else if (results.Count == 0) { return new List <DTO_CORE_GigAlert> { new DTO_CORE_GigAlert { Comment = "empty response" } } } ; else { return(results); } } }
public List <DTO_SPRT_Major> GetMajors() { List <DTO_SPRT_Major> returnObject = new List <DTO_SPRT_Major>(); GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var list = context.proc_GetMajors().ToList(); foreach (var entity in list) { returnObject.Add(new DTO_SPRT_Major(entity.MajorID, entity.MajorName)); } return(returnObject); }
public List <DTO_SPRT_College> GetColleges() { List <DTO_SPRT_College> returnObject = new List <DTO_SPRT_College>(); GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var list = context.proc_GetColleges().ToList(); foreach (var entity in list) { returnObject.Add(new DTO_SPRT_College(entity.CollegeID, entity.CollegeName)); } return(returnObject); }
public List <DTO_SPRT_GigCategory> GetGigCategories() { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); List <DTO_SPRT_GigCategory> results = new List <DTO_SPRT_GigCategory>(); var list = context.SPRT_GigCategories.ToList(); foreach (var entity in list) { results.Add(new DTO_SPRT_GigCategory(entity.CategoryID, entity.Category)); } return(results); }
public List <DTO_SPRT_GigType> GetGigTypeByCategoryID(DTO_SPRT_GigType request) { List <DTO_SPRT_GigType> results = new List <DTO_SPRT_GigType>(); GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var list = context.proc_GetGigTypes().Where(gt => gt.CategoryID == request.CategoryID).ToList(); foreach (var entity in list) { results.Add(new DTO_SPRT_GigType(entity.typeid, entity.TypeName)); } return(results); }
public List <DTO_SPRT_GigType> GetGigTypeByID(DTO_SPRT_GigType request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var returnObject = new List <DTO_SPRT_GigType>(); var gigType = context.proc_GetGigTypes().Where(gt => gt.typeid == request.TypeID).Single(); if (gigType != null) { DTO_SPRT_GigType result = new DTO_SPRT_GigType(gigType.typeid, gigType.TypeName); returnObject.Add(result); } return(returnObject); }
public List <DTO_SPRT_GigType> GetGigs(DTO_SPRT_GigType request) { List <DTO_SPRT_GigType> results = new List <DTO_SPRT_GigType>(); using (DB_connection context = new GigALoan_DAL.DB_connection()) { var list = context.proc_GetGigTypes().ToList(); foreach (var entity in list) { results.Add(new DTO_SPRT_GigType(entity.typeid, entity.TypeName)); } return(results); } }
public List <DTO_SPRT_GigCategory> GetGigCategoryByID(DTO_SPRT_GigCategory request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var returnObject = new List <DTO_SPRT_GigCategory>(); var gigCategory = context.SPRT_GigCategories.Where(gc => gc.CategoryID == request.CategoryID).Single(); if (gigCategory != null) { var gig = new DTO_SPRT_GigCategory(gigCategory.CategoryID, gigCategory.Category); returnObject.Add(gig); } return(returnObject); }
public List <DTO_SPRT_College> GetCollegeByID(DTO_SPRT_College request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var returnObject = new List <DTO_SPRT_College>(); var college = context.proc_GetColleges().Where(col => col.CollegeID == request.CollegeID).Single(); DTO_SPRT_College result = new DTO_SPRT_College(college.CollegeID, college.CollegeName); if (result != null) { returnObject.Add(result); } return(returnObject); }
public List <DTO_CORE_Student> GetStudentAccount(DTO_CORE_Student request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); List <DTO_CORE_Student> returnObject = new List <DTO_CORE_Student>(); var studentList = context.CORE_Students.ToList(); DTO_CORE_Student successfulMatchedStudent = null; foreach (var student in studentList) { if (request.Email.ToLower() == student.Email.ToLower()) { if (request.Pass == student.Pass) { successfulMatchedStudent = new DTO_CORE_Student(); successfulMatchedStudent.StudentID = student.StudentID; successfulMatchedStudent.FirstName = student.FirstName; successfulMatchedStudent.LastName = student.LastName; successfulMatchedStudent.DateJoined = student.DateJoined; successfulMatchedStudent.Email = student.Email; successfulMatchedStudent.Pass = student.Pass; successfulMatchedStudent.MajorID = student.MajorID; successfulMatchedStudent.CollegeID = student.CollegeID; successfulMatchedStudent.Gender = student.Gender; if (student.Employed != null) { successfulMatchedStudent.Employed = (bool)student.Employed; } successfulMatchedStudent.Employer = student.Employer; successfulMatchedStudent.PhoneNumber = student.PhoneNumber; returnObject.Add(successfulMatchedStudent); return(returnObject); } } } return(null); }
public static List <DTO_CORE_Student> GetStudentsBySkillID(DTO_SPRT_GigType request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); List <DTO_CORE_Student> results = new List <DTO_CORE_Student>(); var students = context.CORE_Students.Where(s => s.SPRT_GigTypes.Any(gt => gt.TypeID == request.TypeID)); foreach (var student in students) { results.Add(new DTO_CORE_Student { StudentID = student.StudentID }); } return(results); }
public List <DTO_SPRT_LoanCompany> GetLoanCompanyByID(DTO_SPRT_LoanCompany request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var returnObject = new List <DTO_SPRT_LoanCompany>(); var loanCompany = context.SPRT_LoanCompanies.Where(lc => lc.CompanyID == request.CompanyID).Single(); DTO_SPRT_LoanCompany result = new DTO_SPRT_LoanCompany { CompanyID = loanCompany.CompanyID, CompanyName = loanCompany.CompanyName, CompanyState = loanCompany.CompanyState }; returnObject.Add(result); return(returnObject); }
public List <DTO_SPRT_Major> GetMajorByID(DTO_SPRT_Major request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var major = context.proc_GetMajors().Where(m => m.MajorID == request.MajorID).Single(); var returnObject = new List <DTO_SPRT_Major>(); DTO_SPRT_Major result; if (major != null) { result = new DTO_SPRT_Major(major.MajorID, major.MajorName); returnObject.Add(result); } return(returnObject); }
public List <DTO_CORE_Client> GetClientAccount(DTO_CORE_Client request) { using (DB_connection context = new GigALoan_DAL.DB_connection()) { var clientList = context.CORE_Clients.ToList(); DTO_CORE_Client successfulMatchedClient = null; var returnObject = new List <DTO_CORE_Client>(); foreach (var client in clientList) { if (request.Email.ToLower() == client.Email.ToLower()) { if (request.Pass == client.Pass) { successfulMatchedClient = new DTO_CORE_Client(); successfulMatchedClient.ClientID = client.ClientID; successfulMatchedClient.FirstName = client.FirstName; successfulMatchedClient.LastName = client.LastName; successfulMatchedClient.DateJoined = client.DateJoined; successfulMatchedClient.Email = client.Email; successfulMatchedClient.Pass = client.Pass; successfulMatchedClient.Gender = client.Gender; successfulMatchedClient.PhoneNumber = client.PhoneNumber; if (client.Active != null) { successfulMatchedClient.Active = (bool)client.Active; } returnObject.Add(successfulMatchedClient); return(returnObject); } } } return(null); } }
public List <DTO_SPRT_LoanCompany> GetGigLoanCompanies() { List <DTO_SPRT_LoanCompany> results = new List <DTO_SPRT_LoanCompany>(); GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); var list = context.SPRT_LoanCompanies.ToList(); foreach (var entity in list) { results.Add(new DTO_SPRT_LoanCompany { CompanyID = entity.CompanyID, CompanyName = entity.CompanyName, CompanyState = entity.CompanyState }); } return(results); }
public static List <DTO_CORE_Student> AlertLocalStudents(DTO_CORE_GigAlert alert, int range) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); if (range == 0) { range = 10; //10 miles } var localStudents = context.proc_GetLocalStudentsByAlert(alert.AlertID, range).ToList(); List <DTO_CORE_Student> returnList = new List <DTO_CORE_Student>(); foreach (var s in localStudents) { returnList.Add(new DTO_CORE_Student { StudentID = s.Value }); } return(returnList); }
public List <DTO_CORE_Gig> CreateGig(DTO_CORE_Gig request) { GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection(); string insertString = "IF ((SELECT Active FROM CORE_GigAlerts WHERE AlertID = " + request.AlertID + ") = 1) " + "INSERT INTO CORE_Gigs(AlertID, DateAccepted, StudentID, ClientComments, StudentRating, ClientRating) VALUES(" + request.AlertID + ", " + request.DateAccepted.ToString("yyyy-mm-dd") + ", " + request.StudentID + ", '" + request.ClientComments + "', 0, 0) " + "UPDATE CORE_GigAlerts SET Active = 0 FROM CORE_GigAlerts WHERE AlertID = " + request.AlertID; SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Server=tcp:s05.winhost.com;Database=DB_42039_gig;User ID=DB_42039_gig_user;Password=gigaloan"; SqlCommand cmd = new SqlCommand(insertString, connection); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); var result = context.CORE_Gigs.Where(g => g.AlertID == request.AlertID).Single(); DTO_CORE_Gig gigToBeReturned = new DTO_CORE_Gig { AlertID = result.AlertID, ClientComments = result.ClientComments, ClientRating = 0.0, DateAccepted = result.DateAccepted, DateClosed = Convert.ToDateTime(null), GigID = result.GigID, StudentComments = "", StudentID = result.StudentID, StudentRating = 0.0 }; var returnObject = new List <DTO_CORE_Gig>(); returnObject.Add(gigToBeReturned); return(returnObject); }
public List <DTO_CORE_Gig> FindGigsByClientID(DTO_CORE_Client request) { List <DTO_CORE_Gig> results = new List <DTO_CORE_Gig>(); using (DB_connection context = new GigALoan_DAL.DB_connection()) { var gigList = context.CORE_Gigs.Where(g => g.CORE_GigAlerts.ClientID == request.ClientID); foreach (CORE_Gigs gig in gigList) { DTO_CORE_Gig result = new DTO_CORE_Gig { GigID = gig.GigID, StudentID = gig.StudentID, AlertID = gig.AlertID, DateAccepted = gig.DateAccepted, StudentComments = gig.StudentComments, ClientComments = gig.ClientComments }; if (gig.DateClosed != null) { result.DateClosed = (DateTime)gig.DateClosed; } if (gig.StudentRating != null) { result.StudentRating = (double)gig.StudentRating; } if (gig.ClientRating != null) { result.ClientRating = (double)gig.ClientRating; } results.Add(result); } return(results); } }