public HttpResponseMessage ClientGivenInstalledSave(ServiceSheetZipItem model)
{
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.Created);
try
{
model.CurUserAdSid = GetCurUser().Sid;
model.ClientGivenInstalledSave();
response.Content = new StringContent($"{{\"id\":{model.Id}}}");
}
catch (Exception ex)
{
response = new HttpResponseMessage(HttpStatusCode.OK);
response.Content = new StringContent(MessageHelper.ConfigureExceptionMessage(ex));
}
return response;
}
public ServiceSheetZipItem Get(int id)
{
var model = new ServiceSheetZipItem(id);
return model;
}
/// <summary>
/// Возвращает заказанный для сервисного листа ЗИП
/// </summary>
/// <param name="serviceSheetId"></param>
/// <param name="realyOrdered">Был ли оформлен заказ ЗИП СТП или еще в промежуточной стадии</param>
/// <returns></returns>
public static IEnumerable<ServiceSheetZipItem> GetOrderedList(int serviceSheetId, bool? realyOrdered = null)
{
SqlParameter pServiceSheetId = new SqlParameter() { ParameterName = "id_service_sheet", SqlValue = serviceSheetId, SqlDbType = SqlDbType.Int };
SqlParameter pRealyOrdered = new SqlParameter() { ParameterName = "ordered", SqlValue = realyOrdered, SqlDbType = SqlDbType.Bit };
var dt = Db.Service.ExecuteQueryStoredProcedure("service_sheet_ordered_zip_item_get_list", pServiceSheetId, pRealyOrdered);
var lst = new List<ServiceSheetZipItem>();
foreach (DataRow row in dt.Rows)
{
var model = new ServiceSheetZipItem(row);
lst.Add(model);
}
return lst;
}
public static IEnumerable<ServiceSheetZipItem> GetOrderedZipItemList(int claimId, int? serviceSheetId = null)
{
SqlParameter pClaimId = new SqlParameter() { ParameterName = "claim_id", SqlValue = claimId, SqlDbType = SqlDbType.Int };
SqlParameter pServiceSheetId = new SqlParameter() { ParameterName = "id_service_sheet", SqlValue = serviceSheetId, SqlDbType = SqlDbType.Int };
var dt = Db.Service.ExecuteQueryStoredProcedure("claim_ordered_zip_item_list_get", pClaimId, pServiceSheetId);
var lst = new List<ServiceSheetZipItem>();
foreach (DataRow row in dt.Rows)
{
var model = new ServiceSheetZipItem(row);
lst.Add(model);
}
return lst;
}
public static IEnumerable<ServiceSheetZipItem> GetClientGivenInstalledZipItemList(int serviceSheetId)
{
SqlParameter pServiceSheetId = new SqlParameter() { ParameterName = "id_service_sheet", SqlValue = serviceSheetId, SqlDbType = SqlDbType.Int };
var dt = Db.Service.ExecuteQueryStoredProcedure("service_sheet_client_given_installed_zip_item_get_list", pServiceSheetId);
var lst = new List<ServiceSheetZipItem>();
foreach (DataRow row in dt.Rows)
{
var model = new ServiceSheetZipItem(row);
lst.Add(model);
}
return lst;
}