public int UpdateNum(string id,int type)
{
int number;
OxcoderIDAL.SearchChallengeIDAL sci = new OxcoderDAL.SearchChallengeDAL();
number = Convert.ToInt32(sci.SearchByChallengeID(id).Tables[0].Rows[0]["Challenge_Num"].ToString());
StringBuilder sql2 = new StringBuilder();
sql2.Append("update [Challenge] set Challenge_Num = @number where Challenge_ID like @id");
SqlParameter[] par2 = { new SqlParameter("@number",SqlDbType.Int),
new SqlParameter("@id", SqlDbType.VarChar) };
par2[0].Value = number + type;
par2[1].Value = id;
return Common.DbHelperSQL.ExecuteSql(sql2.ToString(), par2);
}
public int UpdateNum(string id, int type)
{
int number;
OxcoderIDAL.SearchChallengeIDAL sci = new OxcoderDAL.SearchChallengeDAL();
number = Convert.ToInt32(sci.SearchByChallengeID(id).Tables[0].Rows[0]["Challenge_Num"].ToString());
StringBuilder sql2 = new StringBuilder();
sql2.Append("update [Challenge] set Challenge_Num = @number where Challenge_ID like @id");
SqlParameter[] par2 = { new SqlParameter("@number", SqlDbType.Int),
new SqlParameter("@id", SqlDbType.VarChar) };
par2[0].Value = number + type;
par2[1].Value = id;
return(Common.DbHelperSQL.ExecuteSql(sql2.ToString(), par2));
}
