public List <WorkingPoints> List() { List <WorkingPoints> lst = new List <WorkingPoints>(); SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50) { Value = "a" } }; DataTable result = SqlHelper.ExecuteDataTable("spWorkingPoints", param); if (result != null && result.Rows.Count > 0) { foreach (DataRow drow in result.Rows) { WorkingPoints obj = new WorkingPoints(); obj.Id = Convert.ToInt32(drow["Id"]); obj.Name = drow["Name"].ToString(); obj.Code = drow["Code"].ToString(); obj.IsActive = Convert.ToBoolean(drow["IsActive"]); lst.Add(obj); } } return(lst); }
public ActionResult Edit(WorkingPoints obj) { if (ModelState.IsValid) { try { var result = iWorking.Update(obj, "u"); return(Json(new { ErrorCode = result.ErrorCode, Message = result.Msg, Id = result.Id, JsonRequestBehavior.AllowGet })); } catch (Exception ex) { return(Json(new { ErrorCode = 1, Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } Response.TrySkipIisCustomErrors = true; string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return(Json(new { ErrorCode = 1, Message = messages }, JsonRequestBehavior.AllowGet)); }
public WorkingPoints GetById(string Id) { SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50) { Value = "s" } , new SqlParameter("@Id", SqlDbType.Int) { Value = Id } }; DataRow result = SqlHelper.ExecuteDataRow("spWorkingPoints", param); WorkingPoints obj = new WorkingPoints(); obj.Id = Convert.ToInt32(result["Id"]); obj.Name = result["Name"].ToString(); obj.Code = result["Code"].ToString(); obj.IsActive = Convert.ToBoolean(result["IsActive"].ToString()); return(obj); }
public DbResult Update(WorkingPoints obj, string flag) { SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 20) { Value = flag == "i"? "i":"u" } , new SqlParameter("@Name", SqlDbType.VarChar, 50) { Value = obj.Name } , new SqlParameter("@IsActive", SqlDbType.Bit) { Value = obj.IsActive } , new SqlParameter("@Id", SqlDbType.Int) { Value = obj.Id } , new SqlParameter("@Code", SqlDbType.Int) { Value = obj.Code } }; return(SqlHelper.ParseDbResult("spWorkingPoints", param)); }
public DbResult Update(WorkingPoints entity, string flag) { return(repo.Update(entity, flag)); }
public ActionResult Edit(string id) { WorkingPoints obj = iWorking.GetById(id); return(PartialView(obj)); }