public ActionResult FiscalEdit(int id)
{
FiscalDTO data = new FiscalDTO();
data = _fiscalService.GetFiscalById(id);
return(View(data));
}
public int UpdateFiscal(FiscalDTO data)
{
FiscalDTO res = new FiscalDTO();
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_FiscalEdit", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", data.FyId);
cmd.Parameters.AddWithValue("@Name", data.FyName);
cmd.Parameters.AddWithValue("@StartDate", data.FyStartDate);
cmd.Parameters.AddWithValue("@EndDate", data.FyEndDate);
cmd.Parameters.AddWithValue("@StartDateNep", data.FyStartDateNp);
cmd.Parameters.AddWithValue("@EndDateNep", data.FyEndDateNp);
cmd.Parameters.AddWithValue("@IsActive", data.FyCurrent);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
return(dt.Rows.Count);
}
public ActionResult FiscalEdit(FiscalDTO data)
{
data.FyStartDate = !string.IsNullOrEmpty(data.FyStartDateNp) ? Convert.ToDateTime(NepEngDate.NepToEng(data.FyStartDateNp)) : data.FyStartDate;
data.FyEndDate = !string.IsNullOrEmpty(data.FyEndDateNp) ? Convert.ToDateTime(NepEngDate.NepToEng(data.FyEndDateNp)) : data.FyEndDate;
int res = _fiscalService.UpdateFiscal(data);
return(RedirectToAction("FiscalYear"));
}
public static Fiscal ConvertRespondentInfoFromDTO(FiscalDTO fiscalDTO)
{
Mapper.CreateMap <FiscalDTO, Fiscal>().ConvertUsing(
m =>
{
return(new Fiscal
{
FyId = m.FyId,
FyCurrent = m.FyCurrent,
FyEndDate = m.FyEndDate,
FyEndDateNp = m.FyEndDateNp,
FyName = m.FyName,
FyStartDate = m.FyStartDate,
FyStartDateNp = m.FyStartDateNp
});
});
return(Mapper.Map <FiscalDTO, Fiscal>(fiscalDTO));
}
public ActionResult FiscalCreateClose(FiscalDTO data)
{
data.FyStartDate = !string.IsNullOrEmpty(data.FyStartDateNp) ? Convert.ToDateTime(NepEngDate.NepToEng(data.FyStartDateNp)) : data.FyStartDate;
data.FyEndDate = !string.IsNullOrEmpty(data.FyEndDateNp) ? Convert.ToDateTime(NepEngDate.NepToEng(data.FyEndDateNp)) : data.FyEndDate;
try
{
FiscalDTO res = new FiscalDTO();
FiscalDTO fd = new FiscalDTO();
if (!ModelState.IsValid)
{
return(View(fd));
}
res = _fiscalService.InsertFiscal(data);
ViewBag.Success = "Fiscal year " + data.FyName + " has been created";
return(RedirectToAction("FiscalYear"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public FiscalDTO InsertFiscal(FiscalDTO data)
{
FiscalDTO res = new FiscalDTO();
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_FiscalAdd", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", data.FyName);
cmd.Parameters.AddWithValue("@StartDate", data.FyStartDate);
cmd.Parameters.AddWithValue("@EndDate", data.FyEndDate);
cmd.Parameters.AddWithValue("@StartDateNep", data.FyStartDateNp);
cmd.Parameters.AddWithValue("@EndDateNep", data.FyEndDateNp);
cmd.Parameters.AddWithValue("@IsActive", data.FyCurrent);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
foreach (DataRow row in dt.Rows)
{
return(new FiscalDTO
{
FyName = row["FyName"].ToString(),
FyCurrent = Convert.ToBoolean(row["FyCurrent"]),
FyEndDateNp = row["FyEndDateNp"].ToString(),
FyStartDateNp = row["FyStartDateNp"].ToString(),
FyEndDate = Convert.ToDateTime(row["FyEndDate"]),
FyStartDate = Convert.ToDateTime(row["FyStartDate"])
});
}
return(res);
}
