public int InsertData(StudentDetailsData data) { DbHandiler.DbHandiler DbHandle = new DbHandiler.DbHandiler(); string sql = @"insert into student_data (SUBJECT1,SUBJECT2,ADDRESS,MARKS1,MARKS2,NAME,CLASS,AGE,SEX,UID) VALUES (@SUBJECT1,@SUBJECT2,@ADDRESS,@MARKS1,@MARKS2,@NAME,@CLASS,@AGE,@SEX,@UID);"; return(DbHandle.SaveData <StudentDetailsData>(sql, data)); }
public object UpdateToDb(StudentDetailsData data) { DbHandiler.DbHandiler DbHandle = new DbHandiler.DbHandiler(); string sql = @"UPDATE student_data SET SUBJECT1 = @SUBJECT1,SUBJECT2 = @SUBJECT2,ADDRESS = @ADDRESS ,MARKS1 = @MARKS1, MARKS2 = @MARKS2,NAME = @NAME,CLASS = @CLASS ,AGE = @AGE,SEX = @SEX,UID = @UID where ID = @ID "; return(DbHandle.SaveData <StudentDetailsData>(sql, data)); }
public string LoadDataUsingDb(int item) { DbHandiler.DbHandiler DbHandle = new DbHandiler.DbHandiler(); List <StudentDetailsData> returnList = new List <StudentDetailsData>(); string sql = string.Empty; if (item == 0) { sql = @"SELECT `student_data`.`ID`, `student_data`.`UID`, `student_data`.`SUBJECT1`, `student_data`.`SUBJECT2`, `student_data`.`ADDRESS`, `student_data`.`MARKS1`, `student_data`.`MARKS2`, `student_data`.`NAME`, `student_data`.`CLASS`, `student_data`.`AGE`, `student_data`.`SEX` FROM `samle_my_students`.`student_data`;"; } else { sql = string.Concat(@"SELECT `student_data`.`ID`, `student_data`.`UID`, `student_data`.`SUBJECT1`, `student_data`.`SUBJECT2`, `student_data`.`ADDRESS`, `student_data`.`MARKS1`, `student_data`.`MARKS2`, `student_data`.`NAME`, `student_data`.`CLASS`, `student_data`.`AGE`, `student_data`.`SEX` FROM `samle_my_students`.`student_data` where id = ", item, ";"); } returnList = DbHandle.LoadData <StudentDetailsData>(sql); string json = JsonConvert.SerializeObject(returnList); return(json); }