public ExcutionResult GetAll() { ExcutionResult result = new ExcutionResult(); try { var param = KhachHangManager.GetAll(); result.Data = param; } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; } return(result); }
public ExcutionResult GetAllByPaging(PagingItem pagingItem) { ExcutionResult ex = new ExcutionResult(); try { var p = FeedBackManager.GetAllByPaging(pagingItem); ex.Data = p; ex.MetaData = pagingItem; } catch (Exception e) { ex.ErrorCode = 1; ex.Message = e.Message; } return(ex); }
public ExcutionResult GetAll() { ExcutionResult result = new ExcutionResult(); try { var param = AppParamManager.GetAll(); result.Data = param; } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; _iLogger.LogError(e.Message, e); } return(result); }
public ExcutionResult Search(string keyword) { ExcutionResult result = new ExcutionResult(); try { var param = AppParamManager.Search(keyword); result.Data = param; } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; _iLogger.LogError(e.Message, e); } return(result); }
public ExcutionResult GetById(string id) { ExcutionResult result = new ExcutionResult(); try { var param = HolidayManager.GetById(id); result.Data = param; } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; _iLogger.LogError(e.Message, e); } return(result); }
public ExcutionResult GetAllByPaging(PagingItem pagingItem) { ExcutionResult result = new ExcutionResult(); try { var param = HolidayManager.GetAllByPaging(pagingItem); result.Data = param; result.MetaData = pagingItem; } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; _iLogger.LogError(e.Message, e); } return(result); }
public ExcutionResult Insert(BookTour bookTour) { ExcutionResult rowaffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeName = "BookTour_Insert"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeName)) { bookTour.Id = Guid.NewGuid(); db.AddInParameter(dbCommand, "Id", DbType.Guid, bookTour.Id); db.AddInParameter(dbCommand, "KhachHangId", DbType.Guid, bookTour.KhachHangId); db.AddInParameter(dbCommand, "TourDetailId", DbType.Guid, bookTour.TourDetailId); db.AddInParameter(dbCommand, "NguoiLon", DbType.Int32, bookTour.NguoiLon); db.AddInParameter(dbCommand, "TreEm", DbType.Int32, bookTour.TreEm); db.AddInParameter(dbCommand, "ThongDiep", DbType.String, bookTour.ThongDiep); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, bookTour.CreatedBy); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, bookTour.CreatedAt); db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, bookTour.UpdatedBy); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, bookTour.UpdatedAt); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int16, bookTour.IsDeleted); db.AddInParameter(dbCommand, "TripId", DbType.Guid, bookTour.TripId); db.AddInParameter(dbCommand, "TongTien", DbType.Int64, bookTour.TongTien); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = ConvertHelpers.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0); if (isCheck == 1) { rowaffected.ErrorCode = 2; rowaffected.Message = "Insert no success"; } } } catch (Exception e) { rowaffected.ErrorCode = 1; rowaffected.Message = e.Message; } return(rowaffected); }
public ExcutionResult Update(Company company) { ExcutionResult rowAffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeNameProcedure = "Company_Update"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure)) { db.AddInParameter(dbCommand, "Id", DbType.String, company.Id); db.AddInParameter(dbCommand, "Code", DbType.String, company.Code); db.AddInParameter(dbCommand, "TaxCode", DbType.String, company.TaxCode); db.AddInParameter(dbCommand, "Name", DbType.String, company.Name); db.AddInParameter(dbCommand, "Address", DbType.String, company.Address); db.AddInParameter(dbCommand, "Phone", DbType.String, company.Phone); db.AddInParameter(dbCommand, "Fax", DbType.String, company.Fax); db.AddInParameter(dbCommand, "Email", DbType.String, company.Email); db.AddInParameter(dbCommand, "Logo", DbType.String, company.Logo); db.AddInParameter(dbCommand, "Deputy", DbType.String, company.Deputy); db.AddInParameter(dbCommand, "Mobile", DbType.String, company.Mobile); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, company.CreatedBy); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, company.CreatedAt); db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, company.UpdatedBy); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, company.UpdatedAt); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int32, company.IsDeleted); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = ConvertHelper.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0); if (isCheck == 1) { rowAffected.Message = "Update no Success"; } } } catch (Exception e) { rowAffected.ErrorCode = 1; rowAffected.Message = e.Message; } return(rowAffected); }
public ExcutionResult Insert(BookTour bookTour) { ExcutionResult rowsAffected = new ExcutionResult(); try { var now = DateTime.Now; bookTour.CreatedAt = now; rowsAffected = BookTourManager.Insert(bookTour); if (rowsAffected.ErrorCode == 1 || rowsAffected.ErrorCode == 2) { rowsAffected.Message = "Insert failed"; } } catch (Exception e) { rowsAffected.ErrorCode = 1; rowsAffected.Message = e.Message; } return(rowsAffected); }
public ExcutionResult Insert(KhachHang khachHang) { ExcutionResult rowsAffected = new ExcutionResult(); try { var now = DateTime.Now; khachHang.CreatedAt = now; rowsAffected = KhachHangManager.Insert(khachHang); if (rowsAffected.ErrorCode == 1 || rowsAffected.ErrorCode == 2) { rowsAffected.Message = "Insert failed"; } } catch (Exception e) { rowsAffected.ErrorCode = 1; rowsAffected.Message = e.Message; } return(rowsAffected); }
public ExcutionResult Insert(KhachHang khachHang) { ExcutionResult rowaffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeName = "KhachHang_Insert"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeName)) { khachHang.Id = Guid.NewGuid(); db.AddInParameter(dbCommand, "Id", DbType.Guid, khachHang.Id); db.AddInParameter(dbCommand, "FullName", DbType.String, khachHang.FullName); db.AddInParameter(dbCommand, "Address", DbType.String, khachHang.Address); db.AddInParameter(dbCommand, "Email", DbType.String, khachHang.Email); db.AddInParameter(dbCommand, "Phone", DbType.String, khachHang.Phone); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, khachHang.CreatedBy); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, khachHang.CreatedAt); db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, khachHang.UpdatedBy); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, khachHang.UpdatedAt); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int16, khachHang.IsDeleted); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = ConvertHelpers.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0); if (isCheck == 1) { rowaffected.ErrorCode = 2; rowaffected.Message = "Insert no success"; } } } catch (Exception e) { rowaffected.ErrorCode = 1; rowaffected.Message = e.Message; } return(rowaffected); }
public ExcutionResult Update(AppParam appParam) { ExcutionResult rowAffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeNameProcedure = "AppParam_Update"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure)) { db.AddInParameter(dbCommand, "Id", DbType.String, appParam.Id); db.AddInParameter(dbCommand, "Type", DbType.String, appParam.Type); db.AddInParameter(dbCommand, "Code", DbType.String, appParam.Code); db.AddInParameter(dbCommand, "Name", DbType.String, appParam.Name); db.AddInParameter(dbCommand, "Value", DbType.String, appParam.Value); db.AddInParameter(dbCommand, "OrderNo", DbType.Int32, appParam.OrderNo); db.AddInParameter(dbCommand, "Status", DbType.Int32, appParam.Status); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, appParam.CreatedBy); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, appParam.CreatedAt); db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, appParam.UpdatedBy); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, appParam.UpdatedAt); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int32, appParam.IsDeleted); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = ConvertHelper.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0); if (isCheck == 1) { rowAffected.Message = "Update no success"; } } } catch (Exception e) { rowAffected.ErrorCode = 1; rowAffected.Message = e.Message; } return(rowAffected); }
public ExcutionResult Delete(string Id, string userId) { ExcutionResult result = new ExcutionResult(); try { var param = AppParamManager.GetById(Id); if (param != null) { var now = DateTime.Now; param.UpdatedAt = now; param.UpdatedBy = userId; result = AppParamManager.Delete(param); } } catch (Exception e) { result.ErrorCode = 1; result.Message = e.Message; _iLogger.LogError(e.Message, e); } return(result); }
public ExcutionResult Delete(string id, string userId) { ExcutionResult rowAffected = new ExcutionResult(); try { var param = HolidayManager.GetById(id); if (param != null) { var now = DateTime.Now; param.UpdatedAt = now; param.UpdatedBy = userId; rowAffected = HolidayManager.Delete(param); } } catch (Exception e) { rowAffected.ErrorCode = 1; rowAffected.Message = e.Message; _iLogger.LogError(e.Message, e); } return(rowAffected); }
public ExcutionResult Update(FeedBacks employees) { ExcutionResult rowAffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeNameProcedure = "FeedBacks_Update"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure)) { db.AddInParameter(dbCommand, "Id", DbType.String, employees.Id); db.AddInParameter(dbCommand, "EmployeeCode", DbType.String, employees.EmployeeCode); db.AddInParameter(dbCommand, "Titles", DbType.String, employees.Titles); db.AddInParameter(dbCommand, "FeedBack", DbType.String, employees.FeedBack); db.AddInParameter(dbCommand, "Contents", DbType.String, employees.Contents); db.AddInParameter(dbCommand, "FileAttached", DbType.String, employees.FileAttached); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, employees.CreatedBy); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, employees.CreatedAt); db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, employees.CreatedBy); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, employees.CreatedAt); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int32, employees.IsDeleted); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = ConvertHelper.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0); if (isCheck == 1) { rowAffected.Message = "Update Failed"; } } } catch (Exception e) { rowAffected.ErrorCode = 1; rowAffected.Message = e.Message; } return(rowAffected); }
public ExcutionResult Update(Employees employees) { ExcutionResult rowAffected = new ExcutionResult(); try { Database db = this.GetDatabase(); string storeNameProcedure = "Employee_Update"; using (DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure)) { db.AddInParameter(dbCommand, "Id", DbType.String, employees.id); db.AddInParameter(dbCommand, "LastName", DbType.String, employees.LastName); db.AddInParameter(dbCommand, "FullName", DbType.String, employees.FullName); db.AddInParameter(dbCommand, "Email", DbType.String, employees.Email); db.AddInParameter(dbCommand, "Address", DbType.String, employees.Address); db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, employees.CreatedAt); db.AddInParameter(dbCommand, "CreatedBy", DbType.String, employees.CreatedBy); db.AddInParameter(dbCommand, "IsDeleted", DbType.Int16, employees.IsDeleted); db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, employees.UpdatedAt); db.AddInParameter(dbCommand, "UpdateBy", DbType.String, employees.UpdatedBy); db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20); db.ExecuteNonQuery(dbCommand); var isCheck = int.Parse((db.GetParameterValue(dbCommand, "IsCheck")).ToString()); if (isCheck == 1) { rowAffected.Message = "No success"; } } } catch (Exception e) { rowAffected.ErrorCode = 1; rowAffected.Message = e.Message; } return(rowAffected); }
public static ExcutionResult Delete(FeedBacks feedBacks) { ExcutionResult rowAffected = provider.Delete(feedBacks); return(rowAffected); }
public static ExcutionResult Delete(AppParam appParam) { ExcutionResult rowAffected = provider.Delete(appParam); return(rowAffected); }
public static ExcutionResult Insert(AppParam appParam) { ExcutionResult rowAffected = provider.Insert(appParam); return(rowAffected); }
public static ExcutionResult Delete(Holiday holiday) { ExcutionResult rowAffected = provider.Delete(holiday); return(rowAffected); }
public static ExcutionResult Insert(Holiday holiday) { ExcutionResult rowAffected = provider.Insert(holiday); return(rowAffected); }
public static ExcutionResult Insert(FeedBacks feedBacks) { ExcutionResult rowAffected = provider.Insert(feedBacks); return(rowAffected); }
public static ExcutionResult Insert(BookTour bookTour) { ExcutionResult rowAffected = provider.Insert(bookTour); return(rowAffected); }
public static ExcutionResult Insert(KhachHang khachHang) { ExcutionResult rowAffected = provider.Insert(khachHang); return(rowAffected); }
public static ExcutionResult Insert(Employees employees) { ExcutionResult rowAffected = provider.Insert(employees); return(rowAffected); }
public static ExcutionResult Delete(Employees employees) { ExcutionResult rowAffected = provider.Delete(employees); return(rowAffected); }