public ActionResult Location_Search(string p_keysearch, int p_CurrentPage)
{
try
{
decimal _total_record = 0;
string p_to = "";
string p_from = CommonFuc.Get_From_To_Page(p_CurrentPage, ref p_to);
if (p_keysearch == "" || p_keysearch == null)
{
p_keysearch = "ALL";
}
LocationBL _bl = new LocationBL();
List <LocationInfo> _lst = _bl.Location_Search(p_keysearch, ref _total_record, p_from, p_to);
string htmlPaging = NaviCommon.CommonFuc.Get_HtmlPaging <LocationInfo>((int)_total_record, p_CurrentPage, "tỉnh/ thành");
ViewBag.Paging = htmlPaging;
ViewBag.List = _lst;
ViewBag.SumRecord = _total_record;
return(PartialView("~/Areas/ModuleBaseData/Views/Location/_Partial_ListLocation.cshtml"));
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(PartialView("~/Areas/ModuleBaseData/Views/Location/_Partial_ListLocation.cshtml"));
}
}
public ManagerMenu(LocationBL locationBL, OrderBL orderBL, InventoryBL inventoryBL, CustomerBL customerBL)
{
this.locationBL = locationBL;
this.orderBL = orderBL;
this.inventoryBL = inventoryBL;
this.customerBL = customerBL;
}
public InventoryMenu(LocationBL locBL, ProductBL prodBL, OrderBL orderBL, CustomerBL customerBL)
{
_locBL = locBL;
_prodBL = prodBL;
_orderBL = orderBL;
_customerBL = customerBL;
}
public ActionResult Index()
{
LocationBL LocationBL = new LocationBL();
LocationBL.EmailID = User.Identity.Name;
return(View("Index", "_HomeLayout", LoginViewModel));
}
private void SAVEButton_Click(object sender, EventArgs e)
{
Location aLocation = new Location();
aLocation.LocationName = locationNameTextBox.Text;
aLocation.Details = detailsTextBox.Text;
// aBus.NoOfSeat = int.Parse(noOfSeatTextBox.Text);
LocationBL locationBLOBj = new LocationBL();
bool result = locationBLOBj.SaveNewLocationBL(aLocation);
if (result)
{
MessageBox.Show("Succesfuly added new Location!", "Done!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.PopulateGridView();
IntitialButtonMood();
CleanTextBar();
}
else
{
DialogResult dialog = MessageBox.Show("Please fill all the text", "ERROR", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
if (dialog == DialogResult.Cancel)
{
this.Close();
}
}
}
public CustomerMenu(CustomerBL customerBL, OrderBL newOrder, LocationBL locationBL)
{
_customerBL = customerBL;
_orderBL = newOrder;
_locationBL = locationBL;
_inputValidation = new InputValidation();
}
public ManagerMenu(LocationBL locationbl, CustomerBL customerBL, OrderBL orderBL)
{
_locationBL = locationbl;
_customerBL = customerBL;
_orderBL = orderBL;
_inputValidation = new InputValidation();
}
public Decimal Import_file_excel(HttpPostedFileBase fileImport)
{
try
{
DataSet _ds = new DataSet();
if (fileImport != null && fileImport.ContentLength > 0)
{
if (!fileImport.FileName.EndsWith(".xls") && !fileImport.FileName.EndsWith(".xlsx"))
{
return(-3);
}
else
{
Stream stream = fileImport.InputStream;
IExcelDataReader reader = null;
if (fileImport.FileName.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (fileImport.FileName.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
_ds = reader.AsDataSet();
reader.Close();
}
}
if (_ds != null)
{
_ds.Tables[0].Rows[0].Delete();//xóa dòng title
_ds.AcceptChanges();
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _ds.Tables[0].Rows)
{
LocationInfo obj_info = new LocationInfo();
obj_info.Parent_Name = dr[0] == null ? "" : dr[0].ToString();
obj_info.Parent_Id = dr[1] == null ? 0 : decimal.Parse(dr[1].ToString());
obj_info.Name = dr[2] == null ? "" : dr[2].ToString();
obj_info.Code = dr[3] == null ? "" : dr[3].ToString();
LocationBL obj_bl = new LocationBL();
obj_bl.Location_Insert(obj_info);
}
}
else
{
return(-4);//không có dữ liệu
}
}
return(1);
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
return(-1);
}
}
private void PopulateGridView()
{
DataTable dt = new DataTable();
LocationBL locationBLOBj = new LocationBL();
dt = locationBLOBj.GetExistingdBusBL();
locationDataGridView.DataSource = dt;
}
void PoupulateLocationGrid()
{
LocationBL locationTypeBL = new LocationBL();
List <Location> lstLocation = locationTypeBL.GetLocation();
if (lstLocation != null)
{
dgvLocation.DataSource = lstLocation;
}
}
public JsonResult Approve(int id)
{
var response = new ResponseModel();
var locationBL = new LocationBL();
locationBL.Appove(id);
response.Code = SystemStatusCode.Success.GetHashCode();
response.Message = "Bạn đã duyệt thông tin địa điểm thành công !";
return(Json(response, JsonRequestBehavior.AllowGet));
}
public static IMenu GetMenu(string menuType)
{
//configure
var configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
//connect
string connectionString = configuration.GetConnectionString("StoreAppDB");
//Console.WriteLine(connectionString);
//option
DbContextOptions <StoreAppDBContext> options = new DbContextOptionsBuilder <StoreAppDBContext>()
.UseSqlServer(connectionString)
.Options;
//context
var context = new StoreAppDBContext(options);
IRepository repo = new RepoDB(context);
IValidationService inputValidation = new ValidationService();
ICustomerBL customerBL = new CustomerBL(repo);
ILocationBL locationBL = new LocationBL(repo);
IProductBL productBL = new ProductBL(repo);
IInventoryBL inventoryBL = new InventoryBL(repo);
IOrderBL orderBL = new OrderBL(repo);
switch (menuType.ToLower())
{
case "main":
return(new MainMenu());
case "branch":
return(new BranchMenu(locationBL, inputValidation));
case "product":
return(new ProductMenu(productBL, inputValidation));
case "inventory":
return(new InventoryMenu(locationBL, productBL, inventoryBL, orderBL, inputValidation));
case "customer":
return(new CustomerMenu(customerBL));
case "order":
return(new OrderMenu(customerBL, locationBL, productBL, inventoryBL, orderBL, inputValidation));
default:
return(null);
}
}
public ActionResult StoreInfoEdit(string storeDetail, string type)
{
dynamic storeData = JsonConvert.DeserializeObject(storeDetail);
var location = AppHelper.LocationMapFormJson(storeData, type);
var updatedLocation = LocationBL.Update(location, type);
updatedLocation = LocationBL.ApplyTimeFormat(updatedLocation, TimeFormat.Hours12);
return(PartialView("_StoreDetail", updatedLocation));
// return null;
}
//Drink drink = new Drink();
public void Start()
{
bool startMenu = true;
do
{
Console.WriteLine("Welcome to Dozen! Are you a manager or a customer?");
Console.WriteLine("[0] Customer Menu");
Console.WriteLine("[1] Manager");
Console.WriteLine("[2] Exit");
//get user input
Console.WriteLine("Enter a number: ");
string userInput = Console.ReadLine();
var drinkrepo = new DrinkRepositoryDB();
var mapper = new Mapper();
var customerRepo = new CustomerRepoDB(context, mapper);
var customerBL = new CustomerBL(customerRepo);
var locationRepo = new LocationRepositoryDB(context, mapper);
var locationBL = new LocationBL(locationRepo);
var orderRepoDB = new OrderRepositoryDB(context, mapper);
var orderBL = new OrderBL(orderRepoDB);
var inventoryRepoDB = new InventoryRepoDB(context, mapper);
var inventoryBL = new InventoryBL(inventoryRepoDB);
var drinkBL = new DrinkBL(drinkrepo);
switch (userInput)
{
case "0":
CustomerMenu customerMenu = new CustomerMenu(drinkBL, customerBL, locationBL, orderBL, inventoryBL);
customerMenu.Start();
break;
case "1":
ManagerMenu managerMenu = new ManagerMenu(locationBL, orderBL, inventoryBL, customerBL);
managerMenu.Start();
break;
case "2":
startMenu = false;
break;
default:
Console.WriteLine("Invalid input! Try again");
break;
}
} while (startMenu);
}
// GET: ModuleBaseData/Location
public ActionResult LocationDisplay()
{
List <LocationInfo> list = new List <LocationInfo>();
try
{
LocationBL _bl = new LocationBL();
decimal _total_record = 0;
list = _bl.Location_Search("ALL", ref _total_record);
string htmlPaging = NaviCommon.CommonFuc.Get_HtmlPaging <LocationInfo>((int)_total_record, 1, "tỉnh/ huyện");
ViewBag.Paging = htmlPaging;
ViewBag.List = list;
ViewBag.SumRecord = _total_record;
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
}
return(View("~/Areas/ModuleBaseData/Views/Location/LocationDisplay.cshtml"));
}
public JsonResult Get(int?page, int?limit, string sortBy, string direction, string name, string state, string areaManager)
{
int total;
var predicate = PredicateBuilder.True <LocationModel>();
if (!string.IsNullOrWhiteSpace(name))
{
predicate = predicate.And(q => q.Name.Contains(name));
}
if (!string.IsNullOrWhiteSpace(state))
{
predicate = predicate.And(q => q.PhysicalAddress.State != null && q.PhysicalAddress.State.Contains(state));
}
if (!string.IsNullOrWhiteSpace(areaManager))
{
predicate = predicate.And(q => q.Email != null && q.Email.Contains(areaManager));
}
List <LocationModel> records = null;
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = LocationBL.GetAll().AsQueryable().Where(predicate).OrderBy(o => o.Id).Skip(start).Take(limit.Value).ToList();
}
else
{
records = LocationBL.GetAll().AsQueryable().Where(predicate).OrderBy(o => o.Id).ToList();
}
total = LocationBL.GetAll().AsQueryable().Where(predicate).Count();
return(this.Json(new { records, total }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
AppModel appModel = new AppModel()
{
AreaManagers = new List <string>(), States = new List <string>()
};
try
{
appModel.StoreDetails = LocationBL.GetAll();
if (appModel.StoreDetails != null)
{
appModel.States = appModel.StoreDetails.Select(o => o.PhysicalAddress.State).Distinct().ToList();
//TODO
//Area Manager mapped with AdminEmail
appModel.AreaManagers = appModel.StoreDetails.Select(o => o.Email).Distinct().ToList();
}
}
catch (Exception ex)
{
}
return(View(appModel));
}
private void deleteButton_Click_1(object sender, EventArgs e)
{
Location aLocation = new Location();
aLocation.LocationName = locationNameTextBox.Text;
aLocation.Details = detailsTextBox.Text;
// aBus.NoOfSeat = int.Parse(noOfSeatTextBox.Text);
LocationBL locationBLOBj = new LocationBL();
bool result = locationBLOBj.DeleteALocationBL(aLocation);
if (result)
{
MessageBox.Show("Succesfuly Deleted", "Done!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.PopulateGridView();
IntitialButtonMood();
CleanTextBar();
}
else
{
MessageBox.Show("Something wrong!", "Aleart", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <EKATTE> GetAllEKATTEs()
{
List <EKATTE> list = new LocationBL().GetAllEKATTEs();
return(list);
}
public CallContext LocationSave(Location entity, CallContext resultContext)
{
CallContext resContext = new LocationBL().EntitySave <Location>(entity, resultContext);
return(resContext);
}
public LocationView GetLocationViewById(string entityID)
{
LocationView locationView = new LocationBL().GetLocationViewById(Int32.Parse(entityID));
return(locationView);
}
public List <LocationView> GetLocationViewsByMunicipalityId(string municipalityID)
{
List <LocationView> list = new LocationBL().GetLocationViewsByMunicipalityId(Int32.Parse(municipalityID));
return(list);
}
public List <LocationView> GetAllLocationViews()
{
List <LocationView> list = new LocationBL().GetAllLocationViews();
return(list);
}
public Location GetLocationById(string entityID)
{
Location location = new LocationBL().GetLocationById(Int32.Parse(entityID));
return(location);
}
public static FASM_Enums.InfoMessages SaveLocation(ref Location eLocation)
{
LocationBL LocationBL = new LocationBL();
return(LocationBL.SaveLocation(ref eLocation));
}
public static DataTable GetLocation()
{
LocationBL LocationBL = new LocationBL();
return(LocationBL.GetLocation());
}
public static void LoadLocation(ref Location eLocation)
{
LocationBL LocationBL = new LocationBL();
LocationBL.LoadLocation(ref eLocation);
}
public List <EKATTE> GetEKATTEsByMunicipalityId(string municipalityID)
{
List <EKATTE> list = new LocationBL().GetEKATTEsByMunicipalityId(Int32.Parse(municipalityID));
return(list);
}
public static FASM_Enums.InfoMessages DeleteLocation(Int32 LocationId)
{
LocationBL LocationBL = new LocationBL();
return(LocationBL.DeleteLocation(LocationId));
}
public EKATTE GetEKATTEById(string entityID)
{
EKATTE eKATTE = new LocationBL().GetEKATTEById(Int32.Parse(entityID));
return(eKATTE);
}
