public async Task <IActionResult> PutTblCompany(long id, TblCompany tblCompany)
{
if (id != tblCompany.Id)
{
return(BadRequest());
}
_context.Entry(tblCompany).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblCompanyExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public long UpdateCompany(TblCompany model)
{
long res = 0;
// Declare new DataAccess object
CompanyDa dataAccess = new CompanyDa();
using (var transaction = new TransactionScope())
{
try
{
res = dataAccess.UpdateCompany(model);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
transaction.Dispose();
}
}
return(res);
}
public async Task <ActionResult <TblCompany> > PostTblCompany(TblCompany tblCompany)
{
_context.TblCompany.Add(tblCompany);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblCompany", new { id = tblCompany.Id }, tblCompany));
}
public static bool IsMemberExceedUOBBookingThisMonth(string strMembershipID, DateTime uobBookingDate)
{
TblCompany comp = new TblCompany();
DataTable table = comp.SelectAll();
DataRow compMasterRow = table.Rows[0];
int nUOBMonthlyBooking = ACMS.Convert.ToInt32(compMasterRow["nUOBMonthlyBooking"]);
TblServiceSession serviceSession = new TblServiceSession();
DataTable uobBookingTable = serviceSession.GetUOBBookingServiceSessionBaseMembershipID(strMembershipID);
int uobBookingMade = 0;
if (uobBookingTable != null && uobBookingTable.Rows.Count > 0)
{
foreach (DataRow r in uobBookingTable.Rows)
{
DateTime serviceSessionDate = ACMS.Convert.ToDateTime(r["dtDate"]);
if (serviceSessionDate != DateTime.MinValue)
{
if (serviceSessionDate.Month == uobBookingDate.Month &&
serviceSessionDate.Year == uobBookingDate.Year)
{
uobBookingMade++;
}
}
}
}
return(uobBookingMade >= nUOBMonthlyBooking);
}
public async Task <ApiResponse> GetCompanyById(TblCompany tblcompany)
{
var items = await _context.TblCompany.FindAsync(tblcompany.Id);
var ApiResponse = await response.ApiResult("OK", items, "Record Add");
return(ApiResponse);
// return CreatedAtAction("GetTblStock", new { id = tblStock.Id }, tblStock);
}
public async Task <ApiResponse> AddCompany(TblCompany tblcompany)
{
var headd = Request.Headers["Auth"];
_context.TblCompany.Add(tblcompany);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", tblcompany.Id, "Record Add");
return(ApiResponse);
// return CreatedAtAction("GetTblStock", new { id = tblStock.Id }, tblStock);
}
public long InsertCompany(TblCompany entity)
{
entity.DEL_FLG = Constant.DeleteFlag.NON_DELETE;
entity.INS_DATE = DateTime.Now;
entity.INS_USER_ID = CmnEntityModel.ID;
entity.UPD_DATE = DateTime.Now;
entity.UPD_USER_ID = CmnEntityModel.ID;
da.TblCompany.Add(entity);
da.SaveChanges();
return(entity.COMPANY_ID);
}
protected void lnkEdit_Click(object sender, EventArgs e)
{
LinkButton CompanyId = (LinkButton)sender;
TblCompany obj = new TblCompany(CompanyId.CommandArgument);
hfCompany.Value = CompanyId.CommandArgument;
txtName.Text = obj.Company;
txtContact.Text = obj.Contact;
ddlStatus.SelectedValue = obj.IsActive.ToString();
btnSave.Text = "Update";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal('#formPopUp');", true);
loadCompany();
}
public static bool BlockMembershipID(int numberOfNonMemberID, int numberOfMemberID, string strBranchCode)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
TblBranch sqlBranch = new TblBranch();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlBranch.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("BlockMembershipID");
if (numberOfNonMemberID > 0)
{
sqlCompany.UpdateBlockNonMembershipID(numberOfNonMemberID);
}
if (numberOfMemberID > 0)
{
sqlBranch.UpdateBlockMembershipID(strBranchCode, numberOfMemberID);
}
connProvider.CommitTransaction();
return(true);
}
catch (Exception)
{
connProvider.RollbackTransaction("BlockMembershipID");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.Dispose();
sqlBranch.Dispose();
}
}
public ActionResult Save(CompanyViewModel companyViewModel)
{
try
{
if (ModelState.IsValid)
{
//add
if (companyViewModel.CompanyId == 0 && companyViewModel.ActionName == "Add")
{
var model = new TblCompany()
{
CompanyId = companyViewModel.CompanyId + 1, CompanyName = companyViewModel.CompanyName, Address = companyViewModel.Address, CreatedBy = "Rasel", CreatedDate = DateTime.Now, UpdatedBy = "Rasel", UpdatedDate = DateTime.Now
};
_companyRepository.Insert(model);
}
else if (companyViewModel.ActionName == "Edit") //edit
{
TblCompany company = _companyRepository.GetById(Convert.ToInt32(companyViewModel.CompanyId));
if (company != null)
{
company.CompanyId = companyViewModel.CompanyId;
company.CompanyName = companyViewModel.CompanyName;
company.Address = companyViewModel.Address;
company.UpdatedBy = "Rasel";
company.UpdatedDate = DateTime.Now;
_companyRepository.Update(company);
}
else
{
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, companyViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ExceptionMessageForNullObject())));
}
}
_companyRepository.Save();
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.TrueString, companyViewModel.ActionName, MessageType.success.ToString(), "Saved Successfully.")));
}
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, companyViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ModelStateErrorFormat(ModelState))));
}
catch (Exception ex)
{
return(Content(KendoUiHelper.GetKendoUiWindowAjaxSuccessMethod(Boolean.FalseString, companyViewModel.ActionName, MessageType.warning.ToString(), ExceptionHelper.ExceptionMessageFormat(ex))));
}
}
public static void CurrentLastMembershipID(string strTerminalBranch, ref int lastNonMemberID, ref int lastMemberID)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
TblBranch sqlBranch = new TblBranch();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlBranch.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("LastMembershipID");
DataTable companyTable = sqlCompany.SelectAll();
sqlBranch.StrBranchCode = strTerminalBranch;
DataTable branchTable = sqlBranch.SelectOne();
connProvider.CommitTransaction();
lastNonMemberID = ACMS.Convert.ToInt32(companyTable.Rows[0]["nNonMembershipNo"]);
lastMemberID = ACMS.Convert.ToInt32(branchTable.Rows[0]["nMembershipNo"]);
return;
}
catch (Exception)
{
connProvider.RollbackTransaction("ResetMembershipID");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.Dispose();
sqlBranch.Dispose();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
TblCompany obj = new TblCompany();
obj.IsNew = true;
if (!string.IsNullOrEmpty(hfCompany.Value))
{
obj = new TblCompany(hfCompany.Value);
obj.IsNew = false;
}
obj.Company = txtName.Text;
obj.Contact = txtContact.Text;
obj.IsActive = Convert.ToInt32(ddlStatus.SelectedValue);
obj.Save();
btnSave.Text = "Save";
loadCompany();
}
private void loadrptCompanyStatment(string val, int Companyid)
{
TblCompany obj = new TblCompany(Companyid);
ltrName.Text = obj.Company;
ltrContact.Text = obj.Contact;
string[] date = val.Split('-');
DataTable dt = SPs.SpGetCompanyMonthlyStatment(Convert.ToInt32(Companyid), date[0], date[1]).GetDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
ltrPrv.Text = Convert.ToString(-(Convert.ToInt32(dt.Rows[dt.Rows.Count - 1]["PrevRemaining"])));
ltrTotal.Text = Convert.ToString(-(Convert.ToInt32(dt.Rows[dt.Rows.Count - 1]["Remaining"])));
ltrBalance.Text = Convert.ToString(-(Convert.ToInt32(dt.Rows[dt.Rows.Count - 1]["Balance"])));
}
rptrCompanyStatment.DataSource = dt;
rptrCompanyStatment.DataBind();
}
public ActionResult Edit(TblCompany model)
{
try
{
using (CompanyService service = new CompanyService())
{
if (ModelState.IsValid)
{
bool isNew = false;
if (model.COMPANY_ID == 0)
{
isNew = true;
service.InsertCompany(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
else
{
isNew = false;
service.UpdateCompany(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
}
catch (Exception ex)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest;
System.Web.HttpContext.Current.Session["ERROR"] = ex;
return(new EmptyResult());
}
}
// GET: AdminManageCompany
#region REGISTER/ UPDATE
public ActionResult CompanyEdit()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
TblCompany model = new TblCompany();
CommonService comService = new CommonService();
CompanyDa dataAccess = new CompanyDa();
string CompanyCd = "00000";
TblCompany infor = new TblCompany();
infor = dataAccess.getCompanyByCd(CompanyCd);
model = infor != null ? infor : model;
return(View(model));
}
public async Task <ApiResponse> UpdateCompany(TblCompany tblCompany)
{
_context.Entry(tblCompany).State = EntityState.Modified;
_context.Entry(tblCompany).Property(x => x.RecordDate).IsModified = false;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponseCatch = await response.ApiResult("FAILED", ex, "Company Not Found");
return(ApiResponseCatch);
}
var ApiResponse = await response.ApiResult("OK", tblCompany, "Record Update");
return(ApiResponse);
}
public long UpdateCompany(TblCompany entity)
{
var company = da.TblCompany.Find(entity.COMPANY_ID);
if (company != null)
{
try
{
// set data
company.COMPANY_ADDRESS = entity.COMPANY_ADDRESS;
company.COMPANY_EMAIL = entity.COMPANY_EMAIL;
company.COMPANY_LAT = entity.COMPANY_LAT;
company.COMPANY_LNG = entity.COMPANY_LNG;
company.COMPANY_NAME = entity.COMPANY_NAME;
company.COMPANY_PHONE = entity.COMPANY_PHONE;
company.FACE_PAGE = entity.FACE_PAGE;
company.LINK_MAP = entity.LINK_MAP;
company.LOGO = entity.LOGO;
company.DEL_FLG = Constant.DeleteFlag.NON_DELETE;
company.UPD_DATE = DateTime.Now;
company.UPD_USER_ID = CmnEntityModel.ID;
da.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
else
{
return(0);
}
return(entity.COMPANY_ID);
}
public TblCompany getInfoCompany(string CompanyCd)
{
TblCompany comp = da.TblCompany.Where(s => s.COMPANY_CD == CompanyCd && s.DEL_FLG == Constant.DeleteFlag.NON_DELETE).SingleOrDefault();
return(comp);
}
private void BindGrid(int CompanyID)
{
SqlParameter[] prm = new SqlParameter[1];
rptCompanyDetails.DataSource = TblCompany.GetAccountDetails(CompanyID);
rptCompanyDetails.DataBind();
}
/// <summary>
/// Include member or non member
/// </summary>
/// <param name="isMember"></param>
/// <param name="branchCode"></param>
/// <param name="name"></param>
/// <param name="isSingaporean"></param>
/// <param name="NRIC"></param>
/// <param name="nSignUpID"></param>
/// <param name="dob"></param>
/// <param name="aUser"></param>
///
/// 0705
public string AddNewMember(bool isMember, string branchCode, string name, bool isSingaporean, string NRIC, int nSignUpID,
DateTime dob, User aUser, bool isFemale, int nmediaSource)
{
string membershipID = string.Empty;
TblMember sqlMember = new TblMember();
sqlMember.FMember = isMember;
sqlMember.StrMemberName = name;
sqlMember.FFemale = isFemale;
if (name.Length >= 19)
{
sqlMember.StrCardName = name.Substring(0, 19);
}
else
{
sqlMember.StrCardName = name;
}
sqlMember.StrNRICFIN = NRIC;
sqlMember.DtDOB = dob;
sqlMember.StrBranchCode = branchCode;
sqlMember.FSingaporean = isSingaporean;
sqlMember.NMediaSourceID = nmediaSource;
TblCardRequest sqlCardRequest = new TblCardRequest();
TblAudit sqlAudit = new TblAudit();
if (!isMember)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("AddNewNonMember");
sqlCompany.IncOne();
sqlMember.NMembershipNo = sqlCompany.NNonMembershipNo;
sqlMember.NStatus = 1;
sqlMember.NSignupID = nSignUpID;
sqlMember.StrMembershipID = "NMC" + sqlCompany.NNonMembershipNo;
sqlMember.DtSignupDate = DateTime.Now;
//sqlMember.NCardStatusID = (int)CardStatusType.RequestPrint;
sqlMember.NLoyaltyStatusID = 1;
sqlMember.Insert();
membershipID = "NMC" + sqlCompany.NNonMembershipNo;
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("AddNewNonMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.MainConnactionIsCreatedLocal = true;
sqlMember.MainConnactionIsCreatedLocal = true;
sqlCardRequest.MainConnactionIsCreatedLocal = true;
}
}
else
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblBranch sqlBranch = new TblBranch();
try
{
sqlBranch.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("AddNewNonMember");
sqlBranch.StrBranchCode = branchCode;
//sqlBranch.StrBranchCode = "PM";
sqlBranch.IncOne();
sqlMember.NMembershipNo = sqlBranch.NMembershipNo;
sqlMember.NStatus = 1;
sqlMember.NSignupID = nSignUpID;
sqlMember.StrMembershipID = branchCode.TrimEnd() + sqlBranch.NMembershipNo;
// sqlMember.StrMembershipID = "PM" + sqlBranch.NMembershipNo;
sqlMember.DtSignupDate = DateTime.Now;
sqlMember.NCardStatusID = (int)CardStatusType.RequestPrint;
sqlMember.StrCardBranchCode = "HQ";
sqlMember.NLoyaltyStatusID = 1;
sqlMember.Insert();
//Request print for member --now only for fitness member
// sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
// sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
// sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
// sqlCardRequest.StrMembershipID = branchCode.TrimEnd() +sqlBranch.NMembershipNo;
// sqlCardRequest.DtLastEditDate = DateTime.Now;
// sqlCardRequest.Insert();
//Audit trail for request print
// sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
// sqlAudit.NEmployeeID = aUser.NEmployeeID();
// sqlAudit.StrAuditEntry = "New member card request when create new member.";
// sqlAudit.StrReference = branchCode.TrimEnd() +sqlBranch.NMembershipNo;
// sqlAudit.DtDate = DateTime.Now;
// sqlAudit.Insert();
membershipID = branchCode.TrimEnd() + sqlBranch.NMembershipNo;
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("AddNewNonMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlBranch.Dispose();
sqlMember.Dispose();
sqlCardRequest.Dispose();
}
}
return(membershipID);
}
public IActionResult Post([FromBody] TblCompany nCompany)
{
return(new JsonResult(this.repository.AddAsync(nCompany).Result, this.DefaultJsonSettings));
}
public IActionResult Put(int id, [FromBody] TblCompany uCompany)
{
return(new JsonResult(this.repository.UpdateAsync(uCompany, id).Result, this.DefaultJsonSettings));
}
public TblCompany getInfoCompany(string COMPANY_CD)
{
TblCompany slider = da.TblCompany.Where(s => s.COMPANY_CD == COMPANY_CD).SingleOrDefault();
return(slider);
}
public TblCompany getCompanyByCd(string CompanyCd)
{
TblCompany company = da.TblCompany.Where(s => s.COMPANY_CD == CompanyCd).SingleOrDefault();
return(company);
}
public TblCompany getCompanyByID(long Id)
{
TblCompany company = da.TblCompany.Where(s => s.COMPANY_ID == Id).SingleOrDefault();
return(company);
}
public HttpResponseMessage Put(int id, [FromBody] TblCompany value)
{
UserDB.Entry(value).State = EntityState.Modified;
return(ToJson(UserDB.SaveChanges()));
}
public HttpResponseMessage Post([FromBody] TblCompany value)
{
UserDB.TblCompanies.Add(value);
return(ToJson(UserDB.SaveChanges()));
}
public bool IsPeakHour(DateTime dtDate, DateTime dtStartTime, DateTime dtEndTime,
bool isWeekDay, string serviceCode, ref int totalServiceSession)
{
TblCompany comp = new TblCompany();
DataTable table = comp.SelectAll();
DataRow masterRow = table.Rows[0];
TimeSpan dtStartTimeSpan = dtStartTime.TimeOfDay;
TimeSpan dtEndTimeSpan = dtEndTime.TimeOfDay;
if (isWeekDay)
{
if (masterRow["DtUOBWeekdayPeakStart"] == DBNull.Value ||
masterRow["DtUOBWeekdayPeakEnd"] == DBNull.Value)
{
return(false);
}
DateTime weekDayPeakStart = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekdayPeakStart"]);
DateTime weekDayPeakEnd = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekdayPeakEnd"]);
DateTime startTime = new DateTime(dtDate.Year, dtDate.Month, dtDate.Day,
weekDayPeakStart.Hour, weekDayPeakStart.Minute, weekDayPeakStart.Second);
DateTime endTime = new DateTime(dtDate.Year, dtDate.Month, dtDate.Day,
weekDayPeakEnd.Hour, weekDayPeakEnd.Minute, weekDayPeakEnd.Second);
totalServiceSession = 0;
DataTable serviceSessionTable = GetServiceSessionBaseTime(User.BranchCode, serviceCode, dtDate, startTime, endTime);
if (serviceSessionTable != null && serviceSessionTable.Rows.Count > 0)
{
totalServiceSession = serviceSessionTable.Rows.Count;
}
TimeSpan weekDayPeakStartTimeSpan = weekDayPeakStart.TimeOfDay;
TimeSpan weekDayPeakEndTimeSpan = weekDayPeakEnd.TimeOfDay;
if (weekDayPeakStartTimeSpan >= dtStartTimeSpan &&
weekDayPeakEndTimeSpan <= dtStartTimeSpan)
{
return(true);
}
else if (weekDayPeakStartTimeSpan >= dtEndTimeSpan &&
weekDayPeakEndTimeSpan <= dtEndTimeSpan)
{
return(true);
}
else
{
return(false);
}
}
else
{
DateTime weekendPeakStart = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekendPeakStart"]);
DateTime weekendPeakEnd = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekendPeakEnd"]);
DateTime startTime = new DateTime(dtDate.Year, dtDate.Month, dtDate.Day,
weekendPeakStart.Hour, weekendPeakStart.Minute, weekendPeakStart.Second);
DateTime endTime = new DateTime(dtDate.Year, dtDate.Month, dtDate.Day,
weekendPeakEnd.Hour, weekendPeakEnd.Minute, weekendPeakEnd.Second);
totalServiceSession = 0;
DataTable serviceSessionTable = GetServiceSessionBaseTime(User.BranchCode, serviceCode, dtDate, startTime, endTime);
if (serviceSessionTable != null && serviceSessionTable.Rows.Count > 0)
{
totalServiceSession = serviceSessionTable.Rows.Count;
}
TimeSpan weekendPeakStartTimeSpan = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekendPeakStart"]).TimeOfDay;
TimeSpan weekendPeakEndTimeSpan = ACMS.Convert.ToDateTime(masterRow["DtUOBWeekendPeakEnd"]).TimeOfDay;
if (weekendPeakStartTimeSpan >= dtStartTimeSpan &&
weekendPeakEndTimeSpan <= dtStartTimeSpan)
{
return(true);
}
else if (weekendPeakStartTimeSpan >= dtEndTimeSpan &&
weekendPeakEndTimeSpan <= dtEndTimeSpan)
{
return(true);
}
else
{
return(false);
}
}
}
