/// <summary>
/// update vcr model.
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int Update(Vcr mdl)
{
_sb = new StringBuilder();
_sb.AppendFormat(@"UPDATE Vcrs
SET
LessonId = @LessonId,
VideoPath = @VideoPath,
OrderCode = @OrderCode,
UpdateTime = @UpdateTime,
IsFree = @IsFree,
ViewTimes = @ViewTimes,
UpdatedBy = @UpdatedBy,
FileOk = @FileOk,
HasTest = @HasTest,
TrainerId = @TrainerId,
TitleOrName = @TitleOrName,
Memo = @Memo,
IsEnabled = @IsEnabled
WHERE Id=@Id");
var parmlist = Wyb.DbUtility.TableToModel <Vcr> .FillDbParams(mdl, DbConfig.DbProviderType.SqlServer);
_dbFun.ConnectionString = connstr;
return(_dbFun.ExecuteNonQuery(_sb.ToString(), parmlist.ToArray()));
// throw new NotImplementedException();
//throw new NotImplementedException();
}
public int Update(Vcr mdl)
{
using (applicationDbContext = new ApplicationDbContext())
{
applicationDbContext.Entry(mdl).State = System.Data.Entity.EntityState.Modified;
return(applicationDbContext.SaveChanges());
}
}
public int AddVcr(Vcr model)
{
using (var t = new ApplicationDbContext())
{
t.Entry(model).State = System.Data.Entity.EntityState.Added;
return(t.SaveChanges());
}
}
public ActionResult Update([Bind(Include = "Id,LessonId,VideoPath,IsFree,TitleOrName,IsEnabled")] Vcr mdl)
{
int i = 0;
if (ModelState.IsValid)
{
mdl.UpdatedBy = MyUserId;
i = new VcrSvc().UpdateVcr(mdl);
}
return(Json(new { i }, JsonRequestBehavior.AllowGet));
}
public int UpdateVcr(Vcr model)
{
using (var t = new ApplicationDbContext())
{
Entity.TrainLesson.Vcr mdl = t.TrainVcrs.Find(model.Id);
mdl.TitleOrName = model.TitleOrName;
mdl.IsEnabled = model.IsEnabled;
mdl.IsFree = model.IsFree;
mdl.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd");
mdl.UpdatedBy = model.UpdatedBy;
t.Entry(mdl).State = System.Data.Entity.EntityState.Modified;
return(t.SaveChanges());
}
}
public ActionResult VcrAdd([Bind(Exclude = "Maker,TrainerId,Id,UpdateTime,updatedBy,memo")] Vcr mdl)
{
if (ModelState.IsValid)
{
mdl.Maker = MyUserId;
mdl.TrainerId = MyUserId;
mdl.MakeDay = DateTime.Now;
mdl.Id = Guid.NewGuid().ToString("n");
mdl.ViewTimes = 0;
mdl.HasTest = false;
string findalId = string.Empty;
int r = new VcrSvc().AddVcr(mdl);
if (r > 0)
{
findalId = mdl.Id;
}
return(Json(new { i = r, id = findalId }, JsonRequestBehavior.AllowGet));
}
return(Json(new { i = 0 }, JsonRequestBehavior.AllowGet));
}
public int Add(Vcr mdl)
{
throw new NotImplementedException();
}
