public static bool Add(ClientCOMMON pClient) { bool retorno = true; try { var Conectar = new SqlConnection(CadenaDeConexion); Conectar.Open(); // 1. identificamos el store procedure a ejecutar SqlCommand cmd = new SqlCommand("Insert_Client", Conectar); // 2. identificamos el tipo de ejecución, en este caso un SP cmd.CommandType = CommandType.StoredProcedure; // 3. en caso de que los lleve se ponen los parametros del SP cmd.Parameters.Add(new SqlParameter("@Name", pClient.Name)); cmd.Parameters.Add(new SqlParameter("@LastName", pClient.LastName)); cmd.Parameters.Add(new SqlParameter("@Born", pClient.Born)); cmd.Parameters.Add(new SqlParameter("@Email", pClient.Email)); cmd.Parameters.Add(new SqlParameter("@Phone", pClient.Phone)); cmd.Parameters.Add(new SqlParameter("@Ci", pClient.Ci)); cmd.Parameters.Add(new SqlParameter("@Address_Calle", pClient.address.Calle)); cmd.Parameters.Add(new SqlParameter("@Address_Nro", pClient.address.Nro)); cmd.Parameters.Add(new SqlParameter("@Address_Calle_EntreUno", pClient.address.EntreUno)); cmd.Parameters.Add(new SqlParameter("@Address_Calle_EntreDos", pClient.address.EntreDos)); cmd.Parameters.Add(new SqlParameter("@Address_Barrio", pClient.address.Barrio)); cmd.Parameters.Add(new SqlParameter("@City_Id_FK", pClient.City.Id)); cmd.Parameters.Add(new SqlParameter("@CategoryPeople", pClient.CategoryPeople)); cmd.Parameters.Add(new SqlParameter("@Password", pClient.Password)); cmd.Parameters.Add(new SqlParameter("@DateJoin", pClient.DateJoin)); cmd.Parameters.Add(new SqlParameter("@LastLogin", pClient.LastLogin)); cmd.Parameters.Add(new SqlParameter("@Type", pClient.ClientTypeStatus)); // ejecutamos el store desde c# int rtn = cmd.ExecuteNonQuery(); if (rtn <= 0) { retorno = false; } if (Conectar.State == ConnectionState.Open) { Conectar.Close(); } } catch (Exception ex) { throw ex; } return(retorno); }
public static ClientCOMMON SearchClient(ClientCOMMON pClient) { ClientCOMMON Client = null; try { var conn = new SqlConnection(CadenaDeConexion); conn.Open(); // 1. identificamos el store procedure a ejecutar SqlCommand cmd = new SqlCommand("Select_Client", conn); // 2. identificamos el tipo de ejecución, en este caso un SP cmd.CommandType = CommandType.StoredProcedure; // 3. en caso de que los lleve se ponen los parametros del SP cmd.Parameters.Add(new SqlParameter("@Client_Id", pClient.Id)); // ejecutamos el store desde c# using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { Client = new ClientCOMMON(); Client.City = new CityCOMMON(); Client.Id = short.Parse(oReader["People_Id"].ToString()); Client.Name = oReader["People_Name"].ToString(); Client.LastName = oReader["People_LastName"].ToString(); Client.Born = Convert.ToDateTime(oReader["People_Born"].ToString()); Client.Email = oReader["People_Email"].ToString(); Client.Phone = oReader["People_Phone"].ToString(); Client.Ci = oReader["People_Ci"].ToString(); Client.address.Calle = oReader["People_Address_Calle"].ToString(); Client.address.Nro = int.Parse(oReader["People_Address_Nro"].ToString()); Client.address.EntreUno = oReader["People_Address_EntreUno"].ToString(); Client.address.EntreDos = oReader["People_Address_EntreDos"].ToString(); Client.address.Barrio = oReader["People_Address_Barrio"].ToString(); Client.City.Id = int.Parse(oReader["City_Id_FK"].ToString()); Client.CategoryPeople = oReader["People_CategoryDescription"].ToString(); Client.Password = oReader["Client_Password"].ToString(); Client.DateJoin = Convert.ToDateTime(oReader["Client_DateJoin"].ToString()); Client.LastLogin = Convert.ToDateTime(oReader["Client_LastLogin"].ToString()); Client.ClientTypeStatus = oReader["Client_Type"].ToString(); } conn.Close(); } } catch (Exception ex) { throw ex; } return(Client); }
public static bool Delete(ClientCOMMON pClient) { bool retorno = true; try { var conn = new SqlConnection(CadenaDeConexion); conn.Open(); // 1. identificamos el store procedure a ejecutar SqlCommand cmd = new SqlCommand("Delete_Client", conn); // 2. identificamos el tipo de ejecución, en este caso un SP cmd.CommandType = CommandType.StoredProcedure; // 3. en caso de que los lleve se ponen los parametros del SP cmd.Parameters.Add(new SqlParameter("@Client_Id", pClient.Id)); // ejecutamos el store desde c# int rtn = cmd.ExecuteNonQuery(); if (rtn <= 0) { retorno = false; } // si la conexion esta abierta, la cerramos. if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { throw ex; } return(retorno); }