Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Eli Raar
2.2k
28
1.4k
jqgrid no recarga uso mvc4 c#
Jun 15 2017 12:45 PM
Hello, I'm updating a table online, related one to many, this is my structure.
My interface, aki edito a row online, in this case, I click on "edit" and a fileupload appears, where I choose my file. Then press "burn", and if I update in the bd, but the grid does not update me and an error. It seems to me that when it is a single table if it works normal, but when the table is related it does not work and this error comes out:
This is my code for how you sent the data by ajax:
var UserModel =
{
"id"
: id,
"nombre_archivo"
: nombre_archivo
};
$.ajax({
url: base_url(url_editar_grid),
data: JSON.stringify(UserModel),
type:
'POST'
,
contentType:
'application/json; charset=utf-8'
,
success: function (data) {
$(
'#listGrid'
).trigger(
'reloadGrid'
);
// alert(data);
}
});
As receipt on controller:
public
JsonResult editar(periodo model)
{
var periodolista =
new
periodo();
periodolista = periodolista.actualizarbatch(model.id, model.nombre_archivo);
return
Json(periodolista);
}
In the model:
public
periodo actualizarbatch(
int
varid,
string
varnombre)
{
var periodolista =
new
periodo();
try
{
using
(var ctx =
new
ProyectoContext())
{
periodolista = ctx.periodo.Where(x => x.id == varid).SingleOrDefault();
if
(!(periodolista ==
null
))
{
periodolista.nombre_archivo = varnombre;
}
ctx.SaveChanges();
}
}
catch
(Exception)
{
throw
;
}
return
periodolista;
}
And as a weapon my jqgrid in the controller:
ProyectoContext db =
new
ProyectoContext();
[AcceptVerbs(
"Get"
,
"Post"
)]
public
JsonResult GetTodoLists(JqGrid jqgrid,
string
sidx,
string
sord,
int
page,
int
rows)
//Gets the todo Lists.
{
using
(var ctx =
new
ProyectoContext())
{
ctx.Configuration.LazyLoadingEnabled =
false
;
int
pageIndex = Convert.ToInt32(page) - 1;
int
pageSize = rows;
var todoListsResults = db.periodo.Select(a =>
new
{a.id, a.añoId, a.trimestre,a.nombre_archivo,a.descripcion_archivo,a.fecha_creacion});
int
totalRecords = todoListsResults.Count();
var totalPages = (
int
)Math.Ceiling((
float
)totalRecords / (
float
)rows);
/*---*/
if
(sord.ToUpper() ==
"ASC"
)
{
todoListsResults = todoListsResults.OrderByDescending(s => s.id);
todoListsResults = todoListsResults.Skip(pageIndex * pageSize).Take(pageSize);
}
else
{
todoListsResults = todoListsResults.OrderBy(s => s.id);
todoListsResults = todoListsResults.Skip(pageIndex * pageSize).Take(pageSize);
}
/*---*/
var jsonData =
new
{
total = totalPages,
page,
records = totalRecords,
rows = todoListsResults
};
return
Json(jsonData, JsonRequestBehavior.AllowGet);
}
}
Please answer some, I'm stuck on this, thanks.
Reply
Answers (
6
)
Draw Rectangle between two points with arbitrary width
predection............