public bool Delete(string ProjectIdtext)
{
try
{
string query = "DELETE From UpcomingEventTable WHERE ProjectID='" + ProjectIdtext + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteReciever(string RecieverIdtext)
{
try
{
string query = "DELETE From RecieverPeopleTable WHERE RecieverId='" + RecieverIdtext + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
// }
//}
public bool Update(Donarpeople dp)
{
try
{
string query2 = "UPDATE DonatorInfoTable SET DonarName = '" + dp.DonarName + "', DonarPhoneno = " + dp.DonarPhoneno + "WHERE DonarId = '" + dp.DonarId + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query2);
return(true);
}
catch (Exception exasz)
{
return(false);
}
}
bool Insert(DonationByNgo d)
{
try
{
string query = "INSERT into DonationNGOgivenByTable VALUES ('" + d.DonationId + "', '" + d.DonationTitle + "', '" + d.RecieverId + "', '" + d.GivenTime + "', '" + d.DonationItem + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
return(true);
}
catch (Exception exa)
{
return(false);
}
}
public bool Updater(Employee pas22nd)
{
try
{
string query2 = "UPDATE EmployeeTable SET EmployeePassword = '******' WHERE EmployeeId = '" + pas22nd.EmployeeId + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query2);
return(true);
}
catch (Exception exasjuz)
{
return(false);
}
}
public bool Updatex(UpcomingEvent xaxxc)
{
try
{
string query2 = "UPDATE UpcomingEventTable SET Projectname = '" + xaxxc.Projectname + "', Projectarea = '" + xaxxc.Projectarea + "',ProposedDate = '" + xaxxc.ProposedDate + "' WHERE ProjectID = '" + xaxxc.ProjectID + "'";
// string query2 = "UPDATE UpcomingEvent SET Projectname = '" + tas.Projectname + "', Projectarea = "' + tas.Projectarea "' WHERE ProposedDate = '" + tas.ProposedDate + "';
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query2);
return(true);
}
catch (Exception exasz)
{
return(false);
}
}
public bool Insert(UpcomingEvent dpa)
{
try
{
//String combo1 = Convert.ToString(this.DonationTitleCombobox.SelectedItem); RecieverPhone
string query = "INSERT into UpcomingEventTable VALUES ('" + dpa.ProjectID + "', '" + dpa.Projectname + "', '" + dpa.Projectarea + "', '" + dpa.ProposedDate + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
return(true);
}
catch (Exception exfa)
{
return(false);
}
}
public List <RecieverPeople> searchRecieverPeople(string text)
{
string query13 = "SELECT RecieverId,RecieverName,RecieverArea,RecieverPhoneNo from RecieverPeopleTable WHERE RecieverId LIKE '%" + text + "%' OR RecieverName LIKE '%" + text + "%' OR RecieverArea LIKE '%" + text + "%' OR RecieverPhoneNo LIKE '%" + text + "%' ";
List <RecieverPeople> modifiedNewList = new List <RecieverPeople>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query13);
while (sdr.Read())
{
RecieverPeople obj = new RecieverPeople();
obj.RecieverId = sdr["RecieverId"].ToString();
obj.RecieverName = sdr["RecieverName"].ToString();
obj.RecieverArea = sdr["RecieverArea"].ToString();
obj.RecieverPhoneNo = sdr["RecieverPhoneNo"].ToString();
modifiedNewList.Add(obj);
}
return(modifiedNewList);
}
//string query12 = "SELECT * from DonarGivenItemTable WHERE DonarId LIKE '%" + text + "%' OR BkashNo LIKE '%" + text + "%' DonationId LIKE '%" + text + "%' OR DonationTitle LIKE '%" + text + "%' OR DonarName LIKE '%" + text + "%' OR GivenTime LIKE '%" + text + "%' OR Donarphone LIKE '%" + text + "%' OR Donateddollars LIKE '%" + text + "%'";
public List <DonationByDonar> SearchALLDonarDonation(String text)
{
// string query = "SELECT * from RequestedDonationTable WHERE RecieverPhoneNo LIKE '%" + text + "%' OR RecieverId LIKE '%" + text + "%' OR RecieverGood LIKE '%" + text + "%' OR RecieverName LIKE '%" + text + "%' OR RecieverArea LIKE '%" + text + "%' OR RequestId LIKE '%" + text + "%' OR RequestedDate LIKE '%" + text + "%'";
// string query = "SELECT * from DonarGivenItemTable WHERE DonarId LIKE '%" + text + "%' OR DonarName LIKE '%" + text + "%' OR DonationTitle LIKE '%" + text + "%' OR Donateddollars LIKE '%" + text + "%' OR Donarphone LIKE '%" + text + "%' OR GivenTime LIKE '%" + text + "%' OR DonationId LIKE '%" + text + "%' OR BkashNo LIKE '%" + text + "%' ";
string query = "SELECT * from DonarGivenItemTable WHERE DonarId LIKE '%" + text + "%' OR DonarName LIKE '%" + text + "%' OR DonationTitle LIKE '%" + text + "%' OR Donateddollars LIKE '%" + text + "%' OR Donarphone LIKE '%" + text + "%' OR GivenTime LIKE '%" + text + "%' OR DonationId LIKE '%" + text + "%' OR BKashRefferNo LIKE '%" + text + "%' ";
List <DonationByDonar> asdxList = new List <DonationByDonar>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
DonationByDonar bez = new DonationByDonar();
bez.DonarName = sdr["DonarName"].ToString();
bez.DonationTitle = sdr["DonationTitle"].ToString();
bez.DonarId = sdr["DonarId"].ToString();
bez.Donateddollars = Convert.ToDouble(sdr["Donateddollars"]);
bez.Donarphone = sdr["Donarphone"].ToString();
bez.GivenTime = Convert.ToDateTime(sdr["GivenTime"]);
bez.DonationId = sdr["DonationId"].ToString();
bez.BKashRefferNo = sdr["BKashRefferNo"].ToString();
asdxList.Add(bez);
// asdList.Add(a);
}
return(asdxList);
}