/// <summary> /// 连接查询 方法簇 /// </summary> public static Queryer Queryer <M1, M2, M3, M4>(this XConnection conn, out M1 table1, out M2 table2, out M3 table3, out M4 table4) where M1 : class, new() where M2 : class, new() where M3 : class, new() where M4 : class, new() { table1 = new M1(); table2 = new M2(); table3 = new M3(); table4 = new M4(); var dc = new XContext <M1, M2, M3, M4>(conn) { Crud = CrudEnum.Join }; return(new Queryer(dc)); }
//GetAll public static List <CategoryViewModel> All() { List <CategoryViewModel> result = new List <CategoryViewModel>(); using (var db = new XContext()) { result = (from c in db.x_category where c.is_delete == false select new CategoryViewModel { Id = c.Id, Initial = c.initial, Name = c.name, Description = c.description }).ToList(); } return(result); }
/// <summary> /// 根据指定的实体构造一个插入命令 /// </summary> /// <param name="context"></param> /// <param name="entity"></param> internal Insert(XContext context, T entity) : this(context) { if (entity == null) { throw Error.ArgumentNullException(nameof(entity)); } var columns = tableMeta.Columns.Where(x => x.CanInsert).ToList(); foreach (var column in columns) { fieldString.Add(EscapeSqlIdentifier(column.ColumnName)); valueString.Add(GetParameterIndex()); this.parameters.Add(column.GetValue(entity)); } CheckIdentity(entity); }
//GetById public static CategoryViewModel ById(int Id) { CategoryViewModel result = new CategoryViewModel(); using (var db = new XContext()) { result = (from c in db.x_category where c.Id == Id select new CategoryViewModel { Id = c.Id, Initial = c.initial, Name = c.name, Description = c.description }).FirstOrDefault(); } return(result != null ? result : new CategoryViewModel()); }
/// <summary> /// 连接查询 方法簇 /// </summary> public static SelecterX Selecter <M1, M2, M3, M4, M5>(this XConnection conn, out M1 table1, out M2 table2, out M3 table3, out M4 table4, out M5 table5) where M1 : class, new() where M2 : class, new() where M3 : class, new() where M4 : class, new() where M5 : class, new() { table1 = new M1(); table2 = new M2(); table3 = new M3(); table4 = new M4(); table5 = new M5(); var dc = new XContext <M1, M2, M3, M4, M5>(conn) { Crud = CrudEnum.Join }; return(new SelecterX(dc)); }
private async void btnGetRealmInfo_Click(object sender, EventArgs e) { Authenticator aithenticator = new Authenticator(Login, password, siteUrl); await aithenticator.InitializeAuth(); XContext context = await aithenticator.GetCookiesAndDigest(); XUser user = await context.GetCurrentUser(); XList list = await context.GetList("Tests"); //List<XListItem> listItems = await list.GetItems(); //XListItem listItem = await list.GetItemById(23); string currentUserCaml = @"<Where> <Eq> <FieldRef Name='Author' LookupId='True' /> <Value> Type='Integer'> <UserID /> </Value> </Eq> </Where>" ; List <XListItem> listItems = await list.GetItems(currentUserCaml); XListItem item = listItems[0]; item["Title"] = "new title"; await item.Update(); await listItems[0].Delete(); await listItems[0].Recycle(); //Upload a photo: byte[] imageBytes = File.ReadAllBytes("photo.jpg"); string destinationFileName = string.Format("Photo_{0}.jpg", Guid.NewGuid()); string result = await context.UploadFile(imageBytes, "/Photos/", destinationFileName); var file = await context.GetFile("/Photos/", destinationFileName); }
/// <summary> /// 连接查询 方法簇 /// </summary> public static Queryer Queryer <M1, M2, M3, M4, M5, M6>(this IDbConnection conn, out M1 table1, out M2 table2, out M3 table3, out M4 table4, out M5 table5, out M6 table6) where M1 : class, new() where M2 : class, new() where M3 : class, new() where M4 : class, new() where M5 : class, new() where M6 : class, new() { table1 = new M1(); table2 = new M2(); table3 = new M3(); table4 = new M4(); table5 = new M5(); table6 = new M6(); var dc = new XContext <M1, M2, M3, M4, M5, M6>(conn); dc.Crud = CrudEnum.Join; return(new Queryer(dc)); }
/// <summary> /// 根据指定的字段和值构造一个插入命令 /// </summary> /// <param name="context"></param> /// <param name="fieldValues"></param> internal Insert(XContext context, IDictionary <string, object> fieldValues) : this(context) { if (fieldValues.IsNullOrEmpty()) { throw Error.ArgumentNullException(nameof(fieldValues)); } var columns = tableMeta.Columns.Where(x => x.CanInsert && fieldValues.Keys.Contains(x.Member.Name)).ToList(); //if (columns.IsNullOrEmpty()) //{ // throw Error.Exception("必须插入至少一个字段。"); //} foreach (var column in columns) { fieldString.Add(EscapeSqlIdentifier(column.ColumnName)); valueString.Add(GetParameterIndex()); this.parameters.Add(fieldValues[column.Member.Name]); } }
/// <summary> /// 根据实体构造一个更新命令 /// </summary> /// <param name="context"></param> /// <param name="entity"></param> internal Update(XContext context, T entity) : this(context) { if (entity == null) { throw Error.ArgumentNullException(nameof(entity)); } var columns = tableMeta.Columns.Where(x => x.CanUpdate).ToList(); foreach (var column in columns) { this.setterString.Add(string.Format("{0}={1}", EscapeSqlIdentifier(column.ColumnName), GetParameterIndex())); this.parameters.Add(column.GetValue(entity)); } if (!this.parameters.Any()) { throw Error.Exception("必须更新至少一个字段。"); } AddConditionByKey(entity); }
//Create and Edit public static ResponseResult Update(PeminjamanViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XContext()) { #region Create New / Insert if (entity.Id == 0) { x_peminjaman peminjaman = new x_peminjaman(); peminjaman.biodata_id = entity.BiodataId; peminjaman.book_id = entity.BookId; peminjaman.pegawai = entity.Pegawai; peminjaman.tanggal_pinjam = entity.TanggalPinjam; peminjaman.tanggal_kembali = entity.TanggalKembali; peminjaman.status = "Dipinjam"; peminjaman.created_by = 1; peminjaman.created_on = DateTime.Now; db.x_peminjaman.Add(peminjaman); db.SaveChanges(); result.Entity = entity; } #endregion } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
/// <summary> /// 根据指定实体构造一个更新指定字段的命令 /// </summary> /// <param name="context"></param> /// <param name="entity"></param> /// <param name="include">包含或者排除,true包含表示仅更新指定的字段,false排除表示不更新指定的字段</param> /// <param name="fields"></param> internal Update(XContext context, T entity, bool include, Expression <Func <T, object> >[] fields) : this(context) { if (entity == null) { throw Error.ArgumentNullException(nameof(entity)); } var exceptFields = fields.Select(x => x.GetPropertyName()); var columns = tableMeta.Columns.Where(x => x.CanUpdate); columns = columns.Where(x => exceptFields.Contains(x.Member.Name) == include).ToList(); foreach (var column in columns) { this.setterString.Add(string.Format("{0}={1}", EscapeSqlIdentifier(column.ColumnName), GetParameterIndex())); this.parameters.Add(column.GetValue(entity)); } if (!this.parameters.Any()) { throw Error.Exception("必须更新至少一个字段。"); } AddConditionByKey(entity); }
public static ResponseResult Pengembalian(long id, string button) { ResponseResult result = new ResponseResult(); try { using (var db = new XContext()) { x_peminjaman permission = db.x_peminjaman .Where(o => o.id == id) .FirstOrDefault(); if (id != 0) { permission.status = button; permission.modified_by = 1; permission.modified_on = DateTime.Now; permission.tanggal_dikembalikan = DateTime.Now; db.SaveChanges(); //result.Entity = entity; } else { result.Success = false; result.Message = "Not Found ! "; } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
public static BookViewModel ById(int id) { //Id Variant.Id BookViewModel result = new BookViewModel(); using (var db = new XContext()) { result = (from c in db.x_book where c.id == id select new BookViewModel { Id = c.id, CategoryId = c.category_id, Judul = c.judul, Penerbit = c.penerbit, Pengarang = c.pengarang, Tahun = c.tahun, LokasiRak = c.lokasi_rak, Deskripsi = c.deskripsi }).FirstOrDefault(); } return(result != null ? result : new BookViewModel()); }
/// <summary> /// 根据指定的字段值列字典构造一个更新命令 /// </summary> /// <param name="context"></param> /// <param name="fieldValues"></param> /// <param name="expression"></param> internal Update(XContext context, IDictionary <string, object> fieldValues, Expression <Func <T, bool> > expression) : this(context) { if (fieldValues.IsNullOrEmpty()) { throw Error.ArgumentNullException(nameof(fieldValues)); } var columns = tableMeta.Columns.Where(x => x.CanUpdate && fieldValues.Keys.Contains(x.Member.Name)).ToList(); foreach (var column in columns) { this.setterString.Add(string.Format("{0}={1}", EscapeSqlIdentifier(column.ColumnName), GetParameterIndex())); this.parameters.Add(fieldValues[column.Member.Name]); } if (!this.parameters.Any()) { throw Error.Exception("必须更新至少一个字段。"); } if (expression != null) { this.Where(expression); } }
//Delete public static ResponseResult Delete(PeminjamanViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XContext()) { x_peminjaman peminjaman = db.x_peminjaman .Where(o => o.id == entity.Id) .FirstOrDefault(); if (peminjaman != null) { peminjaman.deleted_by = 1; peminjaman.deleted_on = DateTime.Now; peminjaman.is_delete = true; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "Data Not Found ! "; } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
//Delete public static ResponseResult Delete(CategoryViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XContext()) { x_category category = db.x_category .Where(o => o.Id == entity.Id) .FirstOrDefault(); if (category != null) { category.delete_by = 1; category.delete_on = DateTime.Now; category.is_delete = true; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "Category Not Found ! "; } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
//GetAll public static List <BiodataViewModel> All() { List <BiodataViewModel> result = new List <BiodataViewModel>(); using (var db = new XContext()) { result = (from c in db.x_biodata select new BiodataViewModel { Id = c.id, FullName = c.fullname, NPM = c.identity_number, Pob = c.pob, Dob = c.dob, Gender = c.gender, Religion = c.religion, Email = c.email, Phone_number = c.phone_number1, Faculty = c.faculty, Major = c.major }).ToList(); } return(result); }
public static List <BookViewModel> All() { List <BookViewModel> result = new List <BookViewModel>(); using (var db = new XContext()) { result = (from c in db.x_book join d in db.x_category on c.category_id equals d.Id where c.is_delete == false select new BookViewModel { Id = c.id, CategoryId = c.category_id, CategoryName = d.name, Judul = c.judul, Penerbit = c.penerbit, Pengarang = c.pengarang, Tahun = c.tahun, LokasiRak = c.lokasi_rak, Deskripsi = c.deskripsi }).ToList(); } return(result); }
/// <summary> /// Sets the <see cref="DependencyProperty"/> object value as <see cref="XContext"/>. /// </summary> /// <param name="obj">The <see cref="DependencyProperty"/> object.</param> /// <param name="value">The <see cref="XContext"/> value.</param> public static void SetData(DependencyObject obj, XContext value) { obj.SetValue(DataProperty, value); }
public UserRepository(XContext xContext) : base(xContext) { _xContext = xContext; }
public UserRepository(XContext xcontext) : base(xcontext) { _xcontext = xcontext; }
public QuoteController(XContext context) { _context = context; }
/// <summary> /// Initializes a new instance of the <see cref="XContainer"/> class. /// </summary> public XContainer() : base() { _layers = ImmutableArray.Create <XLayer>(); _data = new XContext(); }
public DealController(XContext context) { _context = context; }
public DatabaseFactory() { dataContext = new XContext(); }
//Create and Update public static ResponseResult Update(CategoryViewModel entity) { ResponseResult result = new ResponseResult(); try { using (var db = new XContext()) { #region Create New / Insert if (entity.Id == 0) { x_category category = new x_category(); category.initial = entity.Initial; category.name = entity.Name; category.description = entity.Description; category.is_delete = false; category.created_by = 1; category.created_on = DateTime.Now; db.x_category.Add(category); db.SaveChanges(); result.Entity = entity; } #endregion #region Edit else { x_category category = db.x_category .Where(o => o.Id == entity.Id) .FirstOrDefault(); if (category != null) { category.initial = entity.Initial; category.name = entity.Name; category.description = entity.Description; category.modified_by = 1; category.modified_on = DateTime.Now; db.SaveChanges(); result.Entity = entity; } else { result.Success = false; result.Message = "Category Not Found ! "; } } #endregion } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
public Repository(XContext xcontext) { _xcontext = xcontext; }
public ShareController(XContext context) { _context = context; }
public UnitOfWork(XContext xcontext) { _xcontext = xcontext; userRepository = new UserRepository(_xcontext); }
public YahooController(XContext context) { _context = context; }