public ActionResult Create(FormCollection frm) { EventEntryEntity entity = new EventEntryEntity(); entity.Createddate = DateTime.Now; entity.Createdby = Helper.Helper.CurrentLoggedUser.Id; entity.Eventid = Convert.ToInt64(frm["eventid"]); entity.Location = frm["Location"].ToString(); entity.TotalAmount = Convert.ToDecimal(frm["TotalAmount"]); entity.IsActive = true; string eventdatestr = frm["entrydate"].ToString(); if (eventdatestr != "") { DateTime evdate = DateTime.ParseExact(eventdatestr, "dd/MM/yyyy", CultureInfo.InvariantCulture); entity.Eventdate = evdate; } List <EventCustomerentity> eventcustlist = new List <EventCustomerentity>(); var customerlist = frm["rowstr"].ToString(); if (customerlist != null) { string[] custstr = customerlist.Split('#'); foreach (var cust in custstr) { var custarr = cust.Split('~'); EventCustomerentity eventcustentity = new EventCustomerentity(); eventcustentity.Eventcustomerid = Convert.ToInt32(custarr[0]); eventcustentity.Paidamount = Convert.ToDecimal(custarr[1]); eventcustlist.Add(eventcustentity); } } entity.customerlist = eventcustlist; var inserted = obj.Insert(entity); if (inserted) { return(RedirectToAction("Index")); } return(View()); }
public EventEntryEntity Getbyid(int id) { EventEntryEntity entity = new EventEntryEntity(); using (var db = new EventDBEntities()) { var record = db.EventEntryMasters.Find(id); entity.Id = record.Id; entity.Location = record.Location; entity.TotalAmount = record.TotalAmount; entity.Eventid = record.Eventid; entity.Eventdate = record.Eventdate; var custrecords = db.EventCustomers.Where(x => x.Evententryid == id).ToList(); List <EventCustomerentity> eventcustlist = new List <EventCustomerentity>(); if (custrecords != null) { if (custrecords.Count > 0) { foreach (var item in custrecords) { EventCustomerentity eventcustentity = new EventCustomerentity(); eventcustentity.Eventcustomerid = item.Eventcustomerid; UserEntity userentity = new UserEntity(); if (item.UserMaster != null) { userentity.Id = item.UserMaster.Id; userentity.Fullname = item.UserMaster.Fullname; eventcustentity.UserMaster = userentity; } eventcustentity.Evententryid = item.Evententryid; eventcustentity.Paidamount = item.Paidamount; eventcustlist.Add(eventcustentity); } } entity.customerlist = eventcustlist; } } return(entity); }