public override void Update()
{
_query = "UPDATE Student SET name='" + name + "' , cnic='" + cnic + "' , fathername='" + fathername + "' , fathercnic='" + fathercnic + "' , dateofbirth='" + _dateofbirth + "' , class='" + _class + "' , section='" + _section + "' , registerdate='" + _registerdate + "' , status='" + _status + "' , mobile='" + mobile + "' , contact='" + contact + "' , email='" + email + "' , address1='" + address1 + "' , address2='" + address2 + "' , photo=@img, password='******' WHERE id='" + id + "' ";
DbClient.QueryExecute(_query, photobyte);
}
public override void Update()
{
_query = "UPDATE Staff SET name='" + name + "' , cnic='" + cnic + "' , fathername='" + fathername + "' , fathercnic='" + fathercnic + "' , age='" + _age + "' , registerdate='" + _registerdate + "' , qualification='" + qualification + "' , program='" + _program + "' , designation='" + _designation + "' , maritalstatus='" + _maritalstatus + "' , status='" + _status + "' , mobile='" + mobile + "' , contact='" + contact + "' , email='" + email + "' , address1='" + address1 + "' , address2='" + address2 + "' , photo=@img , password='******' WHERE id='" + id + "'";
DbClient.QueryExecute(_query, photobyte);
}
public override void Save()
{
_query = "INSERT INTO Student (name,cnic,fathername,fathercnic,dateofbirth,class,section,registerdate,status,mobile,contact,email,address1,address2,photo,password) VALUES('" + name + "','" + cnic + "','" + fathername + "','" + fathercnic + "','" + _dateofbirth + "','" + _class + "','" + _section + "','" + _registerdate + "','" + _status + "','" + mobile + "','" + contact + "','" + email + "','" + address1 + "','" + address2 + "',@img,'" + password + "')";
DbClient.QueryExecute(_query, photobyte);
}
public override void Save()
{
_query = "INSERT INTO Staff (name,cnic,fathername,fathercnic,age,registerdate,qualification,program,designation,maritalstatus,status,mobile,contact,email,address1,address2,photo,password) VALUES('" + name + "','" + cnic + "','" + fathername + "','" + fathercnic + "','" + _age + "','" + _registerdate + "','" + qualification + "','" + _program + "','" + _designation + "','" + _maritalstatus + "','" + _status + "','" + mobile + "','" + contact + "','" + email + "','" + address1 + "','" + address2 + "',@img,'" + password + "')";
DbClient.QueryExecute(_query, photobyte);
}
