public ActionResult Edit(int Id) { List <ItemClassDTO> itemClassList = itemClassBL.GetAll(); ViewBag.ItemClassList = new SelectList(itemClassList, "Id", "Name"); ItemClassDTO itemClassDTO = itemClassBL.GetById(Id); return(View(itemClassDTO)); }
public int Create(ItemClassDTO itemClassDTO) { SqlCommand cmd = new SqlCommand("SpCreateItemClass", DbConnector.Connect()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Code", itemClassDTO.Code); cmd.Parameters.AddWithValue("@Name", itemClassDTO.Name); cmd.Parameters.AddWithValue("@CreatedBy", itemClassDTO.CreatedBy); cmd.Parameters.AddWithValue("@Active", itemClassDTO.Active); return(cmd.ExecuteNonQuery()); }
public ActionResult Edit_Post(ItemClassDTO itemClassDTO) { if (itemClassBL.Edit(itemClassDTO) > 0) { ResultMessage resultMessage = new ResultMessage() { Code = "000", Description = "Success save" }; return(Json(resultMessage, JsonRequestBehavior.AllowGet)); } return(Json(new ResultMessage() { Code = "001", Description = "Create fail" }, JsonRequestBehavior.AllowGet)); }
public ItemClassDTO GetById(int id) { ItemClassDTO itemClassDTO = new ItemClassDTO(); SqlCommand cmd = new SqlCommand("select * from Inventory.TblItemClass where Id=@Id", DbConnector.Connect()); cmd.Parameters.AddWithValue("@Id", id); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); DataTable dt = dataSet.Tables[0]; if (dt.Rows.Count > 0) { itemClassDTO = new ItemClassDTO() { Id = Convert.ToInt32(dt.Rows[0]["Id"]), Code = Convert.ToString(dt.Rows[0]["Code"]), Name = Convert.ToString(dt.Rows[0]["Name"]), CreatedOn = Convert.ToDateTime(dt.Rows[0]["CreatedOn"]), CreatedBy = Convert.ToInt32(dt.Rows[0]["CreatedBy"]), Active = Convert.ToBoolean(dt.Rows[0]["Active"]) }; if (dt.Rows[0]["ModifiedOn"] != DBNull.Value) { itemClassDTO.ModifiedOn = Convert.ToDateTime(dt.Rows[0]["ModifiedOn"]); } if (dt.Rows[0]["ModifiedBy"] != DBNull.Value) { itemClassDTO.ModifiedBy = Convert.ToInt32(dt.Rows[0]["ModifiedBy"]); } } return(itemClassDTO); }
public List <ItemClassDTO> GetAll() { List <ItemClassDTO> itemClassDTOs = new List <ItemClassDTO>(); SqlCommand cmd = new SqlCommand("select * from Inventory.TblItemClass", DbConnector.Connect()); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); DataTable dt = dataSet.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ItemClassDTO itemClassDTO = new ItemClassDTO() { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Code = Convert.ToString(dt.Rows[i]["Code"]), Name = Convert.ToString(dt.Rows[i]["Name"]), CreatedOn = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]), CreatedBy = Convert.ToInt32(dt.Rows[i]["CreatedBy"]), Active = Convert.ToBoolean(dt.Rows[i]["Active"]) }; if (dt.Rows[i]["ModifiedOn"] != DBNull.Value) { itemClassDTO.ModifiedOn = Convert.ToDateTime(dt.Rows[i]["ModifiedOn"]); } if (dt.Rows[i]["ModifiedBy"] != DBNull.Value) { itemClassDTO.ModifiedBy = Convert.ToInt32(dt.Rows[i]["ModifiedBy"]); } itemClassDTOs.Add(itemClassDTO); } return(itemClassDTOs); }
public int Edit(ItemClassDTO itemClassDTO) { return(itemClassDAO.Edit(itemClassDTO)); }
public int Create(ItemClassDTO itemClassDTO) { return(itemClassDAO.Create(itemClassDTO)); }