public static int UpdateGroupMeeting(GroupMeeting groupMeeting)
{
{
int rowAffected = 0;
using (IDbConnection con = new SqlConnection(GroupMeeting.strConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", groupMeeting.Id);
parameters.Add("@ProjectName", groupMeeting.ProjectName);
parameters.Add("@GroupMeetingLeadName", groupMeeting.GroupMeetingLeadName);
parameters.Add("@TeamLeadName", groupMeeting.TeamLeadName);
parameters.Add("@Description", groupMeeting.Description);
parameters.Add("@GroupMeetingDate", groupMeeting.GroupMeetingDate);
rowAffected = con.Execute("UpdateGroupMeeting", parameters, commandType: CommandType.StoredProcedure);
}
return(rowAffected);
}
}
public IActionResult DeleteMeeting(int id, GroupMeeting groupMeeting)
{
if (GroupMeeting.DeleteGroupMeeting(id) > 0)
{
return(RedirectToAction("Index"));
}
return(View(groupMeeting));
}
public IActionResult DeleteMeeting(int id)
{
GroupMeeting group = GroupMeeting.GetGroupMeetingById(id);
if (group == null)
{
return(NotFound());
}
return(View(group));
}
public IActionResult Delete(int id, GroupMeeting groupMeeting)
{
var deleteResult = groupMeetingService.GetGroupMeetingById(id);
if (groupMeetingService.DeleteGroupMeeting(id) > 0)
{
return(RedirectToAction("Index"));
}
return(View());
}
public IActionResult AddGroupMeeting([Bind] GroupMeeting groupMeeting)
{
if (ModelState.IsValid)
{
if (GroupMeeting.AddGroupMeeting(groupMeeting) > 0)
{
return(RedirectToAction("Index"));
}
}
return(View(groupMeeting));
}
public IActionResult AddGroupMeeting(GroupMeeting groupMeeting)
{
if (ModelState.IsValid)
{
if (GroupMeeting.InsertGroupMeeting(groupMeeting) > 0)
{
return(RedirectToAction(nameof(Index)));
}
}
return(View(groupMeeting));
}
//[ValidateAntiForgeryToken]
public IActionResult UpdateGroupMeeting(int id, [Bind] GroupMeeting groupMeeting)
{
if (id != groupMeeting.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
GroupMeeting.UpdateGroupMeeting(groupMeeting);
return(RedirectToAction(nameof(Index)));
}
return(View(groupMeeting));
}
public IActionResult Edit(int id, GroupMeeting group)
{
if (id != group.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
groupMeetingService.UpdateGroupMeeting(group);
return(RedirectToAction("Index"));
}
return(View(group));
}
public IActionResult EditMeeting(int?id)
{
if (id == null)
{
return(NotFound());
}
GroupMeeting group = GroupMeeting.GetGroupMeetingById(id);
if (group == null)
{
return(NotFound());
}
return(View(group));
}
// GET: GroupMeeting/Details/5
public IActionResult GroupMeetingDetails(int?id)
{
if (id == null)
{
return(NotFound());
}
var group = GroupMeeting.GetGroupMeetingById(id);
if (group == null)
{
return(NotFound());
}
return(View(group));
}
public IActionResult EditMeeting(int id, [Bind] GroupMeeting groupMeeting)
{
if (id != groupMeeting.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
GroupMeetingRepository.UpdateGroupMeeting(groupMeeting);
return(RedirectToAction("Index"));
}
return(View(groupMeeting));
}
public IActionResult Edit(int id, [Bind] GroupMeeting groupMeting)
{
if (id != groupMeting.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
groupMeeting.UpdateGroupMeeting(groupMeting);
return(RedirectToAction("Index"));
}
ViewBag.Rooms = GetRooms();
return(View(groupMeting));
}
public static GroupMeeting GetGroupMeetingByID(int?Id)
{
GroupMeeting groupMeeting = new GroupMeeting();
if (Id == null)
{
return(groupMeeting);
}
using (IDbConnection con = new SqlConnection(GroupMeeting.strConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", Id);
groupMeeting = con.Query <GroupMeeting>
("GetGroupMeetingByID", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
return(groupMeeting);
}
public void Create(MeetingModel model, string username)
{
try
{
_unitOfWork.BeginTransaction();
GroupMeeting meeting = new GroupMeeting
{
Description = model.Description,
GroupMeetingDate = model.GroupMeetingDate,
GroupMeetingLeadName = model.GroupMeetingLeadName,
ProjectName = model.ProjectName,
TeamLeadName = model.TeamLeadName
};
_repository.Insert(meeting);
_unitOfWork.Commit();
}
catch (System.Exception e)
{
_unitOfWork.Rollback();
throw e;
}
}
public IActionResult Index()
{
return(View(GroupMeeting.GetGroupMeetings()));
}
