public ClienteDescuento(DAC Datos, int Cliente, int DescuentoFijo, decimal ValorDescuento)
{
_datos = Datos;
_cliente = Cliente;
_descuentoFijo = DescuentoFijo;
_valorDescuento = ValorDescuento;
}
//Cac ham xu ly phong ban
// public VatTu(string ma_vat_tu)
// {
// private string matnr { get; set; }
// private string bismt { get; set; }
// private string maktx { get; set; }
// private string meins { get; set; }
// private string mseht { get; set; }
// private string matkl { get; set; }
// private string wgbez { get; set; }
//}
public List <VatTu> LayDanhSacVatTu(int action, int id_vattu)
{
DAC kn = new DAC();
List <VatTu> vattu_col = new List <VatTu>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id_vattu);
SqlParameter[] param = new SqlParameter[2] {
pm, pm2
};
DataTable tb = kn.get_by_procedure("proc_Action_VatTu", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
VatTu vt = new VatTu();
// vt.ID_Vat_Tu = Convert.ToInt64(row["id"]);
vattu_col.Add(vt);
}
}
return(vattu_col);
}
//Este metodo es de tipo internal que perimte que solo se pueda acceder a el desde el mismo ensamblado, resive
//un DbDataRecord y crea un objeto ProductBE para asignarle los valores en el DbDataRecord
internal static ProductBE Get(DbDataRecord row)
{
var product = new ProductBE();
//Para evitar errores de conversión se usan los metodos de DataUtilities para convertir los valores del
//DbDataRecord y asignarselos a los atributos del ProductBE
product.ProductID = DataUtilities.GetInt32(row["ProductID"]).Value;
product.ProductName = DataUtilities.GetString(row["ProductName"]);
product.SupplierID = DataUtilities.GetInt32(row["SupplierID"]);
product.CategoryID = DataUtilities.GetInt32(row["CategoryID"]);
product.QuantityPerUnit = DataUtilities.GetString(row["QuantityPerUnit"]);
product.UnitPrice = DataUtilities.GetDecimal(row["UnitPrice"]);
product.UnitsInStock = DataUtilities.GetInt32(row["UnitsInStock"]);
product.UnitsOnOrder = DataUtilities.GetInt32(row["UnitsOnOrder"]);
product.ReorderLevel = DataUtilities.GetInt32(row["ReorderLevel"]);
product.Discontinued = DataUtilities.GetBoolean(row["Discontinued"]);
//Ahora se buscaran los objetos relacionados con este
var dbCommand = Provider.GetDbCommand("SELECT * FROM Categories WHERE CategoryID = ?");
Data.DataUtilities.Utilities.SetValue(dbCommand, product.CategoryID);
product.Category = CategoryBC.Get(DAC.EjecutarConsulta(dbCommand).FirstOrDefault());
dbCommand = Provider.GetDbCommand("SELECT * FROM Suppliers WHERE SupplierID = ?");
Data.DataUtilities.Utilities.SetValue(dbCommand, product.SupplierID);
product.Supplier = Contacts.SupplierBC.Get(DAC.EjecutarConsulta(dbCommand).FirstOrDefault());
return(product);
}
private void StorageButton_Click(object sender, RoutedEventArgs e)
{
using (DAC dac = new DAC())
{
//
}
}
private void CurrentRequestWindow_PagePreRender(object sender, EventArgs e)
{
WebWindow window = (WebWindow)sender;
string isLeftPanelVisible = (VTC.HasActiveActions() || DAC.HasActiveActions()).ToString().ToLower();
window.RegisterStartupScript("OnLoadCore", string.Format(@"Init(""{1}"", ""DefaultCS"");OnLoadCore(""LPcell"", ""separatorCell"", ""separatorImage"", {0}, true);", isLeftPanelVisible, BaseXafPage.CurrentTheme), true);
}
public List <Quyen> LayDanhSachQuyen(int action, int id_quyen, string tenquyen, string maquyen)
{
DAC kn = new DAC();
List <Quyen> quyen_col = new List <Quyen>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id_quyen);
SqlParameter pm3 = new SqlParameter("@tenquyen", tenquyen);
SqlParameter pm4 = new SqlParameter("@maquyen", maquyen);
SqlParameter[] param = new SqlParameter[4] {
pm, pm2, pm3, pm4
};
DataTable tb = kn.get_by_procedure("proc_Action_Quyen", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
Quyen quyen = new Quyen();
quyen.ID_Quyen = Convert.ToInt16(row["ID"]);
quyen.Ten_Quyen = row["TenQuyen"].ToString();
quyen.Ma_Quyen = row["MaQuyen"].ToString();
quyen_col.Add(quyen);
}
}
return(quyen_col);
}
public List <PhongBan> ReportDanhSachPhongBan_DoanhSo(int id_phongban, string tungay, string denngay)
{
DAC kn = new DAC();
List <PhongBan> phongbans = new List <PhongBan>();
SqlParameter pm = new SqlParameter("@id_phongban", id_phongban);
SqlParameter pm2 = new SqlParameter("@tungay", tungay);
SqlParameter pm3 = new SqlParameter("@denngay", denngay);
SqlParameter[] param = new SqlParameter[3] {
pm, pm2, pm3
};
DataTable tb = kn.get_by_procedure("proc_report_DanhSachPB_PO_theodoanhso", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PhongBan phongban = new PhongBan();
phongban.ID_PhongBan = Convert.ToInt32(row["ID_PhongBan"]);
phongban.Ten_Phong_Ban = row["TenPhongBan"].ToString();
// phongban.Ten_Viet_Tat = row["TenVietTat"].ToString();
phongbans.Add(phongban);
}
}
return(phongbans);
}
public ActionResult WeeklySales(DateTime From, DateTime To)
{
var result = DAC.GetOrders(From, To);
var weekGroups = result.Select(p => new
{
Project = p,
Year = p.Date.Year,
Week = CultureInfo.InvariantCulture.Calendar.GetWeekOfYear
(p.Date, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday)
})
.GroupBy(x => new { x.Year, x.Week })
.Select((g, i) => new
{
WeekGroup = g,
WeekNum = i + 1,
Year = g.Key.Year,
CalendarWeek = g.Key.Week
});
//foreach (var projGroup in weekGroups)
//{
// Console.WriteLine("Week " + projGroup.WeekNum);
// foreach (var proj in projGroup.WeekGroup)
// Console.WriteLine("{0} {1} {2}",
// proj.Project.Name,
// proj.Project.DateStart.ToString("d"),
// proj.Project.ID);
//}
return(Json(weekGroups, JsonRequestBehavior.AllowGet));
}
public frmLecturista(DAC DAC, string Usuario)
{
this.InitializeComponent();
this._DAC = DAC;
this._EDFLecturista = new Lecturista(this._DAC);
this._strUsuario = Usuario;
}
public List <PhongBan> LayDanhSachPhongBan(int action, int id_phongban, string tenphongban, string tenviettat)
{
DAC kn = new DAC();
List <PhongBan> phongbans = new List <PhongBan>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id_phongban);
SqlParameter pm3 = new SqlParameter("@tenphongban", tenphongban);
SqlParameter pm4 = new SqlParameter("@tenviettat", tenviettat);
SqlParameter[] param = new SqlParameter[4] {
pm, pm2, pm3, pm4
};
DataTable tb = kn.get_by_procedure("proc_Action_PhongBan", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PhongBan phongban = new PhongBan();
phongban.ID_PhongBan = Convert.ToInt16(row["ID"]);
phongban.Ten_Phong_Ban = row["TenPhongBan"].ToString();
phongban.Ten_Viet_Tat = row["TenVietTat"].ToString();
phongbans.Add(phongban);
}
}
return(phongbans);
}
public List <PR_ChiTiet> LayDanhSachPR_ChTiet_DaDuyet(int id_phongban)
{
DAC kn = new DAC();
List <PR_ChiTiet> pr_Chitiet_col = new List <PR_ChiTiet>();
SqlParameter pm = new SqlParameter("@id_phongban", id_phongban);
//SqlParameter pm2 = new SqlParameter("@tinhtrangvattu", tinhtrangvattu);
SqlParameter[] param = new SqlParameter[1] {
pm
};
DataTable tb = kn.get_by_procedure("proc_LayDS_PR_PRChiTiet_DaDuyet", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PR_ChiTiet pr_chitiet = new PR_ChiTiet();
pr_chitiet.ID_PR_Chi_Tiet = Convert.ToInt32(row["ID"]);
pr_chitiet.ID_PR = Convert.ToInt32(row["ID_PR"]);
pr_chitiet.Ma_Hang = row["MaHang"].ToString();
pr_chitiet.Ten_Hang = row["TenHang"].ToString();
pr_chitiet.DVT = row["DVT"].ToString();
pr_chitiet.Ton_Kho = Convert.ToInt32(row["TonKho"]);
pr_chitiet.So_Luong_Yeu_cau = Convert.ToInt32(row["SoLuongYeuCau"]);
pr_chitiet.Don_Gia = Convert.ToDouble(row["DonGia"]);
pr_chitiet.Ti_Gia = Convert.ToInt32(row["TiGia"]);
pr_chitiet.Thanh_Tien_Tam_Ung = Convert.ToDouble(row["ThanhTienTamUng"]);
pr_chitiet.Nha_Cung_cap = row["NhaCungCap"].ToString();
pr_chitiet.Tinh_Trang_Vat_Tu = Convert.ToInt32(row["TinhTrangVatTu"]);
pr_chitiet.Ngay_Can_Hang = Convert.ToDateTime(row["NgayCanHang"]);
pr_chitiet.Thoi_Gian_Xu_Dung = row["ThoiGianSuDung"].ToString();
pr_chitiet.Cong_Dung = row["CongDung"].ToString();
pr_chitiet.So_PR_Full = row["SoPR_Full"].ToString();
pr_chitiet.Ngay_Duyet_PR = Convert.ToDateTime(row["NgayDuyet"]);
pr_chitiet.Lead_Time = Convert.ToInt32(row["leadtime"]);
pr_chitiet.So_Luong_Con_Lai = Convert.ToInt32(row["SoLuongConLai"]);
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = "";
if (!row.IsNull("NguoiPTMuaHang"))
{
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = row["NguoiPTMuaHang"].ToString();
}
pr_chitiet.VAT = 0;
if (!row.IsNull("VAT"))
{
pr_chitiet.VAT = Convert.ToInt32(row["VAT"].ToString());
}
pr_chitiet.GiaNhapTay = false;
if (!row.IsNull("GiaNhapTay"))
{
pr_chitiet.GiaNhapTay = Convert.ToBoolean(row["GiaNhapTay"]);
}
pr_Chitiet_col.Add(pr_chitiet);
}
}
return(pr_Chitiet_col);
}
public CatalogoDescuentosFijos(SqlConnection Conexion, int NumeroMaximoPosicionRI, int NumeroMinimoPosicionRI)
{
InitializeComponent();
_datos = new DAC(Conexion);
_numeroMaximoPosicionRI = NumeroMaximoPosicionRI;
_numeroMinimoPosicionRI = NumeroMinimoPosicionRI;
}
public NguoiDung LayThongTinNguoiDung(string tendangnhap)
{
NguoiDung nd = new NguoiDung();
DAC kn = new DAC();
SqlParameter pm = new SqlParameter("@tendangnhap", tendangnhap);
SqlParameter[] param = new SqlParameter[1] {
pm
};
DataTable tb = kn.get_by_procedure("proc_CheckAccount", param);
if (tb != null || tb.Rows.Count > 0)
{
nd.ID_NguoiDung = Convert.ToInt16(tb.Rows[0]["ID"]);
nd.Admin = Convert.ToBoolean(tb.Rows[0]["Admin"]);
nd.Dang_Nhap_Domain = Convert.ToBoolean(tb.Rows[0]["DangNhapDomain"]);
nd.Dang_Su_Dung = Convert.ToBoolean(tb.Rows[0]["DangSuDung"]);
nd.Email = tb.Rows[0]["Email"].ToString();
nd.ID_Phong_Ban = Convert.ToInt32(tb.Rows[0]["ID_PhongBan"]);
nd.Phong_Ban = tb.Rows[0]["PhongBan"].ToString();
nd.Ngay_Tao = Convert.ToDateTime(tb.Rows[0]["NgayTao"]);
nd.Quan_Ly = Convert.ToBoolean(tb.Rows[0]["QuanLy"]);
nd.Ten_Hien_Thi = tb.Rows[0]["TenHienThi"].ToString();
nd.Ten_Dang_Nhap = tb.Rows[0]["TenDangNhap"].ToString();
if (!string.IsNullOrEmpty(tb.Rows[0]["TenDangNhap"].ToString()))
{
nd.Mat_Khau = tb.Rows[0]["Password"].ToString();
}
nd.Quan_Ly_Kho = Convert.ToBoolean(tb.Rows[0]["QuanLyKho"]);
nd.Quan_Ly_Mua_Hang = Convert.ToBoolean(tb.Rows[0]["QuanLyMuaHang"]);
}
return(nd);
}
private void btnSave_Click(object sender, EventArgs e)
{
this.gridSource = this.ViewModel.Transaction.SaleItems.Where(i => !i.Voided).Select(
lineItem => new LineLevelInformationViewModel(lineItem, this.ViewModel.Transaction))
.ToList();
string isPickup = "0";
string shippingmethod = "";
foreach (LineLevelInformationViewModel lv in this.gridSource)
{
isPickup = lv.IsPickup ?"1":"0";
if (lv.ShippingMethodCode == "" && lv.IsPickup)
{
shippingmethod = ApplicationSettings.Terminal.PickupDeliveryModeCode;
}
else
{
shippingmethod = lv.ShippingMethodCode;
}
DAC odac = new DAC(SalesOrder.InternalApplication.Settings.Database.Connection);
odac.SaveLineDataOV(this.ViewModel.Transaction.TransactionId, this.ViewModel.Transaction.TerminalId, this.ViewModel.Transaction.StoreId, lv.StoreNumber, shippingmethod, lv.LineItem.LineId.ToString(), isPickup);
}
DAC odac2 = new DAC(SalesOrder.InternalApplication.Settings.Database.Connection);
odac2.SaveContactDataOV(this.ViewModel.Transaction.TransactionId, this.ViewModel.Transaction.TerminalId, this.ViewModel.Transaction.StoreId, this.ViewModel.Transaction.Customer.Name, this.ViewModel.Transaction.Customer.Email, this.ViewModel.Transaction.Customer.Telephone, this.ViewModel.SalesPerson, this.ViewModel.SalesPersonId);
}
protected override void OnStartup(StartupEventArgs e)
{
this.DispatcherUnhandledException += App_DispatcherUnhandledException;
AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);
AppDomain.CurrentDomain.AssemblyResolve += CurrentDomain_AssemblyResolve;
if (IsAlreadyRunning())
{
MessageBox.Show("YtoX is already running.");
Application.Current.Shutdown();
return;
}
ShellHelper.InstallShortcut();
SystemHelper.SetNativeDllPath();
SystemHelper.RegisterComDll();
SystemHelper.SetLoadOnStartup();
TaskBarHelper.Setup();
if (!DAC.SetupDB())
{
MessageBox.Show("Database not found.", Constants.APP_ID, MessageBoxButton.OK, MessageBoxImage.Error);
Application.Current.Shutdown();
return;
}
Repository.Read();
SettingsHelper.Load();
Engine.Instance.Start();
TaskBarHelper.ShowBalloonTip("YtoX Engine Started!\nPlease make sure you have configured the settings.");
base.OnStartup(e);
}
public ActionResult EditRecords()
{
var AllOrders = DAC.GetAllOrdersDesc();
List <OrderViewModel> OrdersList = new List <OrderViewModel>();
foreach (var order in AllOrders)
{
var customer = DAC.FindCustomerById(order.CustomerId);
OrderViewModel listItem = new OrderViewModel()
{
OrderId = order.OrderId,
OrderNo = order.OrderId,
Date = order.Date.ToString("dd/MM/yyyy"),
Status = ((Constants.PaymentType)order.Status).ToString(),
TotalAmount = order.TotalAmount,
};
if (customer != null)
{
listItem.Name = customer.FirstName + " " + customer.SurName;
listItem.Telephone = customer.Phone;
}
OrdersList.Add(listItem);
}
return(View(OrdersList));
}
public ActionResult AwaitCollections()
{
var CollectionOrders = DAC.GetCollectionOrders();
List <AwaitOrderModel> awaitorders = new List <AwaitOrderModel>();
foreach (var ord in CollectionOrders)
{
var order = DAC.GetOrder(ord.OrderId);
var customer = DAC.FindCustomerById(order.CustomerId);
AwaitOrderModel collectionOrder = new AwaitOrderModel()
{
AwaitOrderId = ord.Id,
OrderNo = order.OrderId,
Date = order.Date.ToString("dd/MM/yyyy"),
Status = ((Constants.PaymentType)order.Status).ToString(),
TotalAmount = order.TotalAmount,
Collect = order.Date.ToString("HH:mm:ss"),
Name = customer.FirstName + " " + customer.SurName,
Telephone = customer.Phone
};
awaitorders.Add(collectionOrder);
}
return(View(awaitorders));
}
public List <PO> LayDanhSachPO_TheoTinhTrangNhapKho(int tinhtrang, int tinhtrangnhapkho, int idphongban)
{
DAC kn = new DAC();
List <PO> po_col = new List <PO>();
SqlParameter pm = new SqlParameter("@tinhtrang", tinhtrang);
SqlParameter pm2 = new SqlParameter("@tinhtrangnhapkho", tinhtrangnhapkho);
SqlParameter pm3 = new SqlParameter("@idphongban", idphongban);
SqlParameter[] param = new SqlParameter[3] {
pm, pm2, pm3
};
DataTable tb = kn.get_by_procedure("proc_DanhSachPO_PhieuNhapKho", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PO po = new PO();
po.ID_PO = Convert.ToInt32(row["ID"]);
po.So_PO = Convert.ToInt32(row["SoPO"]);
//if (tb.Columns.Contains("TenVietTat") == true)
//{
// po.Ten_PhongBan = row["TenVietTat"].ToString();
//}
po.So_PO_Full = row["SoPO_Full"].ToString();
po.Nam = Convert.ToInt32(row["Nam"]);
po.Ngay_PO = Convert.ToDateTime(row["NgayPO"]);
po.Thang_PO = Convert.ToInt32(row["ThangPO"]);
po.ID_NguoiMuaHang = Convert.ToInt32(row["ID_NguoiPhuTrachMuaHang"]);
po.Ten_NguoiMuaHang = row["NguoiPhuTrachMuaHang"].ToString();
po.ID_Nguoi_Duyet_PO = Convert.ToInt32(row["ID_NguoiDuyetPO"]);
po.Ten_Nguoi_Duyet_PO = row["NguoiPheDuyetPO"].ToString();
po.So_Ngay_tre = Convert.ToInt32(row["SoNgayTre"]);
po.ID_Phong_Ban = Convert.ToInt32(row["ID_PhongBan"]);
if (tb.Columns.Contains("TenPhongBan"))
{
po.Ten_Phong_Ban = row["TenPhongBan"].ToString();
}
po.Ten_Nha_Cung_Cap = row["NhaCungCap"].ToString();
po.Ma_Nha_Cung_Cap = row["MaNhaCungCap"].ToString();
po.Kho_Nhan = row["KhoNhan"].ToString();
if (tb.Columns.Contains("GhiChu"))
{
if (row["GhiChu"] != null)
{
po.Ghi_Chu = row["GhiChu"].ToString();
}
else
{
po.Ghi_Chu = "";
}
}
po.Tinh_Trang = Convert.ToInt32(row["TinhTrang"]);
po.Tinh_Trang_Nhap_Kho = Convert.ToInt32(row["TinhTrangNhapKho"]);
po_col.Add(po);
}
}
return(po_col);
}
public frmZonaEdificio(DAC DAC, string Usuario)
{
this.InitializeComponent();
this._DAC = DAC;
this._EDFZonaEdificio = new ZonaEdificio(this._DAC);
this._strUsuario = Usuario;
}
public ActionResult ViewDriverPymentDetails(int id)
{
var Deliveries = DAC.GetDriverDeliveries(id);
List <DeliveriesViewModel> deliveryorders = new List <DeliveriesViewModel>();
foreach (var ord in Deliveries)
{
var order = DAC.GetOrder(ord.OrderId);
var customer = DAC.FindCustomerById(order.CustomerId);
DeliveriesViewModel deliveryOrder = new DeliveriesViewModel()
{
DeliveryId = ord.Id,
OrderNo = order.OrderId,
Time = order.Date.ToString("dd/MM/yyyy") + " " + order.Date.ToString("HH:mm:ss"),
Address = customer.Address1 + " " + customer.Address2,
TotalAmount = order.TotalAmount,
Name = customer.FirstName + " " + customer.SurName,
Telephone = customer.Phone,
PostCode = customer.PostCode,
Status = ((Constants.PaymentStatus)order.Status).ToString()
};
deliveryorders.Add(deliveryOrder);
}
return(View(deliveryorders));
}
public ZonaEdificio(DAC DAC, byte ZonaEdificio)
{
DataTable dataTable = new DataTable();
try
{
this._DAC = DAC;
dataTable = this.ConsultarZonaEdificio(ZonaEdificio, false);
if (dataTable == null || dataTable.Rows.Count <= 0)
{
return;
}
this._zonaEdificio = Convert.ToByte(dataTable.Rows[0]["ZonaEdificio"]);
this._lecturistaTitular = Convert.ToInt16(dataTable.Rows[0]["LecturistaTitular"]);
this._Empleado = Convert.ToInt32(dataTable.Rows[0]["Empleado"]);
this._NombreLecturista = Convert.ToString(dataTable.Rows[0]["NombreLecturista"]);
this._descripcion = Convert.ToString(dataTable.Rows[0]["Descripcion"]);
this._usuarioAlta = Convert.ToString(dataTable.Rows[0]["UsuarioAlta"]);
this._fAlta = Convert.ToDateTime(dataTable.Rows[0]["FAlta"]);
this._status = Convert.ToString(dataTable.Rows[0]["Status"]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dataTable != null)
{
dataTable.Dispose();
}
}
}
//Este metodo sirve para traer varios productos de la base de datos usando un Dctionary de string y object,
//el Dictionary es una colección de KeyParValue el cual consta de Key y de Value donde el Key es del tipo que
//se ubica primero en la declaración y el Value el que le sigue (<string, object>). en este caso el Key sera
//la expresión que complemente el string query para armar la consulta y el Value sera el valor de el parametro
//que se use en el Key, ejemplo: Key = "Discontinued = ?" y Value = 0
public static List <ProductBE> GetProducts(Dictionary <string, object> parameters)
{
var query = "SELECT * FROM Products ";
//Esta es otra forma de usar este metodo, se invoca sin parametros para mas adelante asignar la consulta
var dbCommand = Provider.GetDbCommand();
//Si el codigo que se usará dentro de una validación if solo consta de una linea se pueden omitir los corchetes
if (parameters != null && parameters.Count > 0)
{
query += "WHERE ";
}
//Aca se recorren los parametros para construit la consulta
foreach (var param in parameters)
{
query += param.Key + " ";
Data.DataUtilities.Utilities.SetValue(dbCommand, param.Value);
}
//Ahora se asigna la consulta convertida (Para su correcto uso en la base de datos), a la propiedad CommandText
dbCommand.CommandText = Provider.ConvertQuery(query);
//Aca se crea la lista de ProductBE
var lstProducts = new List <ProductBE>();
//En este ciclo se recorre la lista de los DbDataRecord resultantes de la consulta para obtener el ProductBE y
//agregarlo a la lista
foreach (var row in DAC.EjecutarConsulta(dbCommand))
{
lstProducts.Add(Get(row));
}
return(lstProducts);
}
public static DAC CreateDatabase()
{
try
{
//DatabaseFactorySectionHandler sectionHandler = (DatabaseFactorySectionHandler)ConfigurationManager.GetSection("DatabaseFactoryConfiguration");
/*
* Type database = Type.GetType("_MongoDatabase");
*
* ConstructorInfo constructor = database.GetConstructor(new Type[] { });
* DAC createdObject = (DAC)constructor.Invoke(null);
* createdObject.connectionString = "mongodb://localhost:27017/SocialDB";//sectionHandler.ConnectionString
*/
// TODO: Load this DataBase Calss Through Reflectiona dn Section Handler from DB
DAC createdObject = (DAC)_MongoDatabase.getObject();
return(createdObject);
}
catch (Exception excep)
{
throw new Exception(excep.Message);
}
}
public void DataCompInitialize()
{
TextReader textReader = (TextReader) new StreamReader(HttpContext.Current.Server.MapPath("Conexion.txt"));
this._dataAccess = new DAC(new SqlConnection(textReader.ReadLine()));
textReader.Close();
}
public frmGenerarAsignacion(DAC DAC, string Usuario)
{
this.InitializeComponent();
this._DAC = DAC;
this._strUsuario = Usuario;
this._AsignacionLecturista = new AsignacionLecturistas(DAC, Usuario);
}
public VincularDescuentoFijo(DAC Datos, int DescuentoAInactivar, int ZonaEconomica)
{
InitializeComponent();
_datos = Datos;
_descuentoAInactivar = DescuentoAInactivar;
_zonaEconomicaParaInactivar = ZonaEconomica;
}
public Data(SqlConnection Connection)
{
this.dt = new DataTable();
this._datos = new DAC(Connection);
this.dtClientesFilial = new DataTable("ClientesFilial");
this.dtBitacoraFilial = new DataTable("BitacoraFilial");
}
public List <SoPO> Action_SoPO(int action, int id, int idphongban, int sopo, int nam)
{
SoPO sopo2 = new SoPO();
DAC kn = new DAC();
List <SoPO> sopo_col = new List <SoPO>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id);
SqlParameter pm3 = new SqlParameter("@idphongban", idphongban);
SqlParameter pm4 = new SqlParameter("@sopo", sopo);
SqlParameter pm5 = new SqlParameter("@nam", nam);
SqlParameter[] param = new SqlParameter[5] {
pm, pm2, pm3, pm4, pm5
};
DataTable tb = kn.get_by_procedure("proc_Action_So_PO", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
SoPO sp = new SoPO();
sp.ID_So_PO = Convert.ToInt32(tb.Rows[0]["ID"]);
sp.Phong_Ban = tb.Rows[0]["TenVietTat"].ToString();
sp.So_PO = Convert.ToInt32(tb.Rows[0]["SoPO"]);
sp.Nam = Convert.ToInt32(tb.Rows[0]["Nam"]);
sopo_col.Add(sp);
}
}
return(sopo_col);
}
///Cac ham xu ly
///
public SoPO LaySoPO(int phongban, int nam)
{
SoPO sopo = new SoPO();
DAC kn = new DAC();
SqlParameter pm = new SqlParameter("@action", 1);
SqlParameter pm2 = new SqlParameter("@id", 1);
SqlParameter pm3 = new SqlParameter("@idphongban", phongban);
SqlParameter pm4 = new SqlParameter("@sopo", 1);
SqlParameter pm5 = new SqlParameter("@nam", nam);
SqlParameter[] param = new SqlParameter[5] {
pm, pm2, pm3, pm4, pm5
};
DataTable tb = kn.get_by_procedure("proc_Action_So_PO", param);
if (tb != null)
{
if (tb.Rows.Count > 0)
{
sopo.ID_So_PO = Convert.ToInt32(tb.Rows[0]["ID"]);
sopo.Phong_Ban = tb.Rows[0]["TenVietTat"].ToString();
sopo.So_PO = Convert.ToInt32(tb.Rows[0]["SoPO"]);
sopo.Nam = Convert.ToInt32(tb.Rows[0]["Nam"]);
}
}
return(sopo);
}
public ActionResult Discounts()
{
var list = new List <Discount>();
list = DAC.GetAllDiscounts();
return(PartialView("_Discounts", list));
}
static RemoteLogService()
{
try
{
schema.Columns.Add("MonitorAction", typeof(string));
schema.Columns.Add("MonitorTime", typeof(DateTime));
schema.Columns.Add("Host", typeof(string));
schema.Columns.Add("IP", typeof(string));
schema.Columns.Add("MAC", typeof(string));
schema.Columns.Add("AppPath", typeof(string));
schema.Columns.Add("FirstCag", typeof(string));
schema.Columns.Add("SecondCag", typeof(string));
schema.Columns.Add("ThirdCag", typeof(string));
schema.Columns.Add("ForthCag", typeof(string));
schema.Columns.Add("MonitorValue", typeof(double));
schema.Columns.Add("Msg", typeof(string));
mappings[0] = new SqlBulkCopyColumnMapping("MonitorAction", "MonitorAction");
mappings[1] = new SqlBulkCopyColumnMapping("MonitorTime", "MonitorTime");
mappings[2] = new SqlBulkCopyColumnMapping("Host", "Host");
mappings[3] = new SqlBulkCopyColumnMapping("IP", "IP");
mappings[4] = new SqlBulkCopyColumnMapping("MAC", "MAC");
mappings[5] = new SqlBulkCopyColumnMapping("AppPath", "AppPath");
mappings[6] = new SqlBulkCopyColumnMapping("FirstCag", "FirstCag");
mappings[7] = new SqlBulkCopyColumnMapping("SecondCag", "SecondCag");
mappings[8] = new SqlBulkCopyColumnMapping("ThirdCag", "ThirdCag");
mappings[9] = new SqlBulkCopyColumnMapping("ForthCag", "ForthCag");
mappings[10] = new SqlBulkCopyColumnMapping("MonitorValue", "MonitorValue");
mappings[11] = new SqlBulkCopyColumnMapping("Msg", "Msg");
if (isDb)
dac = new DAC(Config.LogConnectionName);
schemaCache = schema.Clone();
}
catch (Exception e)
{
Log.Error(e);
}
}
public void ProcessRequest(HttpContext context)
{
Menu menu = new Menu();
context.Response.Clear();
context.Response.ContentType = "text/plain";
//StringBuilder response = this.GetResponse();
try
{
// Create and register new channel
this.channel_ = new IiopClientChannel();
ChannelServices.RegisterChannel(this.channel_, false);
//Accessing the target object provided by TEM service
this.tem_ =
(TestExecutionManager)RemotingServices.Connect(typeof(TestExecutionManager),
context.Request.QueryString["temLocation"]);
DataAcquisitionController[] dacs = this.tem_.get_DACs();
if (0 < dacs.Length)
{
menu.Dacs = new List<DAC>();
foreach (DataAcquisitionController dac in dacs)
{
DAC dac_element = new DAC();
dac_element.Name = dac.name;
dac_element.Probes = new List<Probe>();
this.probes_ = dac.get_probe_instances();
if (0 < this.probes_.Length)
{
foreach (ProbeInstance probe in this.probes_)
{
Probe probe_element = new Probe();
probe_element.Name = probe.inst_name;
probe_element.Einode_Name = probe.einode_name;
probe_element.Uuid = probe.inst_uuid;
probe_element.Type_Name = probe.inst_type_name;
dac_element.Probes.Add(probe_element);
}
}
menu.Dacs.Add(dac_element);
}
}
}
finally
{
ChannelServices.UnregisterChannel(this.channel_);
}
StringBuilder response = new StringBuilder();
JavaScriptSerializer ser = new JavaScriptSerializer();
ser.Serialize(menu,response);
context.Response.Write(response.ToString());
context.Response.End();
}
/// <summary>
/// Costruttore
/// </summary>
/// <param name="res">Nome del canale analogico</param>
/// <param name="scale">Valore di scalatura (gain) del valore scritto dal canale analogico</param>
/// <param name="offset">Offset aggiunto sul valore scritto dal canale analogico</param>
public AnalogOut(DAC res, double scale, double offset)
: base((Cpu.AnalogOutputChannel)res)
{
Scale = scale;
Offset = offset;
}
/// <summary>
/// Costruttore
/// </summary>
/// <param name="res">Nome del canale analogico</param>
public AnalogOut(DAC res)
: this(res, 1, 0)
{
}
