public AlertEvents GetAlertEventsRecord(string recordID, string UserSNo) { AlertEvents alertEvents = new AlertEvents(); SqlDataReader dr = null; try { SqlParameter[] Parameters = { new SqlParameter("@SNo", (recordID)), new SqlParameter("@UserID", Convert.ToInt32(UserSNo)) }; dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetAlertEventsRecord", Parameters); if (dr.Read()) { alertEvents.SNo = Convert.ToInt32(dr["SNo"]); alertEvents.RefNo = Convert.ToString(dr["RefNo"]); alertEvents.CitySNo = Convert.ToInt32(dr["CitySNo"] == "" ? 0 : dr["CitySNo"]); alertEvents.Text_CitySNo = dr["CityCode"].ToString().ToUpper(); alertEvents.OfficeSNo = Convert.ToInt32(dr["OfficeSNo"] == "" ? 0 : dr["OfficeSNo"]); alertEvents.Text_OfficeSNo = dr["OfficeName"].ToString().ToUpper(); alertEvents.AirlineSNo = dr["AirlineSNo"].ToString().ToUpper(); alertEvents.Text_AirlineSNo = dr["AirlineName"].ToString().ToUpper(); alertEvents.TransactionType = dr["TransactionType"].ToString().ToUpper(); alertEvents.Text_TransactionType = dr["TypeTrans"].ToString().ToUpper(); alertEvents.SPHCType = dr["SPHCType"].ToString().ToUpper(); alertEvents.Text_SPHCType = dr["Text_SPHCType"].ToString().ToUpper(); alertEvents.SPHCCode = dr["SPHCSNo"].ToString().ToUpper(); alertEvents.Text_SPHCCode = dr["SPHCCode"].ToString().ToUpper(); alertEvents.SPHCSubGroupSNo = dr["SPHCSubGroupSNo"].ToString() == "0" ? "" : dr["SPHCSubGroupSNo"].ToString(); alertEvents.Text_SPHCSubGroupSNo = dr["Text_SPHCSubGroupSNo"].ToString().ToUpper(); alertEvents.AlertEventSNo = Convert.ToInt32(dr["AlertEventSNo"]); alertEvents.Text_AlertEventSNo = dr["AlertEvent"].ToString().ToUpper(); alertEvents.TriggerEventTypeSNo = Convert.ToInt32(dr["TriggerEventTypeSNo"]); //Added by Shivam alertEvents.Text_TriggerEventTypeSNo = dr["Text_TriggerEventTypeSNo"].ToString().ToUpper(); //Added by Shivam alertEvents.TriggerNameSNo = Convert.ToInt32(dr["TriggerNameSNo"]); alertEvents.Text_TriggerNameSNo = dr["Text_TriggerNameSNo"].ToString().ToUpper(); alertEvents.Email = dr["Email"].ToString(); alertEvents.Message = dr["Message"].ToString(); alertEvents.UpdatedBy = dr["UpdatedBy"].ToString().ToUpper(); alertEvents.CommoditySNo = dr["CommoditySNo"].ToString().ToUpper(); alertEvents.Text_CommoditySNo = dr["CommodityName"].ToString().ToUpper(); alertEvents.Active = dr["Active"].ToString().ToUpper(); alertEvents.IsActive = Convert.ToBoolean(dr["IsActive"]); } } catch (Exception ex)// (Exception ex) { dr.Close(); } return(alertEvents); }
private void TrainUnit() { if (GameData.Instance.Capsules < 10) { AlertEvents.InsufficientFunds(); return; } GameData.Instance.Capsules -= 10; if (trainingUnit) { unitsInTrainingQueue++; } else { BeginTrainingUnit(); } }