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)); }