public Billsettlemententity getbyid(long id)
{
Billsettlemententity entity = new Billsettlemententity();
using (var db = new EventDBEntities())
{
var record = db.BillSettlementmasters.Find(id);
entity.Entrydate = record.Entrydate;
entity.Creditedfrom = record.Creditedfrom;
entity.Creditamount = record.Creditamount;
entity.Paidamount = record.Paidamount;
entity.Paidby = record.Paidby;
}
return(entity);
}
public ActionResult Create(FormCollection frm, Billsettlemententity entity)
{
string eventdatestr = frm["entrydate"].ToString();
entity.Paidby = Helper.Helper.CurrentLoggedUser.Id;
if (eventdatestr != "")
{
DateTime evdate = DateTime.ParseExact(eventdatestr, "dd/MM/yyyy", CultureInfo.InvariantCulture);
entity.Entrydate = evdate;
}
var inserted = obj.Insert(entity);
if (inserted)
{
return(RedirectToAction("Index"));
}
return(View());
}
public bool Insert(Billsettlemententity entity)
{
bool inserted = false;
using (var db = new EventDBEntities())
{
BillSettlementmaster record = new BillSettlementmaster();
record.Entrydate = entity.Entrydate;
record.Creditedfrom = entity.Creditedfrom;
record.Creditamount = entity.Creditamount;
record.Paidamount = entity.Paidamount;
record.Paidby = entity.Paidby;
record.IsActive = true;
db.BillSettlementmasters.Add(record);
db.SaveChanges();
inserted = true;
}
return(inserted);
}
public List <Billsettlemententity> Get()
{
List <Billsettlemententity> list = new List <Billsettlemententity>();
using (var db = new EventDBEntities())
{
var records = db.BillSettlementmasters.ToList().Where(x => x.IsActive == true).ToList();
foreach (var item in records)
{
Billsettlemententity entity = new Billsettlemententity();
entity.Id = item.Id;
entity.Paidamount = item.Paidamount;
entity.Paidby = item.Paidby;
entity.Entrydate = item.Entrydate;
list.Add(entity);
}
}
return(list);
}
