public string SaveCode() { var type = TypeMasterData.NCC.ToString(); var result = ""; var idRepo = UnitOfWork.Repository <MdIdBuilder>(); var maDonViCha = GetParentUnitCode(); var config = idRepo.DbSet.Where(x => x.Type == type && x.UnitCode == maDonViCha).FirstOrDefault(); if (config == null) { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = type, Code = type, Current = "0000", UnitCode = maDonViCha, }; result = config.GenerateNumber(); config.Current = result; idRepo.Insert(config); } else { result = config.GenerateNumber(); config.Current = result; config.ObjectState = ObjectState.Modified; } result = string.Format("{0}", config.Current); return(result); }
public string SaveCode(TypeVoucher type = TypeVoucher.XBANLE) { var result = ""; var strType = type.ToString(); var idRepo = UnitOfWork.Repository <MdIdBuilder>(); var config = idRepo.DbSet.Where(x => x.Type == strType).FirstOrDefault(); if (config == null) { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = strType, Code = strType, Current = "0", }; config.Current = config.GenerateNumber(); idRepo.Insert(config); } else { config.Current = config.GenerateNumber(); config.ObjectState = ObjectState.Modified; } result = string.Format("{0}{1}", config.Code, config.Current); return(result); }
public string SaveCodeChild(string code) { var type = TypeMasterData.VATTU.ToString(); var result = ""; var vatTu = UnitOfWork.Repository <MdMerchandise>().DbSet.First(x => x.MaVatTu == code); if (vatTu != null) { var idRepo = UnitOfWork.Repository <MdIdBuilder>(); var config = idRepo.DbSet.Where(x => x.Type == type && x.Code == vatTu.MaVatTu).FirstOrDefault(); if (config == null) { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = type, Code = vatTu.MaVatTu, Current = "00", }; result = config.GenerateNumber(); config.Current = result; idRepo.Insert(config); } else { result = config.GenerateNumber(); config.Current = result; config.ObjectState = ObjectState.Modified; } result = string.Format("{0}{1}", config.Code, result); } return(result); }
public string SaveCodeByParent(string unitCode) { var type = TypeMasterData.NV.ToString(); var result = ""; var idRepo = UnitOfWork.Repository <MdIdBuilder>(); var config = idRepo.DbSet.Where(x => x.Type == type && x.UnitCode == unitCode).FirstOrDefault(); if (config == null) { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = type, Code = type, UnitCode = unitCode, Current = "0", }; result = config.GenerateNumber(); config.Current = result; idRepo.Insert(config); } else { result = config.GenerateNumber(); config.Current = result; config.ObjectState = ObjectState.Modified; } result = unitCode + "-" + config.Code + config.Current; return(result); }
public string SaveCode(string code) { var type = TypeMasterData.VATTU.ToString(); var maDonViCha = GetParentUnitCode(); var result = ""; var loaiVatTu = UnitOfWork.Repository <MdMerchandiseType>().DbSet.First(x => x.MaLoaiVatTu == code && x.UnitCode.StartsWith(maDonViCha)); if (loaiVatTu != null) { var idRepo = UnitOfWork.Repository <MdIdBuilder>(); var config = idRepo.DbSet.Where(x => x.Type == type && x.Code == loaiVatTu.MaLoaiVatTu && x.UnitCode == maDonViCha).FirstOrDefault(); if (config == null) { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = type, Code = loaiVatTu.MaLoaiVatTu, Current = "000000", UnitCode = maDonViCha, }; result = config.GenerateNumber(); config.Current = result; idRepo.Insert(config); } else { result = config.GenerateNumber(); config.Current = result; config.ObjectState = ObjectState.Modified; } result = string.Format("{0}{1}", config.Code, result); } return(result); }
public string SaveCodeRoot() { var result = ""; var type = TypeMasterData.KH.ToString(); string rootUnitcode = ConfigurationManager.AppSettings["rootUnitCode"]; string maDonViCha = GetParentUnitCode(); using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["LTT.Connection"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { MdIdBuilder config = new MdIdBuilder(); OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "SELECT ID,TYPE,CODE,\"CURRENT\",UNITCODE FROM MD_ID_BUILDER WHERE TYPE = '" + type + "' AND CODE = '" + type + "' AND UNITCODE = '" + maDonViCha + "' AND ROWNUM = 1"; cmd.CommandType = CommandType.Text; OracleDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { config = new MdIdBuilder { Id = dataReader["ID"].ToString(), Type = type, Code = type, Current = dataReader["CURRENT"].ToString(), UnitCode = maDonViCha }; result = config.GenerateNumber(); config.Current = result; cmd.CommandText = "UPDATE MD_ID_BUILDER SET \"CURRENT\" = '" + result + "' WHERE TYPE = '" + type + "' AND CODE = '" + type + "' AND UNITCODE = '" + maDonViCha + "' "; cmd.CommandType = CommandType.Text; int countUpdate = cmd.ExecuteNonQuery(); } } else { config = new MdIdBuilder { Id = Guid.NewGuid().ToString(), Type = type, Code = type, Current = "0", UnitCode = maDonViCha }; result = config.GenerateNumber(); config.Current = result; cmd.CommandText = "INSERT INTO MD_ID_BUILDER(ID,TYPE,CODE,CURRENT,UNITCODE) VALUES ('" + config.Id + "','" + config.Type + "','" + config.Code + "','" + config.Current + "','" + config.UnitCode + "')"; cmd.CommandType = CommandType.Text; int count = cmd.ExecuteNonQuery(); } result = string.Format("{0}{1}", config.Code, result); } } catch (Exception ex) { } finally { connection.Close(); connection.Dispose(); } } return(result); }