protected void CVClubname_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CVClubname.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select club_id from club_domain_ftp_tbl where club_id='" + DDLClubName.SelectedValue.ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
//protected void btnAddmore_Click(object sender, EventArgs e)
//{
// if (Page.IsValid)
// {
// ListItem li = new ListItem();
// TRTopics.Visible = true;
// li.Text = DDLDesig.SelectedItem.Text.ToString();
// li.Value = DDLDesig.SelectedValue.ToString();
// listTopics.Items.Add(li);
// DDLDesig.SelectedIndex = 0;
// }
//}
//protected void btnRemove_Click(object sender, EventArgs e)
//{
// try
// {
// if (listTopics.Items.Count > 0)
// {
// ListItem li = new ListItem();
// li.Text = listTopics.SelectedItem.Text.ToString();
// li.Value = listTopics.SelectedValue.ToString();
// listTopics.Items.Remove(li);
// }
// else
// {
// TRTopics.Visible = false;
// }
// }
// catch
// {
// }
//}
protected void CVMember_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CVMember.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select Member_id from dist_officers_tbl where years='" + DDLYears.SelectedItem.Text.Trim() + "' and Member_id='" + int.Parse(DDLMemName.SelectedValue.ToString()) + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
// CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select category from discon_registration_rate_master_tbl where category='" + ddlCat.SelectedItem.Text.Trim().ToString() + "' and member_type='" + rbtnMemType.SelectedItem.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CVCandidate_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
// CVDistNo.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select name from candidates_tbl where name='" + txtName.Text.Trim().ToString() + "' and district_no='" + ddlDistNo.SelectedItem.Text.Trim().ToString() + "' and club_name='" + ddlClubName.SelectedItem.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
// FailureText.Text = "";
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select position from positions_held_tbl where position='" + DDLPosition.SelectedItem.Text.Trim().ToString() + "' and member_id='" + DDLMember.SelectedValue.ToString() + "' ";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CV_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CV.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select DGs_RIPs from DGs_RIPs_Data_tbl where DGs_RIPs='" + DDLDGs.SelectedItem.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
int memId = int.Parse(DDLMember.SelectedValue.ToString());
string desig = DDLDesignation.SelectedItem.ToString();
//int distID = int.Parse(Session["DistrictClubID"].ToString());
int distID = int.Parse(DDLClubName.SelectedValue.ToString());
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select * from View_upcoming_bod where DistrictClubId='" + distID + "' and member_Id='" + memId + "' and designation='" + desig + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select abbreviation from abbreviations_tbl where abbreviation='" + txtAbbri.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CVDistNo_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
// CVDistNo.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select district_no from district_no_tbl where district_no='" + txtName.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CVClubname_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CVClubname.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select club_name from rotaract_club_tbl where club_name='" + txtClubName.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select designation from distt_designation_tbl where designation='" + txtDesig.Text.Trim().ToString() + "' and years='" + DDLYears.SelectedItem.Text.Trim().ToString() + "' ";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CVAttendance_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CVAttendance.Enabled = false;
}
else
{
try
{
string month = DDLMonth.SelectedItem.ToString();
//int clubid = int.Parse(Session["DistrictClubID"].ToString());
int clubid = int.Parse(DDLClubName.SelectedValue.ToString());
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select * from clubs_attendance_tbl where club_id='" + clubid + "' and month='" + month + "' ";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void cvemail_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
cvemail.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select Email from admin_users_tbl where Email='" + txtEmail.Text.Trim().ToString() + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
public int ContabilizarGastos()
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"SELECT COUNT(id) FROM gastos ";
return(Convert.ToInt32(comando.ExecuteScalar().ToString()));
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select club_name from ocv_calendar_tbl where club_name='" + DDLClubName.SelectedItem.Text.Trim().ToString() + "' and datepart(year,date)='2013'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CustomValidator1.Enabled = false;
}
else
{
try
{
int memId = int.Parse(DDLMember.SelectedValue.ToString());
string desig = DDLDesignation.SelectedItem.ToString();
DBconnection obj = new DBconnection();
obj.SetCommandQry = "select * from View_BodMembers where year='" + DDLYears.SelectedItem.Text.Trim() + "' and MemberId='" + memId + "' and designation='" + desig + "'";
object res = obj.ExecuteScalar();
if (res != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
public int CadastrarCategoria(Categoria categorias)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"INSERT INTO categorias (nome) OUTPUT INSERTED.ID VALUES (@NOME)";
comando.Parameters.AddWithValue("@NOME", categorias.Nome);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
public int ContabilizarGastosFiltrados(string search)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"SELECT COUNT(gas.Id) FROM gastos gas
JOIN cartoes car ON (car.Id = gas.id_cartao)
JOIN categorias cat on (cat.Id = gas.id_categoria)
WHERE (cat.nome LIKE @SEARCH OR gas.descricao LIKE @SEARCH)";
comando.Parameters.AddWithValue("@SEARCH", search);
return(Convert.ToInt32(comando.ExecuteScalar().ToString()));
}
private int GetClubId()
{
int id = 0;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetClubId";
object o = obj.ExecuteScalar().ToString();
id = int.Parse(o.ToString());
return(id);
}
public int CadastrarRecebimento(Recebimento recebimento)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"INSERT INTO recebimentos (valor, data, id_pessoas, id_categoria) OUTPUT INSERTED.ID VALUES (@VALOR, @DATA, @IDPESSOA, @IDCATEGORIA)";
comando.Parameters.AddWithValue("@VALOR", recebimento.Valor);
comando.Parameters.AddWithValue("@DATA", recebimento.Data);
comando.Parameters.AddWithValue("@IDPESSOA", recebimento.IdPessoas);
comando.Parameters.AddWithValue("@IDCATEGORIA", recebimento.IdCategoria);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
public int CadastrarLogin(Login login)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = "INSERT INTO login (id_pessoas, usuario, senha, email) OUTPUT INSERTED.ID VALUES (@ID_PESSOAS, @USUARIO, @SENHA, @EMAIL)";
comando.Parameters.AddWithValue("@ID_PESSOAS", login.IdPessoas);
comando.Parameters.AddWithValue("@USUARIO", login.Usuario);
comando.Parameters.AddWithValue("@SENHA", login.Senha);
comando.Parameters.AddWithValue("@EMAIL", login.Email);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
public int CadastrarCartao(Cartoes cartoes)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"INSERT INTO cartoes (numero, conta, bandeira, banco, id_pessoas) OUTPUT INSERTED.ID VALUES ( @NUMERO, @CONTA, @BANDEIRA, @BANCO, @ID_PESSOAS)";
comando.Parameters.AddWithValue("@ID_PESSOAS", cartoes.IdPessoas);
comando.Parameters.AddWithValue("@NUMERO", cartoes.Numero);
comando.Parameters.AddWithValue("@CONTA", cartoes.Conta);
comando.Parameters.AddWithValue("@BANDEIRA", cartoes.Bandeira);
comando.Parameters.AddWithValue("@BANCO", cartoes.Banco);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
public int CadastrarPessoas(Pessoas pessoas)
{
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"INSERT INTO pessoas (nome, sexo, cpf, nascimento, telefone, cep) OUTPUT INSERTED.ID VALUES (@NOME, @SEXO, @CPF, @NASCIMENTO, @TELEFONE, @CEP)";
comando.Parameters.AddWithValue("@NOME", pessoas.Nome);
comando.Parameters.AddWithValue("@SEXO", pessoas.Sexo);
comando.Parameters.AddWithValue("@CPF", pessoas.CPF);
comando.Parameters.AddWithValue("@NASCIMENTO", pessoas.Nascimento);
comando.Parameters.AddWithValue("@TELEFONE", pessoas.Telefone);
comando.Parameters.AddWithValue("@CEP", pessoas.Cep);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
public int CadastrarGastos(Gastos gastos, int idPessoa)
{
//(select cartoes.id_pessoas from cartoes where cartoes.Id = @ID)
//(select gastos.valor from gastos) end)
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"INSERT INTO gastos (id_cartao, id_categoria, valor, entrada, vencimento, descricao) OUTPUT INSERTED.ID VALUES (@IDCARTAO, @IDCATEGORIA, @VALOR, @ENTRADA, @VENCIMENTO, @DESCRICAO)
update recebimentos set valor = (case when (recebimentos.valor - (select sum(gastos.valor) from gastos)) <= 0 then 0
else recebimentos.valor - (@VALOR) end) where recebimentos.id_pessoas = (select cartoes.id_pessoas from cartoes where cartoes.Id = @ID)";
comando.Parameters.AddWithValue("@IDCARTAO", gastos.IdCartao);
comando.Parameters.AddWithValue("@IDCATEGORIA", gastos.IdCategoria);
comando.Parameters.AddWithValue("@VALOR", gastos.Valor);
comando.Parameters.AddWithValue("@DESCRICAO", gastos.Descricao);
comando.Parameters.AddWithValue("@ENTRADA", gastos.Entrada);
comando.Parameters.AddWithValue("@VENCIMENTO", gastos.Vencimento);
comando.Parameters.AddWithValue("@ID", gastos.IdCartao);
int id = Convert.ToInt32(comando.ExecuteScalar().ToString());
return(id);
}
