public static SearchMitkanimResponse SearchEquipment(int mehozId, int mitkanNum, int rashutID) { MefonimGovServiceClient client = new MefonimGovServiceClient("MefonimGovServiceEndpoint"); SearchMitkanimRequest request = new SearchMitkanimRequest() { CurrentPage = 1, MaxRowsPerPage = 10, MahozNum = mehozId, MitkanNum = mitkanNum, RashutID = rashutID, SortingName = SortingMitkanimField.MahozName, SortingOrder = SortingOrder.ASC }; return(client.SearchMitkanim(request)); }
public void SearchMitkanimTest() { MitkanimService s = new MitkanimService(GetConnectionString(), null, null); var req = new SearchMitkanimRequest(); req.MaxRowsPerPage = 3; req.CurrentPage = 1; req.SortingOrder = SortingOrder.DESC; req.SortingName = SortingMitkanimField.MahozName; var lists = s.Search(req); foreach (var item in lists.Return) { Console.WriteLine(item.MahozName); } }
internal ResultWithTotalRows <IEnumerable <ReportMitkanim> > ExcuteReportMitkanim(SearchMitkanimRequest request) { var orderBy = GenerateSortingFieldAndOrder(request.SortingName, request.SortingOrder); var result = new ResultWithTotalRows <IEnumerable <ReportMitkanim> >(); var data = new List <ReportMitkanim>(); result.IsError = false; var connection = GetSqlConnection(); try { var command = new SqlCommand(@"gs_searchMitkan", connection); command.Parameters.Add("@pOrderBy", orderBy); command.Parameters.Add("@pCurrentPage", request.CurrentPage); command.Parameters.Add("@pPageSize", request.MaxRowsPerPage); command.Parameters.Add("@MahozNum", request.MahozNum); command.Parameters.Add("@MitkanNum", request.MitkanNum); command.Parameters.Add("@RashutID", request.RashutID); command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); var drOutput = command.ExecuteReader(); using (drOutput) { while (drOutput.Read()) { var item = new ReportMitkanim(); item.MahozNum = (drOutput["MahozNum"] != Convert.DBNull) ? (int?)int.Parse(drOutput["MahozNum"].ToString()) : null; item.MahozName = (drOutput["MahozName"] != Convert.DBNull) ? drOutput["MahozName"].ToString() : null; item.MitkanNum = (drOutput["MitkanNum"] != Convert.DBNull) ? (int?)int.Parse(drOutput["MitkanNum"].ToString()) : null; item.MitkanName = (drOutput["MitkanName"] != Convert.DBNull) ? drOutput["MitkanName"].ToString() : null; item.RashutID = (drOutput["RashutID"] != Convert.DBNull) ? (int?)int.Parse(drOutput["RashutID"].ToString()) : null; item.RashutName = (drOutput["RashutName"] != Convert.DBNull) ? drOutput["RashutName"].ToString() : null; item.MitkanAddress = (drOutput["MitkanAddress"] != Convert.DBNull) ? drOutput["MitkanAddress"].ToString() : null; item.Sum19To65 = (drOutput["Sum19To65"] != Convert.DBNull) ? (int?)int.Parse(drOutput["Sum19To65"].ToString()) : null; item.Sum3 = (drOutput["Sum3"] != Convert.DBNull) ? (int?)int.Parse(drOutput["Sum3"].ToString()) : null; item.Sum4To6 = (drOutput["Sum4To6"] != Convert.DBNull) ? (int?)int.Parse(drOutput["Sum4To6"].ToString()) : null; item.Sum66 = (drOutput["Sum66"] != Convert.DBNull) ? (int?)int.Parse(drOutput["Sum66"].ToString()) : null; item.Sum7To18 = (drOutput["Sum7To18"] != Convert.DBNull) ? (int?)int.Parse(drOutput["Sum7To18"].ToString()) : null; item.SumAll = (drOutput["SumAll"] != Convert.DBNull) ? (int?)int.Parse(drOutput["SumAll"].ToString()) : null; data.Add(item); } result.Return = data; bool hasNextResult = drOutput.NextResult(); if (hasNextResult) { while (drOutput.Read()) { result.TotalRows = Convert.ToInt32(drOutput.GetValue(0)); break; } } } } catch (Exception ee) { WriteError(ee.ToString()); result.IsError = true; result.ErrorDesc = ee.ToString(); } finally { if (connection != null) { connection.Dispose(); } } return(result); }
public ResultWithTotalRows <IEnumerable <ReportMitkanim> > Search(SearchMitkanimRequest request) { var dbContext = new MedamContext(_connString, _log, _error); return(dbContext.ExcuteReportMitkanim(request)); }