// add a badge give type
public int addBadgeGiveType(BadgeGiveType bgt)
{
if (bgt == null)
{
throw new Exception("Failed to add the badge give type. Passed wrong badge give type.");
}
string name = bgt.BGT_Name
, descript = bgt.BGT_Descript;
using (var conn = new SqlConnection(connectionString))
{
string sql = @"INSERT INTO BadgeGiveType (BGT_Name, BGT_Descript) VALUES ( @name , @descript )";
return(conn.Execute(sql, new { name, descript }));
}
}
// Update badge give type
public int updateBadgeGiveType(BadgeGiveType bgt, string oldBGTName)
{
if (bgt == null || String.IsNullOrEmpty(oldBGTName))
{
throw new Exception("Failed to update the badge give type. Passed in wrong badge type/");
}
string name = bgt.BGT_Name
, descript = bgt.BGT_Descript;
using (var conn = new SqlConnection(connectionString))
{
string sql = @"UPDATE BadgeGiveType SET BGT_Name = @name, BGT_Descript = @descript WHERE BGT_Id =
(select BadgeGiveType.BGT_Id from BadgeGiveType where BGT_Name = @oldBGTName)";
return(conn.Execute(sql, new { name, descript, oldBGTName }));
}
}
