/// <summary> /// Modifica los datos de un ClienteDireccion /// </summary> /// <param name="IdClienteDireccion">Recibe un Objeto de tipo IdCliente</param> public static void UpdateClienteDireccion(ClsClienteDireccion ClienteDireccion) { try { Data DataAccess = new Data(System.Configuration.ConfigurationManager.ConnectionStrings["SISCOC_FEL.Properties.Settings.SISCOC_Con"].ToString()); //Data DataAccess = new Data(System.Configuration.ConfigurationManager.ConnectionStrings["MSConta.Properties.Settings." + Cheque.Empresa.ToString() + ""].ToString()); DataAccess.ExecuteSPNonQuery(SplitItemToParameter(ClienteDireccion, false), "Sp_Update_ClienteDireccion"); DataAccess.CloseConnection(); } catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); } }
///// <summary> ///// Modifica los datos de una cheque ///// </summary> ///// <param name="Contacto">Recibe parametros</param> //public static void UpdateCheque(int IDPoliza, Int16 status, int UsuarioModifica, string Empresa) //{ // try // { // SqlParameter[] Parameters; // Parameters = new SqlParameter[3]; // Parameters[0] = new SqlParameter(); // Parameters[0].Direction = ParameterDirection.Input; // Parameters[0].SqlDbType = SqlDbType.Int; // Parameters[0].ParameterName = "@IdPoliza"; // Parameters[0].Value = IDPoliza; // Parameters[1] = new SqlParameter(); // Parameters[1].Direction = ParameterDirection.Input; // Parameters[1].SqlDbType = SqlDbType.Bit; // Parameters[1].ParameterName = "@Status"; // Parameters[1].Value = status; // Parameters[2] = new SqlParameter(); // Parameters[2].Direction = ParameterDirection.Input; // Parameters[2].SqlDbType = SqlDbType.Int; // Parameters[2].ParameterName = "@UsuarioModifica"; // Parameters[2].Value = UsuarioModifica; // Data DataAccess = new Data(System.Configuration.ConfigurationManager.ConnectionStrings["MSConta.Properties.Settings." + Empresa + ""].ToString()); // DataAccess.ExecuteSPNonQuery(Parameters, "Sp_UpDate_Cheque"); // DataAccess.CloseConnection(); // } // catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); } //} #endregion #region Metodos Privados private static ClsClienteDireccion FillClienteDireccion(DataRow Row) { ClsClienteDireccion ClienteDireccion = new ClsClienteDireccion(); try { ClienteDireccion.IdClienteDireccion = Convert.ToInt32(Row["IdClienteDireccion"]); ClienteDireccion.IdCliente = Convert.ToInt32(Row["IdCliente"]); ClienteDireccion.Domicilio = Convert.ToString(Row["Domicilio"]); ClienteDireccion.Colonia = Convert.ToString(Row["Colonia"]); ClienteDireccion.Ciudad = Convert.ToString(Row["Ciudad"]); ClienteDireccion.Email = Convert.ToString(Row["Email"]); ClienteDireccion.TelCel = Convert.ToString(Row["TelCel"]); ClienteDireccion.TelCasa = Convert.ToString(Row["TelCasa"]); ClienteDireccion.Empresa = Convert.ToString(Row["Empresa"]); ClienteDireccion.TelEmpresa = Convert.ToString(Row["TelEmpresa"]); return ClienteDireccion; } catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); } }
private static SqlParameter[] SplitItemToParameter(ClsClienteDireccion ClienteDireccion, bool isNew) { SqlParameter[] Parameters; if (isNew) //para guardar Parameters = new SqlParameter[9]; else //para modificar Parameters = new SqlParameter[10]; try { Parameters[0] = new SqlParameter(); Parameters[0].Direction = ParameterDirection.Input; Parameters[0].SqlDbType = SqlDbType.Int; Parameters[0].ParameterName = "@IdCliente"; Parameters[0].Value = ClienteDireccion.IdCliente; Parameters[1] = new SqlParameter(); Parameters[1].Direction = ParameterDirection.Input; Parameters[1].SqlDbType = SqlDbType.VarChar; Parameters[1].Size = 50; Parameters[1].ParameterName = "@Domicilio"; Parameters[1].Value = ClienteDireccion.Domicilio; Parameters[2] = new SqlParameter(); Parameters[2].Direction = ParameterDirection.Input; Parameters[2].SqlDbType = SqlDbType.VarChar; Parameters[2].Size = 30; Parameters[2].ParameterName = "@Colonia"; Parameters[2].Value = ClienteDireccion.Colonia; Parameters[3] = new SqlParameter(); Parameters[3].Direction = ParameterDirection.Input; Parameters[3].SqlDbType = SqlDbType.VarChar; Parameters[3].Size = 20; Parameters[3].ParameterName = "@Ciudad"; Parameters[3].Value = ClienteDireccion.Ciudad; Parameters[4] = new SqlParameter(); Parameters[4].Direction = ParameterDirection.Input; Parameters[4].SqlDbType = SqlDbType.VarChar; Parameters[4].Size = 70; Parameters[4].ParameterName = "@Email"; Parameters[4].Value = ClienteDireccion.Email; Parameters[5] = new SqlParameter(); Parameters[5].Direction = ParameterDirection.Input; Parameters[5].SqlDbType = SqlDbType.VarChar; Parameters[5].Size = 12; Parameters[5].ParameterName = "@TelCel"; Parameters[5].Value = ClienteDireccion.TelCel; Parameters[6] = new SqlParameter(); Parameters[6].Direction = ParameterDirection.Input; Parameters[6].SqlDbType = SqlDbType.VarChar; Parameters[6].Size = 12; Parameters[6].ParameterName = "@TelCasa"; Parameters[6].Value = ClienteDireccion.TelCasa; Parameters[7] = new SqlParameter(); Parameters[7].Direction = ParameterDirection.Input; Parameters[7].SqlDbType = SqlDbType.VarChar; Parameters[7].Size = 50; Parameters[7].ParameterName = "@Empresa"; Parameters[7].Value = ClienteDireccion.Empresa; Parameters[8] = new SqlParameter(); Parameters[8].Direction = ParameterDirection.Input; Parameters[8].SqlDbType = SqlDbType.VarChar; Parameters[8].Size = 12; Parameters[8].ParameterName = "@TelEmpresa"; Parameters[8].Value = ClienteDireccion.TelEmpresa; if (!isNew) { Parameters[9] = new SqlParameter(); Parameters[9].Direction = ParameterDirection.Input; Parameters[9].SqlDbType = SqlDbType.Int; Parameters[9].ParameterName = "@IdClienteDireccion"; Parameters[9].Value = ClienteDireccion.IdClienteDireccion; } return Parameters; } catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); } }