public List <SelectListDto> GetSLAccountHeads(int GLAccountId)
{
List <SelectListDto> lstdto = new List <SelectListDto>();
try
{
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
SqlCommand cmd = new SqlCommand(ProcNames.uspGetSLAccountsByGLAccountId, con);
cmd.Parameters.AddWithValue("@GLAccountId", GLAccountId);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
SelectListDto selectListDto;
while (dr.Read())
{
selectListDto = new SelectListDto();
selectListDto.ID = Convert.ToInt32(dr["AHID"]);
selectListDto.Text = Convert.ToString(dr["AHName"]);
lstdto.Add(selectListDto);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstdto);
}
public List <SelectListDto> GetStatusSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspStatusMasterGetAll_Result> lstuspStatusMasterGetAll_Result = _dbContext.uspStatusMasterGetAll().ToList();
foreach (var status in lstuspStatusMasterGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = status.StatusID,
Text = status.Status
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetGroupCodeByClusterID(int Id)
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGroupNameGetByClusterID_Result> lstuspGroupGetAll_Result = _dbContext.uspGroupNameGetByClusterID(Id).ToList();
foreach (var group in lstuspGroupGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = group.GroupID,
Text = group.GroupCode + ':' + group.GroupName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetEmployeeCodeSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspEmployeeGetAll_Result> lstuspEmployeeGetAll_Result = _dbContext.uspEmployeeGetAll().ToList();
foreach (var objuspEmployeeGetAll_Result in lstuspEmployeeGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = objuspEmployeeGetAll_Result.EmployeeID,
Text = objuspEmployeeGetAll_Result.EmployeeCode
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetGroupsSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGroupGetAll_Result> lstuspGroupGetAll_Result = _dbContext.uspGroupGetAll().ToList();
foreach (var group in lstuspGroupGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = group.GroupID,
Text = group.GroupName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetAHCodeByIsMemberTransaction()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspAccountGetAHCODEByIsmemberTransaction_Result> lstuspAccountGetAHCODEByIsmemberTransaction_Result = _dbContext.uspAccountGetAHCODEByIsmemberTransaction().ToList();
foreach (var ahcode in lstuspAccountGetAHCODEByIsmemberTransaction_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = ahcode.AHID,
Text = ahcode.AHCode
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetFederaionAccountHeadSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <AccountHeadDto> lstAh = GetAll(true).ToList();
foreach (var objuspAccountHeadGetAll_Result in lstAh)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = objuspAccountHeadGetAll_Result.AHID,
Text = objuspAccountHeadGetAll_Result.AHName + " - (" + objuspAccountHeadGetAll_Result.AHCode + ")"
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetProjectSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspProjectGetAll_Result> lstuspProjectGetAll_Result = _dbContext.uspProjectGetAll().ToList();
foreach (var project in lstuspProjectGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = project.ProjectID,
Text = project.ProjectName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetEmployeeCodeByGroupId(int GroupId)
{
List <SelectListDto> lstSelectList = new List <SelectListDto>();
List <uspGroupEmployeeGetByGroupID_Result> lstuspGroupEmployeeGetByGroupID_Result = _dbContext.uspGroupEmployeeGetByGroupID(GroupId).ToList();
foreach (var employee in lstuspGroupEmployeeGetByGroupID_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = employee.EmployeeID,
Text = employee.EmployeeCode
};
lstSelectList.Add(objSelectListDto);
}
return(lstSelectList);
}
public List <SelectListDto> GetMemberCodeByGroupId(int GroupId)
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspMemberByGroupId_Result> uspMemberByGroupId_Result = _dbContext.uspMemberByGroupId(GroupId).ToList();
foreach (var group in uspMemberByGroupId_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = group.MemberID,
Text = group.MemberCode
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetGroupsSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGroupEmployeeGetALL_Result> lstuspGroupEmployeeGetAll = _dbContext.uspGroupEmployeeGetALL().ToList();
foreach (var Groups in lstuspGroupEmployeeGetAll)
{
SelectListDto objSelectlistDto = new SelectListDto()
{
ID = Groups.GroupID,
Text = Groups.GroupName
};
lstSelectListDto.Add(objSelectlistDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetFundSourceSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspFundSourceGetAll_Result> lstuspFundSourceGetAll_Result = _dbContext.uspFundSourceGetAll().ToList();
foreach (var fundSource in lstuspFundSourceGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = fundSource.FundSourceID,
Text = string.Format("{0} ( {1} )", fundSource.FundSourceName, fundSource.FundSourceCode)
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetClusterSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspClusterGetAll_Result> lstCluster = _dbContext.uspClusterGetAll().ToList();
foreach (var cluster in lstCluster)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = cluster.ClusterID,
Text = cluster.ClusterName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetVillageSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspVillageGetAll_Result> uspVillageGetAll_Result = _dbContext.uspVillageGetAll().ToList();
foreach (var village in uspVillageGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = village.VillageID,
Text = village.Village
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetAccountHeadSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspAccountHeadGetAll_Result> lstuspAccountHeadGetAll_Result = _dbContext.uspAccountHeadGetAll().ToList();
foreach (var objuspAccountHeadGetAll_Result in lstuspAccountHeadGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = objuspAccountHeadGetAll_Result.AHID,
Text = objuspAccountHeadGetAll_Result.AHName + " - (" + objuspAccountHeadGetAll_Result.AHCode + ")"
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetLeadershiplevelSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGetLeadershipLevel_Result> uspGetLeadershipLevel_Result = _dbContext.uspGetLeadershipLevel().ToList();
foreach (var level in uspGetLeadershipLevel_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = level.EntityID,
Text = level.EntityName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetGroupByVillageID(int villageID)
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGroupNameGetByVillageID_Result> lsuspGroupNameGetByVillageID_Result = _dbContext.uspGroupNameGetByVillageID(villageID).ToList();
foreach (var group in lsuspGroupNameGetByVillageID_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = group.GroupID,
Text = group.GroupName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetLoanPurposeSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspLoanPurposeGetAll_Result> lstuspLoanPurposeGetAll_Result = _dbContext.uspLoanPurposeGetAll().ToList();
foreach (var Loan in lstuspLoanPurposeGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = Loan.LoanPurposeID,
Text = Loan.Purpose
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetDistrictSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspDistrictGetAll_Result> lstuspDistrictGetAll_Result = _dbContext.uspDistrictGetAll().ToList();
foreach (var district in lstuspDistrictGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = district.DistrictID,
Text = district.District
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetOccupationSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspOccupationGetAll_Result> lstuspOccupationGetAll_Result = _dbContext.uspOccupationGetAll().ToList();
foreach (var occupation in lstuspOccupationGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = occupation.OccupationID,
Text = occupation.Occupation
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetMandalSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspMandalGetAll_Result> lstuspMandalGetAll_Result = _dbContext.uspMandalGetAll().ToList();
foreach (var mandal in lstuspMandalGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = mandal.MandalID,
Text = mandal.Mandal
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetLoanSecurityMasterSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspLoanSecurityMasterGetAll_Result> lstuspLoanSecurityMasterGetAll_Result = _dbContext.uspLoanSecurityMasterGetAll().ToList();
foreach (var loansecurity in lstuspLoanSecurityMasterGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = loansecurity.LoanSecurityID,
Text = loansecurity.LoanSecurityName
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetRoleSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspGetRoles_Result> lstuspGetRoles_Result = _dbContext.uspGetRoles().ToList();
foreach (var role in lstuspGetRoles_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = role.RoleId,
Text = role.rolename
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetBankSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspBankMasterGetAll_Result> lstuspBankMasterGetAll_Result = _dbContext.uspBankMasterGetAll().ToList();
foreach (var bank in lstuspBankMasterGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = bank.BankEntryID,
Text = bank.BankName.ToString()
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetOrganizationSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspOrganizationGetAll_Result> lstuspOrganizationGetAll_Result = _dbContext.uspOrganizationGetAll(null).ToList();
foreach (var organization in lstuspOrganizationGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = organization.OrgID,
Text = organization.OrgName.ToString()
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetBranchSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspBranchGetAll_Result> lstuspBranchGetAll_Result = _dbContext.uspBranchGetAll().ToList();
foreach (var branch in lstuspBranchGetAll_Result)
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = branch.BranchID,
Text = branch.BranchName.ToString()
};
lstSelectListDto.Add(objSelectListDto);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetDepositInterestsSelectList()
{
List <SelectListDto> lstSelectListDto = new List <SelectListDto>();
List <uspInterestGetAll_Result> lstuspInterestGetAll_Result = _dbContext.uspInterestGetAll().ToList();
foreach (var interest in lstuspInterestGetAll_Result)
{
if (interest.InterestCode.ToUpper().StartsWith("DIR-"))
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = interest.InterestID,
Text = interest.InterestName
};
lstSelectListDto.Add(objSelectListDto);
}
}
return(lstSelectListDto);
}
public List <SelectListDto> GetRefDropDownByRefMasterCode(string refMasterCode)
{
var lstSelectListDto = new List <SelectListDto>();
var referenceValues = new List <ReferenceValueDto>();
ReferenceValueService _referenceValueService = new ReferenceValueService();
referenceValues = _referenceValueService.GetByRefMasterCode(refMasterCode);
foreach (var refvalue in referenceValues)
{
SelectListDto selectlist = new SelectListDto()
{
ID = refvalue.RefID,
Text = refvalue.RefValue
};
lstSelectListDto.Add(selectlist);
}
return(lstSelectListDto);
}
public List <SelectListDto> GetGeneralLedgerAccountHeads(int?groupId)
{
List <SelectListDto> accountHeadlist = new List <SelectListDto>();
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("uspGetGeneralLedgerAccountHeads", parms);
while (Dr.Read())
{
SelectListDto objSelectListDto = new SelectListDto()
{
ID = Convert.ToInt32(Dr["AHID"]),
Text = Convert.ToString(Dr["AHName"]) + " - (" + Convert.ToString(Dr["AHCode"]) + ")"
};
accountHeadlist.Add(objSelectListDto);
}
return(accountHeadlist);
}
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));
}