public static int Save(Win winToSave)
{
Win win = new Win();
win.WinId = winToSave.WinId;
if (winToSave.WinId > 0)
win.WinId = winToSave.WinId;
if (winToSave.WinValue != null)
win.WinValue = winToSave.WinValue;
return WinDAL.Save(winToSave);
}
public static int Save(Win winToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
// notes: check for valid WinId - if exists then UPDATE , else INSERT
if (winToSave.WinId > 0)
queryId = ExecuteTypeEnum.UpdateItem;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteWin", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@WinId", winToSave.WinId);
if (winToSave.WinValue != null)
myCommand.Parameters.AddWithValue("@Win", winToSave.WinValue);
;
//notes: add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//notes: get return value from stored procedure and return Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return result;
}
private static Win FillDataRecord(IDataRecord myDataRecord)
{
Win myObject = new Win();
myObject.WinId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("WinId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Win")))
myObject.WinValue = myDataRecord.GetString(myDataRecord.GetOrdinal("Win"));
return myObject;
}
