public string generateOrderNumber()
{
string result = "";
var year = DateTime.Now.Year;
var month = DateTime.Now.Month;
var data = _ctx.runningNumber.Where(f => f.Year == year && f.RunningMonth == month).FirstOrDefault();
if (data == null)
{
data = new RunningNumber();
data.Year = year;
data.RunningMonth = month;
data.Prefix = "ODR";
data.CurrentNo = 1;
_ctx.runningNumber.Add(data);
_ctx.SaveChanges();
result = $"{data.Year}/{data.RunningMonth}/{data.Prefix}/{data.CurrentNo.ToString().PadLeft(4,'0')}";
}
else
{
data.CurrentNo++;
_ctx.runningNumber.Update(data);
_ctx.SaveChanges();
result = $"{data.Year}/{data.RunningMonth}/{data.Prefix}/{data.CurrentNo.ToString().PadLeft(4,'0')}";
}
return(result);
}
public string NextId(string key)
{
RunningNumber num = LoadUnique(key);
runNbrTba.UpdateNextId(num.NextId + 1, DateTime.Now, key);
return(num.ToString(true));
}
public static dynamic GetTSObject(RunningNumber dynObject)
{
if (dynObject is null)
{
return(null);
}
return(dynObject.teklaObject);
}
public RunningNumber CreateReceivingRunningNumber(int month, int year)
{
var runNumber = new RunningNumber();
runNumber.Month = month;
runNumber.Year = year;
runNumber.FormCode = "RCV";
runNumber.Prefix = runNumber.FormCode;
runNumber.CurrentNo = 1;
context.RunningNumbers.InsertOnSubmit(runNumber);
context.SubmitChanges();
return(runNumber);
}
private RunningNumber CreateInvoiceNo()
{
var runNo = new RunningNumber();
runNo.Month = 0;
runNo.Year = DateTime.Today.Year;
runNo.EntityCode = INVOICE_ENTITY;
runNo.Prefix = "INV";
runNo.CurrentNo = 1;
runNo.ChangedWhen = DateTime.Now;
runNo.ChangedWho = principal.Identity.Name;
repository.Add(runNo);
return(runNo);
}
private RunningNumber CreateConfirmationLetterNo()
{
var runNo = new RunningNumber();
runNo.Month = 0;
runNo.Year = DateTime.Today.Year;
runNo.EntityCode = CONFIRMATION_LETTER_ENTITY;
runNo.Prefix = "COL";
runNo.CurrentNo = 1;
runNo.ChangedWhen = DateTime.Now;
runNo.ChangedWho = principal.Identity.Name;
repository.Add(runNo);
return(runNo);
}
private RunningNumber CreateCustomerRunningNumber()
{
var runNo = new RunningNumber();
runNo.Month = DateTime.Today.Month;
runNo.Year = DateTime.Today.Year;
runNo.EntityCode = CUSTOMER_ENTITY;
runNo.Prefix = "CUS";
runNo.CurrentNo = 1;
runNo.ChangedWhen = DateTime.Now;
runNo.ChangedWho = principal.Identity.Name;
repository.Add(runNo);
return(runNo);
}
public RunningNumber LoadUnique(string key)
{
try
{
RunningNumber item = new RunningNumber();
DataTable tb = runNbrTba.GetDataByKey(key);
if (tb.Rows.Count != 0)
{
item = (RunningNumber)QueryForObject(tb.Rows[0], typeof(RunningNumber));
return(item);
}
return(null);
}
catch
{
return(null);
}
}
public void CreateRunningNumber(string key, RunningNumberMask mask)
{
var sn = new RunningNumber(key, mask);
repository.Save(sn);
}
public object QueryForObject(DataRow row, Type t)
{
if (t == typeof(RunningNumber))
{
RunningNumber item = new RunningNumber();
try
{
item.Key = Convert.ToString(row["DocKey"]);
}
catch { }
try
{
item.Prefix = Convert.ToString(row["DocPrefix"]);
}
catch { }
try
{
item.LenYearPrefix = Convert.ToInt32(row["YearNbrPrefix"]);
}
catch { }
try
{
item.LenMonthPrefix = Convert.ToInt32(row["MonthNbrPrefix"]);
}
catch { }
try
{
item.LenDayPrefix = Convert.ToInt32(row["DayNbrPrefix"]);
}
catch { }
try
{
item.LenRunId = Convert.ToInt32(row["FormatNbr"]);
}
catch { }
try
{
item.NextId = Convert.ToInt32(row["NextId"]);
}
catch { }
try
{
item.ActiveDate = Convert.ToDateTime(row["ActiveDate"]);
}
catch { }
try
{
item.Date = Convert.ToDateTime(row["CurDate"]);
}
catch { }
try
{
item.Remark = Convert.ToString(row["Remark"]);
}
catch { }
try
{
item.ResetOption = Convert.ToString(row["ResetOption"]);
}
catch { }
return(item);
}
else
{
return(null);
}
}
