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); } } }