public JsonResult Update(GlobaisClienteBE obj, string cli_CFOP) { obj.cli_CFOP = Convert.ToDecimal(cli_CFOP.Replace(".", ",")); var _cliente = new GlobaisClienteBLL().Update(obj); return(Json(_cliente, JsonRequestBehavior.AllowGet)); }
public ActionResult Insert(GlobaisClienteBE _cliente, string cli_CFOP, GlobaisClienteEnderecoBE _endereco, GlobaisClienteContatoBE _contato) { _cliente.cli_CFOP = Convert.ToDecimal(cli_CFOP.Replace(".", ",")); _cliente.cli_id = new GlobaisClienteBLL().Insert(_cliente); _endereco.cli_id = _cliente.cli_id; _endereco.cliEnd_Tipo = "EP"; new GlobaisClienteEnderecoBLL().Insert(_endereco); if (_contato.cont_nome != null) { _contato.cli_id = _cliente.cli_id; new GlobaisClienteContatoBLL().Insert(_contato); } //Response.Redirect("/ClienteServicos?cli_id=" + listaClientes.cli_id); return(View()); }
List <GlobaisClienteBE> CarregaDados(GlobaisClienteBE obj) { List <GlobaisClienteBE> result = new List <GlobaisClienteBE>(); SqlDataReader dr = new BaseDados().RetornaDataReader(this.procedure, Globais.Helper.TipoSql.Select.ToString(), obj); if (dr.HasRows) { while (dr.Read()) { GlobaisClienteBE item = new GlobaisClienteBE(); item.conf_id = DBNull.Value.Equals(dr["conf_id"]) ? 0 : Convert.ToInt32(dr["conf_id"]); item.cli_id = DBNull.Value.Equals(dr["cli_id"]) ? 0 : Convert.ToInt32(dr["cli_id"]); item.usu_id = DBNull.Value.Equals(dr["usu_id"]) ? 0 : Convert.ToInt32(dr["usu_id"]); item.cli_CFOP = DBNull.Value.Equals(dr["cli_CFOP"]) ? 0 : Convert.ToDecimal(dr["cli_CFOP"]); item.cli_SCM = DBNull.Value.Equals(dr["cli_SCM"]) ? false : Convert.ToBoolean(dr["cli_SCM"]); item.cli_MNT = DBNull.Value.Equals(dr["cli_MNT"]) ? false : Convert.ToBoolean(dr["cli_MNT"]); item.cli_tipoVencimento = dr["cli_tipoVencimento"].ToString(); item.cli_parametroVencimento = dr["cli_parametroVencimento"].ToString(); item.cli_nomeFantasia = dr["cli_nomeFantasia"].ToString(); item.cli_razaoSocial = dr["cli_razaoSocial"].ToString(); item.cli_tipoInscricao = dr["cli_tipoInscricao"].ToString(); item.cli_CGC = dr["cli_CGC"].ToString(); item.cli_CPF = dr["cli_CPF"].ToString(); item.cli_CodCidIBGE = dr["cli_CodCidIBGE"].ToString(); item.cli_incricaoEstadual = dr["cli_incricaoEstadual"].ToString(); item.log_id = DBNull.Value.Equals(dr["log_id"]) ? 0 : Convert.ToInt32(dr["log_id"]); item.user_id = DBNull.Value.Equals(dr["user_id"]) ? 0 : Convert.ToInt32(dr["user_id"]); item.log_cadastro = Convert.ToDateTime(dr["log_cadastro"]); item.log_alteracao = DBNull.Value.Equals(dr["user_id"]) ? default(DateTime) : Convert.ToDateTime(dr["log_alteracao"]); item.log_exclusao = DBNull.Value.Equals(dr["user_id"]) ? default(DateTime) : Convert.ToDateTime(dr["log_exclusao"]); result.Add(item); } dr.Close(); } return(result); }
public List <GlobaisClienteBE> CarregaClienteCompleto(GlobaisClienteBE obj) { List <GlobaisClienteBE> result = new List <GlobaisClienteBE>(); SqlDataReader dr = new BaseDados().RetornaDataReader("proc_GlobaisCliente", "cliComp", obj); if (dr.HasRows) { while (dr.Read()) { GlobaisClienteBE item = new GlobaisClienteBE(); item.Endereco = new List <GlobaisClienteEnderecoBE>(); item.Contato = new List <GlobaisClienteContatoBE>(); item.conf_id = DBNull.Value.Equals(dr["conf_id"]) ? 0 : Convert.ToInt32(dr["conf_id"]); item.cli_id = DBNull.Value.Equals(dr["cli_id"])? 0 : Convert.ToInt32(dr["cli_id"]); item.usu_id = DBNull.Value.Equals(dr["usu_id"]) ? 0 : Convert.ToInt32(dr["usu_id"]); item.cli_CFOP = DBNull.Value.Equals(dr["cli_CFOP"]) ? 0 : Convert.ToDecimal(dr["cli_CFOP"]); item.cli_SCM = DBNull.Value.Equals(dr["cli_SCM"])? false : Convert.ToBoolean(dr["cli_SCM"]); item.cli_MNT = DBNull.Value.Equals(dr["cli_MNT"]) ? false : Convert.ToBoolean(dr["cli_MNT"]); item.cli_simplesNacional = DBNull.Value.Equals(dr["cli_simplesNacional"]) ? false : Convert.ToBoolean(dr["cli_simplesNacional"]); item.cli_tipoVencimento = dr["cli_tipoVencimento"].ToString(); item.cli_parametroVencimento = dr["cli_parametroVencimento"].ToString(); item.cli_nomeFantasia = dr["cli_nomeFantasia"].ToString(); item.cli_razaoSocial = dr["cli_razaoSocial"].ToString(); item.cli_tipoInscricao = dr["cli_tipoInscricao"].ToString(); item.cli_CGC = dr["cli_CGC"].ToString(); item.cli_CPF = dr["cli_CPF"].ToString(); item.cli_CodCidIBGE = dr["cli_CodCidIBGE"].ToString(); item.cli_incricaoEstadual = dr["cli_incricaoEstadual"].ToString(); var xml = dr["endereco"].ToString(); XmlDocument xm = new XmlDocument(); if (xml != "") { xm.LoadXml(@xml); foreach (XmlElement linha in xm.GetElementsByTagName("row")) { item.Endereco.Add(new GlobaisClienteEnderecoBE { cliEnd_id = Convert.ToInt32(Common.ConvertXMLItem(linha, "cliEnd_id")), cliEnd_Tipo = Common.ConvertXMLItem(linha, "cliEnd_Tipo"), cli_id = Convert.ToInt32(Common.ConvertXMLItem(linha, "cli_id")), end_id = Convert.ToInt32(Common.ConvertXMLItem(linha, "end_id")), end_cep = Common.ConvertXMLItem(linha, "end_cep"), end_logradouro = Common.ConvertXMLItem(linha, "end_logradouro"), end_numero = Common.ConvertXMLItem(linha, "end_numero"), end_complemento = Common.ConvertXMLItem(linha, "end_complemento"), end_bairro = Common.ConvertXMLItem(linha, "end_bairro"), end_cidade = Common.ConvertXMLItem(linha, "end_cidade"), end_estado = Common.ConvertXMLItem(linha, "end_estado"), end_latitude = Common.ConvertXMLItem(linha, "end_latitude"), end_longetitude = Common.ConvertXMLItem(linha, "end_longetitude"), }); } } xml = dr["contato"].ToString(); if (xml != "") { XmlDocument xm1 = new XmlDocument(); xm1.LoadXml(@xml); foreach (XmlElement linha in xm1.GetElementsByTagName("row")) { item.Contato.Add(new GlobaisClienteContatoBE { cont_id = Convert.ToInt32(Common.ConvertXMLItem(linha, "cont_id")), cli_id = Convert.ToInt32(Common.ConvertXMLItem(linha, "cli_id")), cont_nome = Common.ConvertXMLItem(linha, "cont_nome"), cont_ddd = Common.ConvertXMLItem(linha, "cont_fone"), cont_fone = Common.ConvertXMLItem(linha, "cont_fone"), cont_departamento = Common.ConvertXMLItem(linha, "cont_departamento"), cont_email = Common.ConvertXMLItem(linha, "cont_email"), }); } } result.Add(item); } dr.Close(); } return(result); }
public bool Delete(GlobaisClienteBE obj) { return(new GlobaisClienteDao().Delete(obj).Value); }
public bool Update(GlobaisClienteBE obj) { return(new GlobaisClienteDao().Update(obj).Value); }
public int Insert(GlobaisClienteBE obj) { return(new GlobaisClienteDao().Insert(obj)); }
public GlobaisClienteBE SelectID(GlobaisClienteBE obj) { return(new GlobaisClienteDao().CarregaClienteCompleto(obj).FirstOrDefault <GlobaisClienteBE>()); }
public List <GlobaisClienteBE> Select(GlobaisClienteBE obj) { return(new GlobaisClienteDao().CarregaClienteCompleto(obj)); }
public JsonResult Deletar(GlobaisClienteBE obj) { var _cliente = new GlobaisClienteBLL().Delete(obj); return(Json(_cliente, JsonRequestBehavior.AllowGet)); }