public static int UpdateStudent(int iId, string sName, string sAddress, int iAge, string sStandard, decimal dPercent, DateTime dAddedOn, bool bStatus) { DataLibrary.Models.StudentModel data = new DataLibrary.Models.StudentModel { name = sName, address = sAddress, age = iAge, standard = sStandard, percent = dPercent, status = bStatus }; string sqlU = @"update dbo.Student set [name]=@name, [address]=@address, [age]=@age, [standard]=@standard, [percent]=@percent, [status]=@status where Id=" + iId + ";"; return(SqlDataAccess.SaveData(sqlU, data)); }
public static int CreateStudent(int iId, string sName, string sAddress, int iAge, string sStandard, decimal dPercent, DateTime dAddedOn, bool bStatus) { DataLibrary.Models.StudentModel data = new DataLibrary.Models.StudentModel { id = iId, name = sName, address = sAddress, age = iAge, standard = sStandard, percent = dPercent, addedOn = dAddedOn, status = bStatus }; string sql = @"insert into dbo.Student ([name], [address], [age], [standard], [percent], [status]) values (@name, @address, @age, @standard, @percent, @status);"; return(SqlDataAccess.SaveData(sql, data)); }