internal static InvoiceInfo FetchInvoiceInfo(Data.Invoice data) { var result = new InvoiceInfo(); result.Fetch(data); return(result); }
protected void Insert(Data.Invoice data) { data.InvoiceId = this.ReadProperty(InvoiceIdProperty); data.CreatedBy = ((BusinessIdentity)Csla.ApplicationContext.User.Identity).UserId; data.CreatedDate = DateTime.Now; this.Update(data); }
protected override void DataPortal_DeleteSelf() { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice { InvoiceId = this.ReadProperty(InvoiceIdProperty) }; ctx.ObjectContext.Invoices.DeleteObject(data); ctx.ObjectContext.SaveChanges(); } }
protected void Update(Data.Invoice data) { if (this.IsSelfDirty) { data.Number = this.ReadProperty(NumberProperty); data.TaskId = this.ReadProperty(TaskIdProperty); data.PreparedDate = this.ReadProperty(PreparedDateProperty); data.Description = this.ReadProperty(DescriptionProperty); data.Amount = this.ReadProperty(AmountProperty); data.IsArchived = this.ReadProperty(IsArchivedProperty); data.Notes = this.ReadProperty(NotesProperty); data.ModifiedBy = ((BusinessIdentity)Csla.ApplicationContext.User.Identity).UserId; data.ModifiedDate = DateTime.Now; } }
protected override void DataPortal_DeleteSelf() { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice { InvoiceId = this.ReadProperty(InvoiceIdProperty) }; ctx.ObjectContext.Invoices.DeleteObject(data); ctx.ObjectContext.SaveChanges(); } }
protected override void DataPortal_Insert() { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice(); this.Insert(data); ctx.ObjectContext.AddToInvoices(data); ctx.ObjectContext.SaveChanges(); this.LoadProperty(InvoiceIdProperty, data.InvoiceId); this.LoadProperty(CreatedByProperty, data.CreatedBy); this.LoadProperty(CreatedDateProperty, data.CreatedDate); } }
protected override void DataPortal_Insert() { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice(); this.Insert(data); ctx.ObjectContext.AddToInvoices(data); ctx.ObjectContext.SaveChanges(); this.LoadProperty(InvoiceIdProperty, data.InvoiceId); this.LoadProperty(CreatedByProperty, data.CreatedBy); this.LoadProperty(CreatedDateProperty, data.CreatedDate); } }
protected void Fetch(Data.Invoice data) { this.LoadProperty(InvoiceIdProperty, data.InvoiceId); this.LoadProperty(NumberProperty, data.Number); this.LoadProperty(ProjectIdProperty, data.Task.ProjectId); this.LoadProperty(ProjectNameProperty, data.Task.Project.Name); this.LoadProperty(DescriptionProperty, data.Description); this.LoadProperty(TaskIdProperty, data.TaskId); this.LoadProperty(PreparedDateProperty, data.PreparedDate); this.LoadProperty(AmountProperty, data.Amount); this.LoadProperty(IsArchivedProperty, data.IsArchived); this.LoadProperty(NotesProperty, data.Notes); this.LoadProperty(ModifiedByProperty, data.ModifiedBy); this.LoadProperty(ModifiedByNameProperty, data.ModifiedByUser.Name); this.LoadProperty(ModifiedDateProperty, data.ModifiedDate); this.LoadProperty(CreatedByProperty, data.CreatedBy); this.LoadProperty(CreatedByNameProperty, data.CreatedByUser.Name); this.LoadProperty(CreatedDateProperty, data.CreatedDate); }
protected override void DataPortal_Update() { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice { InvoiceId = this.ReadProperty(InvoiceIdProperty) }; ctx.ObjectContext.Invoices.Attach(data); this.Update(data); ctx.ObjectContext.SaveChanges(); this.LoadProperty(ModifiedByProperty, data.ModifiedBy); this.LoadProperty(ModifiedDateProperty, data.ModifiedDate); } }
protected override void DataPortal_Update() { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var data = new Data.Invoice { InvoiceId = this.ReadProperty(InvoiceIdProperty) }; ctx.ObjectContext.Invoices.Attach(data); this.Update(data); ctx.ObjectContext.SaveChanges(); this.LoadProperty(ModifiedByProperty, data.ModifiedBy); this.LoadProperty(ModifiedDateProperty, data.ModifiedDate); } }
public JsonResult Create(string Tablename, int ClientId, List<string[]> TableValue, string[] ColumnName, string[] ColumnValue ) { string msg = "Data Saved"; var ListData = new List<InvoiceData>(); if (ColumnName.Length != ColumnValue.Length) { msg = "Missing Values"; } else { var invoice = new Data.Invoice() { Client_Id = ClientId, Payment_Status = false, }; foreach (var l in TableValue) ListData.Add(new Data.InvoiceData() { Invoice = invoice, Description = l[0], Labor = decimal.Parse(l[1]), Tax = decimal.Parse(l[2]), Total = decimal.Parse(l[3]) }); foreach (var i in ListData) { DataService.InvoiceData.Add(i); } DataService.Invoice.Add(invoice); try { StringBuilder query = new StringBuilder("INSERT INTO [" + Tablename + "] (Id, "); int i = 0; for (; i < ColumnName.Length - 1; i++) { query.AppendFormat("[{0}], ", ColumnName[i]); } query.AppendFormat("[{0}]) VALUES ({1}, ", ColumnName[i], ClientId); for (i=0; i < ColumnValue.Length - 1; i++) { query.AppendFormat("'{0}', ", ColumnValue[i]); } query.AppendFormat("'{0}')", ColumnValue[i]); DataService.DataContext.Database.ExecuteSqlCommand(query.ToString()); } catch (Exception e) { DataService.Invoice.Delete(invoice); foreach(var i in ListData) DataService.InvoiceData.Delete(i); msg = e.Message; Console.Write(msg); } } return new JsonResult() { Data = new { message = msg} }; }