public ActionResult AddRepairCheck(RepairCheck repairCheck)
{
var requestResult = inventoryLogic.AddRepairCheck(repairCheck);
InvertoryViewModel = new InvertoryViewModel();
InvertoryViewModel.RepairUnit = new RepairUnit()
{
EndUserMessage = requestResult.EndUserMessage,
Status = requestResult.Status
};
return(View(InvertoryViewModel));
}
//public List<RepairUnit> RepairUnitList()
//{
// string query = "SELECT * FROM Inventory";
// SqlCommand queryCommand = new SqlCommand(query, DBConnection);
// SqlDataReader queryCommandReader = queryCommand.ExecuteReader();
// List<InventoryModel> inventoryList = new List<InventoryModel>();
// if (queryCommandReader.HasRows)
// {
// while (queryCommandReader.Read())
// {
// inventoryList.Add(new InventoryModel()
// {
// Name = (string)queryCommandReader["Name"],
// InventoryId = Int32.Parse(queryCommandReader[0].ToString()),
// Address = (string)queryCommandReader["Address"],
// City = (string)queryCommandReader["City"],
// State = (string)queryCommandReader["State"],
// Foundation = (int)queryCommandReader["Foundation"],
// PhoneNumber = (string)queryCommandReader["PhoneNumber"],
// RepairCondition = (bool)queryCommandReader["RepairCondition"],
// Representation = (bool)queryCommandReader["Representation"],
// });
// }
// }
// DBConnection.Close();
// return inventoryList;
//}
public ResponseStatus AddRepairCheck(RepairCheck repairCheck)
{
string query = "INSERT INTO [dbo].[RepairCheck]([VisitDate],[SugesstionPrice],[InventoryRefId]" +
")VALUES('" + repairCheck.VisitDate + "', '" + repairCheck.SugesstionPrice + "', '" + repairCheck.InventoryRefId + "')";
SqlCommand queryCommand = new SqlCommand(query, DBConnection);
queryCommand.ExecuteNonQuery();
query = "UPDATE [dbo].[Inventory] SET [RepairCondition] = '"
+ repairCheck.NeedRepair + "'WHERE ID = " + repairCheck.InventoryRefId;
queryCommand = new SqlCommand(query, DBConnection);
queryCommand.ExecuteNonQuery();
DBConnection.Close();
return(ResponseStatus.Success);
}
public BaseResponse AddRepairCheck(RepairCheck repairCheck)
{
try
{
return(new BaseResponse()
{
Status = inventoryRepository.AddRepairCheck(repairCheck),
EndUserMessage = "با موفقیت اضافه شد"
});
}
catch (Exception ex)
{
return(new BaseResponse()
{
Status = ResponseStatus.InternalError,
EndUserMessage = "یک مشکل پیش آماده است"
});
}
}