public void GoTest(ref ExecResult exec)
{
//MKaryawan oKaryawan = new MKaryawan();
//oKaryawan.ID = 1;
//oKaryawan.Name = "ASDFQW";
//oKaryawan.Office = "LKHSDFL";
//oKaryawan.Age = 978;
//oKaryawan.Position = "kKJHKJH";
//oKaryawan.Salary = 8979821397;
//oKaryawan.StartDate = DateTime.Now;
//oKaryawan.Active = true;
//ObjKaryawan.ID = 23523;
MKaryawanRPO krp = new MKaryawanRPO(imap_);
MKaryawanVMRPO krs = new MKaryawanVMRPO(imap_);
//krp.Conditions("ID", Operator.Equals("3"));
//krp.UpdateFiltered(new MKaryawan() { ID=23444, Name="asdasd" }, ref exec);
//krp.Conditions("ID", Operator.Equals(95442));
//krp.Delete(ref exec);
//Conditions cnd = new Conditions();
//cnd.AddFilter_OR("ID", Operator.Equals(13));
//krp.Conditions(cnd);
//krp.ReadOne(77, 2, ref exec);
//krs.ReadOne(2, ref exec);
//if (krp.InsertGetKeys(oKaryawan, ref exec))
//{
//}
//var ObjTK = new TigaKey();
//ObjTK.ID1 = 112;
//ObjTK.ID2 = 23;
//ObjTK.ID3 = 34;
//ObjTK.Deskripsi = "";
//ObjTK.Dates = DateTime.Now;
//ObjTK.IsActive = true;
//ObjTK.Gaji = 3453454325.8798;
//TigaKeyRPO krpk = new TigaKeyRPO(imap);
//krpk.Delete(32, 2, ref exec);
/*
* KRP.AddFilter("",Operator.IN())
* KRP.AddFilter(field).LIKE();
* lstobjfilter = new lst();
* lstobjfilter.addFilter
* KRP.AddFilterOR(LIST OBJ FILTER)
*
* KRP.WHERE("",)
*/
//if (krp.Insert(ObjTK, ref exec))
//{
//}
}
public IActionResult loaddata(DataTableAjaxPostModel dtpm)
{
int totarec = 0;
var users = new List <MKaryawanVM>();
MKaryawanVMRPO krp = new MKaryawanVMRPO(imap___);
ExecResult exec = new ExecResult();
GridModel grdMdl = FilterOption.BindToGridModel(dtpm, typeof(MKaryawanVM));
if (krp.ReadListPaged(grdMdl, out totarec, ref exec))
{
users = krp.Result.Collection;
}
//Conditions ncon = new Conditions();
//ncon.AddSelect("ID");
//ncon.AddSelect("Age");
//ncon.AddSelect("Name");
//ncon.AddFilter("Age", Operator.Equals(823458));
////ncon.AddGroupBy("Name");
//ncon.AddOrderBy("ID");
//ncon.SetOrderAscending();
//if (krp.ReadOne(ref exec) && krp.Result.AffectedRow>0)
//{
// //users = krp.Result.Collection;
//}
//krp.Conditions(ncon);
////krp.Conditions("Name", Operator.Like("a"));
//if (krp.ReadOne(ref exec) && krp.Result.AffectedRow > 0)
//{
// //users = krp.Result.Collection;
//}
return(new ContentResult
{
ContentType = "application/json",
Content = JsonConvert.SerializeObject(new { draw = dtpm.draw, recordsFiltered = totarec, recordsTotal = totarec, data = users }, new JsonSerializerSettings {
ContractResolver = new CamelCasePropertyNamesContractResolver()
})
});
}
