public async Task <IActionResult> Add(PaperCreateViewModel model)
{
if (model == null)
{
StatusMessage = "Error. Something went wrong.";
return(View(model));
}
if (ModelState.IsValid)
{
if (_paperRepository.TitleTaken(model.Title))
{
StatusMessage = "Error. This title is already taken.";
return(RedirectToAction(nameof(Add)));
}
var user = await _userManager.GetUserAsync(HttpContext.User);
var participancy = _participanciesRepository.GetUserCurrentParticipancy(user.Id);
PaperDTO paper = Mapper.Map <PaperDTO>(model);
paper.ParticipancyId = model.ParticipancyId;
paper.Status = 0;
var result = _paperRepository.AddPaper(paper);
if (result == 1)
{
StatusMessage = "Succesfully created.";
return(RedirectToAction(nameof(MyPapers)));
}
return(RedirectToAction(nameof(MyPapers)));
}
StatusMessage = "Error. Entered data is not valid.";
return(View(model));
}
public ActionResult Edit(PaperDTO objpaper, FormCollection collection, string actionType)
{
if (actionType == "Update")
{
if (string.IsNullOrEmpty(Convert.ToString(objpaper.StateId)))
{
ModelState.AddModelError("Error", "Please Select State");
}
else if (string.IsNullOrEmpty(Convert.ToString(objpaper.CityId)))
{
ModelState.AddModelError("Error", "Please Select City");
}
else
{
objpaper.ModifiedBy = Convert.ToInt32(Session["UserID"]);
DateTime timeUtc = System.DateTime.UtcNow;
TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone);
objpaper.ModifiedDate = cstTime;
objPaperMaster.UpdatePaper(objpaper);
TempData["MessageUpdate"] = "Paper Details Updated Successfully.";
return(RedirectToAction("Details"));
// return RedirectToAction("Details");
}
return(RedirectToAction("Details"));
}
else
{
return(RedirectToAction("Details"));
}
}
public ActionResult Add(PaperAddModel model)
{
PaperDTO dto = new PaperDTO();
dto.ExamTime = model.ExamTime;
dto.PCount = string.Join(",", model.PCount);
dto.PScore = string.Join(",", model.PScore);
dto.Title = model.Title;
dto.ZScore = model.ZScore;
var data = paperService.AddPaper(dto);
if (data > 0)
{
return(Json(new AjaxResult {
Status = "ok"
}));
}
else
{
return(Json(new AjaxResult {
Status = "error", ErrorMsg = "添加失败！"
}));
}
}
public int AddPaper(PaperDTO paper)
{
Paper newPaper = Mapper.Map <Paper>(paper);
_context.Paper.Add(newPaper);
int result = _context.SaveChanges();
return(result);
}
public int UpdatePaperTitle(PaperDTO paper)
{
var paperToUpdate = _context.Paper.Find(paper.Id);
paperToUpdate.Title = paper.Title;
paperToUpdate.Status = 0;
int result = _context.SaveChanges();
return(result);
}
public ActionResult Create()
{
PaperDTO objP = new PaperDTO();
objP.ListState = BindListState();
objP.ListCity = BindListCity();
ViewData["SelectedState"] = string.Empty;
ViewData["SelectedCity"] = string.Empty;
return(View(objP));
}
public int UpdatePaper(PaperDTO paper)
{
Paper paperNew = Mapper.Map <Paper>(paper);
var paperToUpdate = _context.Paper.Find(paper.Id);
paperToUpdate.Title = paperNew.Title;
paperToUpdate.Status = paperNew.Status;
int result = _context.SaveChanges();
return(result);
}
public PaperDTO ToDTO(PaperEntity ef)
{
PaperDTO dto = new PaperDTO();
dto.Id = ef.Id;
dto.ExamTime = ef.ExamTime;
dto.CreateDateTime = ef.CreateDateTime;
dto.PCount = ef.PCount;
dto.PScore = ef.PScore;
dto.Title = ef.Title;
dto.ZScore = ef.ZScore;
return(dto);
}
public int AddPaper(PaperDTO dto)
{
using (MyDbContext ctx = new MyDbContext())
{
PaperEntity ef = new PaperEntity();
ef.Title = dto.Title;
ef.PCount = dto.PCount;
ef.PScore = dto.PScore;
ef.ExamTime = dto.ExamTime;
ef.ZScore = dto.ZScore;
ctx.Papers.Add(ef);
ctx.SaveChanges();
return(ef.Id);
}
}
public void UpdatePaper(PaperDTO paper)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString()))
{
con.Open();
var para = new DynamicParameters();
para.Add("@PaperId", paper.PaperId); // Normal Parameters
para.Add("@PaperName", paper.PaperName);
para.Add("@StateId", paper.StateId);
para.Add("@CityId", paper.CityId);
para.Add("@Language", paper.Language);
para.Add("@CreatedDate", paper.CreatedDate);
para.Add("@CreatedBy", paper.CreatedBy);
para.Add("@ModifiedDate", paper.ModifiedDate);
para.Add("@ModifiedBy", paper.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_PaperMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
}
public void InsertPaper(PaperDTO paper)
{
con.Open();
var para = new DynamicParameters();
para.Add("@PaperId", paper.PaperId); // Normal Parameters
para.Add("@PaperName", paper.PaperName);
para.Add("@StateId", paper.StateId);
para.Add("@CityId", paper.CityId);
para.Add("@Language", paper.Language);
para.Add("@CreatedDate", paper.CreatedDate);
para.Add("@CreatedBy", paper.CreatedBy);
para.Add("@ModifiedDate", paper.ModifiedDate);
para.Add("@ModifiedBy", paper.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_PaperMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
public List <PaperDTO> BindListPaper(string CityId)
{
List <PaperDTO>
ListPaper = new List <PaperDTO>()
{
new PaperDTO {
PaperId = 0, PaperName = "Select"
}
};
foreach (var item in objPaperMaster.GetPaperByCityIdBySession(CityId))
{
PaperDTO p = new PaperDTO();
p.PaperId = item.PaperId;
p.PaperName = item.PaperName;
ListPaper.Add(p);
}
return(ListPaper);
}
public IEnumerable <PaperDTO> BindListPaperL(string CityId, String DistributorId)
{
List <PaperDTO>
ListPaper = new List <PaperDTO>()
{
new PaperDTO {
PaperId = 0, PaperName = "Select"
}
};
foreach (var item in objdistributorsale.GetPaperByCityIdnDistributor(CityId, DistributorId))
{
PaperDTO P = new PaperDTO();
P.PaperId = item.PaperId;
P.PaperName = item.PaperName;
ListPaper.Add(P);
}
return(ListPaper);
}
public List <PaperDTO> BindListPaper()
{
List <PaperDTO>
ListPaper = new List <PaperDTO>()
{
new PaperDTO {
PaperId = 0, PaperName = "Select"
}
};
foreach (var item in objpaper.GetPapers())
{
PaperDTO p = new PaperDTO();
p.PaperId = item.PaperId;
p.PaperName = item.PaperName;
ListPaper.Add(p);
}
return(ListPaper);
}
public ActionResult Create(PaperDTO obj, FormCollection collection)
{
try
{
if (string.IsNullOrEmpty(Convert.ToString(obj.StateId)))
{
ModelState.AddModelError("Error", "Please Select State");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.CityId)))
{
ModelState.AddModelError("Error", "Please Select City");
}
else
{
obj.PaperId = 0;
obj.CreatedBy = Convert.ToInt32(Session["UserID"]);
DateTime timeUtc = System.DateTime.UtcNow;
TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone);
obj.CreatedDate = cstTime;
TempData["MessageRegistration"] = "Data Saved Successfully!";
objPaperMaster.InsertPaper(obj);
return(RedirectToAction("Create"));
}
obj.ListState = BindListState();
obj.ListCity = BindListCity();
ViewData["SelectedState"] = obj.StateId;
ViewData["SelectedCity"] = obj.CityId;
return(View(obj));
}
catch (Exception)
{
throw;
}
}
public async Task <ActionResult <PaperDTO> > Register(PaperDTO paperDTO)
{
var p = new Paper {
Id = paperDTO.Id,
Name = paperDTO.Name,
Duration = paperDTO.Duration,
PassScore = paperDTO.PassScore,
eval = paperDTO.eval,
SubjId = paperDTO.SubjId
};
this.Context.Papers.Add(p);
await this.Context.SaveChangesAsync();
return(new PaperDTO {
Id = p.Id,
Name = p.Name,
Duration = p.Duration,
PassScore = p.PassScore,
eval = p.eval,
SubjId = p.SubjId
});
}
public void Method(PaperDTO objpaper)
{
ModelState.Remove("ListState");
List <StateDTO> liststate = new List <StateDTO>();
liststate = new List <StateDTO>()
{
new StateDTO {
StateId = 0, StateName = "Select"
}
};
foreach (var item in objState.GetStates())
{
StateDTO sm = new StateDTO();
sm.StateId = item.StateId;
sm.StateName = item.StateName;
liststate.Add(sm);
}
objpaper.ListState = liststate;
}
