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