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; }