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));
}
