public ReturnMachinePart Insert(MachinePart machinePart) { ReturnMachinePart returnMachinePart = new ReturnMachinePart(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachinePart_InsertUpdate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machinePart.ID; cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar)).Value = machinePart.Name; cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.NVarChar)).Value = machinePart.Description; cmd.Parameters.Add(new SqlParameter("@MachineType", SqlDbType.Int)).Value = machinePart.MachineType; cmd.ExecuteNonQuery(); returnMachinePart.Code = "00"; returnMachinePart.Message = "Cập nhật dữ liệu thành công."; } } } catch (Exception ex) { returnMachinePart.Code = "99"; returnMachinePart.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachinePart.Total = 0; returnMachinePart.lstMachinePart = null; mylog4net.Error("", ex); } return(returnMachinePart); }
public ReturnMachinePart GetbyID(int ID) { List <MachinePart> lstMachinePart = null; MachinePart machinePart = null; ReturnMachinePart returnMachinePart = new ReturnMachinePart(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { //cmd.Connection = _sqlConnection; cmd.CommandText = "sp_tMachinePart_SelectByID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection)) { if (sqlDr.HasRows) { lstMachinePart = new List <MachinePart>(); while (sqlDr.Read()) { machinePart = new MachinePart(); machinePart.ID = int.Parse(sqlDr["ID"].ToString()); machinePart.Name = sqlDr["Name"].ToString(); machinePart.Description = sqlDr["Description"].ToString(); machinePart.MachineType = int.Parse(sqlDr["MachineType"].ToString()); machinePart.DateCreated = DateTime.Parse(sqlDr["DateCreated"].ToString()); lstMachinePart.Add(machinePart); } returnMachinePart.Code = "00"; returnMachinePart.Message = "Lấy dữ liệu thành công."; returnMachinePart.lstMachinePart = lstMachinePart; } else { returnMachinePart.Code = "01"; returnMachinePart.Message = "Không tồn tại bản ghi nào."; returnMachinePart.Total = 0; returnMachinePart.lstMachinePart = null; } } } } } catch (Exception ex) { returnMachinePart.Code = "99"; returnMachinePart.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachinePart.Total = 0; returnMachinePart.lstMachinePart = null; mylog4net.Error("", ex); } return(returnMachinePart); }