public SavingState DeleteMarket(string Id)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "DELETE FROM IM_Markets WHERE Id = @Id";
CreateParameter.AddParam(comm, "@Id", Id, DbType.String);
GenericDataAccess.ExecuteNonQuery(comm);
comm.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public SavingState SaveSrPaymentDetails(DetailPaymentInfo paymentInfo)
{
SavingState svState = SavingState.Failed;
/// paymentInfo.Id is SrId
if (paymentInfo != null && !string.IsNullOrEmpty(paymentInfo.Id) && paymentInfo.PaymentDate != null && !paymentInfo.PaymentDate.Equals(DateTime.MinValue))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new payment
if (!IsPaymentInfoExist(paymentInfo.Id, paymentInfo.CompanyId, paymentInfo.PaymentDate))
{
thisCommand.CommandText = "INSERT INTO IM_SR_DSR_PAYMENT_DETAILS (PaymentId, SrId, CompanyId, PaymentDate, ThousendCount, FiveHundredCount, OneHundredCount, FiftyCount, TwentyCount, TenCount, FiveCount, TwoCount, OneCount, TotalPayment) VALUES(@PaymentId, @SrId, @CompanyId, @PaymentDate, @ThousendCount, @FiveHundredCount, @OneHundredCount, @FiftyCount, @TwentyCount, @TenCount, @FiveCount, @TwoCount, @OneCount, @TotalPayment)";
CreateParameter.AddParam(thisCommand, "@PaymentId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
thisCommand.CommandText = "UPDATE IM_SR_DSR_PAYMENT_DETAILS SET PaymentDate = @PaymentDate, ThousendCount = @ThousendCount, FiveHundredCount = @FiveHundredCount, OneHundredCount = @OneHundredCount, FiftyCount = @FiftyCount, TwentyCount = @TwentyCount, TenCount = @TenCount, FiveCount = @FiveCount, TwoCount = @TwoCount, OneCount = @OneCount, TotalPayment = @TotalPayment WHERE SrId = @SrId AND CompanyId = @CompanyId AND PaymentDate = @PaymentDate";
}
CreateParameter.AddParam(thisCommand, "@SrId", paymentInfo.Id, DbType.String);
CreateParameter.AddParam(thisCommand, "@CompanyId", paymentInfo.CompanyId, DbType.String);
CreateParameter.AddParam(thisCommand, "@PaymentDate", paymentInfo.PaymentDate, DbType.DateTime);
CreateParameter.AddParam(thisCommand, "@ThousendCount", paymentInfo.ThousendCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@FiveHundredCount", paymentInfo.FiveHundredCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@OneHundredCount", paymentInfo.OneHundredCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@FiftyCount", paymentInfo.FiftyCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@TwentyCount", paymentInfo.TwentyCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@TenCount", paymentInfo.TenCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@FiveCount", paymentInfo.FiveCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@TwoCount", paymentInfo.TwoCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@OneCount", paymentInfo.OneCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@TotalPayment", Math.Round(paymentInfo.TotalPayment, 2), DbType.Decimal);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
public void UpdateSaveKey()
{
if (savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
Debug.WriteLine("SaveCompleted!");
}
}
public SavingState SaveItem(Item item)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(item.CompanyId) && !string.IsNullOrEmpty(item.ItemName))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new Item
if (string.IsNullOrEmpty(item.ItemId))
{
if (!IsItemExist(item.CompanyId, item.ItemName))
{
thisCommand.CommandText = "INSERT INTO IM_Items (CompanyId, ItemId, ItemName, CountPerBox, Price) VALUES(@CompanyId, @ItemId, @ItemName, @CountPerBox, @Price)";
CreateParameter.AddParam(thisCommand, "@ItemId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
thisCommand.CommandText = "UPDATE IM_Items SET CompanyId = @CompanyId, ItemName = @ItemName, CountPerBox = @CountPerBox, Price = @Price WHERE ItemId = @ItemId";
CreateParameter.AddParam(thisCommand, "@ItemId", item.ItemId, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@CompanyId", item.CompanyId, DbType.String);
CreateParameter.AddParam(thisCommand, "@ItemName", item.ItemName, DbType.String);
CreateParameter.AddParam(thisCommand, "@CountPerBox", item.CountPerBox, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@Price", item.Price, DbType.Double);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
private void UpdateSaveKey(Keys saveKey)
{
if (!oldKeyboardState.IsKeyDown(saveKey) && currentKeyboardState.IsKeyDown(saveKey))
{
if (savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
}
}
private async Task WaitForActionToComplete()
{
Console.WriteLine("Performing save action...");
await saveAction_();
Console.WriteLine("...Save action finished.");
savedTimer_.Stop();
savedTimer_.Start();
state = SavingState.Displaying;
}
public SavingState SaveSrDsr(SRDSR srDsr)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(srDsr.Name) && !string.IsNullOrEmpty(srDsr.CellNo))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new sr
if (string.IsNullOrEmpty(srDsr.Id))
{
if (!IsSRDSRExist(srDsr.Name, srDsr.CellNo))
{
thisCommand.CommandText = "INSERT INTO IM_SR_DSR (Id, Name, Type, CellNo) VALUES(@Id, @Name, @Type, @CellNo)";
CreateParameter.AddParam(thisCommand, "@Id", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
thisCommand.CommandText = "UPDATE IM_SR_DSR SET Name = @Name, Type = @Type, CellNo = @CellNo WHERE Id = @Id";
CreateParameter.AddParam(thisCommand, "@Id", srDsr.Id, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@Name", srDsr.Name, DbType.String);
CreateParameter.AddParam(thisCommand, "@Type", (int)srDsr.Type, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@CellNo", srDsr.CellNo, DbType.String);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
//trigger checkpoint
public void GetSpawn(Transform spawnHum, Transform spawnRbt)
{
mySavingState = SavingState.Running;
Invoke(nameof(StopSaving), 1f);
SpawnPointH = spawnHum;
if (mp.RobotPlayer)
{
SpawnPointR = spawnRbt;
}
}
public SavingsDto(int userId, int savingId, string savingName, decimal savingCurrentAmount, decimal savingsGoalAmount, SavingState state, int iconId, DateTime goalDate)
{
UserId = userId;
SavingId = savingId;
SavingName = savingName;
SavingCurrentAmount = savingCurrentAmount;
SavingsGoalAmount = savingsGoalAmount;
State = state;
IconId = iconId;
GoalDate = goalDate;
}
public SavingState SaveCompany(Company company)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(company.companyName))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new company
if (string.IsNullOrEmpty(company.companyId))
{
if (!IsCompanyExist(company.companyName))
{
thisCommand.CommandText = "INSERT INTO IM_Company (CompanyId, CompanyName) VALUES(@CompanyId, @CompanyName)";
CreateParameter.AddParam(thisCommand, "@CompanyId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
thisCommand.CommandText = "UPDATE IM_Company SET CompanyName = @CompanyName WHERE CompanyId = @CompanyId";
CreateParameter.AddParam(thisCommand, "@CompanyId", company.companyId, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@CompanyName", company.companyName, DbType.String);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
public SavingState SaveChalan(Chalan chalan)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(chalan.ChalanNo))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new chalan
if (!IsItemChalanExist(chalan.ChalanNo, chalan.ItemId, chalan.ChalanDate))
{
thisCommand.CommandText = "INSERT INTO IM_Chalan_Activity (ChalanId, ChalanNo, ItemId, EntryCount, ChalanDate) VALUES(@ChalanId, @ChalanNo, @ItemId, @EntryCount, @ChalanDate)";
CreateParameter.AddParam(thisCommand, "@ChalanId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
thisCommand.CommandText = "UPDATE IM_Chalan_Activity SET EntryCount = @EntryCount WHERE ItemId = @ItemId AND ChalanNo = @ChalanNo AND ChalanDate = @ChalanDate";
}
CreateParameter.AddParam(thisCommand, "@ChalanNo", chalan.ChalanNo, DbType.String);
CreateParameter.AddParam(thisCommand, "@ItemId", chalan.ItemId, DbType.String);
CreateParameter.AddParam(thisCommand, "@EntryCount", chalan.EntryCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ChalanDate", chalan.ChalanDate.Date, DbType.Date);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
public SavingState SaveSrDsrDue(SRDSRDue srDsrDue)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(srDsrDue.Id))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new sr
if (!IsSRDSRDueExist(srDsrDue.Id))
{
thisCommand.CommandText = "INSERT INTO IM_SR_DSR_ORDER_DUE (SrId, TotalDue) VALUES(@SrId, @TotalDue)";
}
else
{
thisCommand.CommandText = "UPDATE IM_SR_DSR_ORDER_DUE SET TotalDue = @TotalDue WHERE SrId = @SrId";
}
CreateParameter.AddParam(thisCommand, "@SrId", srDsrDue.Id, DbType.String);
CreateParameter.AddParam(thisCommand, "@TotalDue", Math.Round(srDsrDue.Due, 2), DbType.Double);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
public Autosave(Func <ValueTask> saveAction)
{
saveAction_ = saveAction;
savingTimer_ = new Timer(SaveIntervalInMsDefault)
{
AutoReset = false
};
savingTimer_.Elapsed += async(sender, e) =>
{
state = SavingState.Saving;
await WaitForActionToComplete();
};
savedTimer_ = new Timer(SavedMessageDisplayLengthInMsDefault)
{
AutoReset = false
};
savedTimer_.Elapsed += (sender, e) => state = SavingState.Idle;
state = SavingState.Idle;
}
public SavingState DeleteSrDSrOrder(string companyId, string srDsrId, string marketId, DateTime orderDate)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "DELETE FROM IM_Orders WHERE CompanyId = @CompanyId AND SrId = @SrId AND MarketId = @MarketId AND Date = @Date";
CreateParameter.AddParam(comm, "@CompanyId", companyId, DbType.String);
CreateParameter.AddParam(comm, "@SrId", srDsrId, DbType.String);
CreateParameter.AddParam(comm, "@MarketId", marketId, DbType.String);
CreateParameter.AddParam(comm, "@Date", orderDate.Date, DbType.Date);
if (GenericDataAccess.ExecuteNonQuery(comm) > 0)
{
svState = SavingState.Success;
}
comm.Parameters.Clear();
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public SavingState UpdateUser(User objUser)
{
SavingState svState = SavingState.Failed;
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
thisCommand.CommandText = "UPDATE IM_USERS SET USER_NAME=@USER_NAME, PASSWORD=@PASSWORD, ACTIVE=@ACTIVE WHERE USER_ID=@USER_ID";
CreateParameter.AddParam(thisCommand, "@USER_ID", objUser.userID, DbType.String);
CreateParameter.AddParam(thisCommand, "@USER_NAME", objUser.userName, DbType.String);
CreateParameter.AddParam(thisCommand, "@PASSWORD", objUser.password, DbType.String);
CreateParameter.AddParam(thisCommand, "@ACTIVE", objUser.active, DbType.Boolean);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
return(svState);
}
public SavingState DeductItemsStock(int stockNeedToDeduct, string stockId)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "UPDATE IM_Items_Stock SET TotalStock = @TotalStock WHERE StockId = @StockId";
CreateParameter.AddParam(comm, "@TotalStock", stockNeedToDeduct, DbType.String);
CreateParameter.AddParam(comm, "@StockId", stockId, DbType.String);
GenericDataAccess.ExecuteNonQuery(comm);
comm.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public SavingState DeductAllDamagedItemsStockOfCompany(string companyId)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "UPDATE IM_Items_Stock SET DamagedStock = @DamagedStock WHERE ItemId IN (SELECT ItemId FROM IM_Items WHERE CompanyId = @CompanyId)";
CreateParameter.AddParam(comm, "@DamagedStock", 0, DbType.Int32);
CreateParameter.AddParam(comm, "@CompanyId", companyId, DbType.String);
GenericDataAccess.ExecuteNonQuery(comm);
comm.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public SavingState SaveUser(User objUser)
{
SavingState svState = SavingState.Failed;
if (objUser != null)
{
if (!IsUserExist(objUser.userName))
{
if (!IsUserIdExist(objUser.userID))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
thisCommand.CommandText = "INSERT INTO IM_USERS (USER_ID, USER_NAME, PASSWORD, CREATION_DATE, ROLE_TYPE, ACTIVE) VALUES(@USER_ID, @USER_NAME, @PASSWORD, @CREATION_DATE, @ROLE_TYPE, @ACTIVE)";
CreateParameter.AddParam(thisCommand, "@USER_ID", objUser.userID, DbType.String);
CreateParameter.AddParam(thisCommand, "@USER_NAME", objUser.userName, DbType.String);
CreateParameter.AddParam(thisCommand, "@PASSWORD", objUser.password, DbType.String);
CreateParameter.AddParam(thisCommand, "@CREATION_DATE", DateTime.Now, DbType.DateTime);
CreateParameter.AddParam(thisCommand, "@ROLE_TYPE", (int)objUser.roleType, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ACTIVE", objUser.active, DbType.Boolean);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
else
{
svState = UpdateUser(objUser);
}
}
else
{
svState = SavingState.DuplicateExists;
}
}
else
{
svState = SavingState.Failed;
}
return(svState);
}
private void UpdateSaveKey(Keys saveKey)
{
if (!oldKeyboardState.IsKeyDown(saveKey) && currentKeyboardState.IsKeyDown(saveKey))
{
if (savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
}
}
private void StopSaving() => mySavingState = SavingState.None;
public void UpdateSaving()
{
switch (savingState)
{
case SavingState.ReadyToSelectStorageDevice:
{
asyncResult = StorageDevice.BeginShowSelector(playerIndex, null, null);
savingState = SavingState.SelectingStorageDevice;
}
break;
case SavingState.SelectingStorageDevice:
if (asyncResult.IsCompleted)
{
storageDevice = StorageDevice.EndShowSelector(asyncResult);
savingState = SavingState.ReadyToOpenStorageContainer;
}
break;
case SavingState.ReadyToOpenStorageContainer:
if (storageDevice == null || !storageDevice.IsConnected)
{
savingState = SavingState.ReadyToSelectStorageDevice;
}
else
{
asyncResult = storageDevice.BeginOpenContainer("Game1StorageContainer", null, null);
savingState = SavingState.OpeningStorageContainer;
}
break;
case SavingState.OpeningStorageContainer:
if (asyncResult.IsCompleted)
{
storageContainer = storageDevice.EndOpenContainer(asyncResult);
savingState = SavingState.ReadyToSave;
}
break;
case SavingState.ReadyToSave:
if (storageContainer == null)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
else
{
try
{
DeleteExisting();
Save();
}
catch (IOException e)
{
// Replace with in game dialog notifying user of error
Debug.WriteLine(e.Message);
}
finally
{
storageContainer.Dispose();
storageContainer = null;
savingState = SavingState.NotSaving;
}
}
break;
}
}
/// <summary>
/// Maps number keys to selection between the tile templates, and the 'S' key to requesting a save\
/// Escapes to start screen if espace key is pressed
/// </summary>
private void handleKey()
{
keyboardState = Keyboard.GetState();
if (CheckKey(Keys.D1))
{
tileTemplate = brownTemplate;
}
if (CheckKey(Keys.D2))
{
tileTemplate = redTemplate;
}
if (CheckKey(Keys.D3))
{
tileTemplate = blueTemplate;
}
if (CheckKey(Keys.D4))
{
tileTemplate = greenTemplate;
}
if (CheckKey(Keys.Back) || CheckKey(Keys.Delete))
{
tilemap.Clear();
}
if (CheckKey(Keys.S) && savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
if (CheckKey(Keys.Escape))
{
this.Hide();
screenManager.activeScreen = screenManager.startScreen;
screenManager.activeScreen.Show();
}
oldKeyboardState = keyboardState;
}
/// <summary>
/// Transitions the SavingState through the saving process.
/// Handles selecting the storage device, opening the storage container, and executing the save function
/// </summary>
private void UpdateSaving()
{
switch (savingState)
{
case SavingState.ReadyToSelectStorageDevice:
#if XBOX
if (!Guide.IsVisible)
#endif
{
asyncResult = StorageDevice.BeginShowSelector(playerIndex, null, null);
savingState = SavingState.SelectingStorageDevice;
}
break;
case SavingState.SelectingStorageDevice:
if (asyncResult.IsCompleted)
{
storageDevice = StorageDevice.EndShowSelector(asyncResult);
savingState = SavingState.ReadyToOpenStorageContainer;
}
break;
case SavingState.ReadyToOpenStorageContainer:
if (storageDevice == null || !storageDevice.IsConnected)
{
savingState = SavingState.ReadyToSelectStorageDevice;
}
else
{
asyncResult = storageDevice.BeginOpenContainer("EditorStorageContainer", null, null);
savingState = SavingState.OpeningStorageContainer;
}
break;
case SavingState.OpeningStorageContainer:
if (asyncResult.IsCompleted)
{
storageContainer = storageDevice.EndOpenContainer(asyncResult);
savingState = SavingState.ReadyToSave;
}
break;
case SavingState.ReadyToSave:
if (storageContainer == null)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
else
{
try
{
string filename = GetUniqueFileName();
Save(filename);
}
catch (IOException e)
{
// Replace with in game dialog notifying user of error
Console.Out.WriteLine(e.Message);
}
finally
{
storageContainer.Dispose();
storageContainer = null;
savingState = SavingState.NotSaving;
}
}
break;
}
}
private void UpdateSaving()
{
switch (savingState)
{
case SavingState.ReadyToSelectStorageDevice:
#if XBOX
if (!Guide.IsVisible)
#endif
{
asyncResult = StorageDevice.BeginShowSelector(playerIndex, null, null);
savingState = SavingState.SelectingStorageDevice;
}
break;
case SavingState.SelectingStorageDevice:
if (asyncResult.IsCompleted)
{
storageDevice = StorageDevice.EndShowSelector(asyncResult);
savingState = SavingState.ReadyToOpenStorageContainer;
}
break;
case SavingState.ReadyToOpenStorageContainer:
if (storageDevice == null || !storageDevice.IsConnected)
{
savingState = SavingState.ReadyToSelectStorageDevice;
}
else
{
asyncResult = storageDevice.BeginOpenContainer("Game1StorageContainer", null, null);
savingState = SavingState.OpeningStorageContainer;
}
break;
case SavingState.OpeningStorageContainer:
if (asyncResult.IsCompleted)
{
storageContainer = storageDevice.EndOpenContainer(asyncResult);
savingState = SavingState.ReadyToSave;
}
break;
case SavingState.ReadyToSave:
if (storageContainer == null)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
else
{
try
{
DeleteExisting();
Save();
}
catch (IOException e)
{
// Replace with in game dialog notifying user of error
Debug.WriteLine(e.Message);
}
finally
{
storageContainer.Dispose();
storageContainer = null;
savingState = SavingState.NotSaving;
}
}
break;
}
}
public SavingState SaveStockItem(ItemStock itemStock, DbCommand command = null, bool isTransection = false)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(itemStock.ItemId))
{
DbCommand thisCommand = null;
try
{
if (!isTransection)
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
}
else
{
thisCommand = command;
}
/// if new Item
if (string.IsNullOrEmpty(itemStock.StockId))
{
if (!isTransection)
{
if (!IsItemExistInStock(itemStock.ItemId))
{
thisCommand.CommandText = "INSERT INTO IM_Items_Stock (StockId, ItemId, TotalStock, DamagedStock, ChalanNo, StockEntryDate) VALUES(@StockId, @ItemId, @TotalStock, @DamagedStock, @ChalanNo, @StockEntryDate)";
CreateParameter.AddParam(thisCommand, "@StockId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
if (!IsItemExistInStock(itemStock.ItemId, thisCommand, isTransection))
{
thisCommand.CommandText = "INSERT INTO IM_Items_Stock (StockId, ItemId, TotalStock, DamagedStock, ChalanNo, StockEntryDate) VALUES(@StockId, @ItemId, @TotalStock, @DamagedStock, @ChalanNo, @StockEntryDate)";
CreateParameter.AddParam(thisCommand, "@StockId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
}
else
{
thisCommand.CommandText = "UPDATE IM_Items_Stock SET TotalStock = @TotalStock, DamagedStock = @DamagedStock, ChalanNo = @ChalanNo, StockEntryDate = @StockEntryDate WHERE StockId = @StockId AND ItemId = @ItemId";
CreateParameter.AddParam(thisCommand, "@StockId", itemStock.StockId, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@ItemId", itemStock.ItemId, DbType.String);
CreateParameter.AddParam(thisCommand, "@TotalStock", itemStock.CurrentStockTotal, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@DamagedStock", itemStock.CurrentDamagedStockTotal, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ChalanNo", itemStock.ChalanNo, DbType.String);
CreateParameter.AddParam(thisCommand, "@StockEntryDate", itemStock.StockEntryDate.Date, DbType.Date);
if (!itemStock.StockEntryDate.Date.Equals(DateTime.MinValue))
{
if (isTransection)
{
GenericDataAccess.ExecuteNonQueryTransaction(thisCommand);
}
else
{
GenericDataAccess.ExecuteNonQuery(thisCommand);
}
}
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (!isTransection)
{
GenericDataAccess.CloseDBConnection(thisCommand);
}
}
}
return(svState);
}
//commented out by chad
//void LoadFromDevice()
//{
// XmlSerializer reader = new XmlSerializer(typeof(SaveGame));
// try
// {
// if (File.Exists(filename))
// {
// using (FileStream input = File.OpenRead(filename))
// {
// loadData = reader.Deserialize(input) as SaveGame;
// }
// }
// }
// catch (InvalidOperationException)
// {
// Console.WriteLine("Your mom is an invalid operation, with loading data from ScoreBoard");
// }
//}
void SaveToDevice()
{
//saveData = new SaveGame();
saveData.saveLevel0 = loadData.saveLevel0;
saveData.saveLevel1 = loadData.saveLevel1;
saveData.saveLevel2 = loadData.saveLevel2;
saveData.saveLevel3 = loadData.saveLevel3;
saveData.saveLevel4 = loadData.saveLevel4;
saveData.saveLevel5 = loadData.saveLevel5;
saveData.saveLevel6 = loadData.saveLevel6;
saveData.saveLevel7 = loadData.saveLevel7;
saveData.level0Played = loadData.level0Played;
saveData.level0Average = loadData.level0Average;
saveData.level1Played = loadData.level1Played;
saveData.level1Average = loadData.level1Average;
saveData.level2Played = loadData.level2Played;
saveData.level2Average = loadData.level2Average;
saveData.level3Played = loadData.level3Played;
saveData.level3Average = loadData.level3Average;
saveData.level4Played = loadData.level4Played;
saveData.level4Average = loadData.level4Average;
saveData.level5Played = loadData.level5Played;
saveData.level5Average = loadData.level5Average;
saveData.level6Played = loadData.level6Played;
saveData.level6Average = loadData.level6Average;
saveData.level7Played = loadData.level7Played;
saveData.level7Average = loadData.level7Average;
saveData.level0Fastest = loadData.level0Fastest;
saveData.level1Fastest = loadData.level1Fastest;
saveData.level2Fastest = loadData.level2Fastest;
saveData.level3Fastest = loadData.level3Fastest;
saveData.level4Fastest = loadData.level4Fastest;
saveData.level5Fastest = loadData.level5Fastest;
saveData.level6Fastest = loadData.level6Fastest;
saveData.level7Fastest = loadData.level7Fastest;
if (levelID == 0)
{
if (Convert.ToInt32(loadData.saveLevel0) < levelPercent)
saveData.saveLevel0 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level0Fastest) > timeNeeded || loadData.level0Fastest == "0")
saveData.level0Fastest = Convert.ToString(timeNeeded);
saveData.level0Average = Convert.ToString(((Convert.ToInt32(loadData.level0Average) * Convert.ToInt32(loadData.level0Played)) + levelPercent) / (Convert.ToInt32(loadData.level0Played) + 1));
saveData.level0Played = Convert.ToString((Convert.ToInt32(loadData.level0Played) + 1));
}
if (levelID == 1)
{
if (Convert.ToInt32(loadData.saveLevel1) < levelPercent)
saveData.saveLevel1 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level1Fastest) > timeNeeded || loadData.level1Fastest == "0")
saveData.level1Fastest = Convert.ToString(timeNeeded);
saveData.level1Average = Convert.ToString(((Convert.ToInt32(loadData.level1Average) * Convert.ToInt32(loadData.level1Played)) + levelPercent) / (Convert.ToInt32(loadData.level1Played) + 1));
saveData.level1Played = Convert.ToString((Convert.ToInt32(loadData.level1Played) + 1));
}
if (levelID == 2)
{
if (Convert.ToInt32(loadData.saveLevel2) < levelPercent)
saveData.saveLevel2 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level2Fastest) > timeNeeded || loadData.level2Fastest == "0")
saveData.level2Fastest = Convert.ToString(timeNeeded);
saveData.level2Average = Convert.ToString(((Convert.ToInt32(loadData.level2Average) * Convert.ToInt32(loadData.level2Played)) + levelPercent) / (Convert.ToInt32(loadData.level2Played) + 1));
saveData.level2Played = Convert.ToString((Convert.ToInt32(loadData.level2Played) + 1));
}
if (levelID == 3)
{
if (Convert.ToInt32(loadData.saveLevel3) < levelPercent)
saveData.saveLevel3 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level3Fastest) > timeNeeded || loadData.level3Fastest == "0")
saveData.level3Fastest = Convert.ToString(timeNeeded);
saveData.level3Average = Convert.ToString(((Convert.ToInt32(loadData.level3Average) * Convert.ToInt32(loadData.level3Played)) + levelPercent) / (Convert.ToInt32(loadData.level3Played) + 1));
saveData.level3Played = Convert.ToString((Convert.ToInt32(loadData.level3Played) + 1));
}
if (levelID == 4)
{
if (Convert.ToInt32(loadData.saveLevel4) < levelPercent)
saveData.saveLevel4 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level4Fastest) > timeNeeded || loadData.level4Fastest == "0")
saveData.level4Fastest = Convert.ToString(timeNeeded);
saveData.level4Average = Convert.ToString(((Convert.ToInt32(loadData.level4Average) * Convert.ToInt32(loadData.level4Played)) + levelPercent) / (Convert.ToInt32(loadData.level4Played) + 1));
saveData.level4Played = Convert.ToString((Convert.ToInt32(loadData.level4Played) + 1));
}
if (levelID == 5)
{
if (Convert.ToInt32(loadData.saveLevel5) < levelPercent)
saveData.saveLevel5 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level5Fastest) > timeNeeded || loadData.level5Fastest == "0")
saveData.level5Fastest = Convert.ToString(timeNeeded);
saveData.level5Average = Convert.ToString(((Convert.ToInt32(loadData.level5Average) * Convert.ToInt32(loadData.level5Played)) + levelPercent) / (Convert.ToInt32(loadData.level5Played) + 1));
saveData.level5Played = Convert.ToString((Convert.ToInt32(loadData.level5Played) + 1));
}
if (levelID == 6)
{
if (Convert.ToInt32(loadData.saveLevel6) < levelPercent)
saveData.saveLevel6 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level6Fastest) > timeNeeded || loadData.level6Fastest == "0")
saveData.level6Fastest = Convert.ToString(timeNeeded);
saveData.level6Average = Convert.ToString(((Convert.ToInt32(loadData.level6Average) * Convert.ToInt32(loadData.level6Played)) + levelPercent) / (Convert.ToInt32(loadData.level6Played) + 1));
saveData.level6Played = Convert.ToString((Convert.ToInt32(loadData.level6Played) + 1));
}
if (levelID == 7)
{
if (Convert.ToInt32(loadData.saveLevel7) < levelPercent)
saveData.saveLevel7 = Convert.ToString(levelPercent);
if (Convert.ToInt32(loadData.level7Fastest) > timeNeeded || loadData.level7Fastest == "0")
saveData.level7Fastest = Convert.ToString(timeNeeded);
saveData.level7Average = Convert.ToString(((Convert.ToInt32(loadData.level7Average) * Convert.ToInt32(loadData.level7Played)) + levelPercent) / (Convert.ToInt32(loadData.level7Played) + 1));
saveData.level7Played = Convert.ToString((Convert.ToInt32(loadData.level7Played) + 1));
}
//added by chad
if (savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
}
//commented out by chad
//try
//{
// XmlSerializer writer = new XmlSerializer(typeof(SaveGame));
// using (FileStream file = File.OpenWrite(filename))
// {
// StreamWriter write = new StreamWriter(filename);
// writer.Serialize(file, saveData);
// errorFreeSave = true;
// }
//}
//catch (Exception e)
//{
// Console.WriteLine(e.ToString());
// Console.WriteLine("Your mom failed to save the game properly");
// errorFreeSave = false;
//}
}
/// <summary>
/// Helper methods : Save/Load
/// </summary>
public void UpdateSaveKey(Microsoft.Xna.Framework.Input.Keys key)
{
if (keyboard.isPressed(key))
{
if (savingState == SavingState.NotSaving)
{
savingState = SavingState.ReadyToOpenStorageContainer;
Debug.WriteLine("Updatesavekey");
}
}
}
public SavingState SaveItemsOrder(DataGridView dataGridViewOrder, string companyId, string srDsrId, string marketId, DateTime orderDate, SRDSRDue srDsrDue, bool isFromTemplate = false, bool isItemReturnedFromOrder = false, bool isDamagedItemReturnedFromOrder = false)
{
SavingState svState = SavingState.Failed;
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
GenericDataAccess.OpenDBConnection(thisCommand);
if ((isFromTemplate && !IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate)) || (!isFromTemplate && IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate)))
{
foreach (DataGridViewRow row in dataGridViewOrder.Rows)
{
int stockAvailableInStore = 0;
int damagedItemAvailableInStock = 0;
if (string.IsNullOrEmpty(NullHandler.GetString(row.Cells["OrderId"].Value)))
{
/// insert the item order
thisCommand.CommandText = "INSERT INTO IM_Orders (OrderId, CompanyId, SrId, MarketId, ItemId, Date, OrderCount, ReturnCount, SoldCount, DamagedCount) VALUES(@OrderId, @CompanyId, @SrId, @MarketId, @ItemId, @Date, @OrderCount, @ReturnCount, @SoldCount, @DamagedCount)";
CreateParameter.AddParam(thisCommand, "@OrderId", Guid.NewGuid().ToString(), DbType.String);
CreateParameter.AddParam(thisCommand, "@CompanyId", companyId, DbType.String);
CreateParameter.AddParam(thisCommand, "@SrId", srDsrId, DbType.String);
CreateParameter.AddParam(thisCommand, "@MarketId", marketId, DbType.String);
CreateParameter.AddParam(thisCommand, "@ItemId", NullHandler.GetString(row.Cells["ItemId"].Value), DbType.String);
CreateParameter.AddParam(thisCommand, "@Date", orderDate.Date, DbType.Date);
stockAvailableInStore = NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) - NullHandler.GetInt32(row.Cells["SellsCount"].Value);
damagedItemAvailableInStock = NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value);
}
else
{
/// update the item order based on OrderId
thisCommand.CommandText = "UPDATE IM_Orders SET OrderCount = @OrderCount, ReturnCount = @ReturnCount, SoldCount = @SoldCount, DamagedCount = @DamagedCount WHERE OrderId = @OrderId";
CreateParameter.AddParam(thisCommand, "@OrderId", row.Cells["OrderId"].Value.ToString(), DbType.String);
stockAvailableInStore = isItemReturnedFromOrder ? (NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) + NullHandler.GetInt32(row.Cells["ReturnCount"].Value)) : NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value);
damagedItemAvailableInStock = isDamagedItemReturnedFromOrder? (NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value) + NullHandler.GetInt32(row.Cells["DamageCount"].Value)): NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value);
}
CreateParameter.AddParam(thisCommand, "@OrderCount", row.Cells["OrderCount"].Value, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ReturnCount", row.Cells["ReturnCount"].Value, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@DamagedCount", row.Cells["DamageCount"].Value, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@SoldCount", row.Cells["SellsCount"].Value, DbType.Int32);
GenericDataAccess.ExecuteNonQueryTransaction(thisCommand);
thisCommand.Parameters.Clear();
if (!string.IsNullOrEmpty(NullHandler.GetString(row.Cells["StockId"].Value)))
{
ItemStock stock = new ItemStock();
stock.StockId = NullHandler.GetString(row.Cells["StockId"].Value);
stock.ItemId = NullHandler.GetString(row.Cells["ItemId"].Value);
stock.ChalanNo = NullHandler.GetString(row.Cells["ChalanNo"].Value);
stock.StockEntryDate = NullHandler.GetDateTime(row.Cells["StockEntryDate"].Value);
stock.CurrentStockTotal = stockAvailableInStore;//NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value);
stock.CurrentDamagedStockTotal = damagedItemAvailableInStock;
svState = SaveStockItem(stock, thisCommand, true);
}
}
}
else
{
svState = SavingState.DuplicateExists;
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
GenericDataAccess.CloseDBConnection(thisCommand);
}
if (svState.Equals(SavingState.Success) && !string.IsNullOrEmpty(srDsrDue.Id))
{
svState = SRDSRManager.Instance.SaveSrDsrDue(srDsrDue);
}
return(svState);
}
