public int create(BitacoraBarrenacion bitacora) { bitacora.status_edicion = 1; bitacora.dias_apertura_calendario = 0; SqlConnection connection = null; using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Operaciones_DB"].ConnectionString)) { try { connection.Open(); SqlCommand command = new SqlCommand("sp_createBitacoraBarrenacion", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("maquinaria_id", bitacora.maquinaria.id)); command.Parameters.Add(new SqlParameter("operador_id", bitacora.operador.id)); command.Parameters.Add(new SqlParameter("ayudante_id", bitacora.ayudante.id)); command.Parameters.Add(new SqlParameter("turno", bitacora.turno)); command.Parameters.Add(new SqlParameter("fecha_bitacora", bitacora.fecha_bitacora)); command.Parameters.Add(new SqlParameter("mesa", bitacora.mesa)); command.Parameters.Add(new SqlParameter("beta", bitacora.beta)); command.Parameters.Add(new SqlParameter("comentarios", Validations.defaultString(bitacora.comentarios))); command.Parameters.Add(new SqlParameter("metros_finales", bitacora.metros_finales)); command.Parameters.Add(new SqlParameter("vale_acero", Validations.defaultString(bitacora.vale_acero))); command.Parameters.Add(new SqlParameter("hora_primer_barreno", Validations.defaultString(bitacora.hora_primer_barreno.ToShortTimeString()))); command.Parameters.Add(new SqlParameter("hora_ultimo_barreno", Validations.defaultString(bitacora.hora_ultimo_barreno.ToShortTimeString()))); command.Parameters.Add(new SqlParameter("status_edicion", bitacora.status_edicion)); command.Parameters.Add(new SqlParameter("dias_apertura_calendario", bitacora.dias_apertura_calendario)); command.Parameters.Add(new SqlParameter("user_id", bitacora.user.id)); SqlDataAdapter data_adapter = new SqlDataAdapter(command); DataSet data_set = new DataSet(); data_adapter.Fill(data_set); DataRow row = data_set.Tables[0].Rows[0]; return(int.Parse(row[0].ToString())); } catch (SqlException ex) { if (connection != null) { connection.Close(); } if (ex.Number == 2627) { return(0); } return(0); } catch (Exception ex) { Console.WriteLine(ex.Message); if (connection != null) { connection.Close(); } return(0); } } }
public TransactionResult update(BitacoraBarrenacion bitacora) { bitacora.status_edicion = 0; bitacora.dias_apertura_calendario = 0; SqlConnection connection = null; using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Operaciones_DB"].ConnectionString)) { try { connection.Open(); SqlCommand command = new SqlCommand("sp_updateBitacoraBarrenacion", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("maquinaria_id", bitacora.maquinaria.id)); command.Parameters.Add(new SqlParameter("operador_id", bitacora.operador.id)); command.Parameters.Add(new SqlParameter("ayudante_id", bitacora.ayudante.id)); command.Parameters.Add(new SqlParameter("turno", bitacora.turno)); command.Parameters.Add(new SqlParameter("fecha_bitacora", bitacora.fecha_bitacora)); command.Parameters.Add(new SqlParameter("mesa", bitacora.mesa)); command.Parameters.Add(new SqlParameter("beta", bitacora.beta)); command.Parameters.Add(new SqlParameter("comentarios", Validations.defaultString(bitacora.comentarios))); command.Parameters.Add(new SqlParameter("metros_finales", bitacora.metros_finales)); command.Parameters.Add(new SqlParameter("vale_acero", Validations.defaultString(bitacora.vale_acero))); command.Parameters.Add(new SqlParameter("hora_primer_barreno", Validations.defaultString(bitacora.hora_primer_barreno.ToShortTimeString()))); command.Parameters.Add(new SqlParameter("hora_ultimo_barreno", Validations.defaultString(bitacora.hora_ultimo_barreno.ToShortTimeString()))); command.Parameters.Add(new SqlParameter("status_edicion", bitacora.status_edicion)); command.Parameters.Add(new SqlParameter("dias_apertura_calendario", bitacora.dias_apertura_calendario)); command.Parameters.Add(new SqlParameter("user_id", bitacora.user.id)); command.Parameters.Add(new SqlParameter("id", bitacora.id)); command.ExecuteNonQuery(); return(TransactionResult.OK); } catch (SqlException ex) { if (connection != null) { connection.Close(); } if (ex.Number == 2627) { return(TransactionResult.EXISTS); } return(TransactionResult.NOT_PERMITTED); } catch (Exception ex) { Console.WriteLine(ex.Message); if (connection != null) { connection.Close(); } return(TransactionResult.ERROR); } } }
public BitacoraBarrenacion detail(int id) { BitacoraBarrenacion bit = bitacora_repository.detail(id); bit.demoras = bitacora_repository.getDemorasByIdBitacora(bit.id); bit.lineas = bitacora_repository.getLineasByIdBitacora(bit.id); foreach (Linea lin in bit.lineas) { lin.barrenos = bitacora_repository.getBarrenosByIdLinea(lin.id); } return(bit); }
public HttpResponseMessage detail(int id) { BitacoraBarrenacion bitacora = bitacora_service.detail(id); if (bitacora != null) { IDictionary <string, BitacoraBarrenacion> data = new Dictionary <string, BitacoraBarrenacion>(); data.Add("data", bitacora); return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { IDictionary <string, string> data = new Dictionary <string, string>(); data.Add("message", "Object not found."); return(Request.CreateResponse(HttpStatusCode.BadRequest, data)); } }
public TransactionResult autorizarRango(BitacoraBarrenacion bitacora) { SqlConnection connection = null; using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Operaciones_DB"].ConnectionString)) { try { connection.Open(); SqlCommand command = new SqlCommand("sp_autorizarRangoBitacoraBarrenacion", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("dias_apertura_calendario", bitacora.dias_apertura_calendario)); command.Parameters.Add(new SqlParameter("id", bitacora.id)); command.ExecuteNonQuery(); return(TransactionResult.OK); } catch (SqlException ex) { if (connection != null) { connection.Close(); } if (ex.Number == 2627) { return(TransactionResult.EXISTS); } return(TransactionResult.NOT_PERMITTED); } catch (Exception ex) { Console.WriteLine(ex.Message); if (connection != null) { connection.Close(); } return(TransactionResult.ERROR); } } }
public TransactionResult create(BitacoraBarrenacionVo bitacora_vo, User user_log) { if (bitacora_vo.comentarios == null) { bitacora_vo.comentarios = ""; } if (bitacora_vo.mesa == null) { bitacora_vo.mesa = ""; } if (bitacora_vo.beta == null) { bitacora_vo.beta = ""; } if (bitacora_vo.vale_acero == null) { bitacora_vo.vale_acero = ""; } BitacoraBarrenacion obj = BitacoraBarrenacionAdapter.voToObject(bitacora_vo); obj.user = user_log; int id = bitacora_repository.create(obj); if (id > 0) { var tr = TransactionResult.CREATED; if (bitacora_vo.demoras != null) { //Agregar demoras foreach (DetalleDemoraBitacoraVo dvo in bitacora_vo.demoras) { dvo.bitacora_barrenacion_id = id; dvo.tipo_bitacora = 2; tr = bitacora_repository.createDetalleDemoraBitacora(DetalleDemoraBitacoraAdapter.voToObject(dvo)); if (tr != TransactionResult.CREATED) { return(tr); } } } if (bitacora_vo.lineas != null) { //Agregar lineas foreach (LineaVo lin in bitacora_vo.lineas) { lin.bitacora_id = id; int idL = bitacora_repository.createLineaBitacora(LineaAdapter.voToObject(lin)); if (idL > 0) { if (lin.barrenos != null) { foreach (BarrenoVo bvo in lin.barrenos) { bvo.bitacora_id = bitacora_vo.id; bvo.linea_id = idL; tr = bitacora_repository.createBarrenoLineaBitacora(BarrenoAdapter.voToObject(bvo)); if (tr != TransactionResult.CREATED) { return(tr); } } } } } } return(tr); } return(TransactionResult.ERROR); //return bitacora_repository.create(obj); }