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