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