protected void Alterar(object sender, EventArgs e)
{
try
{
RepasseParceriaDAL rpDAL = new RepasseParceriaDAL();
RepasseParceria rp = rpDAL.ObterDadosPorId(Convert.ToInt32(Request.QueryString["idRpp"]));
rp.DataVencimento = Convert.ToDateTime(txtDataVencimento.Text);
if (txtDataRepasse.Text == "")
{
rp.DataRepasse = new DateTime(1900, 1, 1);
}
else
{
rp.DataRepasse = Convert.ToDateTime(txtDataRepasse.Text);
}
rp.ValorRepasse = Convert.ToDecimal(txtValor.Text);
rp.Status = ddlStatus.SelectedValue;
rpDAL.Alterar(rp);
Response.Write("<script language='JavaScript'>alert('Repasse da Parceria alterado com sucesso');window.parent.location='RepassesParceria.aspx?idPrc=" + Request.QueryString["idPrc"] + "';</script>");
}
catch (Exception)
{ throw; }
}
public void Cadastrar(object obj)
{
using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString))
{
try
{
objConn.Open();
RepasseParceria rc = (RepasseParceria)obj;
SqlCommand cmd = new SqlCommand("INSERT INTO TB_RepasseParceria(IDParceria,DTVencimento,DTRepasse,VLRepasse,DSStatus) VALUES(@IDParceria,@DTVencimento,@DTRepasse,@VLRepasse,@DSStatus)", objConn);
cmd.Parameters.Add("@IDParceria", SqlDbType.Int).Value = rc.Parceria.IdParceria;
cmd.Parameters.Add("@DTVencimento", SqlDbType.SmallDateTime).Value = rc.DataVencimento;
cmd.Parameters.Add("@DTRepasse", SqlDbType.SmallDateTime).Value = rc.DataRepasse;
cmd.Parameters.Add("@VLRepasse", SqlDbType.Decimal).Value = rc.ValorRepasse;
cmd.Parameters.Add("@DSStatus", SqlDbType.VarChar, 10).Value = rc.Status;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
public RepasseParceria ObterDadosPorId(int _IdRepasseParceria)
{
using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString))
{
try
{
objConn.Open();
RepasseParceria rp = new RepasseParceria();
SqlCommand cmd = new SqlCommand("SELECT IDRepasseParceria,IDParceria,DTVencimento,DTRepasse,VLRepasse,DSStatus FROM TB_RepasseParceria WHERE IDRepasseParceria = " + _IdRepasseParceria, objConn);
SqlDataReader dr = cmd.ExecuteReader();
ParceriaDAL pDAL = new ParceriaDAL();
if (dr.Read())
{
rp.IdRepasseParceria = Convert.ToInt32(dr["IDRepasseParceria"]);
rp.Parceria = pDAL.ObterDadosPorId(Convert.ToInt32(dr["IDParceria"]));
rp.DataVencimento = Convert.ToDateTime(dr["DTVencimento"]);
if (dr["DTRepasse"] != DBNull.Value)
{
rp.DataRepasse = Convert.ToDateTime(dr["DTRepasse"]);
}
rp.ValorRepasse = Convert.ToDecimal(dr["VLRepasse"]);
rp.Status = dr["DSStatus"].ToString();
}
return(rp);
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
RepasseParceriaDAL rpDAL = new RepasseParceriaDAL();
RepasseParceria rp = rpDAL.ObterDadosPorId(Convert.ToInt32(Request.QueryString["idRpp"]));
txtDataVencimento.Text = rp.DataVencimento.ToShortDateString();
if (Convert.ToDateTime(rp.DataRepasse) != new DateTime(1900, 1, 1))
{
txtDataRepasse.Text = Convert.ToDateTime(rp.DataRepasse).ToShortDateString();
}
txtValor.Text = String.Format("{0:0.00}", rp.ValorRepasse);
ddlStatus.SelectedValue = rp.Status;
}
}
catch (Exception)
{ throw; }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
RepasseParceriaDAL rpDAL = new RepasseParceriaDAL();
switch (Request.QueryString["act"])
{
case "exc":
RepasseParceria rp = rpDAL.ObterDadosPorId(Convert.ToInt32(Request.QueryString["idRpp"]));
rpDAL.Excluir(rp);
Response.Write("<script language='JavaScript'>alert('O Repasse da Parceria foi excluído com sucesso');location='RepassesParceria.aspx?idPrc=" + Request.QueryString["idPrc"] + "';</script>");
break;
default:
break;
}
// LISTA OS REPASSES DA PARCERIA //
rptRepassesParceria.DataSource = rpDAL.ListarPorParceria(Convert.ToInt32(Request.QueryString["idPrc"]));
rptRepassesParceria.DataBind();
// FIM //
decimal decTotalRepasses, decTotalRepassesPagos, decTotalRepassesPendentes;
var lstRepasses = (List <RepasseParceria>)rpDAL.ListarPorParceria(Convert.ToInt32(Request.QueryString["idPrc"]));
decTotalRepasses = lstRepasses.Sum(vEF => vEF.ValorRepasse);
decTotalRepassesPagos = lstRepasses.Where(sEF => sEF.Status == "pago").Sum(vEF => vEF.ValorRepasse);
decTotalRepassesPendentes = lstRepasses.Where(sEF => sEF.Status == "pendente").Sum(vEF => vEF.ValorRepasse);
litTotalRepasses.Text = String.Format("{0:0.00}", decTotalRepasses);
litTotalRepassesPagos.Text = String.Format("{0:0.00}", decTotalRepassesPagos);
litTotalRepassesPendentes.Text = String.Format("{0:0.00}", decTotalRepassesPendentes);
}
catch (Exception)
{ throw; }
}
public void Excluir(object obj)
{
using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString))
{
try
{
objConn.Open();
RepasseParceria rc = (RepasseParceria)obj;
SqlCommand cmd = new SqlCommand("DELETE FROM TB_RepasseParceria WHERE IDRepasseParceria = @IDRepasseParceria", objConn);
cmd.Parameters.Add("@IDRepasseParceria", SqlDbType.Int).Value = rc.IdRepasseParceria;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
