public ActionResult PartialDetail(string id)
{
if (userAsset.ContainsKey("View") && userAsset["View"])
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var dict = new Dictionary <string, object>();
dict["asset"] = userAsset;
dict["listWH"] = dbConn.Select <WareHouse>(p => p.Status == true);
dict["listWHL"] = dbConn.Select <WareHouseLocation>(p => p.Status == true);
dict["listVendor"] = dbConn.Select <Vendor>(p => p.Status == true);
dict["listWH"] = dbConn.Select <WareHouse>(p => p.Status == true);
dict["listWHL"] = dbConn.Select <WareHouseLocation>(p => p.Status == true);
dict["listUnit"] = dbConn.Select <INUnit>(p => p.Status == true);
dict["SONumber"] = id;
dict["activestatus"] = new CommonLib().GetActiveStatus();
dbConn.Close();
if (string.IsNullOrEmpty(id))
{
return(PartialView("_OP_CreateOrderIndex", dict));
}
else
{
return(PartialView("_OP_CreateOrder", dict));
}
}
else
{
return(RedirectToAction("NoAccess", "Error"));
}
}
public ActionResult Index()
{
//using (IDbConnection dbConn = OrmliteConnection.openConn())
//{
// OrmLiteConfig.DialectProvider.UseUnicode = true;
// dbConn.DropTables(typeof(Deca_SMS_Template));
// const bool overwrite = false;
// dbConn.CreateTables(overwrite, typeof(Deca_SMS_Template));
//}
if (asset.View)
{
ViewData["AllowCreate"] = asset.Create;
ViewData["AllowUpdate"] = asset.Update;
ViewData["AllowDelete"] = asset.Delete;
ViewData["AllowExport"] = asset.Export;
ViewBag.AllowView = true;
using (var dbConn = OrmliteConnection.openConn())
{
ViewBag.listUser = dbConn.Select <Users>();
ViewBag.listGroup = dbConn.Select <Groups>();
}
return(View());
}
else
{
ViewBag.AllowView = false;
return(RedirectToAction("NoAccessRights", "Error"));
}
}
//public string ChangeStatus(string[] ids, string connectionString, string Username, string status)
//{
// using (var db = new OrmliteConnection().openConn(connectionString))
// {
// try
// {
// foreach (var id in ids)
// {
// var checkID = db.SingleOrDefault<Merchant_Voucher>("id={0}", id);
// if (checkID != null)
// {
// checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG;
// checkID.nguoi_cap_nhat = Username;
// checkID.ngay_cap_nhat = DateTime.Now;
// db.UpdateOnly(checkID,
// onlyFields: p =>
// new
// {
// p.trang_thai,
// p.nguoi_cap_nhat,
// p.ngay_cap_nhat
// },
// where: p => p.id == checkID.id);
// }
// }
// return "true";
// }
// catch (Exception e)
// {
// return e.Message.ToString();
// }
// }
//}
public string Delete(string[] ids, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (var id in ids)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@id", id));
new SqlHelper().ExecuteNoneQuery("delete Merchant_Voucher where id = @id", param, CommandType.Text);
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public int Delete(string[] ids, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (var id in ids)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@id", id));
new SqlHelper().ExecuteNoneQuery("delete Product_Evaluation where id = @id", param, CommandType.Text);
}
dbTrans.Commit();
return(1);
}
catch
{
dbTrans.Rollback();
return(0);
}
}
}
}
public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Models.Master_Calendar> lst)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
foreach (var item in lst)
{
if (userAsset.ContainsKey("Update") && userAsset["Update"] && dbConn.GetByIdOrDefault <Master_Calendar>(item.Date) != null)
{
if (string.IsNullOrEmpty(item.Holiday))
{
item.Holiday = "";
}
item.RowUpdatedAt = DateTime.Now;
item.RowUpdatedBy = currentUser.UserID;
dbConn.Update <Master_Calendar>(item);
}
else
{
return(Json(new { success = false, message = "You don't have permission" }));
}
}
return(Json(new { success = true }));
}
catch (Exception ex)
{
log.Error("AdminMasterHoliday - Create - " + ex.Message);
return(Json(new { success = false, message = ex.Message }));
}
finally
{
dbConn.Close();
}
}
private Image AutoResize(Image img, string type)
{
using (IDbConnection db = OrmliteConnection.openConn())
{
var x = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "IMGAutoResize").OrderBy(s => s.ParamID);
int width = 0, height = 0;
foreach (BIBIAM.Core.Entities.Parameters item in x)
{
if (item.ParamID == type + "_WIDTH")
{
width = Int16.Parse(item.Value);
}
if (item.ParamID == type + "_HEIGHT")
{
height = Int16.Parse(item.Value);
}
}
if (width * height != 0)
{
return(ResizeImage(img, width, height));
}
else
{
return(null);
}
}
}
public ActionResult Create(int Id = 0)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
ViewBag.listContractTerms = dbConn.Select <Parameters>("Type ={0}", "ContractDraffType").OrderBy(s => s.ParamID);
if (Id != 0)
{
ViewBag.rowItem = dbConn.SingleOrDefault <CRM_Contract_Extra>("RowID= {0}", Id);
if (asset.Update)
{
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
else
{
if (asset.Create)
{
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
}
}
public static bool CheckScheduleBooking(string action, long id, string type, string website, string category, string location, DateTime dateup, int hour)
{
using (var dbConn = OrmliteConnection.openConn())
{
if (action == "update")
{
var bookBao = dbConn.SingleOrDefault <CRM_BookPRLocation>("Website = {0} AND Category = {1} AND Location = {2} AND NgayLen = {3} AND GioLen = {4} AND Type = {5} AND ID <> {6}", website, category, location, dateup, hour, type, id);
if (bookBao != null)
{
return(false);
}
}
else
{
var bookBao = dbConn.SingleOrDefault <CRM_BookPRLocation>("Website = {0} AND Category = {1} AND Location = {2} AND NgayLen = {3} AND GioLen = {4} AND Type = {5} ", website, category, location, dateup, hour, type);
if (bookBao != null)
{
return(false);
}
}
return(true);
}
}
public ActionResult AddUserToGroup(int id, string data)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
// Delete All User in Role
db.Delete <Auth_UserInRole>(p => p.RoleID == id);
// Add User Role
if (!string.IsNullOrEmpty(data))
{
string[] arr = data.Split(',');
foreach (string item in arr)
{
var detail = new Auth_UserInRole();
detail.UserID = item;
detail.RoleID = id;
detail.RowCreatedAt = DateTime.Now;
detail.RowCreatedBy = currentUser.UserID;
db.Insert <Auth_UserInRole>(detail);
}
}
return(Json(new { success = true }));
}
catch (Exception e) { return(Json(new { success = false, message = e.Message })); }
finally { db.Close(); }
}
public ActionResult BookNew()
{
using (var dbConn = OrmliteConnection.openConn())
{
ViewData["AllowCreate"] = asset.Create;
ViewData["AllowUpdate"] = asset.Update;
ViewData["AllowDelete"] = asset.Delete;
ViewData["AllowExport"] = asset.Export;
ViewBag.listStaff = dbConn.Select <DropDownListData>("select RefStaffId AS Code,FullName AS Name from EmployeeInfo");
ViewBag.listWebsite = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 20");
ViewBag.listCategory = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 22");
ViewBag.listLocation = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 23");
ViewBag.listNature = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 25");
ViewBag.listTeam = dbConn.Select <DropDownListData>("select TeamID AS Code ,TeamName AS Name from CRM_Team where FKUnit = 13");
ViewBag.listRegion = dbConn.Select <DropDownListData>("select Code,Name from ERPAPD_List WHERE FKListtype = 52 ");
ViewBag.listPosition = dbConn.Select <DropDownListData>("select PKList AS Code, Name from ERPAPD_List WHERE FKListtype = 5");
var bookcode = dbConn.SingleOrDefault <Parameters>("Type = 'BookLocation'");
if (bookcode != null)
{
var bk = int.Parse(bookcode.Value) + 1;
string b = "B." + String.Format("{0:000000}", bk);
bookcode.Value = bk.ToString();
ViewBag.BookCode = b;
dbConn.Update(bookcode);
}
}
return(View());
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
string sqlQuery = @"SELECT req.*
,SUBSTRING(c_code,3, 10) AS BookCode
,ISNULL(l.PKBookLocation,0) AS PKBookLocation
,ISNULL(l.FKBookReq,'') AS FKBookReq
,ISNULL(l.Website,'') AS Website
,ISNULL(l.Category,'') AS Category
,ISNULL(l.Location,'') AS Location
,ISNULL(l.Nature,'') AS Nature
,ISNULL(l.NgayLen,'') AS NgayLen
,ISNULL(l.NgayXuong ,'') AS NgayXuong
,ISNULL(l.InputDate,'') AS InputDate
,ISNULL(l.AccountStatus,'') AS AccountStatus
,ISNULL(cus.CustomerName,'') AS CustomerName
FROM CRM_Book_Req req
INNER JOIN CRM_Book_Location l on l.FKBookReq = req.pk_book_req
LEFT JOIN ERPAPD_Customer cus on cus.CustomerCode = req.c_customer_code
";
return(Json(KendoApplyFilter.KendoDataByQuery <BookBannerViewModel>(request, sqlQuery, "")));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
//Result by Customer block
public PartialViewResult PartialResultByCustomer(string ManagementID)
{
using (var dbConn = OrmliteConnection.openConn())
{
//tra ra danh sach header.
List <ExpandoObject> result = new List <ExpandoObject>();
//2 cot dau tien
dynamic Ngaylam = new ExpandoObject();
Ngaylam.Name = "CreatedAt";
Ngaylam.Title = "Ngày làm";
result.Add(Ngaylam);
dynamic khach = new ExpandoObject();
khach.Name = "CustomerInfo";
khach.Title = "Thông tin khách hàng";
result.Add(khach);
//lay danh sach cau hoi, bind thanh header.
string query = @"SELECT mq.Id, q.QuestionID, q.[Description] FROM CRM_Survey_Management_Question mq
LEFT JOIN CRM_Survey_Question q
ON mq.QuestionID = q.QuestionID
WHERE mq.SurveyManagementID = " + ManagementID + " ORDER BY mq.SortOrder";
var listQuestion = dbConn.Select <CRM_Survey_Management_Question>(query);
foreach (var question in listQuestion)
{
dynamic dynamicQuestion = new ExpandoObject();
dynamicQuestion.Name = question.QuestionID;
dynamicQuestion.Title = question.Description;
result.Add(dynamicQuestion);
}
return(PartialView("_GridResultByCustomer", result));
}
}
public JsonResult GetDistrict(string CityID)
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <DC_OCM_Territory>("[Level] = {0} AND [ParentID] = {1}", "District", CityID).OrderBy(a => a.TerritoryName), JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCity()
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <DC_OCM_Territory>("[Level] = {0}", "Province").OrderBy(a => a.TerritoryName), JsonRequestBehavior.AllowGet));
}
}
public List <Menu> GetSubMenu(int ID)
{
using (var dbconn = new OrmliteConnection().openConn())
{
return(dbconn.Select <Menu>(m => m.ParentID == ID && m.Status == true));
}
}
//public JsonResult GetMenu([DataSourceRequest] DataSourceRequest request)
//{
// IDbConnection db = new OrmliteConnection().openConn();
// try
// {
// var listMenu = db.Select<Auth_Menu>(p => p.IsVisible == true).OrderBy(p => p.MenuIndex).ToList();
// DataSourceResult dsr = new DataSourceResult();
// dsr.Data = listMenu;
// return Json(dsr, JsonRequestBehavior.AllowGet);
// }
// catch (Exception e)
// {
// return Json(new { success = false, message = e.Message });
// }
// finally { db.Close(); }
//}
//[HttpPost]
public JsonResult GetMenu(string action, int roleID)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
//select list menu cha
List <Auth_Menu> lstFirstMenu = db.Select <Auth_Menu>("IsVisible = 1 AND ParentMenuID ='' AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList();
List <Auth_Menu> allAuthMenu = db.Select <Auth_Menu>("IsVisible = 1 AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList();
var listAction = new List <Auth_Menu>();
if (!string.IsNullOrEmpty(action))
{
listAction = db.SqlList <Auth_Menu>("p_Auth_Menu_Select_By_Action '" + action + "', " + roleID);
}
List <AuthMenuViewModel> lstMenuView = new List <AuthMenuViewModel>();
foreach (Auth_Menu der in lstFirstMenu)
{
AuthMenuViewModel node = new AuthMenuViewModel();
node.id = der.MenuID;
node.text = der.MenuName;
node.items = new List <AuthMenuViewModel>();
AddChidrenNode(ref node, allAuthMenu, listAction);
lstMenuView.Add(node);
}
return(Json(new { success = true, Data = lstMenuView }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { db.Close(); }
}
public ActionResult Deactive(string data)
{
if (userAsset.ContainsKey("Delete") && userAsset["Delete"])
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
var newdata = data.Split(',');
foreach (string id in newdata)
{
dbConn.Delete <Master_Announcement>(p => p.AnnouncementID == Convert.ToInt32(id));
}
return(Json(new { success = true, }));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
finally
{
dbConn.Close();
}
}
else
{
return(Json(new { success = false, message = "You don't have permission" }));
}
}
public ActionResult SavePermission(int RoleID, string Action, string MenuIDs)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (RoleID == 0 || string.IsNullOrEmpty(Action))
{
return(Json(new { success = false, message = "Có dữ liệu rỗng" }));
}
if (string.IsNullOrEmpty(MenuIDs))
{
db.UpdateOnly(new Auth_Action()
{
IsAllowed = false, RowUpdatedAt = DateTime.Now, RowUpdatedBy = currentUser.UserID
},
onlyFields: p => new { p.IsAllowed, p.RowUpdatedAt, p.RowUpdatedBy },
where : p => p.RoleID == RoleID && p.Action == Action);
}
else
{
db.ExecuteNonQuery("p_Auth_Action_Save_By_RoleID @RoleID, @UserID, @Action, @MenuIDs", new
{
RoleID = RoleID,
UserID = currentUser.UserID,
Action = Action,
MenuIDs = MenuIDs
});
}
return(Json(new { success = true }));
}
catch (Exception e) { return(Json(new { success = false, message = e.Message })); }
finally { db.Close(); }
}
public ActionResult GetListCurrency([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <ti_gia_tien_te>().OrderBy(a => a.ID), JsonRequestBehavior.AllowGet));
}
}
public string ChangeStatus(string[] ids, string connectionString, string Username, string status)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
foreach (var id in ids)
{
var checkID = db.SingleOrDefault <Merchant_Warehouse>("id={0}", id);
if (checkID != null)
{
checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG;
checkID.nguoi_cap_nhat = Username;
checkID.ngay_cap_nhat = DateTime.Now;
db.UpdateOnly(checkID,
onlyFields: p =>
new
{
p.trang_thai,
p.nguoi_cap_nhat,
p.ngay_cap_nhat
},
where : p => p.id == checkID.id);
}
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request, string ma_gian_hang = "")
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["view"]))
{
using (IDbConnection db = OrmliteConnection.openConn(AppConfigs.MCCConnectionString))
{
var data = new DataSourceResult();
if (!isAdmin)
{
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request, "ma_gian_hang={0}".Params(currentUser.ma_gian_hang));
//return Json(db.Select<Merchant_Catalog>(s => s.ma_gian_hang == currentUser.ma_gian_hang).ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
else
{
if (!string.IsNullOrEmpty(ma_gian_hang.Trim()))
{
//return Json(db.Select<Merchant_Catalog>(s => s.ma_gian_hang == ma_gian_hang).ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request, " ma_gian_hang={0}".Params(currentUser.ma_gian_hang));
}
else
{
//return Json(db.Select<Merchant_Catalog>().ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request);
}
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult GetListReason()
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <Deca_Code_Master>("CodeType={0}", "CancelOrderReason"), JsonRequestBehavior.AllowGet));
}
}
public void UpSert(List <Product_Evaluation> lstProductEvaluation, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Product_Evaluation row in lstProductEvaluation)
{
if (Type == "Insert")
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Save(row);
}
else
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
db.Update(row);
}
}
dbTrans.Commit();
}
catch
{
dbTrans.Rollback();
}
}
}
}
public string Create(List <Merchant_Product_Image> list, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
if (list == null)
{
dbTrans.Rollback();
return("No Data");
}
db.Delete <Merchant_Product_Image>("ma_san_pham = {0} and ma_gian_hang = {1}", list.ElementAt(0).ma_san_pham, list.ElementAt(0).ma_gian_hang);
foreach (Merchant_Product_Image item in list)
{
item.ngay_tao = DateTime.Now;
item.nguoi_tao = UserName;
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public ActionResult Update(string ma_gian_hang, string data)
{
using (IDbConnection db = OrmliteConnection.openConn())
{
if (asset.Create || asset.Update)
{
try
{
new Merchant_Image_DAO().DeleteForCode(ma_gian_hang);
string[] separators = { "@@" };
var listdata = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in listdata)
{
new Merchant_Image_DAO().Insert(ma_gian_hang, item, currentUser.UserName);
}
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(RedirectToAction("NoAccess", "Error"));
//return Json(new { success = false, message = e.Message });
}
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền." }));
}
}
}
public ActionResult Index()
{
if (asset.View)
{
ViewBag.Create = asset.Create;
ViewBag.Update = asset.Update;
ViewBag.Delete = asset.Delete;
ViewBag.Export = asset.Export;
ViewBag.listWebsite = CRM_Website.GetList();
using (IDbConnection db = OrmliteConnection.openConn())
{
//ViewBag.listAll = db.Select<Hierarchy>();
ViewBag.listAll = db.Select <DropListDown>("Select ma_phan_cap as Value , ten_phan_cap as Text from Hierarchy");
ViewBag.listStatus = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "HierarchyStatus").OrderBy(s => s.ID);
ViewBag.listHierarchyType = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "HierarchyType").OrderBy(s => s.ID);
}
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public string UpSert(List <Product_Hierarchy_Property> lstProductHierarchyProperty, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Product_Hierarchy_Property row in lstProductHierarchyProperty)
{
if (Type == "Insert")
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Insert(row);
}
else
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
db.Update(row);
}
}
dbTrans.Commit();
return("true");
}
catch (Exception ex)
{
dbTrans.Rollback();
return(ex.Message);
}
}
}
}
public List <Menu> GetAll()
{
using (var dbconn = new OrmliteConnection().openConn())
{
return(dbconn.Select <Menu>());
}
}
public ActionResult UpdateActiveStatus(int entryid, bool isactive)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
var isExist = AuthUser.GetById(entryid, null, false);
isExist.isactive = isactive;
isExist.updatedby = currentUser.entryid;
isExist.updatedat = DateTime.Now;
db.UpdateOnly(isExist,
onlyFields: p =>
new
{
p.isactive,
p.updatedat,
p.updatedby
},
where : p => p.entryid == entryid);
return(Json(new { success = true }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { db.Close(); }
}
//public ActionResult ReadDetail([DataSourceRequest] DataSourceRequest request, string SONumber)
//{
// log4net.Config.XmlConfigurator.Configure();
// string whereCondition = "";
// if (request.Filters.Count > 0)
// {
// whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]);
// }
// var data = new DC_AD_SO_Detail().GetPage(request, whereCondition, SONumber);
// return Json(data);
//}
public ActionResult Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Products> list, string SONumber)
{
var dbConn = new OrmliteConnection().openConn();
try
{
if (list != null && ModelState.IsValid)
{
foreach (var item in list)
{
if (item.Qty > 0)
{
//string SONumber = Request["SONumber"];
var header = new SOHeader();
var detail = new SODetail();
if (dbConn.Select <SODetail>(s => s.SONumber == SONumber && s.ItemCode == item.Code).Count() > 0)
{
dbConn.Update <SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "'", where : "SONumber = '" + SONumber + "'");
}
else
{
var data = new SODetail();
data.ItemName = item.Name;
data.ItemCode = item.Code;
data.Note = "";
data.Price = item.VATPrice;
data.Qty = item.Qty;
data.SONumber = SONumber;
data.UnitID = item.Unit;
data.UnitName = dbConn.Select <INUnit>(s => s.UnitID == item.Unit).FirstOrDefault().UnitName;
data.TotalAmt = item.Qty * item.VATPrice;
data.Status = "";
data.CreatedAt = DateTime.Now;
data.CreatedBy = currentUser.UserID;
//data.UpdatedAt = DateTime.Parse("1900-01-01");
data.UpdatedAt = DateTime.Now;
data.UpdatedBy = "";
dbConn.Insert <SODetail>(data);
}
dbConn.Update <SOHeader>(set: "TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + +dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + SONumber + "'");
}
else
{
dbConn.Delete <SOHeader>(s => s.SONumber == SONumber);
ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0");
return(Json(list.ToDataSourceResult(request, ModelState)));
}
}
}
dbConn.Close();
}
catch (Exception e)
{
dbConn.Close();
ModelState.AddModelError("error", e.Message);
return(Json(list.ToDataSourceResult(request, ModelState)));
}
return(Json(new { sussess = true }));
}
