public string checkMedal(long acc)
{
BankEntities2 dbContext2 = new BankEntities2();
int amt;
CustomerClass obj = new CustomerClass();
Account account = dbContext.Accounts.Where(val => val.accountNo == acc).Single <Account>();
amt = (int)(account.amount);
CustomerMedal medal = dbContext2.CustomerMedals.Where(val => val.min <amt && val.max> amt).Single <CustomerMedal>();
account.type = medal.type;
dbContext.SaveChanges();
return(account.type);
}
public string checkMedal(long acc)
{
int amt;
CustomerClass obj = new CustomerClass();
amt = obj.getAmount(acc);
String ConnectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
string sql = "changeMedal";
SqlCommand command = new SqlCommand(sql, con);
SqlParameter param1 = new SqlParameter("@amt", amt);
command.Parameters.Add(param1);
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
string sql2 = "getMedal";
SqlCommand command2 = new SqlCommand(sql2, con);
SqlParameter param12 = new SqlParameter("@acc", acc);
command2.Parameters.Add(param12);
command2.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da2 = new SqlDataAdapter(command2);
DataSet ds = new DataSet();
da2.Fill(ds);
string res = null;
if (ds.Tables[0].Rows.Count > 0)
{
res = ds.Tables[0].Rows[0]["type"].ToString();
}
con.Close();
return(res);
}
