/// <summary>
/// Thêm mới quyền cho nhân viên
/// </summary>
/// <param name="lstMember"></param>
/// <returns></returns>
public bool Insert(List <MemberModel> lstMember, int userID)
{
try
{
db = new THN_WebApplicationEntities();
if (lstMember != null && lstMember.Count > 0)
{
foreach (var item in lstMember)
{
Member model = new Member();
model.UserID = item.UserID;
model.FuncID = item.FuncID;
model.CreateBy = ConfigHelper.User.Username;
model.CreateDate = DateTime.Now;
db.Members.Add(model);
}
if (db.SaveChanges() > 0)
{
return(true);
}
}
return(false);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(false);
}
}
public JsonResult UploadOnlyImage(IFormFile fileinput)
{
try
{
var files = HttpContext.Request.Form.Files;
var file = files.FirstOrDefault();
var fileName = file.FileName;
string fileContentType = file.ContentType.ToString();
if (!(fileContentType == "image/bmp" || fileContentType == "image/gif" ||
fileContentType == "image/png" || fileContentType == "image/x-png" || fileContentType == "image/jpeg" ||
fileContentType == "image/pjpeg"))
{
return(Json(new { msg = "小主，只能上传图片", status = "false" }));
}
string filePath = Directory.GetCurrentDirectory() + @"\wwwroot\UploadImage";
fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + fileName;
using (FileStream fs = new FileStream(filePath + "\\" + fileName, FileMode.Create))
{
file.CopyTo(fs);
}
string imageurl = "/UploadImage/" + fileName;
WriteLogs.WriteLog("log.log", "exception", "111111111111111");
return(Json(new { msg = fileName, status = "false" }, new Newtonsoft.Json.JsonSerializerSettings()));
}
catch (Exception ex)
{
WriteLogs.WriteLog("log.log", "exception", ex.Message);
return(null);
}
}
public ActionResult AddUpdateOffer(Offer o)
{
try
{
using (var dbContext = new shreayaaSysEntities())
{
if (o.Id == 0)
{
dbContext.Offers.Add(o);
}
else
{
var serviceObj = dbContext.Offers.Where(oo => oo.Id == o.Id).FirstOrDefault();
serviceObj.Name = o.Name;
serviceObj.StartDate = o.StartDate;
serviceObj.EndDate = o.EndDate;
serviceObj.HtmlContent = o.HtmlContent;
}
dbContext.SaveChanges();
return(Json(new { result = "success", newId = o.Id }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
private void LUU_DULIEU(NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_DTO)
{
try
{
int countSave = 0;
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
if (result)
{
countSave = SAVE_DATA_TO_ORACLE(_NVGDQUAY_ASYNCCLIENT_DTO);
}
else
{
countSave = SAVE_DATA_TO_SQL(_NVGDQUAY_ASYNCCLIENT_DTO);
}
if (countSave >= 2)
{
NotificationLauncher.ShowNotification("Thông báo", "Hoàn thành giao dịch", 1, "0x1", "0x8", "normal");
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
public ActionResult UpdateCourse(Courses obj)
{
try
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
obj.Syllabus = file.FileName;
int courseId = 0;
semBAL.AddUpdateCourseDetails(obj, ref courseId);
string path = Server.MapPath("~/Syllabus docs");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string filename = path + "/" + courseId + ".pdf";
if (System.IO.File.Exists(filename))
{
System.IO.File.Delete(path + "/" + courseId + ".pdf");
}
file.SaveAs(filename);
return(Json(new { result = "success", courseId = courseId, syllabus = obj.Syllabus }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UploadOffersPhoto(HttpPostedFileBase file)
{
try
{
if (Request.Files.Count > 0)
{
file = Request.Files[0];
string extension = System.IO.Path.GetExtension(file.FileName);
string ImgPath = "~/images/offers/";
string fname = DateTime.Now.ToString("yyyyddmmhhmmssss");
string path = System.IO.Path.Combine(Server.MapPath(ImgPath), fname + extension);
if (!Directory.Exists(Server.MapPath(ImgPath)))
{
Directory.CreateDirectory(Server.MapPath(ImgPath));
}
file.SaveAs(path);
return(Json(new { result = "success", imgUrl = "/images/offers/" + fname + extension }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetAllClients()
{
try
{
using (var dbcontext = new shreayaaSysEntities())
{
var list = dbcontext.Clients.Select(c => new { Id = c.Id, Name = c.Name }).ToList();
string tempClient = string.Empty;
foreach (var client in list)
{
tempClient += "<div class='col-lg-5 col-lg-offset-1'><div class='client-edit animation animated fadeInDown' data-animation='fadeInDown' data-animation-delay='0s' style='animation-delay: 0s;'><table style='width:100%'><tr style='padding-left:10px;' ><td><span class='fa fa-arrow-right client-listing'></span><span class='clients-txt-overflow' title='" + client.Name + "'>" + client.Name + "</span></td>";
if (User.Identity.IsAuthenticated)
{
tempClient += "<td style='text-align:right'><span class='fa fa-edit data-client-edit' style='cursor:pointer' title='Edit' data-client-name='" + client.Name + "' data-id='" + client.Id + "'></span></td>";
}
tempClient += "</tr></table></div></div>";
}
return(Json(new { result = "success", htmlData = tempClient }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddUpdateService(Service s)
{
try
{
using (var dbContext = new shreayaaSysEntities())
{
if (s.Id == 0)
{
dbContext.Services.Add(s);
}
else
{
var serviceObj = dbContext.Services.Where(ss => ss.Id == s.Id).FirstOrDefault();
serviceObj.Name = s.Name;
serviceObj.HtmlContent = s.HtmlContent;
}
dbContext.SaveChanges();
return(Json(new { result = "success", obj = s }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public async Task <IHttpActionResult> Put(string id, NvCongNoVm.Dto instance)
{
TransferObj <NvCongNo> result = new TransferObj <NvCongNo>();
NvCongNo check = _service.FindById(instance.Id);
if (id != instance.Id || check.TrangThai == (int)ApprovalState.IsComplete)
{
result.Status = false;
result.Message = "Dữ liệu không đúng!";
return(Ok(result));
}
try
{
NvCongNo item = _service.UpdatePhieu(instance);
await _service.UnitOfWork.SaveAsync();
result.Status = true;
result.Message = "Update thành công!";
result.Data = item;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Status = false;
result.Message = e.Message.ToString();
}
return(Ok(result));
}
private void THANHTOAN_HOADON_BANLE_TRALAI()
{
bool success = false;
string TONGTIEN_BANGCHU = ConvertSoThanhChu.ChuyenDoiSoThanhChu(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN);
try
{
LUU_DULIEU(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL);
}
catch
{
MessageBox.Show("CẢNH BÁO ! XẢY RA LỖI KHI LƯU HÓA ĐƠN NÀY, HÃY LƯU LẠI HÓA ĐƠN ĐỂ KIỂM TRA ! XIN CẢM ƠN ");
}
try
{
string MA_TEN_KHACHHANG = "";
if (Config.CheckConnectToServer())
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_ORACLE(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
else
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
using (frmPrintBill_TraLai frmBanTraLai = new frmPrintBill_TraLai())
{
try
{
BILL_DTO infoBill = new BILL_DTO()
{
ADDRESS = Session.Session.CurrentAddress,
CONLAI = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIEN_TRALAI_KHACH,
PHONE = Session.Session.CurrentPhone,
MAKH = MA_TEN_KHACHHANG,
DIEM = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.SODIEM,
INFOTHUNGAN = "THU NGÂN: " + Session.Session.CurrentTenNhanVien,
MA_GIAODICH = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MA_GIAODICH,
THANHTIENCHU = TONGTIEN_BANGCHU,
TIENKHACHTRA = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIENKHACH_TRA,
TENCUAHANG = Session.Session.CurrentNameStore
};
frmBanTraLai.PrintInvoice_BanLeTraLai(infoBill, _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL);
}
catch
{
}
finally
{
this.handler(true);
this.Dispose();
frmBanTraLai.Dispose();
frmBanTraLai.Refresh();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
public ActionResult AddUpdateClients(int id, string name)
{
try
{
using (var dbcontext = new shreayaaSysEntities())
{
var client = dbcontext.Clients.Where(cli => cli.Id == id).FirstOrDefault();
if (client != null)
{
client.Name = name;
}
else
{
dbcontext.Clients.Add(new Client {
Id = id, Name = name
});
}
dbcontext.SaveChanges();
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Update
/// </summary>
/// <param name="update"></param>
/// <returns></returns>
public int update(CategoryModel update)
{
try
{
var model = db.Categories.Find(update.Id);
if (model != null)
{
model.Name = update.Name;
model.Slug = !string.IsNullOrEmpty(update.Slug) ? update.Slug : Utility.GetAlias(update.Name);
model.Parent = update.Parent;
model.OrderBy = update.OrderBy;
model.Visible = update.Visibled;
model.MetaTitle = update.MetaTitle;
model.MetaKeyword = update.MetaKeyWord;
model.MetaDescription = update.MetaDescription;
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
}
return(-1);
}
/// <summary>
/// Insert new category
/// </summary>
/// <param name="add"></param>
/// <returns></returns>
public int insert(CategoryModel add)
{
try
{
Category model = new Category();
model.Name = add.Name;
model.Slug = !string.IsNullOrEmpty(add.Slug) ? add.Slug : Utility.GetAlias(add.Name);
model.Parent = add.Parent;
model.Visible = add.Visibled;
model.OrderBy = add.OrderBy;
model.MetaTitle = add.MetaTitle;
model.MetaKeyword = add.MetaKeyWord;
model.MetaDescription = add.MetaDescription;
db.Categories.Add(model);
if (db.SaveChanges() > 0)
{
return(1);
}
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
return(0);
}
public async Task <IHttpActionResult> Delete(string id)
{
NvVatTuChungTu instance = await _service.Repository.FindAsync(id);
List <NvVatTuChungTuChiTiet> chitietinstance = _service.UnitOfWork.Repository <NvVatTuChungTuChiTiet>().DbSet.Where(o => o.MaChungTuPk == instance.MaChungTuPk).ToList();
if (instance == null)
{
return(NotFound());
}
try
{
if (_service.DeletePhieu(id))
{
_service.Delete(instance.Id);
_service.UnitOfWork.Save();
return(Ok(instance));
}
return(InternalServerError());
}
catch (Exception e)
{
WriteLogs.LogError(e);
return(InternalServerError());
}
}
private void SetBingImage()
{
if (Cache.GetCache("photourl") != null)
{
try
{
string path = AppDomain.CurrentDomain.BaseDirectory + "ImagesT\\Bing\\" + DateTime.Now.ToString("yyyyMMdd") + ".png";
if (!File.Exists(path))
{
AppHelper.Httpget_Img(Cache.GetCache("photourl").ToString(), "");
}
string tmp = Path.GetTempFileName();
File.Copy(path, tmp, true);
Image image = Image.FromFile(path);
this.pic_Box_Slide.Image = Image.FromFile(tmp);
image.Save(path + ".bmp", System.Drawing.Imaging.ImageFormat.Bmp);
WinAPI.SystemParametersInfo(20, 0, path + ".bmp", 0x2);
}
catch (Exception ex)
{
WriteLogs.WiteEx(ex);
}
}
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
TransferObj <PagedObj <NvCongNoVm.Dto> > result = new TransferObj <PagedObj <NvCongNoVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvCongNoVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvCongNoVm.Search> >();
PagedObj <NvCongNo> paged = ((JObject)postData.paged).ToObject <PagedObj <NvCongNo> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().LoaiChungTu),
Method = FilterMethod.EqualTo,
Value = filtered.AdvanceData.LoaiChungTu
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvCongNo().ICreateDate),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvCongNo> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvCongNo>, PagedObj <NvCongNoVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Status = false;
result.Message = e.Message.ToString();
return(Ok(result));
}
}
public static List <GIAODICH_DTO> TIMKIEM_GIAODICHQUAY(string KeySearch, DateTime TuNgay, DateTime DenNgay, int DieuKienLoc)
{
List <GIAODICH_DTO> listReturn = new List <GIAODICH_DTO>();
try
{
using (var connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
connection.OpenAsync();
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.InitialLONGFetchSize = 1000;
cmd.CommandText = "TIMKIEM_GIAODICHQUAY";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = KeySearch;
cmd.Parameters.Add("P_TUNGAY", OracleDbType.Date).Value = TuNgay;
cmd.Parameters.Add("P_DENNGAY", OracleDbType.Date).Value = DenNgay;
cmd.Parameters.Add("P_DIEUKIENLOC", OracleDbType.Int32).Value = DieuKienLoc;
cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = Session.Session.CurrentUnitCode;
cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = null;
dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
GIAODICH_DTO GDQUAY_DTO = new GIAODICH_DTO();
decimal TIENKHACH_TRA, TIENTHE, TIEN_TRALAI_KHACH, THANHTIEN = 0;
GDQUAY_DTO.MA_GIAODICH = dataReader["MA_GIAODICH"].ToString();
GDQUAY_DTO.LOAI_GIAODICH = dataReader["LOAI_GIAODICH"].ToString();
GDQUAY_DTO.I_CREATE_DATE = DateTime.Parse(dataReader["I_CREATE_DATE"].ToString());
GDQUAY_DTO.I_CREATE_BY = dataReader["I_CREATE_BY"].ToString();
GDQUAY_DTO.NGAY_GIAODICH = DateTime.Parse(dataReader["NGAY_GIAODICH"].ToString());
GDQUAY_DTO.MA_VOUCHER = dataReader["MA_VOUCHER"].ToString();
decimal.TryParse(dataReader["TIENKHACH_TRA"].ToString(), out TIENKHACH_TRA);
GDQUAY_DTO.TIENKHACH_TRA = TIENKHACH_TRA;
decimal.TryParse(dataReader["TIENTHE"].ToString(), out TIENTHE);
GDQUAY_DTO.TIENTHE = TIENTHE;
decimal.TryParse(dataReader["TIEN_TRALAI_KHACH"].ToString(), out TIEN_TRALAI_KHACH);
GDQUAY_DTO.TIEN_TRALAI_KHACH = TIEN_TRALAI_KHACH;
decimal.TryParse(dataReader["TIENTHE"].ToString(), out TIENTHE);
GDQUAY_DTO.TIENTHE = TIENTHE;
decimal.TryParse(dataReader["THANHTIEN"].ToString(), out THANHTIEN);
GDQUAY_DTO.THANHTIEN = THANHTIEN;
GDQUAY_DTO.THOIGIAN_TAO = dataReader["THOIGIAN_TAO"].ToString();
GDQUAY_DTO.MAKHACHHANG = dataReader["MAKHACHHANG"].ToString();
GDQUAY_DTO.UNITCODE = dataReader["UNITCODE"].ToString();
listReturn.Add(GDQUAY_DTO);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotification("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(listReturn);
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
var result = new TransferObj <PagedObj <NvPhieuDatHangNCCVm.Dto> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvPhieuDatHangNCCVm.Search> >();
filtered.OrderType = "DESC";
filtered.OrderBy = "Ngay";
var paged = ((JObject)postData.paged).ToObject <PagedObj <NvDatHang> >();
var unitCode = _service.GetCurrentUnitCode();
var query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().Loai),
Method = FilterMethod.EqualTo,
Value = (int)LoaiDatHang.NHACUNGCAP
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().SoPhieuCon),
Method = FilterMethod.Null,
}
},
Method = FilterMethod.And
},
};
try
{
var filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvDatHang>, PagedObj <NvPhieuDatHangNCCVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
return(InternalServerError());
}
}
protected void Application_Error(Object sender, EventArgs e)
{
Exception ex = Server.GetLastError();
if (ex is ThreadAbortException)
{
return;
}
WriteLogs.LogError(ex);
}
public static string LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(string MAKHACHHANG)
{
string RESULT = "";
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT CONCAT (DM_KHACHHANG.MAKH,' - ',DM_KHACHHANG.TENKH) AS KHACHHANG FROM dbo.DM_KHACHHANG WHERE DM_KHACHHANG.MAKH = '" + MAKHACHHANG + "'";
cmd.CommandType = CommandType.Text;
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["KHACHHANG"] != null)
{
RESULT = dataReader["KHACHHANG"].ToString();
}
else
{
RESULT = "";
}
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
public static string LAY_MA_TEN_KHACHHANG_FROM_ORACLE(string MAKHACHHANG)
{
string RESULT = "";
try
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT MAKHACHHANG || ' - ' || TENKHACHHANG AS KHACHHANG FROM KHACHHANG WHERE MAKHACHHANG = '" + MAKHACHHANG + "'";
cmd.CommandType = CommandType.Text;
OracleDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["KHACHHANG"] != null)
{
RESULT = dataReader["KHACHHANG"].ToString();
}
else
{
RESULT = "";
}
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
/// <summary>
/// Get Product by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Product GetByID(int id)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Find(id));
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
public ActionResult GetNewsList()
{
try
{
NewsDAL obj = new NewsDAL();
return(Json(new { result = "success", list = obj.GetNewsList(), JsonRequestBehavior.AllowGet }));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public List <Member> GetList(int userID)
{
try
{
db = new THN_WebApplicationEntities();
var lst = db.Members.Where(m => m.UserID == userID).ToList();
return(lst != null ? lst : null);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get Product by product name
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Product> GetByName(string name)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Where(p => p.Name.Contains(name)).OrderBy(p => p.OrderBy).ToList());
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
public ActionResult Offers(int?id)
{
try
{
var model = Tuple.Create(GetAnOfferDetails(id));
return(View(model));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(View());
}
}
public static AppSetting GetSingle()
{
try
{
THN_WebApplicationEntities db = new THN_WebApplicationEntities();
var model = db.AppSettings.Take(1).FirstOrDefault();
return(model);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get Product by category id
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public List <Product> GetByCategoryID(int categoryId)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Where(p => p.CategoryID == categoryId).OrderBy(p => p.OrderBy).ToList());
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
public ActionResult AddUpdateNews(DAL.News n)
{
try
{
NewsDAL obj = new NewsDAL();
int newsId = 0;
obj.AddUpdate(n, out newsId);
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fileExt = file.FileName.Split('.').LastOrDefault();
string attachmentFolder = "doc";
if (fileExt == "jpg" || fileExt == "jpeg" || fileExt == "png")
{
attachmentFolder = "Images";
}
else
{
attachmentFolder = "Attachments";
}
string path = Server.MapPath("~/Files/News/" + attachmentFolder + "/" + newsId);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(path + "\\" + InputFileName);
//Save file to server folder
int count = 1;
checkIfFileExists:
if (System.IO.File.Exists(ServerSavePath))
{
ServerSavePath = Path.Combine(path + "\\" + InputFileName.Substring(0, InputFileName.LastIndexOf('.')) + count++ + InputFileName.Substring(InputFileName.IndexOf('.')));
goto checkIfFileExists;
}
else
{
file.SaveAs(ServerSavePath);
}
}
return(Json(new { result = "success", images = GetEventPhotos(newsId), newsId = newsId }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddUpdateStaff(StaffDetails s, string image)
{
try
{
int staffId = 0;
var data = staffDALObj.AddUpdate(s, ref staffId);
JsonSerializer j = new JsonSerializer();
string newImage = Server.MapPath("~/images/staff/" + staffId + ".jpg");
if (System.IO.File.Exists(newImage))
{
System.IO.File.Delete(newImage);
}
if (image.Contains("data:image/png;base64") || image.Contains("data:image/jpg;base64") || image.Contains("data:image/jpeg;base64"))
{
string x = string.Empty;
if (image.Contains("data:image/png;base64,"))
{
x = image.Replace("data:image/png;base64,", "");
}
else if (image.Contains("data:image/jpg;base64,"))
{
x = image.Replace("data:image/jpg;base64,", "");
}
else
{
x = image.Replace("data:image/jpeg;base64,", "");
}
// Convert Base64 String to byte[]
byte[] imageBytes = Convert.FromBase64String(x);
MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
// Convert byte[] to Image
ms.Write(imageBytes, 0, imageBytes.Length);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms, true);
img.Save(Server.MapPath("~/images/staff/" + staffId + ".jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);
}
else
{
System.IO.File.Copy(Server.MapPath("~/images/no-image.jpg"), Server.MapPath("~/images/staff/" + staffId + ".jpg"));
}
return(Json(new { result = "success", staffId = staffId }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
