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