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