internal static string GetNewId(Type tipe)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, tipe.Name.ToString());
int length = 8;//int.Parse(ConfigurationManager.AppSettings["IdLength"]);
string result = string.Empty;
string lastId = string.Empty;
if (refer == null)
{
refer = new TReference();
lastId = decimal.Zero.ToString();
}
else
{
lastId = refer.NextId;
}
decimal nextId = Convert.ToDecimal(lastId) + 1;
for (int i = 0; i < length - nextId.ToString().Length; i++)
{
result = "0" + result;
}
result = tipe.Name.ToString().Substring(1, tipe.Name.ToString().Length - 1) + result + nextId.ToString();
refer.NextId = nextId.ToString();
refer.ReferenceType = tipe.Name.ToString();
DataMaster.SaveOrUpdate(refer);
return(result);
}
public static TReference GetReference(EnumReferenceType referenceType)
{
////check in cache first
//object obj = System.Web.HttpContext.Current.Cache[referenceType.ToString()];
////if not available, set it first
//if (obj == null)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
TReference reference = referenceRepository.GetByReferenceType(referenceType);
if (reference == null)
{
referenceRepository.DbContext.BeginTransaction();
reference = new TReference();
reference.SetAssignedIdTo(Guid.NewGuid().ToString());
reference.ReferenceType = referenceType.ToString();
reference.ReferenceValue = "0";
reference.CreatedDate = DateTime.Now;
reference.DataStatus = EnumDataStatus.New.ToString();
referenceRepository.Save(reference);
referenceRepository.DbContext.CommitTransaction();
}
return(reference);
// //save to cache
// System.Web.HttpContext.Current.Cache[referenceType.ToString()] = reference;
}
////return cache
//return System.Web.HttpContext.Current.Cache[referenceType.ToString()] as TReference;
}
public static string GetVoucherNo()
{
string voucherFrontString = "V/" + DateTime.Now.Year.ToString() + "/";
int voucherLength = 8;
string lastVoucher;
string VoucherNo = "VoucherNo";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, VoucherNo);
if (refer == null)
{
refer = new TReference();
lastVoucher = decimal.Zero.ToString();
}
else
{
lastVoucher = refer.NextId.Substring(refer.NextId.Length - voucherLength, voucherLength);
//voucherLength = voucherLength - 1;
}
decimal nextNumVoucher = Convert.ToDecimal(lastVoucher) + 1;
string nextVoucher = nextNumVoucher.ToString();
for (int i = 0; i < voucherLength - nextNumVoucher.ToString().Length; i++)
{
nextVoucher = "0" + nextVoucher;
}
nextVoucher = voucherFrontString + nextVoucher;
refer.NextId = nextVoucher;
refer.ReferenceType = VoucherNo;
DataMaster.SaveOrUpdate(refer);
return(nextVoucher);
}
private string GetNewWONo()
{
TReference refer = _refTasks.GetByReferenceType(EnumReferenceType.WONo);
bool automatedIncrease = true;
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
//reset wo no to 1 every month
if (DateTime.Today.Day == 1 && refer.ModifiedDate < DateTime.Today)
{
no = 1;
}
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
refer.ModifiedDate = DateTime.Now;
refer.ModifiedBy = User.Identity.Name;
refer.DataStatus = "Updated";
_refTasks.Update(refer);
}
StringBuilder result = new StringBuilder();
result.Append("WO[YEAR][MONTH][XXXX]");
result.Replace("[XXXX]", GetNo(4, no));
result.Replace("[DAY]", DateTime.Today.Day.ToString());
result.Replace("[MONTH]", DateTime.Today.ToString("MM").ToUpper());
result.Replace("[YEAR]", DateTime.Today.ToString("yy"));
return(result.ToString());
}
/// <summary>
/// get default warehouse
/// </summary>
/// <returns></returns>
internal static MWarehouse GetDefaultWarehouse()
{
object obj = System.Web.HttpContext.Current.Cache[EnumReferenceType.DefaultWarehouse.ToString()];
if (obj == null)
{
TReference refer = GetReference(EnumReferenceType.DefaultWarehouse);
if (!string.IsNullOrEmpty(refer.ReferenceValue))
{
IMWarehouseRepository warehouseRepository = new MWarehouseRepository();
System.Web.HttpContext.Current.Cache[EnumReferenceType.DefaultWarehouse.ToString()] = warehouseRepository.Get(refer.ReferenceValue);
}
}
return(System.Web.HttpContext.Current.Cache[EnumReferenceType.DefaultWarehouse.ToString()] as MWarehouse);
}
public static string GetFacturNo(EnumTransactionStatus transactionStatus, bool automatedIncrease)
{
TReference refer = GetReference((EnumReferenceType)Enum.Parse(typeof(EnumReferenceType), transactionStatus.ToString()));
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
//reset factur no to 1 every month
//if (DateTime.Today.Day == 1 && refer.ModifiedDate < DateTime.Today)
if (refer.ModifiedDate < DateTime.Today)
{
no = 1;
}
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
refer.ModifiedDate = DateTime.Now;
referenceRepository.Update(refer);
referenceRepository.DbContext.CommitChanges();
}
string tipeTrans = string.Empty;
char[] charTransArray = transactionStatus.ToString().ToCharArray();
char charTrans;
for (int i = 0; i < transactionStatus.ToString().Length; i++)
{
charTrans = charTransArray[i];
if (char.IsUpper(transactionStatus.ToString(), i))
{
tipeTrans += transactionStatus.ToString().Substring(i, 1);
}
}
StringBuilder result = new StringBuilder();
result.Append(CONST_FACTURFORMAT);
result.Replace("[TRANS]", tipeTrans);
result.Replace("[XXX]", GetFactur(5, no));
result.Replace("[DAY]", DateTime.Today.Day.ToString());
result.Replace("[MONTH]", DateTime.Today.ToString("MMM").ToUpper());
result.Replace("[YEAR]", DateTime.Today.Year.ToString());
return(result.ToString());
}
public static TReference GetReference(EnumReferenceType referenceType)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
TReference reference = referenceRepository.GetByReferenceType(referenceType);
if (reference == null)
{
reference = new TReference();
reference.SetAssignedIdTo(Guid.NewGuid().ToString());
reference.ReferenceType = referenceType.ToString();
reference.ReferenceValue = "0";
reference.CreatedDate = DateTime.Now;
reference.DataStatus = EnumDataStatus.New.ToString();
referenceRepository.Save(reference);
referenceRepository.DbContext.CommitChanges();
}
return(reference);
}
public static string GenerateFacturNo(ListOfTransaction tr, string DeskNo)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectById(typeof(MSetting), AssemblyProduct);
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, tr.ToString());
if (refer == null)
{
refer = new TReference();
refer.NextId = decimal.Zero.ToString();
}
string facturNoTemplate = set.FacturNoFormat;
decimal no = Convert.ToDecimal(refer.NextId) + 1;
int len = set.FacturNoLength - no.ToString().Length;
string factur = no.ToString();
for (int i = 0; i < len; i++)
{
factur = "0" + factur;
}
refer.NextId = no.ToString();
refer.ReferenceType = tr.ToString();
DataMaster.SaveOrUpdate(refer);
string tipeTrans = string.Empty;
char[] charTransArray = tr.ToString().ToCharArray();
char charTrans;
for (int i = 0; i < tr.ToString().Length; i++)
{
charTrans = charTransArray[i];
if (char.IsUpper(tr.ToString(), i))
{
tipeTrans += tr.ToString().Substring(i, 1);
}
}
return(facturNoTemplate.Replace("[xxx]", factur).Replace("[meja]", DeskNo).Replace("[tanggal]", DateTime.Now.Day.ToString()).Replace("[bulan]", DateTime.Now.Month.ToString()).Replace("[tahun]", DateTime.Now.Year.ToString()).Replace("[Tipe]", tipeTrans));
}
public static string GetOtherRevenueAccountNo()
{
string OtherRevenueAccountNo = "OtherRevenueAccountNo";
string defaultOtherRevenueAccountNo = "680";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, OtherRevenueAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = OtherRevenueAccountNo;
refer.NextId = defaultOtherRevenueAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultOtherRevenueAccountNo = refer.NextId;
}
return(defaultOtherRevenueAccountNo);
}
public static string GetBiayaStokAccountNo()
{
string BiayaStokAccountNo = "BiayaStokAccountNo";
string defaultBiayaStokAccountNo = "830STO001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, BiayaStokAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = BiayaStokAccountNo;
refer.NextId = defaultBiayaStokAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultBiayaStokAccountNo = refer.NextId;
}
return(defaultBiayaStokAccountNo);
}
public static string GetPPNPurchaseAccountNo()
{
string PPNPurchaseAccountNo = "PPNPurchase";
string defaultPPNPurchaseAccountNo = "320PPN001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, PPNPurchaseAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = PPNPurchaseAccountNo;
refer.NextId = defaultPPNPurchaseAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultPPNPurchaseAccountNo = refer.NextId;
}
return(defaultPPNPurchaseAccountNo);
}
public static string GetIkhtiarRLAccountNo()
{
string IkhtiarRLAccountNo = "IkhtiarRLAccountNo";
string defaultIkhtiarRLAccountNo = "1000-RL001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, IkhtiarRLAccountNo);
if (refer == null)
{
refer = new TReference();
}
else
{
defaultIkhtiarRLAccountNo = refer.NextId;
}
refer.ReferenceType = IkhtiarRLAccountNo;
refer.NextId = defaultIkhtiarRLAccountNo;
DataMaster.SaveOrUpdate(refer);
return(defaultIkhtiarRLAccountNo);
}
public static string GetReceiptNo(bool automatedIncrease)
{
TReference refer = GetReference(EnumReferenceType.InstallmentReceiptNo);
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
referenceRepository.DbContext.BeginTransaction();
referenceRepository.Update(refer);
referenceRepository.DbContext.CommitTransaction();
}
string formatFactur = "WMTI/[XXX]";
StringBuilder result = new StringBuilder();
result.Append(formatFactur);
result.Replace("[XXX]", GetFactur(5, no));
return(result.ToString());
}
public static string GetHutangEkspedisiAccountNo()
{
string HutangEkspedisiAccountNo = "HutangEkspedisiAccountNo";
string defaultHutangEkspedisiAccountNo = "400HUT002";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, HutangEkspedisiAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = HutangEkspedisiAccountNo;
refer.NextId = defaultHutangEkspedisiAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultHutangEkspedisiAccountNo = refer.NextId;
}
return(defaultHutangEkspedisiAccountNo);
}
public static string GetLabaDitahanAccountNo()
{
string LabaDitahanAccountNo = "LabaDitahanAccountNo";
string defaultLabaDitahanAccountNo = "510LAB001";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, LabaDitahanAccountNo);
if (refer == null)
{
refer = new TReference();
refer.ReferenceType = LabaDitahanAccountNo;
refer.NextId = defaultLabaDitahanAccountNo;
DataMaster.SaveOrUpdate(refer);
}
else
{
defaultLabaDitahanAccountNo = refer.NextId;
}
return(defaultLabaDitahanAccountNo);
}
public static string GetVoucherNo(bool automatedIncrease)
{
TReference refer = GetReference(EnumReferenceType.VoucherNo);
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
referenceRepository.DbContext.BeginTransaction();
referenceRepository.Update(refer);
referenceRepository.DbContext.CommitTransaction();
}
StringBuilder result = new StringBuilder();
result.Append(CONST_VOUCHERNO);
result.Replace("[XXX]", GetFactur(5, no));
result.Replace("[DAY]", DateTime.Today.Day.ToString());
result.Replace("[MONTH]", DateTime.Today.ToString("MMM").ToUpper());
result.Replace("[YEAR]", DateTime.Today.Year.ToString());
return(result.ToString());
}
public static string GetFacturNo(EnumTransactionStatus transactionStatus, bool automatedIncrease)
{
TReference refer = GetReference((EnumReferenceType)Enum.Parse(typeof(EnumReferenceType), transactionStatus.ToString()));
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
referenceRepository.Update(refer);
referenceRepository.DbContext.CommitChanges();
}
string tipeTrans = string.Empty;
char[] charTransArray = transactionStatus.ToString().ToCharArray();
char charTrans;
for (int i = 0; i < transactionStatus.ToString().Length; i++)
{
charTrans = charTransArray[i];
if (char.IsUpper(transactionStatus.ToString(), i))
{
tipeTrans += transactionStatus.ToString().Substring(i, 1);
}
}
string formatFactur = "GRAHA/[TRANS]/[XXX]/[MONTH]/[YEAR]";
StringBuilder result = new StringBuilder();
result.Append(formatFactur);
result.Replace("[TRANS]", tipeTrans);
result.Replace("[XXX]", GetFactur(5, no));
result.Replace("[MONTH]", DateTime.Today.ToString("MMM").ToUpper());
result.Replace("[YEAR]", DateTime.Now.Year.ToString());
return(result.ToString());
}
public static string GetVoucherNo(bool automatedIncrease, EnumJournalType journalType)
{
TReference refer = GetReference(EnumReferenceType.VoucherNo);
decimal no = Convert.ToDecimal(refer.ReferenceValue) + 1;
refer.ReferenceValue = no.ToString();
if (automatedIncrease)
{
ITReferenceRepository referenceRepository = new TReferenceRepository();
referenceRepository.DbContext.BeginTransaction();
referenceRepository.Update(refer);
referenceRepository.DbContext.CommitTransaction();
}
string formatFactur = "GRAHA/[TYPE]/[XXX]/[MONTH]/[YEAR]";
StringBuilder result = new StringBuilder();
result.Append(formatFactur);
result.Replace("[TYPE]", GetStringValue(journalType));
result.Replace("[XXX]", GetFactur(5, no));
result.Replace("[MONTH]", DateTime.Today.ToString("MMM").ToUpper());
result.Replace("[YEAR]", DateTime.Now.Year.ToString());
return(result.ToString());
}
public async Task <ResultWrapper <GetCustomerGFactorOutput> > Handle(GetCustomerGFactorQuery request, CancellationToken cancellationToken)
{
ResultWrapper <GetCustomerGFactorOutput> result = new ResultWrapper <GetCustomerGFactorOutput>();
TUser tUser = await _dbContext.TUser
.Include(x => x.TReference)
.FirstOrDefaultAsync(x => x.Id == request.Id);
if (tUser == null)
{
result.Status = false;
result.Message = "this user doesn't exists";
return(result);
}
TReference tUserReference = tUser.TReference;
if (tUserReference == null)
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.RequiresNew))
{
tUserReference = new TReference()
{
Enabled = true,
RecordType = ReferenceRecordTypeEnum.GFACTOR,
RecordId = tUser.Id,
Biotin_B7 = 1,
Calcium = 1,
Chromium = 1,
Copper = 1,
Dietary_Fibre = 1,
Fluoride = 1,
Folate = 1,
Iodine = 1,
Iron = 1,
Magnesium = 1,
Manganese = 1,
Molybdenum = 1,
Niacin_B3 = 1,
Pantothenic_Acid_B5 = 1,
Phosphorus = 1,
Potassium = 1,
Riboflavin_B2 = 1,
Selenium = 1,
Sodium = 1,
Thiamin_B1 = 1,
Vitamin_A = 1,
Vitamin_B12 = 1,
Vitamin_B6 = 1,
Vitamin_C = 1,
Vitamin_D = 1,
Vitamin_E = 1,
Zinc = 1
};
_dbContext.TReference.Add(tUserReference);
_dbContext.SaveChanges();
tUser.TReferenceId = tUserReference.Id;
_dbContext.TUser.Update(tUser);
_dbContext.SaveChanges();
transaction.Complete();
}
}
result.Status = true;
result.Result = new GetCustomerGFactorOutput()
{
Biotin_B7 = tUserReference.Biotin_B7,
Calcium_Ca = tUserReference.Calcium,
Chromium_Cr = tUserReference.Chromium,
Copper_Cu = tUserReference.Copper,
DietaryFibre = tUserReference.Dietary_Fibre,
Fluoride_F = tUserReference.Fluoride,
Folate = tUserReference.Folate,
Iodine_I = tUserReference.Iodine,
Iron_Fe = tUserReference.Iron,
Magnesium_Mg = tUserReference.Magnesium,
Manganese_Mn = tUserReference.Manganese,
Molybdenum_Mo = tUserReference.Molybdenum,
Niacin_B3 = tUserReference.Niacin_B3,
Pantothenic_acid_B5 = tUserReference.Pantothenic_Acid_B5,
Phosphorus_P = tUserReference.Phosphorus,
Potassium_K = tUserReference.Potassium,
Riboflavin_B2 = tUserReference.Riboflavin_B2,
Selenium_Se = tUserReference.Selenium,
Sodium_Na = tUserReference.Sodium,
Thiamin_B1 = tUserReference.Thiamin_B1,
Vitamin_A = tUserReference.Vitamin_A,
Vitamin_B12 = tUserReference.Vitamin_B12,
Vitamin_B6 = tUserReference.Vitamin_B6,
Vitamin_C = tUserReference.Vitamin_C,
Vitamin_D = tUserReference.Vitamin_D,
Vitamin_E = tUserReference.Vitamin_E,
Zinc_Zn = tUserReference.Zinc
};
return(result);
}
public async Task <ResultWrapper <UpdateCustomerGFactorOutput> > Handle(UpdateCustomerGFactorCommand request, CancellationToken cancellationToken)
{
ResultWrapper <UpdateCustomerGFactorOutput> result = new ResultWrapper <UpdateCustomerGFactorOutput>();
TUser tUser = await _dbContext.TUser
.Include(x => x.TReference)
.FirstOrDefaultAsync(x => x.Id == request.Id);
if (tUser == null)
{
result.Status = false;
result.Message = "This user doesn't exists";
return(result);
}
TReference tUserReference = tUser.TReference;
if (tUserReference == null)
{
result.Status = false;
result.Message = "This user record has some problems!";
return(result);
}
tUserReference.Biotin_B7 = request.Biotin_B7;
tUserReference.Calcium = request.Calcium_Ca;
tUserReference.Chromium = request.Chromium_Cr;
tUserReference.Copper = request.Copper_Cu;
tUserReference.Dietary_Fibre = request.DietaryFibre;
tUserReference.Fluoride = request.Fluoride_F;
tUserReference.Folate = request.Folate;
tUserReference.Iodine = request.Iodine_I;
tUserReference.Iron = request.Iron_Fe;
tUserReference.Magnesium = request.Magnesium_Mg;
tUserReference.Manganese = request.Manganese_Mn;
tUserReference.Molybdenum = request.Molybdenum_Mo;
tUserReference.Niacin_B3 = request.Niacin_B3;
tUserReference.Pantothenic_Acid_B5 = request.Pantothenic_acid_B5;
tUserReference.Phosphorus = request.Phosphorus_P;
tUserReference.Potassium = request.Potassium_K;
tUserReference.Riboflavin_B2 = request.Riboflavin_B2;
tUserReference.Selenium = request.Selenium_Se;
tUserReference.Sodium = request.Sodium_Na;
tUserReference.Thiamin_B1 = request.Thiamin_B1;
tUserReference.Vitamin_A = request.Vitamin_A;
tUserReference.Vitamin_B12 = request.Vitamin_B12;
tUserReference.Vitamin_B6 = request.Vitamin_B6;
tUserReference.Vitamin_C = request.Vitamin_C;
tUserReference.Vitamin_D = request.Vitamin_D;
tUserReference.Vitamin_E = request.Vitamin_E;
tUserReference.Zinc = request.Zinc_Zn;
_dbContext.TReference.Update(tUserReference);
_dbContext.SaveChanges();
result.Status = true;
result.Result = new UpdateCustomerGFactorOutput()
{
Id = tUser.Id
};
return(result);
}
