public List <GroupMeetingDto> GetMeetingInfoByGroupID(int groupId)
{
GroupMeetingDto grpMeetingDto = null;
List <GroupMeetingDto> lstGroup = new List <GroupMeetingDto>();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupId", groupId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader Dr = obj.ExecDataReaderProc("UspGetGroupMeeitngInfo", parms);
while (Dr.Read())
{
grpMeetingDto = new GroupMeetingDto();
grpMeetingDto.GroupMeetingID = Convert.ToInt32(Dr["GroupMeetingID"]);
grpMeetingDto.IsConducted = Convert.ToBoolean(Dr["IsConducted"]);
grpMeetingDto.IsSplMeeting = Convert.ToBoolean(Dr["IsSplMeeting"]);
grpMeetingDto.MeetingType = grpMeetingDto.IsSplMeeting == true ? "Special" : "Regular";
grpMeetingDto.MeetingMemberCount = Convert.ToInt32(Dr["MemberCount"]);
grpMeetingDto.MeetingDate = Convert.ToDateTime(Dr["MeetingDate"]);
lstGroup.Add(grpMeetingDto);
}
return(lstGroup);
}
private ResultDto InsertUpdateGroupMeeting(GroupMeetingDto Groupmeeting)
{
GroupMeetingDAL groupMeetingDAL = new GroupMeetingDAL();
ResultDto resultdto = new ResultDto();
string obectName = "Group Meeting";
string GroupMeetingmember = CommonMethods.SerializeListDto <List <GroupMeetingMembersDto> >(Groupmeeting.lstgroupMembersDto);
resultdto = groupMeetingDAL.InsertUpdateGroupMeeting(Groupmeeting, GroupMeetingmember);
return(resultdto);
}
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 GroupMeetingDto GetDate(int groupId)
{
GroupMeetingDto grpMeetingDto = null;
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupId", groupId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader Dr = obj.ExecDataReaderProc("UspGroupCurrentMeeitngDate", parms);
if (Dr.Read())
{
grpMeetingDto = new GroupMeetingDto();
grpMeetingDto.Month = Convert.ToInt32(Dr["MeetingMonth"]);
grpMeetingDto.Year = Convert.ToInt32(Dr["MeetingYear"]);
grpMeetingDto.GroupMeetingDay = Convert.ToInt32(Dr["MeetingDay"]);
}
return(grpMeetingDto);
}
public List <GroupMeetingDto> GetMeetingDates(int GroupId)
{
List <GroupMeetingDto> lstgroupMeetingDto = new List <GroupMeetingDto>();
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
SqlCommand cmd = new SqlCommand(ProcNames.uspGroupMeetingCurrentDates, con);
cmd.Parameters.AddWithValue("@GroupId", GroupId);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
GroupMeetingDto groupMeetingDto;
while (dr.Read())
{
groupMeetingDto = new GroupMeetingDto();
groupMeetingDto.GroupMeetingID = Convert.ToInt32(dr["GroupMeetingID"]);
groupMeetingDto.MeetingDate = Convert.ToDateTime(dr["MeetingDate"]);
lstgroupMeetingDto.Add(groupMeetingDto);
}
con.Close();
return(lstgroupMeetingDto);
}
public ActionResult CreateGroupMeeting(string Id)
{
int GroupMeetingId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt32(Id.DecryptString());
GroupMeetingDto groupmeetingdto = new GroupMeetingDto();
if (GroupMeetingId > 0)
{
groupmeetingdto = _groupmeetingService.GetByID(GroupMeetingId);
groupmeetingdto.IsConducted = !groupmeetingdto.IsConducted;
}
if (groupmeetingdto.lstgroupMembersDto == null || groupmeetingdto.lstgroupMembersDto.Count() < 1)
{
var newMembers = _memberService.GetByGroupId(GroupInfo.GroupID);
var members = new List <GroupMeetingMembersDto>();
foreach (var newmember in newMembers)
{
members.Add(new GroupMeetingMembersDto()
{
IsAttended = false, MemberID = newmember.MemberID, MemberName = newmember.MemberName
});
}
groupmeetingdto.lstgroupMembersDto = members;
}
GroupMeetingDAL dal = new GroupMeetingDAL();
GroupMeetingDto MeetngDateGroupMeetingDto = dal.GetDate(GroupInfo.GroupID);
if (MeetngDateGroupMeetingDto != null)
{
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(MeetngDateGroupMeetingDto.Month).ToString();
groupmeetingdto.Month = MeetngDateGroupMeetingDto.Month;
groupmeetingdto.Year = MeetngDateGroupMeetingDto.Year;
groupmeetingdto.GroupMeetingDay = MeetngDateGroupMeetingDto.GroupMeetingDay;
groupmeetingdto.MonthName = strMonthName;
int NoOfDays = DateTime.DaysInMonth(groupmeetingdto.Year, groupmeetingdto.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);
}
int GroupMeetingDay = GroupMeetingId > 0 ? groupmeetingdto.MeetingDate.Day : groupmeetingdto.GroupMeetingDay;
if (TempData["Result"] != null)
{
ViewBag.Result = TempData["Result"];
}
SelectList slDates = new SelectList(lstDates, "ID", "Text", GroupMeetingDay);
ViewBag.Dates = slDates;
}
SelectList Reason = GetDropDownListByMasterCode(Enums.RefMasterCodes.REASON);
ViewBag.Reason = Reason;
List <GroupMeetingDto> lstGroupMeeting = dal.GetMeetingInfoByGroupID(GroupInfo.GroupID);
ViewBag.lstGroupInfo = lstGroupMeeting;
return(View(groupmeetingdto));
}
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"));
}
public ResultDto Update(GroupMeetingDto Groupmeeting)
{
return(InsertUpdateGroupMeeting(Groupmeeting));
}
public ResultDto InsertUpdateGroupMeeting(GroupMeetingDto Groupmeeting, string GroupMeetingMembers)
{
AdoHelper obj = new AdoHelper();
ResultDto resultDto = new ResultDto();
string obectName = "Group Meeting";
try
{
SqlParameter[] parms = new SqlParameter[12];
parms[0] = new SqlParameter("@GroupId", Groupmeeting.GroupID);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
parms[1] = new SqlParameter("@MeetingObjective", Groupmeeting.MeetingObjective);
parms[1].SqlDbType = System.Data.SqlDbType.VarChar;
parms[2] = new SqlParameter("@MeetingComments", Groupmeeting.MeetingComments);
parms[2].SqlDbType = System.Data.SqlDbType.VarChar;
parms[3] = new SqlParameter("@MeetingDate", Groupmeeting.MeetingDate);
parms[3].SqlDbType = System.Data.SqlDbType.Date;
parms[4] = new SqlParameter("@TransactionDate", Groupmeeting.TransactionDate);
parms[4].SqlDbType = System.Data.SqlDbType.Date;
parms[5] = new SqlParameter("@IsConducted", Groupmeeting.IsConducted);
parms[5].SqlDbType = System.Data.SqlDbType.Bit;
parms[6] = new SqlParameter("@IsSplMeeting", Groupmeeting.IsSplMeeting);
parms[6].SqlDbType = System.Data.SqlDbType.Bit;
parms[7] = new SqlParameter("@Reason", Groupmeeting.Reason);
parms[7].SqlDbType = System.Data.SqlDbType.VarChar;
parms[8] = new SqlParameter("@OtherReason", Groupmeeting.OtherReason);
parms[8].SqlDbType = System.Data.SqlDbType.VarChar;
parms[9] = new SqlParameter("@UserId", Groupmeeting.UserId);
parms[9].SqlDbType = System.Data.SqlDbType.Int;
parms[10] = new SqlParameter("@GroupMeetingmember", GroupMeetingMembers);
parms[10].SqlDbType = System.Data.SqlDbType.NVarChar;
parms[11] = new SqlParameter("@GroupMeetingID", Groupmeeting.GroupMeetingID);
parms[11].SqlDbType = System.Data.SqlDbType.Int;
parms[11].Direction = ParameterDirection.InputOutput;
obj.ExecNonQueryProc("UspGroupMeetingInsertUpdate", parms);
resultDto.ObjectId = (int)parms[11].Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details saved successfully", obectName);
}
else if (resultDto.ObjectId == -99)
{
resultDto.Message = string.Format("Error occured while saving {0} details", obectName);
}
else if (resultDto.ObjectId == -98)
{
resultDto.Message = string.Format("MEETING ALREADY CONDUCTED/NOT CONDUCTED BOTH TYPE OF ENTRIES NOT POSSIBLE", obectName);
}
else if (resultDto.ObjectId == -97)
{
resultDto.Message = string.Format("MULTIPLE NOT CONDUCTED SHOULD NOT ALLOWED", obectName);
}
else if (resultDto.ObjectId == -96)
{
resultDto.Message = string.Format("ALREADY MEETING EXISTIS WITH GIVEN DATE", obectName);
}
}
catch (Exception)
{
resultDto.Message = string.Format("Service layer error occured while saving the {0} details", obectName);
resultDto.ObjectId = -98;
}
return(resultDto);
}
