private ListResponse <TbKtpRow> FunctionGetWarga(string filter, int totalCount)
{
TbKtpRepository repo = new TbKtpRepository();
ListRequest request = new ListRequest();
ListResponse <TbKtpRow> response = new ListResponse <TbKtpRow>();
var ud = (UserDefinition)Authorization.UserDefinition;
//using (var connection = SqlConnections.NewByKey("Rukuntangga"))
//{
// request.Criteria = new Criteria("KodeRt") == ud.Ktp.KodeRt & (new Criteria("Nama").Like("%" + filter + "%") | new Criteria("Nik").Like("%" + filter + "%"));
// request.Take = totalCount;
// response = repo.List(connection, request);
//}
using (var connection = SqlConnections.NewByKey("Rukuntangga"))
{
var data = (List <TbKtpRow>)connection.Query <TbKtpRow>("SpSearhWarga", param: new { nik = ud.Ktp.Nik, search = filter, takeCount = totalCount }, commandType: System.Data.CommandType.StoredProcedure);
if (data.Count > 0)
{
response.Entities = data;
}
}
return(response);
}
public ActionResult Details(int id)
{
TbKtpRepository repo = new TbKtpRepository();
RetrieveRequest request = new RetrieveRequest();
RetrieveResponse <TbKtpRow> response = new RetrieveResponse <TbKtpRow>();
using (var connection = SqlConnections.NewByKey("Rukuntangga"))
{
request.EntityId = id;
response = repo.Retrieve(connection, request);
}
return(PartialView(MVC.Views.Rukuntangga.Warga.WargaDetail, response.Entity));
}
public ActionResult Index()
{
TbKtpRepository repo = new TbKtpRepository();
RetrieveRequest request = new RetrieveRequest();
RetrieveResponse <TbKtpRow> response = new RetrieveResponse <TbKtpRow>();
using (var connection = SqlConnections.NewByKey("Rukuntangga"))
{
var ud = (UserDefinition)Serenity.Authorization.UserDefinition;
request.EntityId = ud.Ktp.Id;
response = repo.Retrieve(connection, request);
}
return(View(MVC.Views.Rukuntangga.Profile.ProfileIndex, response.Entity));
}
