public static FiscalPeriod CreateFiscalPeriod(string calendar,
string fiscalYear,
global::System.DateTimeOffset startDate,
global::System.DateTimeOffset endDate,
string periodName,
int days,
global::Microsoft.Dynamics.DataEntities.FiscalCalendarEntity fiscalCalendarPeriod,
global::Microsoft.Dynamics.DataEntities.FiscalCalendarYearEntity fiscalCalendarYear)
{
FiscalPeriod fiscalPeriod = new FiscalPeriod();
fiscalPeriod.Calendar = calendar;
fiscalPeriod.FiscalYear = fiscalYear;
fiscalPeriod.StartDate = startDate;
fiscalPeriod.EndDate = endDate;
fiscalPeriod.PeriodName = periodName;
fiscalPeriod.Days = days;
if ((fiscalCalendarPeriod == null))
{
throw new global::System.ArgumentNullException("fiscalCalendarPeriod");
}
fiscalPeriod.FiscalCalendarPeriod = fiscalCalendarPeriod;
if ((fiscalCalendarYear == null))
{
throw new global::System.ArgumentNullException("fiscalCalendarYear");
}
fiscalPeriod.FiscalCalendarYear = fiscalCalendarYear;
return(fiscalPeriod);
}
// No.400 Add Start
/// <summary>
/// 年度指定期間の設定
/// </summary>
/// <param name="fiscalYm">年度指定yyyy/MM</param>
/// <returns></returns>
public FiscalPeriod getFiscalFromTo(string fiscalYm)
{
if (string.IsNullOrEmpty(fiscalYm))
{
return(null);
}
FiscalPeriod ret = new FiscalPeriod();
int ival = -1;
string[] yearMonth = fiscalYm.Split('/');
DateTime wkDt = new DateTime(Int32.TryParse(yearMonth[0], out ival) ? ival : -1,
Int32.TryParse(yearMonth[1], out ival) ? ival : -1,
1);
if (wkDt == null)
{
return(null);
}
// 年度指定の値から過去12か月が指定期間
ret.PeriodStart = wkDt.AddMonths(-11);
ret.PeriodEnd = wkDt.AddMonths(1).AddDays(-1);
return(ret);
}
/// <summary>
/// Page Load Event Handler
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
try
{
connectionString = ConfigurationManager.AppSettings["PFCERPConnectionString"].ToString();
fiscalPeriod = new FiscalPeriod();
maintenanceUtils = new MaintenanceUtility();
lblMessage.Text = "";
if (!Page.IsPostBack)
{
// lblCurrentDate.Text = DateTime.Now.ToShortDateString();
Session["FiscalSecurity"] = maintenanceUtils.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.FiscalPeriod);
Mode = "Add";
BindDataGrid();
}
if (FiscalSecurity == "")
{
EnableQueryMode();
}
//btnSave.Visible = false;
}
catch (Exception ex)
{
DisplaStatusMessage(ex.Message, "Fail");
}
}
/// <summary>
/// 画面初期化
/// </summary>
private void ScreenClear()
{
this.MaintenanceMode = null;
// No.353 Mod Start
// 自社コード
this.MyCompany.Text1 = ccfg.自社コード.ToString();
this.MyCompany.IsEnabled = ccfg.自社販社区分 == 自社販社区分.自社.GetHashCode();
// No.353 Mod End
// 処理年度の初期値設定
// No.400 Mod Start
this.FiscalYear.Text = string.Format("{0}/{1}", DateTime.Now.Year, DateTime.Now.Month);
FiscalPeriod period = getFiscalFromTo(this.FiscalYear.Text);
this.PeriodYM.Text = string.Format("月度 : {0}～{1}月度", period.PeriodStart.ToString("yyyy/MM"), period.PeriodEnd.ToString("yyyy/MM"));
// No.400 Mod End
// 得意先の入力値クリア
this.得意先From.Text1 = string.Empty;
this.得意先From.Text2 = string.Empty;
this.得意先To.Text1 = string.Empty;
this.得意先To.Text2 = string.Empty;
// 品番指定
this.ProductFrom.Text1 = string.Empty;
this.ProductFrom.Text2 = string.Empty;
this.ProductTo.Text1 = string.Empty;
this.ProductTo.Text2 = string.Empty;
ResetAllValidation();
SetFocusToTopControl();
}
public HttpResponseMessage UpdateFiscalPeriod(HttpRequestMessage request, [FromBody] FiscalPeriod fiscalPeriodModel)
{
return(GetHttpResponse(request, () =>
{
var fiscalPeriod = _CoreService.UpdateFiscalPeriod(fiscalPeriodModel);
return request.CreateResponse <FiscalPeriod>(HttpStatusCode.OK, fiscalPeriod);
}));
}
private void cbAcc_SelectedIndexChanged(object sender, EventArgs e)
{
FiscalPeriod period = new FiscalPeriod();
if (cbAcc.SelectedItem != null)
{
period = (FiscalPeriod)cbAcc.SelectedItem;
accFilter = period.AccountName;
nTotalAdvance.Value = 0;
}
}
public HttpResponseMessage GetFiscalPeriod(HttpRequestMessage request, int fiscalPeriodId)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
FiscalPeriod fiscalPeriod = _CoreService.GetFiscalPeriod(fiscalPeriodId);
// notice no need to create a seperate model object since FiscalPeriod entity will do just fine
response = request.CreateResponse <FiscalPeriod>(HttpStatusCode.OK, fiscalPeriod);
return response;
}));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
FiscalPeriod = await _context.FiscalPeriods.FirstOrDefaultAsync(m => m.Id == id);
if (FiscalPeriod == null)
{
return(NotFound());
}
return(Page());
}
/// <summary>
/// 年度指定が変更された時のイベント処理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FiscalYear_cTextChanged(object sender, RoutedEventArgs e)
{
FiscalPeriod period = new FiscalPeriod();
// 年度指定期間を再計算
period = getFiscalFromTo(this.FiscalYear.Text);
if (period == null)
{
this.PeriodYM.Text = string.Empty;
}
else
{
this.PeriodYM.Text = string.Format("月度 : {0}～{1}月度", period.PeriodStart.ToString("yyyy/MM"), period.PeriodEnd.ToString("yyyy/MM"));
}
}
private void CalculateCum()
{
drowYTD = dtable.NewRow();
drowYTD["FiscalPeriod"] = drowYTD["YearMonth"] = FiscalPeriod.Substring(0, 4) + "99";
for (int i = 2; i < dtable.Columns.Count; i++)
{
drowYTD[i] = 0;
}
for (int r = 0; r <= iCurrentRow; r++)
{
for (int i = 2; i < dtable.Columns.Count; i++)
{
drowYTD[i] = Convert.ToInt32(drowYTD[i]) + Convert.ToInt32(dtable.Rows[r][i]);
}
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
FiscalPeriod = await _context.FiscalPeriods.FindAsync(id);
if (FiscalPeriod != null)
{
_context.FiscalPeriods.Remove(FiscalPeriod);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
/// <summary>
/// パラメータを設定する
/// </summary>
private void setSearchParams()
{
paramDic.Clear();
paramDic.Add(PARAMS_NAME_FISCAL_YEAR, FiscalYear.Text);
paramDic.Add(PARAMS_NAME_COMPANY, MyCompany.Text1);
// No.398 Add Start
FiscalPeriod period = new FiscalPeriod();
period = getFiscalFromTo(FiscalYear.Text);
paramDic.Add(PARAMS_NAME_FISCAL_FROM, period.PeriodStart.ToShortDateString());
paramDic.Add(PARAMS_NAME_FISCAL_TO, period.PeriodEnd.ToShortDateString());
paramDic.Add(PARAMS_NAME_TOKCD_FROM, 得意先From.Text1);
paramDic.Add(PARAMS_NAME_TOKED_FROM, 得意先From.Text2);
paramDic.Add(PARAMS_NAME_TOKCD_TO, 得意先To.Text1);
paramDic.Add(PARAMS_NAME_TOKED_TO, 得意先To.Text2);
// No.398 Add End
}
public HttpResponseMessage DeleteFiscalPeriod(HttpRequestMessage request, [FromBody] int fiscalPeriodId)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
// not that calling the WCF service here will authenticate access to the data
FiscalPeriod fiscalPeriod = _CoreService.GetFiscalPeriod(fiscalPeriodId);
if (fiscalPeriod != null)
{
_CoreService.DeleteFiscalPeriod(fiscalPeriodId);
response = request.CreateResponse(HttpStatusCode.OK);
}
else
{
response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No fiscalPeriod found under that ID.");
}
return response;
}));
}
public FiscalPeriod UpdateFiscalPeriod(FiscalPeriod fiscalPeriod)
{
return(Channel.UpdateFiscalPeriod(fiscalPeriod));
}
protected void saveNewFiscalPeriod(object sender, DirectEventArgs e)
{
try
{
//Getting the id to check if it is an Add or an edit as they are managed within the same form.
string salaryType = e.ExtraParams["salaryType"];
string periodId = e.ExtraParams["periodId"];
string status = e.ExtraParams["status"];
string obj = e.ExtraParams["schedule"];
FiscalPeriod b = JsonConvert.DeserializeObject <FiscalPeriod>(obj);
b.fiscalYear = CurrentYear.Text;
b.salaryType = Convert.ToInt16(salaryType);
b.status = Convert.ToInt16(status);
// Define the object to add or edit as null
//New Mode
//Step 1 : Fill The object and insert in the store
PostRequest <FiscalPeriod> request = new PostRequest <FiscalPeriod>();
request.entity = b;
PostResponse <FiscalPeriod> r = _payrollService.ChildAddOrUpdate <FiscalPeriod>(request);
//check if the insert failed
if (!r.Success)//it maybe be another condition
{
//Show an error saving...
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
Common.errorMessage(r);;
return;
}
else
{
//Add this record to the store
fiscalPeriodsStore.Reload();
//Display successful notification
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordSavingSucc
});
this.fiscalPeriodWindow.Close();
}
}
catch (Exception ex)
{
//Error exception displaying a messsage box
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.Error, Resources.Common.ErrorSavingRecord).Show();
}
}
private void LoadFiscalPeriods()
{
fiscalPeriods = new List<FiscalPeriod>();
if (stock == null)
stock = new StockController();
foreach( DataRow dr in stock.GetFiscalAccount().Rows)
{
FiscalPeriod period = new FiscalPeriod();
if ( dr[0].ToString().Contains("JANUARY"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("FEBRUARY"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("MARCH"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("APRIL"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("MAY"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("JUNE"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("JULY"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("AUGUST"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("SEPTEMBER"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("OCTOBER"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("NOVEMBER"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
if (dr[0].ToString().Contains("DECEMBER"))
{
period.month = dr[1].ToString();
period.AccountName = dr[0].ToString();
}
fiscalPeriods.Add(period);
}
//fiscalPeriods= fiscalPeriods.OrderByDescending(o => o.month).ToList();
cbAcc.DataSource = fiscalPeriods;
cbAcc.DisplayMember = "AccountName";
cbAcc.ValueMember = "month";
//throw new NotImplementedException();
}
