private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
DialogResult message = MessageBox.Show("Bạn có chắc chắn sửa điểm tích lũy?", "Sửa điểm tích lũy", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (message == DialogResult.Cancel)
{
return;
}
if (e.RowIndex == -1)
{
return;
}
DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
if (row.Cells[REWARD_POINT_HISTORY_ID_COLUMN_NAME].Value.ToString() == "-1")
{
//Insert Reward point
return;
}
int rewardPointHistoryId = int.Parse(row.Cells[REWARD_POINT_HISTORY_ID_COLUMN_NAME].Value.ToString());
int point = int.Parse(row.Cells[POINTS_COLUMN_NAME].Value.ToString());
int pointBalance = int.Parse(row.Cells[POINTS_BALANCE_COLUMN_NAME].Value.ToString());
decimal usedAmount = decimal.Parse(row.Cells[USED_AMOUNT_COLUMN_NAME].Value.ToString());
JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter rewardPointHistoryTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter();
rewardPointHistoryTableAdapter.Connection = CommonHelper.GetSQLConnection();
rewardPointHistoryTableAdapter.UpdateRewardPointsInfoById(point, pointBalance, usedAmount, rewardPointHistoryId);
}
public CustomerRewardPointsHistoryUserControl()
{
InitializeComponent();
custTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter();
custTableAdapter.Connection = CommonHelper.GetSQLConnection();
rewardPointsByCustIdTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryByCustomerIdTableAdapter();
rewardPointsByCustIdTableAdapter.Connection = CommonHelper.GetSQLConnection();
rewardPointHistoryTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter();
rewardPointHistoryTableAdapter.Connection = CommonHelper.GetSQLConnection();
}
public CustomerForm()
{
InitializeComponent();
customerTableAdapter = new JSManagementDataSetTableAdapters.CustomerTableAdapter();
this.customerTableAdapter.Connection = CommonHelper.GetSQLConnection();
customerTypeTableAdapter = new JSManagementDataSetTableAdapters.CustomerTypeTableAdapter();
customerTypeTableAdapter.Connection = CommonHelper.GetSQLConnection();
rewardPointsHistoryTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryTableAdapter();
rewardPointsHistoryTableAdapter.Connection = CommonHelper.GetSQLConnection();
getProductInOutDetailTableAdapter = new JSManagementDataSetTableAdapters.GetProductInOutDetailTableAdapter();
getProductInOutDetailTableAdapter.Connection = CommonHelper.GetSQLConnection();
rewardPointsByCustIdTableAdapter = new JSManagementDataSetTableAdapters.RewardPointsHistoryByCustomerIdTableAdapter();
rewardPointsByCustIdTableAdapter.Connection = CommonHelper.GetSQLConnection();
}
