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