public void UpdateOrganizerWithoutImage(BALOrganizer obj)
{
query = "update Organizer set organizername='" + obj.OrganizerName + "',description='" + obj.Description + "',address='" + obj.Address + "',email='" + obj.Email + "',website='" + obj.Website + "',contactno='" + obj.ContactNo + "',loginid=" + obj.LoginId + " where organizerid=" + obj.OrganizerId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteOrganizer(BALOrganizer obj)
{
query = "delete from Organizer where organizerid=" + obj.OrganizerId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertOrganizer(BALOrganizer obj)
{
query = "insert into organizer(organizername,description,imagefile,address,email,website,contactno,loginid) values ('" + obj.OrganizerName + "','" + obj.Description + "','"+obj.ImageFile+"','"+obj.Address+"','"+obj.Email+"','"+obj.Website+"','"+obj.ContactNo+"',"+obj.LoginId+")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectOrganizerByLoginId(BALOrganizer obj)
{
query = "select * from Organizer o inner join login l on o.loginid=l.loginid where o.loginid=" + obj.LoginId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
