public HttpResponseMessage Get([FromUri] Guid?id, [FromUri] Guid?projectId)
{
var model = db.MemberPayments
.Include(x => x.Member)
.Include(x => x.Project)
.FirstOrDefault(x => x.Id == id);
if (model == null)
{
model = new MemberPayment
{
Id = Guid.Empty,
DateTime = DateTime.Now,
ProjectId = projectId.Value,
Project = db.Projects.FirstOrDefault(x => x.Id == projectId.Value),
};
model.Member = db.ProjectMembers.Where(x => x.ProjectId == projectId & x.MemberType == ProjectMemberType.Customer).Select(z => z.Member).FirstOrDefault();
model.MemberId = model.Member == null ? (Guid?)null : model.Member.Id;
}
var r = ExtensionsOject.ToDynamic(model);
r.Currency = db.Currencies.FirstOrDefault(x => x.UserId == UserId & x.CurrencyType == model.Project.RateCurrencyType);
return(ResponseObject2Json(r));
}
public IEnumerable <MemberPayment> GetAllMemberPaymentById(int id)
{
try
{
SqlDataReader dr;
List <MemberPayment> MemberPaymentList = new List <MemberPayment>();
using (SqlConnection con = new SqlConnection(connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl_Payment where MemberId= " + id + "", con);
dr = cmd.ExecuteReader();
MemberPayment MemberPayment = new MemberPayment();
while (dr.Read())
{
MemberPayment.MemberId = Convert.ToInt32(dr["MemberId"]);
MemberPayment.PaymentId = Convert.ToInt32(dr["PaymentId"]);
MemberPayment.PaymentDate = Convert.ToDateTime(dr["PaymentDate"]);
MemberPayment.PaymentAmount = Convert.ToInt32(dr["PaymentAmount"]);
MemberPayment.NextPaymentDate = Convert.ToDateTime(dr["NextPaymentDate"]);
// MemberPayment.IsRenewal = Convert.ToBoolean(dr["IsRenewal"]);
MemberPaymentList.Add(MemberPayment);
}
con.Close();
}
return(MemberPaymentList);
}
catch (Exception e)
{
throw e;
}
}
private void UpdateMemberPaymentsTable(string TransactionID)
{
//CREATE A LIST TO STORE THE ATHLETE DETAILS
List <Members> memberList = new List <Members>();
var str = HttpContext.Session.GetString("memberList");
if (str != null)
{
var obj = JsonConvert.DeserializeObject <List <Members> >(str);
memberList = (obj);
}
if (User.IsInRole("RegisteredUser"))
{
// Retrieve members that are attached to this user account
memberList = GetAssociatedMembers();
}
MemberPayment memPay = new MemberPayment();
foreach (Members member in memberList)
{
memPay.MemberID = member.MemberID;
memPay.PaymentID = TransactionID;
//MEMBERSHIP PAID COLUMN UPDATED TO 'TRUE' USING A TRIGGER ON MEMBERPAYMENTS TABLE
_context.Add(memPay);
_context.SaveChanges();
}
HttpContext.Session.Remove("memberList");
}
public int InsertMemberPayment(MemberPayment payment)
{
try
{
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_AddPayment", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberId", payment.MemberId);
cmd.Parameters.AddWithValue("@PaymentDate", payment.PaymentDate);
cmd.Parameters.AddWithValue("@NextPaymentDate", payment.NextPaymentDate);
if (string.IsNullOrEmpty(payment.PaymentBy))
{
payment.PaymentBy = "";
}
cmd.Parameters.AddWithValue("@PaymentBy", payment.PaymentBy);
cmd.Parameters.AddWithValue("@PaymentAmount", payment.PaymentAmount);
cmd.Parameters.AddWithValue("@IsRenewal", payment.IsRenewal);
con.Open();
int paymentid = cmd.ExecuteNonQuery();
con.Close();
return(paymentid);
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult UpdateRenewMember(MemberPayment payment)
{
try
{
payment.IsRenewal = "Y";
payment.PaymentBy = "Avi";
int PaymentId = objPaymentMember.UpdateMemberPayment(payment);
if (PaymentId > 0)
{
ViewBag.Text = "Payment updated Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Member updated.";
}
return(Json(payment, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
throw e;
}
}
public List <MemberPayment> MemberLastPaymentReport()
{
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
SqlCommand sqlCommand = new SqlCommand();
List <MemberPayment> listMemberPayments = new List <MemberPayment>();
try
{
using (SqlConnection connection =
new SqlConnection(CommonUtility.Sqlconnectionstring))
{
connection.Open();
sqlCommand.Connection = connection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "Sp_getmemberwiselastpayment";
adapter.SelectCommand = sqlCommand;
adapter.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var objDateTime = (DateTime)ds.Tables[0].Rows[i]["lastpaymentdate"];
string memberPaymentDate = objDateTime.ToString("dd-MMM-yyyy");
MemberPayment membersList = new MemberPayment
{
MemberCode = (string)ds.Tables[0].Rows[i]["membercode"],
MemberName = (string)ds.Tables[0].Rows[i]["membername"],
MemberMobile = ds.Tables[0].Rows[i]["membermobile"].ToString(),
MemberType = (string)ds.Tables[0].Rows[i]["membertype"],
TimeSlot = (string)ds.Tables[0].Rows[i]["slotname"],
PaymentDate = memberPaymentDate,
PaymentAmount = ds.Tables[0].Rows[i]["paymentamount"].ToString(),
IsActive = (bool)ds.Tables[0].Rows[i]["isactive"]
};
listMemberPayments.Add(membersList);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
finally
{
sqlCommand?.Connection?.Close();
}
return(listMemberPayments);
}
public ActionResult Create(MemberPayment payment)
{
try
{
if (string.IsNullOrEmpty(payment.PaymentDate.ToString()))
{
ModelState.AddModelError("Error", "Please enter Payment Date");
}
else if (string.IsNullOrEmpty(payment.NextPaymentDate.ToString()))
{
ModelState.AddModelError("Error", "Please enter Next Payment Date");
}
else if (string.IsNullOrEmpty(payment.PaymentAmount.ToString()))
{
ModelState.AddModelError("Error", "Please enter Amount");
}
else
{
payment.MemberId = payment.MemberDetails.MemberId.Value;
payment.IsRenewal = "Y";
payment.PaymentBy = "Avi";
int PaymentId = objPayment.InsertMemberPayment(payment);
if (PaymentId > 0)
{
ViewBag.Text = "Member Created Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Member Created .";
}
return(RedirectToAction("create"));
}
return(View(payment));
}
catch (Exception e)
{
throw e;
}
}
public HttpResponseMessage Post(MemberPayment model)
{
var p = db.ProjectMembers.FirstOrDefault(x => x.ProjectId == model.ProjectId & x.MemberType == ProjectMemberType.Implementer & x.Member.MainMemberId == UserId);
if (p != null)
{
model.Member = null;
model.Project = null;
model.Id = Guid.NewGuid();
model.UserId = UserId;
db.MemberPayments.Add(model);
db.SaveChanges();
}
return(ResponseObject2Json(null));
}
private List <Members> GetAssociatedMembers()
{
var userEmail = User.FindFirstValue(ClaimTypes.Name);
Members thisMember = _context.Members.Where(m => m.Email == userEmail).First();
MemberPayment memPay = _context.MemberPayments.Where(mp => mp.MemberID == thisMember.MemberID).First();
List <MemberPayment> memPayments = _context.MemberPayments.Where(mp => mp.PaymentID == memPay.PaymentID).ToList();
List <Members> userMembers = new List <Members>();
foreach (var item in memPayments)
{
Members member = _context.Members.Where(m => m.MemberID == item.MemberID).First();
userMembers.Add(member);
}
return(userMembers);
}
public HttpResponseMessage Put(MemberPayment model)
{
var p = db.ProjectMembers.FirstOrDefault(x => x.ProjectId == model.ProjectId & x.MemberType == ProjectMemberType.Implementer & x.Member.MainMemberId == UserId);
var m = db.MemberPayments.FirstOrDefault(x => x.Id == model.Id & x.UserId == UserId);
if ((p != null) & (m != null))
{
db.AttachModel(model,
x => x.DateTime,
x => x.Amount
);
db.SaveChanges();
}
return(ResponseObject2Json(null));
}
public int InsertPayment(MemberRegistration ObjMember, int MemberId)
{
try {
MemberPayment ObjMemberPayment = new MemberPayment();
ObjMemberPayment.MemberId = MemberId;
ObjMemberPayment.PaymentDate = ObjMember.MembershipDate;
ObjMemberPayment.NextPaymentDate = ObjMember.MembershipExpiryDate;
ObjMemberPayment.PaymentAmount = ObjMember.MembershipAmount;
ObjMemberPayment.PaymentBy = "Avi";
ObjMemberPayment.IsRenewal = "N";
int paymentid = objPaymentMember.InsertMemberPayment(ObjMemberPayment);
return(paymentid);
}
catch (Exception e)
{
throw e;
}
}
public MemberPayment GetMemberPaymentById(int id)
{
try
{
SqlDataReader dr;
MemberPayment MemberPayment = new MemberPayment();
using (SqlConnection con = new SqlConnection(connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from View_MemberPayment where IsRenewal='N' and MemberId= " + id + "", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
MemberPayment.PaymentId = Convert.ToInt32(dr["PaymentId"]);
MemberPayment.NextPaymentDate = Convert.ToDateTime(dr["NextPaymentDate"]);
MemberPayment.MemberDetails = new MemberRegistration
{
MemberId = Convert.ToInt32(dr["MemberId"]),
MemberFirstName = dr["MemberFirstName"].ToString(),
MemberMiddleName = dr["MemberMiddleName"].ToString(),
MemberLastName = dr["MemberLastName"].ToString(),
MemberAddress = dr["MemberAddress"].ToString(),
EmailAddress = dr["EmailAddress"].ToString(),
Gender = dr["Gender"].ToString(),
MembershipAmount = Convert.ToInt32(dr["MembershipAmount"])
};
}
con.Close();
}
return(MemberPayment);
}
catch (Exception e)
{
throw e;
}
}
public IEnumerable <MemberPayment> GetPaymentDetails(int id)
{
try
{
using (SqlConnection con = new SqlConnection(connection))
{
SqlDataReader dr;
List <MemberPayment> PaymentList = new List <MemberPayment>();
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl_Payment where MemberId= " + id + "", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
MemberPayment payment = new MemberPayment();
payment.PaymentId = Convert.ToInt32(dr["PaymentId"]);
payment.MemberId = Convert.ToInt32(dr["MemberId"]);
payment.PaymentDate = Convert.ToDateTime(dr["PaymentDate"]);
DateTime dt = Convert.ToDateTime(dr["PaymentDate"]);
payment._PaymentDateToDisplay = dt.ToShortDateString();
payment.PaymentAmount = Convert.ToInt32(dr["PaymentAmount"]);
payment.NextPaymentDate = Convert.ToDateTime(dr["NextPaymentDate"]);
DateTime dtNextPay = Convert.ToDateTime(dr["NextPaymentDate"]);
payment._NextPaymentDateToDisplay = dtNextPay.ToShortDateString();
payment.disable = "disabled";
PaymentList.Add(payment);
}
con.Close();
return(PaymentList);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit(MemberPayment MemberPayment)
{
MemberPayment.PaymentBy = "Avi";
if (string.IsNullOrEmpty(MemberPayment.PaymentDate.ToString()))
{
ModelState.AddModelError("Error", "Please enter Payment Date");
}
else if (string.IsNullOrEmpty(MemberPayment.PaymentAmount.ToString()))
{
ModelState.AddModelError("Error", "Please enter Payment Amount");
}
else if (string.IsNullOrEmpty(MemberPayment.PaymentBy.ToString()))
{
ModelState.AddModelError("Error", "Please enter Payment By");
}
else
{
int payment = objPayment.UpdateMemberPayment(MemberPayment);
if (payment > 0)
{
ViewBag.Text = "Payment Updaed Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Payment Updated .";
}
return(RedirectToAction("Edit"));
}
return(View(MemberPayment));
}
