C# (CSharp) EL.REGISTRATIONS.staffs Examples

Example #1

File: staffs.cs Project: godofping/LABS-ADVANCE-DATABASE

        public bool Delete(EL.REGISTRATIONS.staffs staffEL)
        {
            string sQuery = "DELETE FROM staffs where staffid = '" + staffEL.Staffid + "'";

            return(Helper.executeNonQueryBool(sQuery));
        }

Example #2

File: staffs.cs Project: godofping/LABS-ADVANCE-DATABASE

        public bool Update(EL.REGISTRATIONS.staffs staffEL)
        {
            string sQuery = "UPDATE staffs SET designationid = '" + staffEL.Designationid + "', datehired = '" + staffEL.Datehired + "' WHERE staffid = '" + staffEL.Staffid + "'";

            return(Helper.executeNonQueryBool(sQuery));
        }

Example #3

File: staffs.cs Project: godofping/LABS-ADVANCE-DATABASE

        public long Insert(EL.REGISTRATIONS.staffs staffEL)
        {
            string sQuery = "INSERT INTO staffs (basicinformationid, designationid, datehired) VALUES ('" + staffEL.Basicinformationid + "', '" + staffEL.Designationid + "', '" + staffEL.Datehired + "')";

            return(Helper.executeNonQueryLong(sQuery));
        }

Example #4

 public bool Delete(EL.REGISTRATIONS.staffs staffEL)
 {
     return(staffDL.Delete(staffEL));
 }

Example #5

 public bool Update(EL.REGISTRATIONS.staffs staffEL)
 {
     return(staffDL.Update(staffEL));
 }

Example #6

 public long Insert(EL.REGISTRATIONS.staffs staffEL)
 {
     return(staffDL.Insert(staffEL));
 }