private static void PostAddUser_A3() { sdb = new SqlDB(DataPara.GetDbConnectionString("ICDB")); opc.Clear(); opc.Add(DataPara.CreateDataParameter("@P_EmpId", DbType.String, "Employeeid", ParameterDirection.Input)); DataTable dtuser = sdb.ExecuteProcTable("P_GetCardUSERInfo", opc); if (dtuser.Rows.Count > 0) { foreach (DataRow druser in dtuser.Rows) { bool Status = CheckUser(druser); if (Status == false) { InsertUser(druser); } } SendMails("success"); } else { SendMails("None"); } }