public static List <MemberList> GetClubsMemberList(GroupInfo input) { try { MySqlParameter[] parameterList = new MySqlParameter[2]; parameterList[0] = new MySqlParameter("?groupID", input.grpID); parameterList[1] = new MySqlParameter("?SearchText", input.SearchText); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_USPGetClubMemberList", parameterList); DataTable dtMemberList = result.Tables[0]; List <MemberList> memberList = new List <MemberList>(); if (dtMemberList.Rows.Count > 0) { memberList = GlobalFuns.DataTableToList <MemberList>(dtMemberList); foreach (MemberList mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } } return(memberList); } catch (Exception ex) { throw ex; } }
public static List <DistrictMemListResult> GetMemberByClassification(string classification, string groupID) { List <DistrictMemListResult> memberList = new List <DistrictMemListResult>(); try { MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("?classification", classification.Replace(" ", "%")); param[1] = new MySqlParameter("?groupID", groupID); DataSet dsMember = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_USPGetMemberByClassification", param); if (dsMember != null) { if (dsMember.Tables[0].Rows.Count > 0) { memberList = GlobalFuns.DataTableToList <DistrictMemListResult>(dsMember.Tables[0]); foreach (DistrictMemListResult mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } } } } catch { throw; } return(memberList); }
public static districtCommittee getDistrictCommitteeList(districtCommitteeInput Obj) { try { MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("@p_groupId", Obj.groupID); param[1] = new MySqlParameter("@p_searchText", Obj.searchText); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "API_districtCommitteeList", param); DataTable dt_WithoutCatlist = Result.Tables[0]; DataTable dt_withcatlist = Result.Tables[1]; List <districtCommitteeWithoutCatList> WithoutCategoryList = new List <districtCommitteeWithoutCatList>(); List <districtCommitteeWithCatList> WithDirectoryList = new List <districtCommitteeWithCatList>(); if (dt_WithoutCatlist.Rows.Count > 0) { foreach (DataRow item in dt_WithoutCatlist.Rows) { if (item["img"].ToString() != "") { if (item["fk_Member_profileID"].ToString() == "0") { string profile_Image = item["img"].ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/DistrictCommittee/Group" + Obj.groupID + "/thumb/"; item["img"] = path + profile_Image; } else { string profile_Image = item["img"].ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; item["img"] = path + profile_Image; } } else { item["img"] = ""; } } WithoutCategoryList = GlobalFuns.DataTableToList <districtCommitteeWithoutCatList>(dt_WithoutCatlist); } if (dt_withcatlist.Rows.Count > 0) { WithDirectoryList = GlobalFuns.DataTableToList <districtCommitteeWithCatList>(dt_withcatlist); } districtCommittee obj = new districtCommittee(); obj.districtCommitteeWithoutCatList = WithoutCategoryList; obj.districtCommitteeWithCatList = WithDirectoryList; return(obj); } catch (Exception ex) { throw ex; } }
/// <summary> /// Created By : Nandkishor K /// Created Date : 24/07/2017 /// Reason : Listing of Public Albums /// </summary> public static List <ClsAlbumList> GetPublicAlbumList(GroupInfo input) { try { MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?grpID", input.grpID); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "USPPublicAlbumList", parameterList); DataTable dtNewAlbums = result.Tables[0]; List <ClsAlbumList> NewMemberList = new List <ClsAlbumList>(); if (dtNewAlbums.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtNewAlbums); foreach (ClsAlbumList g in NewMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } } } return(NewMemberList); } catch (Exception ex) { throw ex; } }
/// <summary> /// Created By : Nandkishor K /// Created Date : 24/07/2017 /// Reason : Listing of Events(Only having Event Type - All) /// </summary> public static List <EventList1> GetPublicEventsList(GroupInfo input) { try { MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?grpID", input.grpID); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V3_USPPublicEventList", parameterList); DataTable dtEventList = result.Tables[0]; List <EventList1> PublicEventList = new List <EventList1>(); if (dtEventList.Rows.Count > 0) { PublicEventList = GlobalFuns.DataTableToList <EventList1>(dtEventList); foreach (EventList1 g in PublicEventList) { if (!string.IsNullOrEmpty(g.eventImg)) { string event_Image = g.eventImg.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + input.grpID + "/thumb/"; g.eventImg = path + event_Image; } } } return(PublicEventList); } catch (Exception ex) { throw ex; } }
public static List <classificationOutput> GetClassificationList(DistrictMemListInput obj, out int totalPages) { List <classificationOutput> Result = new List <classificationOutput>(); try { MySqlParameter[] param = new MySqlParameter[5]; param[0] = new MySqlParameter("?grpID", obj.grpID); param[1] = new MySqlParameter("?PageNo", string.IsNullOrEmpty(obj.pageNo) ? "1" : obj.pageNo); param[2] = new MySqlParameter("?NoOfRecord", string.IsNullOrEmpty(obj.recordCount) ? "100" : obj.recordCount); param[3] = new MySqlParameter("?TotalCount", DbType.Int32); param[4] = new MySqlParameter("?SearchText", string.IsNullOrEmpty(obj.searchText) ? "" : obj.searchText); param[3].Direction = ParameterDirection.Output; DataSet dsClassification = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7GetDistrictClassifications", param); totalPages = Convert.ToInt32(param[3].Value); if (dsClassification != null) { if (dsClassification.Tables[0].Rows.Count > 0) { Result = GlobalFuns.DataTableToList <classificationOutput>(dsClassification.Tables[0]); } } } catch { throw; } return(Result); }
/// <summary> /// Created By : Nandkishor K /// Created Date : 24/07/2017 /// Reason : Listing of Newsletters(Only having Newsletters Type - All) /// </summary> public static List <EbulletinList> GetPublicNewsletterList(GroupInfo input) { try { MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?grpID", input.grpID); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V2_USPPublicEbulletinList", parameterList); DataTable dtNewsletterList = result.Tables[0]; List <EbulletinList> PublicNewsletterList = new List <EbulletinList>(); if (dtNewsletterList.Rows.Count > 0) { PublicNewsletterList = GlobalFuns.DataTableToList <EbulletinList>(dtNewsletterList); foreach (EbulletinList g in PublicNewsletterList) { if (!string.IsNullOrEmpty(g.ebulletinlink) && g.ebulletinType != "Link") { string ebulletinlink = g.ebulletinlink.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/ebulletin/Group" + input.grpID + "/"; g.ebulletinlink = path + ebulletinlink; } } } return(PublicNewsletterList); } catch (Exception ex) { throw ex; } }
public object GetAnnouncementList(AnnouncementSearch ann) { dynamic TBAnnounceListResult; List <object> AnnounListResult = new List <object>(); DataSet Result = new DataSet(); try { string search = ""; if (ann.searchText == null) { search = ""; } else { search = ann.searchText; } Result = Announcement.GetAnnouncementList(ann, search); DataTable dt = Result.Tables[0]; DataTable dt1 = Result.Tables[1]; List <AnnounceList> res = new List <AnnounceList>(); if (dt.Rows.Count > 0) { res = GlobalFuns.DataTableToList <AnnounceList>(dt); if (!string.IsNullOrEmpty(res[0].announImg)) { string announ_Image = res[0].announImg.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/announcement/Group" + ann.groupId + "/thumb/"; res[0].announImg = path + announ_Image; } } for (int i = 0; i < res.Count; i++) { AnnounListResult.Add(new { AnnounceList = res[i] }); } if (res != null && res.Count != 0) { TBAnnounceListResult = new { status = "0", message = "success", smscount = dt1.Rows[0]["SMSCount"].ToString(), AnnounListResult = AnnounListResult }; } else { TBAnnounceListResult = new { status = "1", message = "Record not found", smscount = dt1.Rows[0]["SMSCount"].ToString(), AnnounListResult = AnnounListResult }; } } catch { TBAnnounceListResult = new { status = "1", message = "failed", smscount = 0 }; } return(new { TBAnnounceListResult }); }
public object GetWelcomeScreen(UserLogin user) { string message; string Status; int uId = Convert.ToInt32(user.masterUID); var memberName = ""; //var grpPartResults = ""; try { List <object> grpPartResults = new List <object>(); DataSet ds_Data = Login.Get_Welcomescreen_Data(user); List <GrpPartResult> GrpPartResult = null; if (ds_Data.Tables[0].Rows.Count > 0) { memberName = ds_Data.Tables[0].Rows[0]["member_name"].ToString(); } if (ds_Data.Tables[1].Rows.Count > 0) { GrpPartResult = GlobalFuns.DataTableToList <GrpPartResult>(ds_Data.Tables[1]); } for (int i = 0; i < GrpPartResult.Count; i++) { grpPartResults.Add(new { GrpPartResult = GrpPartResult[i] }); } if (grpPartResults.Count > 0) { message = "Success"; Status = "0"; var WelcomeResult = new { status = Status, message = message, Name = memberName, grpPartResults }; return(new { WelcomeResult }); } else { var WelcomeResult = new { status = "1", message = "User does not belong to any group", grpPartResults }; return(new { WelcomeResult }); } } catch { var WelcomeResult = new { status = "1", message = "An error occurred, please try again or contact the administrator" }; return(new { WelcomeResult }); } }
public object GetLeaderBoardDetails(LeaderBoard_Input Obj) { dynamic TBLeaderBoardResult; List <object> LeaderBoardResult = new List <object>(); try { DataSet ds_details = LeaderBoard.getLeaderBoardDetails(Obj); List <LeaderBoard_clubList> Result = GlobalFuns.DataTableToList <LeaderBoard_clubList>(ds_details.Tables[1]); string TotalProjectsstr = "0"; string ProjectCoststr = "0"; string BeneficiaryCountstr = "0"; string ManHoursCountstr = "0"; string RotariansCountstr = "0"; string MembersCountstr = "0"; string TRFCountstr = "0"; if (ds_details.Tables[0].Rows.Count > 0) { string[] commandArgs = ds_details.Tables[0].Rows[0]["ClubsDetails"].ToString().Split(new char[] { '|' }); TotalProjectsstr = commandArgs[0].ToString(); ProjectCoststr = commandArgs[1].ToString(); BeneficiaryCountstr = commandArgs[2].ToString(); ManHoursCountstr = commandArgs[3].ToString(); RotariansCountstr = commandArgs[4].ToString(); MembersCountstr = commandArgs[5].ToString(); TRFCountstr = commandArgs[6].ToString(); } for (int i = 0; i < Result.Count; i++) { LeaderBoardResult.Add(new { LeaderBoardResult = Result[i] }); } if (LeaderBoardResult != null) { TBLeaderBoardResult = new { status = "0", message = "success", TotalProjects = TotalProjectsstr, ProjectCost = ProjectCoststr, BeneficiaryCount = BeneficiaryCountstr, ManHoursCount = ManHoursCountstr, RotariansCount = RotariansCountstr, MembersCount = MembersCountstr, TRFCount = TRFCountstr, LeaderBoardResult }; } else { TBLeaderBoardResult = new { status = "0", message = "Record not found" }; } } catch { TBLeaderBoardResult = new { status = "1", message = "failed" }; } return(new { TBLeaderBoardResult }); }
public static RotarianDetailsOutput GetRotarianDetails(string profileID) { try { MySqlParameter[] param = new MySqlParameter[1]; param[0] = new MySqlParameter("?profileID", profileID); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V2_1_USPGetRotarianDetails", param); List <RotarianDetailsOutput> rowMember = new List <RotarianDetailsOutput>(); if (result != null) { DataTable dtMember = result.Tables[0]; if (dtMember.Rows.Count > 0) { rowMember = GlobalFuns.DataTableToList <RotarianDetailsOutput>(dtMember); if (!string.IsNullOrEmpty(rowMember[0].pic) && rowMember[0].pic != "profile_photo.png") { string ImageName = rowMember[0].pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; rowMember[0].pic = path + ImageName; } } if (result.Tables[1] != null) { if (result.Tables[1].Rows.Count > 0) { rowMember[0].BusinessAddress = result.Tables[1].Rows[0]["BusinessAddress"].ToString(); rowMember[0].city = result.Tables[1].Rows[0]["city"].ToString(); rowMember[0].state = result.Tables[1].Rows[0]["state"].ToString(); rowMember[0].country = result.Tables[1].Rows[0]["country"].ToString(); rowMember[0].pincode = result.Tables[1].Rows[0]["pincode"].ToString(); rowMember[0].Fax = result.Tables[1].Rows[0]["Fax"].ToString(); rowMember[0].phoneNo = result.Tables[1].Rows[0]["phoneNo"].ToString(); } else { rowMember[0].BusinessAddress = ""; rowMember[0].city = ""; rowMember[0].state = ""; rowMember[0].country = ""; rowMember[0].pincode = ""; rowMember[0].Fax = ""; rowMember[0].phoneNo = ""; } } } return(rowMember[0]); } catch (Exception ex) { throw ex; } }
public static ClsMonthCalenderOutput GetMonthEventList(ClsMonthCalenderInput monthCal) { try { string sqlProc; if (monthCal.groupCategory == "2") { sqlProc = "V7_USPGetDistrictEventByMonth_Calender"; } else { sqlProc = "V7_USPGetEventByMonth_Calender"; } MySqlParameter[] parameterList = new MySqlParameter[4]; parameterList[0] = new MySqlParameter("?GroupID", monthCal.groupId); parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId); parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate); parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); DataTable dtNewEvents = result.Tables[0]; DataTable dtUpdatedEvents = result.Tables[1]; DataTable dtDeletedEvents = result.Tables[2]; List <CalenderEventList> NewEventList = new List <CalenderEventList>(); if (dtNewEvents.Rows.Count > 0) { NewEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtNewEvents); } List <CalenderEventList> UpdatedEventList = new List <CalenderEventList>(); if (dtUpdatedEvents.Rows.Count > 0) { UpdatedEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtUpdatedEvents); } List <CalenderEventList> DeletedEventList = new List <CalenderEventList>(); if (dtDeletedEvents.Rows.Count > 0) { DeletedEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtDeletedEvents); } ClsMonthCalenderOutput calender = new ClsMonthCalenderOutput(); calender.newEvents = NewEventList; calender.updatedEvents = UpdatedEventList; calender.deletedEvents = DeletedEventList; return(calender); } catch { throw; } }
public object GetDocumentList(GetDocument doc) { dynamic TBDocumentistResult; List <object> DocumentListResult = new List <object>(); DataSet Result = new DataSet(); try { Result = DocumentSafe.GetDocumentList(doc); DataTable dt = Result.Tables[0]; DataTable dt1 = Result.Tables[1]; List <DocumentList> res = new List <DocumentList>(); if (dt.Rows.Count > 0) { res = GlobalFuns.DataTableToList <DocumentList>(dt); for (int i = 0; i < res.Count; i++) { if (!string.IsNullOrEmpty(res[i].docURL)) { string docURL = res[i].docURL.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/documentsafe/Group" + doc.grpID + "/"; res[i].docURL = path + docURL; } } } for (int i = 0; i < res.Count; i++) { DocumentListResult.Add(new { DocumentList = res[i] }); } if (res != null && res.Count != 0) { TBDocumentistResult = new { status = "0", message = "success", smscount = dt1.Rows[0]["SMSCount"].ToString(), DocumentLsitResult = DocumentListResult }; } else { TBDocumentistResult = new { status = "1", message = "Record not found", smscount = dt1.Rows[0]["SMSCount"].ToString(), DocumentLsitResult = DocumentListResult }; } } catch { TBDocumentistResult = new { status = "1", message = "failed", smscount = 0 }; } return(new { TBDocumentistResult }); }
public static ClubDetails GetClubDetails(string clubId) { try { MySqlParameter[] param = new MySqlParameter[1]; param[0] = new MySqlParameter("?clubId", clubId); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V1_USPClubDetails", param); DataTable dtclub = result.Tables[0]; DataTable dtpresident = result.Tables[1]; DataTable dtsecretary = result.Tables[2]; DataTable dtGovernor = result.Tables[3]; List <ClubDetails> ClubDetailList = new List <ClubDetails>(); if (dtclub.Rows.Count > 0) { ClubDetailList = GlobalFuns.DataTableToList <ClubDetails>(dtclub); } List <MemberDetl> presidentList = new List <MemberDetl>(); if (dtpresident.Rows.Count > 0) { presidentList = GlobalFuns.DataTableToList <MemberDetl>(dtpresident); } List <MemberDetl> secretaryList = new List <MemberDetl>(); if (dtpresident.Rows.Count > 0) { secretaryList = GlobalFuns.DataTableToList <MemberDetl>(dtsecretary); } List <MemberDetl> Governor = new List <MemberDetl>(); if (dtpresident.Rows.Count > 0) { Governor = GlobalFuns.DataTableToList <MemberDetl>(dtGovernor); } if (ClubDetailList.Count > 0) { ClubDetailList[0].president = presidentList; ClubDetailList[0].secretary = secretaryList; ClubDetailList[0].districtGovernor = Governor; } return(ClubDetailList[0]); } catch { throw; } }
public static clsPastPresidentsOutput GetPastPresidentsList(clsPastPresidentsInput inputParam) { try { MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("?GroupId", inputParam.GroupId); param[1] = new MySqlParameter("?SearchText", string.IsNullOrEmpty(inputParam.SearchText) ? "" : inputParam.SearchText.Replace(" ", "%").Trim()); param[2] = new MySqlParameter("?updateOn", inputParam.updateOn); DataSet ds = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V1_USPGetPastPresidentsList", param); DataTable dtNewRecords = ds.Tables[0]; DataTable dtUpdatedRecords = ds.Tables[1]; string strDeletedRecords = ds.Tables[2].Rows[0]["PastPresidentId"].ToString(); List <clsPastPresident> newRecords = new List <clsPastPresident>(); newRecords = GlobalFuns.DataTableToList <clsPastPresident>(dtNewRecords); foreach (clsPastPresident objPP in newRecords) { if (!string.IsNullOrEmpty(objPP.PhotoPath)) { objPP.PhotoPath = ConfigurationManager.AppSettings["imgPath"] + "Documents/pastpresidents/Group" + inputParam.GroupId + "/" + objPP.PhotoPath; } } List <clsPastPresident> updatedRecords = new List <clsPastPresident>(); updatedRecords = GlobalFuns.DataTableToList <clsPastPresident>(dtUpdatedRecords); foreach (clsPastPresident objPP in updatedRecords) { if (!string.IsNullOrEmpty(objPP.PhotoPath)) { objPP.PhotoPath = ConfigurationManager.AppSettings["imgPath"] + "Documents/pastpresidents/Group" + inputParam.GroupId + "/" + objPP.PhotoPath; } } clsPastPresidentsOutput obj = new clsPastPresidentsOutput(); obj.newRecords = newRecords; obj.updatedRecords = updatedRecords; obj.deletedRecords = strDeletedRecords; return(obj); } catch (Exception ex) { throw ex; } }
public static List <AnnounceList> GetAnnouncementDetails(AnnouncementDetail ann) { string repeatDateTime = ""; try { MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("@announID", ann.announID); param[1] = new MySqlParameter("@grpID", ann.grpID); param[2] = new MySqlParameter("@memberProfileID", ann.memberProfileID); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_USPGetAnnouncementDetails", param); DataTable dtAnnouncement = Result.Tables[0]; DataTable dtRepeatAnnouncement = Result.Tables[1]; List <AnnounceList> Anndetail = new List <AnnounceList>(); if (dtAnnouncement.Rows.Count > 0) { Anndetail = GlobalFuns.DataTableToList <AnnounceList>(dtAnnouncement); if (!string.IsNullOrEmpty(Anndetail[0].announImg)) { string announ_Image = Anndetail[0].announImg.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/announcement/Group" + ann.grpID + "/"; Anndetail[0].announImg = path + announ_Image; } if (dtRepeatAnnouncement.Rows.Count > 0) { for (int i = 0; i < dtRepeatAnnouncement.Rows.Count; i++) { repeatDateTime += dtRepeatAnnouncement.Rows[i]["annRepeatDate"].ToString() + ","; } repeatDateTime = repeatDateTime.TrimEnd(','); } Anndetail[0].repeatDateTime = repeatDateTime; } return(Anndetail); } catch (Exception ex) { throw ex; } }
public static List <DistrictMemListResult> GetDistrictMemberList(DistrictMemListInput obj, out int totalPages) { List <DistrictMemListResult> memberList = new List <DistrictMemListResult>(); try { if (!string.IsNullOrEmpty(obj.searchText)) { obj.searchText = obj.searchText.Replace(" ", "%"); } MySqlParameter[] param = new MySqlParameter[6]; param[0] = new MySqlParameter("?masterUID", obj.masterUID); param[1] = new MySqlParameter("?groupID", obj.grpID); param[2] = new MySqlParameter("?SearchText", string.IsNullOrEmpty(obj.searchText)?"":obj.searchText); param[3] = new MySqlParameter("?PageNo", string.IsNullOrEmpty(obj.pageNo)?"1":obj.pageNo); param[4] = new MySqlParameter("?NoOfRecord", string.IsNullOrEmpty(obj.recordCount)?"100":obj.recordCount); param[5] = new MySqlParameter("?TotalCount", DbType.Int32); param[5].Direction = ParameterDirection.InputOutput; DataSet dsMember = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_USPGetDistrictDirectoryList", param); totalPages = Convert.ToInt32(param[5].Value); if (dsMember != null) { if (dsMember.Tables[0].Rows.Count > 0) { memberList = GlobalFuns.DataTableToList <DistrictMemListResult>(dsMember.Tables[0]); foreach (DistrictMemListResult mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } } } } catch { throw; } return(memberList); }
//private static TouchBaseWebAPI.Data.row_productionEntities _DbTouchbase = new TouchBaseWebAPI.Data.row_productionEntities(); public static List <ClubMonthlyReportList> GetMonthlyReportList(ClubMonthlyReport_Input Obj) { try { MySqlParameter[] param = new MySqlParameter[5]; param[0] = new MySqlParameter("?p_profileId", Obj.profileId); param[1] = new MySqlParameter("?p_groupId", Obj.groupId); param[2] = new MySqlParameter("?p_month", Obj.month); param[3] = new MySqlParameter("?p_type", Obj.type); param[4] = new MySqlParameter("?p_Fk_ZoneID", Obj.Fk_ZoneID); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "USP_API_Mobile_GetMonthlyReportList", param); //var Result = _DbTouchbase.ExecuteStoreQuery<ClubMonthlyReportList>("CALL USP_API_Mobile_GetMonthlyReportList(?p_profileId,?p_groupId,?p_month,?p_type)", param).ToList(); DataTable dtResult = Result.Tables[0]; List <ClubMonthlyReportList> EbulletinList = new List <ClubMonthlyReportList>(); if (dtResult.Rows.Count > 0) { EbulletinList = GlobalFuns.DataTableToList <ClubMonthlyReportList>(dtResult); for (int i = 0; i < EbulletinList.Count; i++) { if (!string.IsNullOrEmpty(EbulletinList[i].reportUrl)) { string ebulletinlink = EbulletinList[i].reportUrl.ToString(); string path = System.Configuration.ConfigurationManager.AppSettings["imgPath"] + "Documents/Clubmonthly/Group" + EbulletinList[i].ClubId + "/"; EbulletinList[i].reportUrl = path + ebulletinlink; } } } return(EbulletinList); } catch (Exception ex) { throw ex; } }
public static List <ClsPhotoList> GetAlbumPhotoList_New(ClsPhotoListInput album) { try { MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?AlbumId", album.albumId); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_1_USPAlbumList_New", parameterList); DataTable dtNewPhoto = result.Tables[0]; List <ClsPhotoList> NewPhotoList = new List <ClsPhotoList>(); if (dtNewPhoto.Rows.Count > 0) { NewPhotoList = GlobalFuns.DataTableToList <ClsPhotoList>(dtNewPhoto); foreach (ClsPhotoList g in NewPhotoList) { if (!string.IsNullOrEmpty(g.url)) { string ImageName = g.url.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + album.groupId + "/Album" + album.albumId + "/"; g.url = path + ImageName; } } } ClsPhotoListOutput photoList = new ClsPhotoListOutput(); photoList.newPhotos = NewPhotoList; return(photoList.newPhotos); } catch (Exception ex) { throw ex; } }
public static List <EventList> GetEventList(string memberID, string grpID, string SearchText, string type, string Admin, out string Grp_SMSCount) { try { MySqlParameter[] param = new MySqlParameter[6]; param[0] = new MySqlParameter("?memberId", memberID); param[1] = new MySqlParameter("?grpId", grpID); param[2] = new MySqlParameter("?searchText", SearchText); param[3] = new MySqlParameter("?filterType", type); param[4] = new MySqlParameter("?Admin", Admin); param[5] = new MySqlParameter("?SMS_Count", 0); param[5].Direction = ParameterDirection.InputOutput; DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPEventSearchBYText", param); DataTable dt = Result.Tables[0]; List <EventList> res = new List <EventList>(); if (dt.Rows.Count > 0) { res = GlobalFuns.DataTableToList <EventList>(dt); foreach (EventList eve in res) { if (!string.IsNullOrEmpty(eve.eventImg)) { string event_Image = eve.eventImg.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + grpID + "/thumb/"; eve.eventImg = path + event_Image; } } } Grp_SMSCount = param[5].Value.ToString(); return(res); } catch (Exception ex) { ManageExceptions.TraceException("Event/GetEventList", "GetEventList()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
public static ClsSeviceCategoryData GetServiceCategoriesData(ServiceDirectorySearch input) { try { MySqlParameter[] param = new MySqlParameter[4]; param[0] = new MySqlParameter("@grpId", input.groupId); param[1] = new MySqlParameter("@moduleId", input.moduleId); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V8_GetServiceCategoriesList", param); DataTable dtCategory = Result.Tables[0]; DataTable dtDirectory = Result.Tables[1]; List <ServiceCategoryList> ServiceCategoryList = new List <ServiceCategoryList>(); List <ServiceDirectoryList> ServiceDirectoryList = new List <ServiceDirectoryList>(); if (dtCategory.Rows.Count > 0) { ServiceCategoryList = GlobalFuns.DataTableToList <ServiceCategoryList>(dtCategory); } if (dtDirectory.Rows.Count > 0) { ServiceDirectoryList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtDirectory); } ClsSeviceCategoryData obj = new ClsSeviceCategoryData(); obj.Category = ServiceCategoryList; obj.DirectoryData = ServiceDirectoryList; return(obj); } catch (Exception ex) { throw ex; } }
public static List <EbulletinList> GetYearWiseEbulletinList(InputGetYearWiseEbull input) { try { MySqlParameter[] param = new MySqlParameter[4]; param[0] = new MySqlParameter("@memberId", input.memberProfileId); param[1] = new MySqlParameter("@grpId", input.groupId); param[2] = new MySqlParameter("@fromYear", input.fromYear); param[3] = new MySqlParameter("@toYear", input.toYear); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V3_USPGetYearWiseEbulletinList", param); DataTable dtResult = Result.Tables[0]; List <EbulletinList> EbulletinList = new List <EbulletinList>(); if (dtResult.Rows.Count > 0) { EbulletinList = GlobalFuns.DataTableToList <EbulletinList>(dtResult); for (int i = 0; i < EbulletinList.Count; i++) { if (!string.IsNullOrEmpty(EbulletinList[i].ebulletinlink) && EbulletinList[i].ebulletinType != "Link") { string ebulletinlink = EbulletinList[i].ebulletinlink.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/ebulletin/Group" + input.groupId + "/"; EbulletinList[i].ebulletinlink = path + ebulletinlink; } } } return(EbulletinList); } catch (Exception ex) { throw ex; } }
public static List <EventsDetail> GetEventDetails(string grpID, string eventID, string groupProfileID) { string repeatDateTime = ""; try { MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("@grpID", MySqlDbType.Int16); param[1] = new MySqlParameter("@eventID", MySqlDbType.Int16); param[2] = new MySqlParameter("@groupProfileID", MySqlDbType.Int16); param[0].Value = grpID; param[1].Value = eventID; param[2].Value = groupProfileID; DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPGetEventListDetails", param); DataTable dtEvent = result.Tables[0]; DataTable dtRepeatEvent = result.Tables[1]; DataTable dtQuestions = result.Tables[2]; List <EventsDetail> Eventdetail = new List <EventsDetail>(); if (dtEvent.Rows.Count > 0) { Eventdetail = GlobalFuns.DataTableToList <EventsDetail>(dtEvent); if (!string.IsNullOrEmpty(Eventdetail[0].eventImg)) { string event_Image = Eventdetail[0].eventImg.ToString(); // string path = HttpContext.Current.Server.MapPath("~/Documents/Events/Group" + grpID + "/thumb/"); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + grpID + "/"; Eventdetail[0].eventImg = path + event_Image; } if (dtRepeatEvent.Rows.Count > 0) { for (int i = 0; i < dtRepeatEvent.Rows.Count; i++) { repeatDateTime += dtRepeatEvent.Rows[i]["eventDate"].ToString() + ","; } repeatDateTime = repeatDateTime.TrimEnd(','); } Eventdetail[0].repeatDateTime = repeatDateTime; //Eventdetail[0].repeatEventResult = new List<object>(); //Eventdetail[0].questionArray = new List<object>(); //if (dtRepeatEvent.Rows.Count > 0) //{ // List<RepeatEvent> RepeatEvent = GlobalFuns.DataTableToList<RepeatEvent>(dtRepeatEvent); // for (int i = 0; i < RepeatEvent.Count; i++) // { // Eventdetail[0].repeatEventResult.Add(new { RepeatEvent = (object)RepeatEvent[i] }); // } //} if (dtQuestions.Rows.Count == 1) { Eventdetail[0].questionId = dtQuestions.Rows[0]["questionId"].ToString(); Eventdetail[0].questionText = dtQuestions.Rows[0]["questionText"].ToString(); Eventdetail[0].questionType = dtQuestions.Rows[0]["questionType"].ToString(); Eventdetail[0].option1 = dtQuestions.Rows[0]["option1"].ToString(); Eventdetail[0].option2 = dtQuestions.Rows[0]["option2"].ToString(); } else { Eventdetail[0].questionId = ""; Eventdetail[0].questionText = ""; Eventdetail[0].questionType = ""; Eventdetail[0].option1 = ""; Eventdetail[0].option2 = ""; } } return(Eventdetail); } catch (Exception ex) { throw ex; } }
//public static ClsGetShowcaseDetailsOutPut GetShowcaseDetails(GetShowcaseDetails clschowcase) //{ // try // { // string sqlProc; // sqlProc = "V1_USPGetShowcaseDetails"; // MySqlParameter[] parameterList = new MySqlParameter[0]; // parameterList[0] = new MySqlParameter("?DistrictID", clschowcase.DistrictID); // //parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId); // //parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate); // //parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn); // DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); // DataTable dtClub = result.Tables[0]; // List<GetShowcaseDetails> ClubList = new List<GetShowcaseDetails>(); // if (dtClub.Rows.Count > 0) // { // ClubList = GlobalFuns.DataTableToList<GetShowcaseDetails>(dtClub); // } // ClsGetShowcaseDetailsOutPut showcase = new ClsGetShowcaseDetailsOutPut(); // showcase.Club = ClubList; // return showcase; // } // catch // { // throw; // } //} public static ClsAlbumListOutput GetGalleryList_New(ClsAlbumListInput gallery) { try { MySqlParameter[] parameterList = new MySqlParameter[10]; parameterList[0] = new MySqlParameter("?grpId", gallery.groupId); parameterList[1] = new MySqlParameter("?district_id", gallery.district_id); parameterList[2] = new MySqlParameter("?category_id", gallery.category_id); parameterList[3] = new MySqlParameter("?year", gallery.year); parameterList[4] = new MySqlParameter("?club_id", gallery.club_id); parameterList[5] = new MySqlParameter("?SharType", gallery.SharType); parameterList[6] = new MySqlParameter("?ProfileId", gallery.profileId); parameterList[7] = new MySqlParameter("?ModuleID", gallery.moduleId); parameterList[8] = new MySqlParameter("?ClubRotaryType", gallery.ClubRotaryType); parameterList[9] = new MySqlParameter("?SearchText", gallery.searchText);//Nitesh Tiwari 27.03.2019 12.30 pm DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_1_USPGalleryList", parameterList); DataTable dtNewAlbums = result.Tables[0]; //DataTable dtTotals = result.Tables[0]; //DataTable dtDeletedAlbums = result.Tables[2]; List <ClsAlbumList> NewMemberList = new List <ClsAlbumList>(); //List<ClsTotalOutput> TotalList = new List<ClsTotalOutput>(); if (dtNewAlbums.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtNewAlbums); //TotalList = GlobalFuns.DataTableToList<ClsTotalOutput>(dtTotals); foreach (ClsAlbumList g in NewMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } if (!string.IsNullOrEmpty(g.AgendaDocID)) { string ImageName = g.AgendaDocID.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.AgendaDocID = path + ImageName; } if (!string.IsNullOrEmpty(g.MOMDocID)) { string ImageName = g.MOMDocID.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.MOMDocID = path + ImageName; } } } ClsAlbumListOutput galleryList = new ClsAlbumListOutput(); galleryList.newAlbums = NewMemberList; //galleryList.TotalList = TotalList; return(galleryList); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get SubGrp Directory /// </summary> /// <param name="sub"></param> /// <returns></returns> public static SubGrpDirectoryResult GetSubGroupDirectory(SubGrpDirectoryInput sub) { string subGrpIDs = ""; SubGrpDirectoryResult directory = new SubGrpDirectoryResult(); try { // Check if member is group Admin MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("?grpId", sub.groupId); param[1] = new MySqlParameter("?profileID", sub.profileId); param[2] = new MySqlParameter("?IsAdmin", "0"); param[2].Direction = ParameterDirection.InputOutput; DataSet dsSubgrpIDs = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_SubGroupIsAdmin", param); if (dsSubgrpIDs != null) { for (int i = 0; i < dsSubgrpIDs.Tables[0].Rows.Count; i++) { subGrpIDs += dsSubgrpIDs.Tables[0].Rows[i]["subGrpID"].ToString(); subGrpIDs += ","; } subGrpIDs = subGrpIDs.TrimEnd(','); // Member Is subGroup Admin return subgrp List if (Convert.ToInt32(param[2].Value.ToString()) > 0 && subGrpIDs != "") { if (sub.parentID == "0") { MySqlParameter[] param1 = new MySqlParameter[4]; param1[0] = new MySqlParameter("?grpId", sub.groupId); param1[1] = new MySqlParameter("?profileID", sub.profileId); param1[2] = new MySqlParameter("?subGrpIds", subGrpIDs); param1[3] = new MySqlParameter("?parentID", sub.parentID); var subgrpList = _DbTouchbase.ExecuteStoreQuery <SubGrpListResult>("V4_USPGetSubGrpList(?grpId,?profileID,?subGrpIds,?parentID)", param1).ToList(); directory.subGrpList = subgrpList; } else { MySqlParameter[] param2 = new MySqlParameter[3]; param2[0] = new MySqlParameter("?grpId", sub.groupId); param2[1] = new MySqlParameter("?profileID", sub.profileId); param2[2] = new MySqlParameter("?parentID", sub.parentID); DataSet dsSubgrpList = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPGetSubGrpDetails", param2); if (dsSubgrpList != null) { if (dsSubgrpList.Tables[0].Rows.Count > 0) { List <SubGrpListResult> subgrpList = GlobalFuns.DataTableToList <SubGrpListResult>(dsSubgrpList.Tables[0]); directory.subGrpList = subgrpList; } if (dsSubgrpList.Tables[1].Rows.Count > 0) { List <MemberList> memList = GlobalFuns.DataTableToList <MemberList>(dsSubgrpList.Tables[1]); foreach (MemberList mem in memList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } directory.memberList = memList; } } } } //IF Member Is Not an Admin Then return Member Directory else if (param[2].Value.ToString() == "0" && subGrpIDs != "") { MySqlParameter[] param3 = new MySqlParameter[3]; param3[0] = new MySqlParameter("?grpId", sub.groupId); param3[1] = new MySqlParameter("?profileID", sub.profileId); param3[2] = new MySqlParameter("?subGrpIds", subGrpIDs); var memberList = _DbTouchbase.ExecuteStoreQuery <MemberList>("CALL V4_USPGetSubGrpMemberList(?grpId,?profileID,?subGrpIds)", param3).ToList(); foreach (MemberList mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } directory.memberList = memberList; } } } catch { throw; } if (directory.memberList == null) { directory.memberList = new List <MemberList>(); } if (directory.subGrpList == null) { directory.subGrpList = new List <SubGrpListResult>(); } return(directory); }
public static ClsGetShowcaseDetailsOutPut GetShowcaseDetails(GetShowcaseDetails clschowcase) { try { string sqlProc; sqlProc = "V1_1_USPGetShowcaseDetails"; MySqlParameter[] parameterList = new MySqlParameter[1]; parameterList[0] = new MySqlParameter("?DistrictID", clschowcase.DistrictID); //parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId); //parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate); //parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); ClsGetShowcaseDetailsOutPut showcase = new ClsGetShowcaseDetailsOutPut(); if (clschowcase.DistrictID == "0") { //Inserted One row for ALL as per told rupesh DataTable dt_Category = new DataTable(); if (result.Tables[0].Rows.Count > 0) { //DataRow toInsert_Category = result.Tables[0].NewRow(); //result.Tables[0].Rows.Add("0", "All", ""); DataView dv_Category = result.Tables[0].DefaultView; dv_Category.Sort = "ID ASC"; dt_Category = dv_Category.ToTable(); DataRow toInsert_Category1 = dt_Category.NewRow(); dt_Category.Rows.Add("-1", "Others", ""); } //Inserted One row for ALL as per told rupesh DataTable dt_Club = new DataTable(); if (result.Tables[1].Rows.Count > 0) { DataRow toInsert_Club = result.Tables[1].NewRow(); result.Tables[1].Rows.Add("0", "All", ""); DataView dv_Club = result.Tables[1].DefaultView; dv_Club.Sort = "ID ASC"; dt_Club = dv_Club.ToTable(); } //Inserted One row for ALL as per told rupesh DataTable dt_District = new DataTable(); if (result.Tables[2].Rows.Count > 0) { DataRow toInsert_District = result.Tables[2].NewRow(); result.Tables[2].Rows.Add("0", "All", ""); DataView dv_District = result.Tables[2].DefaultView; dv_District.Sort = "ID ASC"; dt_District = dv_District.ToTable(); } DataTable dtCategory = dt_Category; DataTable dtClub = dt_Club; DataTable dtDistrict = dt_District; List <GetShowcaseDetails> CategoryList = new List <GetShowcaseDetails>(); if (dtCategory.Rows.Count > 0) { CategoryList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtCategory); } List <GetShowcaseDetails> ClubList = new List <GetShowcaseDetails>(); if (dtClub.Rows.Count > 0) { ClubList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtClub); } List <GetShowcaseDetails> DistrictList = new List <GetShowcaseDetails>(); if (dtDistrict.Rows.Count > 0) { DistrictList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtDistrict); } showcase.District = DistrictList; showcase.Club = ClubList; showcase.Categories = CategoryList; } else { //Inserted One row for ALL as per told rupesh DataTable dt_Club = new DataTable(); if (result.Tables[0].Rows.Count > 0) { DataRow toInsert_Club = result.Tables[0].NewRow(); result.Tables[0].Rows.Add("0", "All", ""); DataView dv_Club = result.Tables[0].DefaultView; dv_Club.Sort = "ID ASC"; dt_Club = dv_Club.ToTable(); } //DataTable dtClub = result.Tables[0]; List <GetShowcaseDetails> CategoryList = new List <GetShowcaseDetails>(); List <GetShowcaseDetails> ClubList = new List <GetShowcaseDetails>(); if (dt_Club.Rows.Count > 0) { ClubList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dt_Club); } List <GetShowcaseDetails> DistrictList = new List <GetShowcaseDetails>(); showcase.District = DistrictList; showcase.Club = ClubList; showcase.Categories = CategoryList; } return(showcase); } catch { throw; } }
//private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities(); public static ClsAlbumListOutput GetGalleryList(ClsAlbumListInput gallery) { try { MySqlParameter[] parameterList = new MySqlParameter[4]; parameterList[0] = new MySqlParameter("?ProfileId", gallery.profileId); parameterList[1] = new MySqlParameter("?GroupId", gallery.groupId); parameterList[2] = new MySqlParameter("?UpdatedOn", gallery.updatedOn); parameterList[3] = new MySqlParameter("?ModuleID", gallery.moduleId); // parameterList[3] = new MySqlParameter("?UpdatedOn", gallery.updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_1_USPGalleryList", parameterList); DataTable dtNewAlbums = result.Tables[0]; DataTable dtUpdatedAlbums = result.Tables[1]; DataTable dtDeletedAlbums = result.Tables[2]; List <ClsAlbumList> NewMemberList = new List <ClsAlbumList>(); if (dtNewAlbums.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtNewAlbums); foreach (ClsAlbumList g in NewMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } } } List <ClsAlbumList> updatedMemberList = new List <ClsAlbumList>(); if (dtUpdatedAlbums.Rows.Count > 0) { updatedMemberList = GlobalFuns.DataTableToList <ClsAlbumList>(dtUpdatedAlbums); foreach (ClsAlbumList g in updatedMemberList) { if (!string.IsNullOrEmpty(g.image)) { string ImageName = g.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/gallery/Group" + g.groupId + "/"; g.image = path + ImageName; } } } ClsAlbumListOutput galleryList = new ClsAlbumListOutput(); galleryList.deletedAlbums = dtDeletedAlbums.Rows[0]["GalleryId"].ToString(); galleryList.newAlbums = NewMemberList; galleryList.updatedAlbums = updatedMemberList; return(galleryList); } catch (Exception ex) { throw ex; } }
public object GetGroupSetting(GetGroup grp) { dynamic TBGroupSettingResult; List <object> AllTBSettingResults = new List <object>(); try { DataSet Result = Setting.getGroupSetting(grp); DataTable dtmain = Result.Tables[0]; DataTable dt2 = Result.Tables[1]; //string isMob, isEmail, isPersonal, isFamily, isBusiness; string isMobileSelf, isMobileOther, isEmailSelf, isEmailOther; //isMob = dt2.Rows[0]["isMob"].ToString(); //isEmail = dt2.Rows[0]["isEmail"].ToString(); //isPersonal = dt2.Rows[0]["isPersonal"].ToString(); //isFamily = dt2.Rows[0]["isFamily"].ToString(); //isBusiness = dt2.Rows[0]["isBusiness"].ToString(); isMobileSelf = dt2.Rows[0]["show_mobile_self_club"].ToString(); isMobileOther = dt2.Rows[0]["show_mobile_other_club"].ToString(); isEmailSelf = dt2.Rows[0]["show_email_self_club"].ToString(); isEmailOther = dt2.Rows[0]["show_email_other_club"].ToString(); //Convert DataTable into List List <GRpSettingDetails> GroupSetting = new List <GRpSettingDetails>(); if (dtmain.Rows.Count > 0) { GroupSetting = GlobalFuns.DataTableToList <GRpSettingDetails>(dtmain); } //Add List into another List for (int i = 0; i < GroupSetting.Count; i++) { AllTBSettingResults.Add(new { GRpSettingDetails = GroupSetting[i] }); } if (AllTBSettingResults != null) { //TBGroupSettingResult = new { status = "0", message = "success", isMob = isMob, isEmail = isEmail, isPersonal = isPersonal, isFamily = isFamily, isBusiness = isBusiness, GRpSettingResult = AllTBSettingResults }; TBGroupSettingResult = new { status = "0", message = "success", isMobileSelf = isMobileSelf, isMobileOther = isMobileOther, isEmailSelf = isEmailSelf, isEmailOther = isEmailOther, GRpSettingResult = AllTBSettingResults }; } else { TBGroupSettingResult = new { status = "0", message = "Record not found" }; } } catch { TBGroupSettingResult = new { status = "1", message = "failed" }; } return(new { TBGroupSettingResult }); }
public static ClsMonthCalenderOutputNew GetMonthEventTypeList(ClsMonthCalenderInput monthCal) { try { string sqlProc; if (monthCal.groupCategory == "2") { sqlProc = "V8_USPGetDistrictEventByMonth_Calender"; } else { sqlProc = "V8_USPGetEventByMonth_Calender"; } MySqlParameter[] parameterList = new MySqlParameter[5]; parameterList[0] = new MySqlParameter("?GroupID", monthCal.groupId); parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId); parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate); parameterList[3] = new MySqlParameter("?Type", monthCal.Type); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); DataTable dtNewEvents = result.Tables[0]; List <clsCalenderEventList> NewEventList = new List <clsCalenderEventList>(); if (dtNewEvents.Rows.Count > 0) { NewEventList = GlobalFuns.DataTableToList <clsCalenderEventList>(dtNewEvents); } //if (monthCal.Type == "E") //{ foreach (clsCalenderEventList eve in NewEventList) { if (!string.IsNullOrEmpty(eve.eventImg)) { string event_Image = eve.eventImg.ToString(); // string path = HttpContext.Current.Server.MapPath("~/Documents/Events/Group" + grpID + "/thumb/"); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + monthCal.groupId + "/"; eve.eventImg = path + event_Image; } DataSet result1 = null; List <clsCalenderMobileNo> MobileNoList = new List <clsCalenderMobileNo>(); List <clsCalenderEmailId> EmailIdsList = new List <clsCalenderEmailId>(); List <clsCalenderMobileNo> ListResult = new List <clsCalenderMobileNo>(); List <clsCalenderEmailId> ListResult1 = new List <clsCalenderEmailId>(); if (monthCal.Type != "E") { //if (string.IsNullOrEmpty(eve.ContactNumber)) //{ sqlProc = "V8_USPGetCalenderEvent_MobileNoEmailIds_New"; parameterList = new MySqlParameter[2]; if (monthCal.groupCategory == "2") { parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID.Substring(1)); } else { parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID); } parameterList[1] = new MySqlParameter("?Type", "M"); result1 = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); if (result1 != null) { MobileNoList = GlobalFuns.DataTableToList <clsCalenderMobileNo>(result1.Tables[0]); } //if (MobileNoList.Count > 0) //{ // ListResult.Add(MobileNoList[0]); //} //} //else if (string.IsNullOrEmpty(eve.EmailId)) //{ sqlProc = "V8_USPGetCalenderEvent_MobileNoEmailIds_New"; parameterList = new MySqlParameter[2]; if (monthCal.groupCategory == "2") { parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID.Substring(1)); } else { parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID); } parameterList[1] = new MySqlParameter("?Type", "E"); result1 = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList); if (result1 != null) { EmailIdsList = GlobalFuns.DataTableToList <clsCalenderEmailId>(result1.Tables[0]); } //if (EmailIdsList.Count > 0) //{ // ListResult1.Add(EmailIdsList[0]); //} //} eve.EmailIds = EmailIdsList; eve.MobileNo = MobileNoList; } else { eve.EmailIds = EmailIdsList; eve.MobileNo = MobileNoList; } } //} ClsMonthCalenderOutputNew calender = new ClsMonthCalenderOutputNew(); calender.Events = NewEventList; return(calender); } catch { throw; } }
// For Offline data fetch public static ServiceDirector GetServiceDirectoryListSync(ServiceDirectorySearch search) { try { MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("@grpId", search.groupId); param[1] = new MySqlParameter("@moduleId", search.moduleId); // Added by Nandu on 30/09/2016 Task--> Module replica param[2] = new MySqlParameter("@updateOn", search.updatedOn); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_USPGetServiceDirectoryListSync", param); // Added by Nandu on 30/09/2016 Task--> Module replica DataTable dtNewServiceMember = result.Tables[0]; DataTable dtUpdatedServiceMember = result.Tables[1]; DataTable dtDeletedServiceMember = result.Tables[2]; List <ServiceDirectoryList> NewMemberList = new List <ServiceDirectoryList>(); if (dtNewServiceMember.Rows.Count > 0) { NewMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtNewServiceMember); foreach (ServiceDirectoryList sev in NewMemberList) { if (!string.IsNullOrEmpty(sev.image)) { string ImageName = sev.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/servicedirectory/Group" + sev.groupId + "/thumb/"; sev.image = path + ImageName; } } } List <ServiceDirectoryList> updatedMemberList = new List <ServiceDirectoryList>(); if (dtUpdatedServiceMember.Rows.Count > 0) { updatedMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtUpdatedServiceMember); foreach (ServiceDirectoryList sev in updatedMemberList) { if (!string.IsNullOrEmpty(sev.image)) { string ImageName = sev.image.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/servicedirectory/Group" + sev.groupId + "/thumb/"; sev.image = path + ImageName; } } } List <ServiceDirectoryList> deletedMemberList = new List <ServiceDirectoryList>(); if (dtDeletedServiceMember.Rows.Count > 0) { deletedMemberList = GlobalFuns.DataTableToList <ServiceDirectoryList>(dtDeletedServiceMember); } ServiceDirector serviceList = new ServiceDirector(); serviceList.deletedMembers = deletedMemberList; serviceList.newMembers = NewMemberList; serviceList.updatedMembers = updatedMemberList; return(serviceList); } catch (Exception ex) { throw ex; } }