public HttpResponseMessage AddTransaction([FromBody] M_SendInvitation SendInvitation)
{
try
{
ChitConnection _NewInvitation = new ChitConnection();
_NewInvitation.chitid = SendInvitation.ChitId;
_NewInvitation.userid = SendInvitation.UserId;
_NewInvitation.organiser = false;
_NewInvitation.statusid = 0;
_NewInvitation.createddate = DateTime.Now;
_NewInvitation.updatedate = DateTime.Now;
_db.ChitConnections.Add(_NewInvitation);
_db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
catch (Exception E)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed Transaction" + E.InnerException));
}
}
public HttpResponseMessage CreateChit([FromBody] M_CreateChit CreateChit)
{
//Creating New Chit First
try
{
//ChitDetail NewChit = new ChitDetail
//{
// chitname = CreateChit.ChitName,
// tenure = CreateChit.ChitDuration,
// percentage = 0,
// membercount = CreateChit.TotalMembers,
// startdate = CreateChit.StartDate,
// amount = (CreateChit.ChitEMIAmount * CreateChit.ChitDuration),
// emi = CreateChit.ChitEMIAmount,
// createddate = DateTime.Now,
// updateddate = DateTime.Now,
// status = 1
//};
_db.Database.ExecuteSqlCommand("" +
"Insert into CHitDetails(chitname,tenure,percentage,membercount,startdate,amount,createddate,updateddate,status,emi) values(@chitname,@tenure,@percentage,@membercount,@startdate,@amount,@createddate,@updateddate,@status,@emi)",
new SqlParameter("@chitname", CreateChit.ChitName),
new SqlParameter("@tenure", CreateChit.ChitDuration),
new SqlParameter("@percentage", Convert.ToDecimal(0)),
new SqlParameter("@membercount", CreateChit.TotalMembers),
new SqlParameter("@startdate", CreateChit.StartDate),
new SqlParameter("@amount", (CreateChit.ChitEMIAmount * CreateChit.ChitDuration)),
new SqlParameter("@createddate", DateTime.Now),
new SqlParameter("@updateddate", DateTime.Now),
new SqlParameter("@status", 1),
new SqlParameter("@emi", CreateChit.ChitEMIAmount)
);
// var a = _db.ChitDetails.Add(NewChit);
_db.SaveChanges();
//Getting Chit Id from ChitDetails table
String GetChitId = _db.ChitDetails.Where(s => s.chitname == CreateChit.ChitName).FirstOrDefault().chitid;
//Create Connection
ChitConnection NewChitConnection = new ChitConnection();
NewChitConnection.userid = CreateChit.UserId;
NewChitConnection.chitid = GetChitId;
NewChitConnection.organiser = true;
NewChitConnection.statusid = 1;
NewChitConnection.createddate = DateTime.Now;
NewChitConnection.updatedate = DateTime.Now;
var StatusChitConnection = _db.ChitConnections.Add(NewChitConnection);
_db.SaveChanges();
//Creating Chit Table
List <ChitTermGroup> _ChitTermGroupList = new List <ChitTermGroup>();
foreach (var ed in CreateChit.UserFinalChitDateTime)
{
ChitTermGroup A = new ChitTermGroup();
A.chitid = GetChitId;
A.termgroupid = GetChitId + "/" + ed.DurationID;
A.startdate = ed.StartDate;
A.enddate = ed.EndDate;
A.termnumber = ed.DurationID;
A.createddate = DateTime.Now;
A.status = true;
A.EMIAmount = CreateChit.ChitEMIAmount;
_ChitTermGroupList.Add(A);
}
_db.ChitTermGroups.AddRange(_ChitTermGroupList);
_db.SaveChanges();
//Creating BID Table
List <ChitTermGroup> GetTermDetailsList = _db.ChitTermGroups.Where(d => d.chitid == GetChitId).ToList();
List <ChitBidTimeTable> NewChitBidTimeTableList = new List <ChitBidTimeTable>();
int CountChitTable = 0;
foreach (var e in GetTermDetailsList)
{
ChitBidTimeTable NewChitBidTimeTable = new ChitBidTimeTable();
NewChitBidTimeTable.chitID = GetChitId;
if ((GetTermDetailsList[CountChitTable].termnumber) - 1 == CountChitTable)
{
NewChitBidTimeTable.Amount = CreateChit.UserBidDateTime[CountChitTable].BidAmount;
NewChitBidTimeTable.startDate = e.startdate;
NewChitBidTimeTable.endDate = e.enddate;
NewChitBidTimeTable.Termid = e.termgroupid;
CountChitTable++;
NewChitBidTimeTableList.Add(NewChitBidTimeTable);
}
}
_db.ChitBidTimeTables.AddRange(NewChitBidTimeTableList);
_db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
catch (Exception E)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Failed"));
}
//Updating Bid Table
}
