public HttpResponseMessage GetUserChitInvitaion(string UserId) { try { using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[UserChitInvitaion]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@userid", UserId)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> Foo List <M_UserChitInvitation> _UserChitInvitation = ((IObjectContextAdapter)db) .ObjectContext .Translate <M_UserChitInvitation>(reader).ToList <M_UserChitInvitation>(); // move to next result set return(Request.CreateResponse(HttpStatusCode.OK, _UserChitInvitation)); } } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E)); } }
public HttpResponseMessage GetMemberList(string SearchTerm) { try { using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[SearchUser]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@searchterm", SearchTerm)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Get Current Chit List List <M_SearchUser> _SearchUserList = ((IObjectContextAdapter)db) .ObjectContext .Translate <M_SearchUser>(reader).ToList(); //move to next result set //reader.NextResult(); return(Request.CreateResponse(HttpStatusCode.OK, _SearchUserList)); } } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed")); } }
public HttpResponseMessage GetProfile(string UserId) { try { G_UserProfile _UserProfile; using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[UserProfile]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@userid", UserId)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> Foo _UserProfile = ((IObjectContextAdapter)db).ObjectContext.Translate <G_UserProfile>(reader).FirstOrDefault(); } return(Request.CreateResponse(HttpStatusCode.OK, _UserProfile)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E)); } }
public HttpResponseMessage GetInvitation(string ChitId) { try { List <G_ChitInvitation> _G_ChitInvitation = new List <G_ChitInvitation>(); //var a = _db.GetChitDetails(Chitid); using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[ChitInvitationsStatus]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@chitid", ChitId)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> _G_ChitInvitation _G_ChitInvitation = ((IObjectContextAdapter)db) .ObjectContext .Translate <G_ChitInvitation>(reader).ToList <G_ChitInvitation>(); } return(Request.CreateResponse(HttpStatusCode.OK, _G_ChitInvitation)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed Transaction" + E.InnerException)); } }
public HttpResponseMessage GetChitDetails(String Chitid, string UserId) { try { HomeChitData _HomeChitData = new HomeChitData(); //var a = _db.GetChitDetails(Chitid); using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[GetChitDetails]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@chitid", Chitid)); cmd.Parameters.Add(new SqlParameter("@userid", UserId)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> Foo _HomeChitData.ChitDetails = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitDetail>(reader, "ChitDetails", MergeOption.AppendOnly).FirstOrDefault(); // move to next result set reader.NextResult(); // Read second model --> Bar _HomeChitData.ChitUserDetails = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitUserDetails>(reader).ToList <ChitUserDetails>(); reader.NextResult(); _HomeChitData.ChitTermGroupList = ((IObjectContextAdapter)db) .ObjectContext .Translate <TempChitTermGroup>(reader).ToList(); reader.NextResult(); _HomeChitData.ChitBidTimeTableList = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitBidTimeTable>(reader, "ChitBidTimeTables", MergeOption.AppendOnly).ToList(); reader.NextResult(); _HomeChitData.ConnectionDetails = ((IObjectContextAdapter)db).ObjectContext .Translate <ChitConnection>(reader, "ChitConnections", MergeOption.AppendOnly).FirstOrDefault(); } return(Request.CreateResponse(HttpStatusCode.OK, _HomeChitData)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E)); } }
public HttpResponseMessage GetTenureDetails(string userid, string Chitid, string termgroupid) { try { TransactionService _TransactionService = new TransactionService(); using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[TermGroupDetails]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@chitid", Chitid)); cmd.Parameters.Add(new SqlParameter("@termgroupid", termgroupid)); cmd.Parameters.Add(new SqlParameter("@userid", userid)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> Foo _TransactionService.TenureTransactionList = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitTenureTransaction>(reader).ToList(); // move to next result set reader.NextResult(); // Read second model --> Bar _TransactionService.TermGroupBidList = ((IObjectContextAdapter)db) .ObjectContext .Translate <TermGroupBidList>(reader).ToList <TermGroupBidList>(); reader.NextResult(); _TransactionService.TransactionChitTermDetails = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitTermGroup>(reader, "ChitTermGroups", MergeOption.AppendOnly).FirstOrDefault(); reader.NextResult(); _TransactionService.IsTransactionDoneForCurrentTerm = ((IObjectContextAdapter)db) .ObjectContext .Translate <ChitTransaction>(reader).ToList(); reader.NextResult(); _TransactionService.IsBidDoneForCurrentTerms = ((IObjectContextAdapter)db) .ObjectContext .Translate <IsBidDoneForCurrentTerm>(reader).FirstOrDefault(); } return(Request.CreateResponse(HttpStatusCode.OK, _TransactionService)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E)); } }
public HttpResponseMessage GetTimeTable(string ChitId) { try { G_ChitTimeTable _G_ChitTimeTable = new G_ChitTimeTable(); using (var db = new chittiedevEntities()) { _G_ChitTimeTable.ChitBidTimeTablesList = db.ChitBidTimeTables.Where(d => d.chitID == ChitId).ToList(); _G_ChitTimeTable.ChitTermGroupsList = db.ChitTermGroups.Where(d => d.chitid == ChitId).ToList(); } return(Request.CreateResponse(HttpStatusCode.OK, _G_ChitTimeTable)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E.InnerException)); } }
public HttpResponseMessage getDashboardDetails(string UserId) { try { G_M_DashboardDetails _DashboardDetails = new G_M_DashboardDetails(); //var a = _db.GetChitDetails(Chitid); using (var db = new chittiedevEntities()) { // Create a SQL command and add parameter var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "[getDashboardDetails]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@userid", UserId)); // execute your command db.Database.Connection.Open(); var reader = cmd.ExecuteReader(); // Read first model --> Foo _DashboardDetails.TotalChits = ((IObjectContextAdapter)db).ObjectContext.Translate <Int32>(reader).FirstOrDefault(); // move to next result set reader.NextResult(); _DashboardDetails.TotalSavings = ((IObjectContextAdapter)db).ObjectContext.Translate <Int32>(reader).FirstOrDefault(); reader.NextResult(); _DashboardDetails.TotalLoansAvailed = ((IObjectContextAdapter)db).ObjectContext.Translate <Int32>(reader).FirstOrDefault(); } return(Request.CreateResponse(HttpStatusCode.OK, _DashboardDetails)); } catch (Exception E) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed" + E)); } }