private void dgTokenDetail_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 9)
{
if (Convert.ToInt32(dgTokenDetail.Rows[e.RowIndex].Cells["tId"].Value) <= 0)
{
return;
}
frmTokenInformation frm = new frmTokenInformation();
// frm.MdiParent = this.MdiParent;
StaticClass.DealerTokenId = Convert.ToInt32(dgTokenDetail.Rows[e.RowIndex].Cells["tId"].Value);
// StaticClass.LocationX = 0;
// StaticClass.LocationY = 92;
// frm.Dock = DockStyle.Fill;
frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.MaximizeBox = false;
frm.ShowDialog();
GetDealerUserLedger();
}
}
private void dgAdvtDetail_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 9)
{
frmTokenInformation frm = new frmTokenInformation();
StaticClass.DealerTokenId = 0;
StaticClass.dealerUserId = Convert.ToInt32(dgAdvtDetail.Rows[e.RowIndex].Cells["userid"].Value);
StaticClass.DealerDfClientId = Convert.ToInt32(cmbClientName.SelectedValue);
StaticClass.DealerTokenId = Convert.ToInt32(dgAdvtDetail.Rows[e.RowIndex].Cells["tId"].Value);
frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.MaximizeBox = false;
frm.ShowDialog();
string str = "";
if (cmbPlayerVersion.Text == "")
{
str = "GetLicenseExpiryToken " + Convert.ToInt32(cmbClientName.SelectedValue) + " , 'Normal' , '" + gblClass.MusicType + "' ";
}
else
{
str = "GetLicenseExpiryToken " + Convert.ToInt32(cmbClientName.SelectedValue) + " , '" + cmbPlayerVersion.Text + "' , '" + gblClass.MusicType + "' ";
}
FillAdvertisementData(str);
}
}
private void dgToken_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 10)
{
frmTokenInformation frm = new frmTokenInformation();
StaticClass.DealerTokenId = 0;
StaticClass.dealerUserId = Convert.ToInt32(dgToken.Rows[e.RowIndex].Cells["uId"].Value);
StaticClass.DealerDfClientId = Convert.ToInt32(cmbClientName.SelectedValue);
StaticClass.DealerTokenId = Convert.ToInt32(dgToken.Rows[e.RowIndex].Cells["id"].Value);
frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.MaximizeBox = false;
frm.ShowDialog();
FillData();
}
}
private void dgAccountSettings_CellClick(object sender, DataGridViewCellEventArgs e)
{
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
string swr = "";
string sAr = "";
Int32 NoofToken = 0;
if (e.RowIndex < 0)
{
return;
}
try
{
if ((dgAccountSettings.Focused) && (dgAccountSettings.CurrentCell.ColumnIndex == 3))
{
dtpOrder.Location = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Location;
dtpOrder.Width = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Width;
dtpOrder.Visible = true;
if (dgAccountSettings.CurrentCell.Value != DBNull.Value)
{
dtpOrder.Value = Convert.ToDateTime(dgAccountSettings.CurrentCell.Value);
}
else
{
dtpOrder.Value = DateTime.Today;
}
}
else if ((dgAccountSettings.Focused) && (dgAccountSettings.CurrentCell.ColumnIndex == 5))
{
dtpOrder.Location = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Location;
dtpOrder.Width = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Width;
dtpOrder.Visible = true;
if (dgAccountSettings.CurrentCell.Value != DBNull.Value)
{
dtpOrder.Value = Convert.ToDateTime(dgAccountSettings.CurrentCell.Value);
}
else
{
dtpOrder.Value = DateTime.Today;
}
}
else if ((dgAccountSettings.Focused) && (dgAccountSettings.CurrentCell.ColumnIndex == 7))
{
dtpOrder.Location = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Location;
dtpOrder.Width = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Width;
dtpOrder.Visible = true;
if (dgAccountSettings.CurrentCell.Value != DBNull.Value)
{
dtpOrder.Value = Convert.ToDateTime(dgAccountSettings.CurrentCell.Value);
}
else
{
dtpOrder.Value = DateTime.Today;
}
}
else if ((dgAccountSettings.Focused) && (dgAccountSettings.CurrentCell.ColumnIndex == 10))
{
dtpOrder.Location = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Location;
dtpOrder.Width = dgAccountSettings.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false).Width;
dtpOrder.Visible = true;
if (dgAccountSettings.CurrentCell.Value != DBNull.Value)
{
dtpOrder.Value = Convert.ToDateTime(dgAccountSettings.CurrentCell.Value);
}
else
{
dtpOrder.Value = DateTime.Today;
}
}
else
{
dtpOrder.Visible = false;
}
if (e.ColumnIndex == 14)
{
frmTokenInformation frm = new frmTokenInformation();
StaticClass.DealerTokenId = 0;
StaticClass.dealerUserId = Convert.ToInt32(cmbUserName.SelectedValue);
StaticClass.DealerDfClientId = Convert.ToInt32(cmbClientName.SelectedValue);
StaticClass.DealerUserName = cmbUserName.Text.ToString();
StaticClass.DealerTokenId = Convert.ToInt32(dgAccountSettings.Rows[e.RowIndex].Cells["tokenid"].Value);
frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.MaximizeBox = false;
frm.ShowDialog();
FillTokenGenerationData();
}
if (e.ColumnIndex == 15)
{
DialogResult result1;
result1 = MessageBox.Show("Are you sure to delete ?", "Management Panel", MessageBoxButtons.YesNo);
if (result1 == System.Windows.Forms.DialogResult.Yes)
{
string strDel = "";
strDel = "";
strDel = "delete from TitlesInPlaylists where Playlistid in( ";
strDel = strDel + "select distinct Playlistid from playlists where tokenid = " + Convert.ToInt32(dgAccountSettings.Rows[e.RowIndex].Cells["tokenid"].Value) + ")";
if (StaticClass.constr.State == ConnectionState.Open)
{
StaticClass.constr.Close();
}
StaticClass.constr.Open();
SqlCommand cmd = new SqlCommand(strDel, StaticClass.constr);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
StaticClass.constr.Close();
strDel = "";
strDel = "delete from playlists where tokenid = " + Convert.ToInt32(dgAccountSettings.Rows[e.RowIndex].Cells["tokenid"].Value) + " ";
if (StaticClass.constr.State == ConnectionState.Open)
{
StaticClass.constr.Close();
}
StaticClass.constr.Open();
cmd = new SqlCommand(strDel, StaticClass.constr);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
StaticClass.constr.Close();
strDel = "";
strDel = "delete from AMPlayerTokens where tokenid = " + Convert.ToInt32(dgAccountSettings.Rows[e.RowIndex].Cells["tokenid"].Value) + " ";
if (StaticClass.constr.State == ConnectionState.Open)
{
StaticClass.constr.Close();
}
StaticClass.constr.Open();
cmd = new SqlCommand(strDel, StaticClass.constr);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
StaticClass.constr.Close();
dtpOrder.Visible = false;
FillTokenGenerationData();
}
}
if (e.ColumnIndex == 4)
{
if (Convert.ToBoolean(dgAccountSettings.Rows[e.RowIndex].Cells[6].Value) == true)
{
dgAccountSettings.Rows[e.RowIndex].Cells[6].Value = false;
}
}
if (e.ColumnIndex == 6)
{
if (Convert.ToBoolean(dgAccountSettings.Rows[e.RowIndex].Cells[4].Value) == true)
{
dgAccountSettings.Rows[e.RowIndex].Cells[4].Value = false;
}
}
//if (e.ColumnIndex == 9)
//{
// if (dgAccountSettings.Rows[e.RowIndex].Cells[1].Value.ToString() == "Used")
// {
// MessageBox.Show("This token is used by client. !! You only block this token !!", "Management Panel");
// return;
// }
// result = MessageBox.Show("Are you sure to delete this token ?", "Management Panel", buttons);
// if (result == System.Windows.Forms.DialogResult.Yes)
// {
// swr = "select NoOfToken from Users where userid=" + Convert.ToInt32(cmbUserName.SelectedValue);
// DataTable dsUser = new DataTable();
// dsUser = objMainClass.fnFillDataTable(swr);
// NoofToken = Convert.ToInt32(dsUser.Rows[0]["NoOfToken"]);
// NoofToken = NoofToken - 1;
// if (StaticClass.constr.State == ConnectionState.Open) StaticClass.constr.Close();
// StaticClass.constr.Open();
// SqlCommand cmd = new SqlCommand("Delete_User_Token", StaticClass.constr);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.BigInt));
// cmd.Parameters["@UserId"].Value = Convert.ToInt32(cmbUserName.SelectedValue);
// cmd.Parameters.Add(new SqlParameter("@TokenId", SqlDbType.BigInt));
// cmd.Parameters["@TokenId"].Value = Convert.ToInt32(dgAccountSettings.Rows[e.RowIndex].Cells[0].Value);
// cmd.Parameters.Add(new SqlParameter("@ClientId", SqlDbType.BigInt));
// cmd.Parameters["@ClientId"].Value = Convert.ToInt32(cmbClientName.SelectedValue);
// cmd.Parameters.Add(new SqlParameter("@NoofToken", SqlDbType.BigInt));
// cmd.Parameters["@NoofToken"].Value = Convert.ToInt32(NoofToken);
// try
// {
// cmd.ExecuteNonQuery();
// dgAccountSettings.Rows.RemoveAt(e.RowIndex);
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
// finally
// {
// StaticClass.constr.Close();
// }
// }
// else if (result == System.Windows.Forms.DialogResult.No)
// {
// return;
// }
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
