public MdSupplier SyncSQLToOracle(TDS_Dmkhachhang instance)
{
using (var ctx = new DBCSQL())
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <TDS_Dmkhachhang, MdSupplier>()
.ForMember(dest => dest.MaNCC, opt => opt.MapFrom(u => u.Makhachhang))
.ForMember(dest => dest.TenNCC, opt => opt.MapFrom(u => u.Tenkhachhang))
.ForMember(dest => dest.DiaChi, opt => opt.MapFrom(u => u.Diachi))
.ForMember(dest => dest.DienThoai, opt => opt.MapFrom(u => u.Dienthoai))
.ForMember(dest => dest.Fax, opt => opt.MapFrom(u => u.Fax))
.ForMember(dest => dest.Email, opt => opt.MapFrom(u => u.Email))
.ForMember(dest => dest.TrangThai, opt => opt.UseValue(10))
.ForMember(dest => dest.IState, opt => opt.UseValue(10));
});
try
{
var mapper = config.CreateMapper();
var customer = mapper.Map <TDS_Dmkhachhang, MdSupplier>(instance);
customer.ICreateBy = GetClaimsPrincipal().Identity.Name;
customer.ICreateDate = DateTime.Now;
var result = Insert(customer);
return(result);
}
catch
{
return(null);
}
}
}
public string CheckBarcodeAtSQL(string barcodes)
{
var result = "";
using (var ctx = new DBCSQL())
{
if (!string.IsNullOrWhiteSpace(barcodes))
{
var barcodeCollection = barcodes.Split(';');
barcodeCollection = barcodeCollection.Where(x => !string.IsNullOrWhiteSpace(x)).ToArray();
foreach (var code in barcodeCollection)
{
try
{
var str = string.Format("SELECT * FROM TDS_Dmmathang WHERE Barcode LIKE '%;{0};%'", code);
var data = ctx.TDS_Dmmathang.SqlQuery(str);
if (data.Count() > 0)
{
result = string.Format("{0};{1}", result, code);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
return(result);
}
public TDS_VatVm GetTaxFromSQL(string maVat)
{
using (var ctx = new DBCSQL())
{
var item = ctx.TDS_Dmvat.FirstOrDefault(x => x.Mavat == maVat);
var result = Mapper.Map <TDS_Dmvat, TDS_VatVm>(item);
return(result);
}
}
public IList <ChoiceObj> GetSelectDataFromSQLByMaLoai(string code)
{
using (var ctx = new DBCSQL())
{
var data = ctx.TDS_Dmnhomhang;
return(data.Where(x => x.Manganh == code).Select(x => new ChoiceObj {
Value = x.Manhomhang, Text = x.Tennhomhang
}).ToList());
}
}
public IList <ChoiceObj> GetSelectDataFromSQL()
{
using (var ctx = new DBCSQL())
{
var data = ctx.TDS_Dmkehang;
return(data.Select(x => new ChoiceObj
{
Value = x.Makehang,
Text = x.Tenkehang
}).ToList());
}
}
public IList <ChoiceObj> GetSelectDataFromSQL()
{
using (var ctx = new DBCSQL())
{
var data = ctx.TDS_Dmvat;
return(data.Select(x => new ChoiceObj
{
Value = x.Mavat,
Text = x.Tenvat,
ExtendValue = "" + x.Vat + ""
}).ToList());
}
}
public IList <ChoiceObj> GetSelectDataFromSQL()
{
using (var ctx = new DBCSQL())
{
var data = ctx.TDS_Dmdonvitinh;
return(data.Select(x => new ChoiceObj
{
Value = x.Madvtinh,
Text = "Đv Lẻ: " + x.Donvile + "-Đv lớn: " + x.Donvilon,
ExtendValue = x.Donvilon
}).ToList());
}
}
public string SaveCodeCanDienTuFromSQL(DBCSQL context)
{
var type = TypeMasterData.CANDIENTU.ToString();
var result = "";
var dbSet = context.TDS_Dmcapma;
var instanceBuilder = dbSet.FirstOrDefault(x => x.Loaima == type);
if (instanceBuilder != null)
{
var newNumber = instanceBuilder.GenerateNumber();
result = string.Format("{0}{1}", instanceBuilder.Mastart, newNumber);
instanceBuilder.Macappk = newNumber;
}
return(result);
}
public string BuildCodeCanDienTuFromSQL()
{
var type = TypeMasterData.CANDIENTU.ToString();
var result = "";
using (var ctx = new DBCSQL())
{
var dbSet = ctx.TDS_Dmcapma;
var instanceBuilder = dbSet.FirstOrDefault(x => x.Loaima == type);
if (instanceBuilder != null)
{
result = string.Format("{0}{1}", instanceBuilder.Mastart, instanceBuilder.GenerateNumber());
}
}
return(result);
}