protected void btnSetPurchase_Click(object sender, EventArgs e)
{
if (Page.IsPostBack && ddlFiscalYear.SelectedValue != "-1")
{
string[] GetDates = ddlFiscalYear.SelectedItem.Text.Split('-');
DateTime from = Convert.ToDateTime(GetDates[0]);
DateTime to = Convert.ToDateTime(GetDates[1]);
Models.MFiscalYear mf = new Models.MFiscalYear();
mf.fiscalFrom = from;
mf.fiscalTo = to;
int fiscalYearId = Convert.ToInt32(ddlFiscalYear.SelectedValue);
Classes.CFiscalYear cf = new Classes.CFiscalYear();
if (cf.UpdateDefaultFiscalYear(fiscalYearId) < 0)
{
ShowFailMessage();
}
else
{
ShowSuccessMessage();
}
}
else
{
ShowErrorModal("Please select a fiscal year");
}
}
public int Update(Models.MFiscalYear model)
{
try
{
var query = from o in obj.FiscalYears where model.id == o.id select o;
foreach (var item in query)
{
item.fiscalFrom = model.fiscalFrom;
item.fiscalTo = model.fiscalTo;
}
obj.SubmitChanges();
return(1);
}
catch (Exception)
{
return(-1);
}
}
public List <Models.MFiscalYear> GetAllById(int FiscalYear)
{
List <Models.MFiscalYear> Get = new List <Models.MFiscalYear>();
var query = from o in obj.FiscalYears
where o.id == FiscalYear
select
o;
foreach (var item in query)
{
Models.MFiscalYear mf = new Models.MFiscalYear();
mf.fiscalFrom = Convert.ToDateTime(item.fiscalFrom);
mf.fiscalTo = Convert.ToDateTime(item.fiscalTo);
Get.Add(mf);
}
return(Get);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid && IsPostBack)
{
DateTime from = Convert.ToDateTime(txtFrom.Text);
DateTime to = Convert.ToDateTime(txtTo.Text);
Models.MFiscalYear mf = new Models.MFiscalYear();
mf.fiscalFrom = from;
mf.fiscalTo = to;
Classes.CFiscalYear cf = new Classes.CFiscalYear();
if (cf.Save(mf) > 0)
{
ShowSuccessMessage();
}
else
{
ShowFailMessage();
}
}
}
public int Save(Models.MFiscalYear model)
{
try
{
DB.FiscalYear fy = new DB.FiscalYear();
fy.fiscalFrom = model.fiscalFrom;
fy.fiscalTo = model.fiscalTo;
obj.FiscalYears.InsertOnSubmit(fy);
obj.SubmitChanges();
//Setting the newly added fiscal year as default
UpdateDefaultFiscalYear(GetLastFiscalYearId());
return(1);
}
catch
{
return(-1);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid && IsPostBack)
{
DateTime from = Convert.ToDateTime(txtFrom.Text);
DateTime to = Convert.ToDateTime(txtTo.Text);
Models.MFiscalYear mf = new Models.MFiscalYear();
mf.fiscalFrom = from;
mf.fiscalTo = to;
Classes.CFiscalYear cf = new Classes.CFiscalYear();
if (cf.Save(mf) > 0)
{
Response.Redirect("~/Pages/Main.aspx");
}
else
{
ShowErrorModal("there was an error saving the new fiscal year");
}
}
}