public GroupMeetingDto GetGroupMeetingDetailsByID(int groupMeetingId)
{
GroupMeetingDto meetingInfo = new GroupMeetingDto();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupMeetingID", groupMeetingId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader dr = obj.ExecDataReaderProc("uspGroupMeetingGetById", parms);
if (dr.Read())
{
meetingInfo.GroupMeetingID = Convert.ToInt32(dr["GroupMeetingID"]);
meetingInfo.GroupID = Convert.ToInt32(dr["GroupID"]);
meetingInfo.MeetingComments = Convert.ToString(dr["MeetingComments"]);
meetingInfo.MeetingObjective = Convert.ToString(dr["MeetingObjective"]);
meetingInfo.MeetingDate = Convert.ToDateTime(dr["MeetingDate"]);
if (dr["TransactionDate"] != DBNull.Value)
{
meetingInfo.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]);
}
meetingInfo.IsConducted = Convert.ToBoolean(dr["IsConducted"]);
meetingInfo.IsSplMeeting = Convert.ToBoolean(dr["IsSplMeeting"]);
if (dr["Reason"] != DBNull.Value)
{
meetingInfo.Reason = Convert.ToInt32(dr["Reason"]);
}
meetingInfo.ReasonName = Convert.ToString(dr["ReasonName"]);
meetingInfo.OtherReason = Convert.ToString(dr["OtherReason"]);
}
if (dr.NextResult())
{
meetingInfo.lstgroupMembersDto = new List <GroupMeetingMembersDto>();
GroupMeetingMembersDto objMeetingMemberDto = null;
while (dr.Read())
{
objMeetingMemberDto = new GroupMeetingMembersDto();
objMeetingMemberDto.MemberID = Convert.ToInt32(dr["MemberID"]);
objMeetingMemberDto.IsAttended = Convert.ToBoolean(dr["IsAttended"]);
objMeetingMemberDto.MemberName = Convert.ToString(dr["MemberName"]);
meetingInfo.lstgroupMembersDto.Add(objMeetingMemberDto);
}
}
return(meetingInfo);
}
public ActionResult CreateGroupMeeting(GroupMeetingDto objmeeting, FormCollection form)
{
SelectList Reason = GetDropDownListByMasterCode(Enums.RefMasterCodes.REASON);
ViewBag.Reason = Reason;
if (form["TransactionDate"].Trim() != string.Empty)
{
objmeeting.TransactionDate = Convert.ToDateTime(form["TransactionDate"]);
}
string MeetingDate = form["MeetingYearMonth"] + "-" + form["MeetingDay"];
objmeeting.MeetingDate = Convert.ToDateTime(MeetingDate);
objmeeting.IsConducted = !objmeeting.IsConducted;
objmeeting.GroupID = GroupInfo.GroupID;
objmeeting.UserId = UserInfo.UserID;
int maxIndex = Convert.ToInt32(form["hdnIndex"]);
objmeeting.lstgroupMembersDto = new List <GroupMeetingMembersDto>();
GroupMeetingMembersDto members = null;
for (int i = 1; objmeeting.IsConducted && i <= maxIndex; i++)
{
if (form["hdnMemberID_" + i] == null)
{
continue;
}
members = new GroupMeetingMembersDto();
members.MemberID = Convert.ToInt32(form["hdnMemberID_" + i]);
members.MemberName = form["hdnMember_" + i];
if (form["Checkmember_" + i] == "on")
{
members.IsAttended = true;
}
objmeeting.lstgroupMembersDto.Add(members);
}
var resultDto = new ResultDto();
objmeeting.GroupMeetingID = Convert.ToInt32(form["GroupMeetingID"]);
if (objmeeting.GroupMeetingID == 0)
{
resultDto = _groupmeetingService.Insert(objmeeting);
}
else
{
resultDto = _groupmeetingService.Update(objmeeting);
}
UpdateGroupInfoSessionbyGroupId(GroupInfo.GroupID);
TempData["Result"] = resultDto;
GroupMeetingDto MeetngDateGroupMeetingDto = dal.GetDate(GroupInfo.GroupID);
if (MeetngDateGroupMeetingDto != null)
{
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(MeetngDateGroupMeetingDto.Month).ToString();
objmeeting.Month = MeetngDateGroupMeetingDto.Month;
objmeeting.Year = MeetngDateGroupMeetingDto.Year;
objmeeting.GroupMeetingDay = MeetngDateGroupMeetingDto.GroupMeetingDay;
objmeeting.MonthName = strMonthName;
int NoOfDays = DateTime.DaysInMonth(objmeeting.Year, objmeeting.Month);
List <SelectListDto> lstDates = new List <SelectListDto>();
SelectListDto dateSelectListDto = null;
for (int i = 1; i <= NoOfDays; i++)
{
dateSelectListDto = new SelectListDto();
dateSelectListDto.ID = i;
dateSelectListDto.Text = i.ToString();
lstDates.Add(dateSelectListDto);
}
SelectList slDates = new SelectList(lstDates, "ID", "Text", objmeeting.GroupMeetingDay);
ViewBag.Dates = slDates;
List <GroupMeetingDto> lstGroupMeeting = dal.GetMeetingInfoByGroupID(GroupInfo.GroupID);
ViewBag.lstGroupInfo = lstGroupMeeting;
}
return(RedirectToAction("GroupMeetingLookup"));
}
