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); }