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));
}
}
