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