private void Userlogin()
{
DataSet dsDefault = new DataSet();
DataSet ds = new DataSet();
Int32 dfId = 0;
TokenDealerCode = "AlenkaMyclaud";
if (txtUsername.Text == "" || txtTokenNo.Text == "")
{
lblWait.Visible = false;
MessageBox.Show("Username and Token no cannot be blank", "Player");
return;
}
if (txtDealerCode.Text.Trim() != "" && txtDealerCode.Text != "AlenkaMyclaud")
{
str = "";
str = "select * from DFClients where isdealer=1 and ClientName='" + txtUsername.Text.Trim() + "'";
dsDefault = ObjMainClass.fnFillDataSet(str);
if (dsDefault.Tables[0].Rows.Count > 0)
{
if (txtDealerCode.Text.ToUpper() != dsDefault.Tables[0].Rows[0]["DealerCode"].ToString())
{
lblWait.Visible = false;
MessageBox.Show("The dealer code you have inserted is wrong.", "Player");
txtDealerCode.Focus();
return;
}
else if (txtDealerCode.Text.ToUpper() == dsDefault.Tables[0].Rows[0]["DealerCode"].ToString())
{
TokenDealerCode = dsDefault.Tables[0].Rows[0]["DealerCode"].ToString();
dfId = Convert.ToInt32(dsDefault.Tables[0].Rows[0]["DFClientId"]);
}
}
}
if (TokenDealerCode == "AlenkaMyclaud")
{
str = "";
str = "select * from DFClients where isdealer=1 and ClientName='" + txtUsername.Text.Trim() + "'";
dsDefault = ObjMainClass.fnFillDataSet(str);
if (dsDefault.Tables[0].Rows.Count > 0)
{
TokenDealerCode = dsDefault.Tables[0].Rows[0]["DealerCode"].ToString();
dfId = Convert.ToInt32(dsDefault.Tables[0].Rows[0]["DFClientId"]);
}
}
if (dfId != 0)
{
if (GetDealerPendingTokens(dfId) == 0)
{
//MessageBox.Show("You have reached the maximum of your tokens. Please contact your administrator.", "Player");
//txtUsername.Focus();
//return;
}
}
str = "spGetTokenRights '" + txtUsername.Text + "', '" + txtTokenNo.Text + "' ";
ds = new DataSet();
ds = ObjMainClass.fnFillDataSet(str);
if (ds.Tables[0].Rows.Count <= 0)
{
lblWait.Visible = false;
MessageBox.Show("Your username or token is wrong.", "Player");
return;
}
else if (ds.Tables[0].Rows[0]["PlayerType"].ToString() != "Desktop")
{
lblWait.Visible = false;
MessageBox.Show("This token is not matching with this license type.", "Player");
return;
}
//else if ((ds.Tables[0].Rows[0]["MusicType"].ToString() != "Copyright") && (ds.Tables[0].Rows[0]["MusicType"].ToString() != "NativeCR"))
//{
// lblWait.Visible = false;
// MessageBox.Show("This token is not matching with this music type.", "Player");
// return;
//}
StaticClass.dfClientId = ds.Tables[0].Rows[0]["ClientID"].ToString();
StaticClass.TokenId = ds.Tables[0].Rows[0]["tokenid"].ToString();
str = "";
str = "Update AMPlayerTokens set Code='" + GenerateId.getKey(GenerateId._wvpaudi) + "' , " +
" pVersion='NativeCR', DateTokenUsed=getdate() , Token='used' ,DealerCode='" + TokenDealerCode + "' " +
" where TokenId=" + StaticClass.TokenId + "";
if (StaticClass.constr.State == ConnectionState.Open)
{
StaticClass.constr.Close();
}
StaticClass.constr.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = StaticClass.constr;
cmd.CommandText = str;
cmd.ExecuteNonQuery();
StaticClass.constr.Close();
CreateFile(ds.Tables[0].Rows[0]["tokenid"].ToString());
str = "";
str = "select * from tbluser_client_rights where userid=" + StaticClass.dfClientId + " and isAdmin=1";
dsDefault = ObjMainClass.fnFillDataSet(str);
if (dsDefault.Tables[0].Rows.Count <= 0)
{
SaveDefaultUser();
}
CheckClientsRights();
lblWait.Visible = false;
if (StaticClass.LocalCon.State == ConnectionState.Open)
{
StaticClass.LocalCon.Close();
}
StaticClass.LocalCon.Open();
OleDbCommand cmdLocal = new OleDbCommand();
cmdLocal.Connection = StaticClass.LocalCon;
cmdLocal.CommandText = "insert into tbMisc(DealerCode,IsStore,DfClientId,IsAdvt,IsLock,ScheduleType) values('" + StaticClass.DealerCode + "'," + Convert.ToByte(StaticClass.IsStore) + "," + StaticClass.dfClientId + "," + Convert.ToByte(StaticClass.IsAdvt) + "," + Convert.ToByte(StaticClass.IsLock) + ",'" + StaticClass.ScheduleType + "')";
cmdLocal.ExecuteNonQuery();
StaticClass.LocalCon.Close();
Clientlogin objClientlogin = new Clientlogin();
objClientlogin.Show();
this.Hide();
}
static void Main(string[] args)
{
try
{
gblClass objMainClass = new gblClass();
StaticClass.constr = new SqlConnection("Data Source=134.119.178.26;database=OnlineDB;uid=sa;password=Jan@Server007;Connect Timeout=5000");
StaticClass.LocalCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\db.mdb;User Id=admin;Password=;";
string str = "";
string localCode = "";
string filename = Application.StartupPath + "\\tid.amp";
string textline = "";
Int64 IsBlock = 0;
Int64 IsSuspend = 0;
string ExpiryCopyrightStatus = "";
Int64 LeftCopyrightDays = 0;
string strOpt = "";
string proc = Process.GetCurrentProcess().ProcessName;
Process[] processes = Process.GetProcessesByName(proc);
if (processes.Length > 1)
{
// MessageBox.Show("Application is already running", "Player");
// return;
}
if (File.Exists(filename))
{
System.IO.StreamReader objReader;
objReader = new System.IO.StreamReader(filename);
do
{
textline = textline + objReader.ReadLine();
} while (objReader.Peek() != -1);
objReader.Close();
if (objMainClass.CheckForInternetConnection() == false)
{
StaticClass.DealerCode = "0";
StaticClass.TokenServiceId = 0;
StaticClass.IsAdvtManual = false;
StaticClass.IsAdvt = false;
StaticClass.IsBlockAdvt = false;
StaticClass.TokenUserId = 0;
StaticClass.AdvtCityId = 0;
StaticClass.IsCopyright = true;
StaticClass.dfClientId = "0";
StaticClass.TokenId = textline;
try
{
string strOpt1 = "select * from tbMisc";
DataSet dsOption1 = new DataSet();
dsOption1 = objMainClass.fnFillDataSet_Local(strOpt1);
if (dsOption1.Tables[0].Rows.Count > 0)
{
StaticClass.DealerCode = dsOption1.Tables[0].Rows[0]["DealerCode"].ToString();
StaticClass.dfClientId = dsOption1.Tables[0].Rows[0]["dfClientId"].ToString();
StaticClass.IsStore = Convert.ToBoolean(dsOption1.Tables[0].Rows[0]["IsStore"]);
StaticClass.IsAdvt = Convert.ToBoolean(dsOption1.Tables[0].Rows[0]["IsAdvt"]);
StaticClass.IsLock = Convert.ToBoolean(dsOption1.Tables[0].Rows[0]["IsLock"]);
StaticClass.IsVedioActive = Convert.ToBoolean(dsOption1.Tables[0].Rows[0]["IsLock"]);
StaticClass.ScheduleType = dsOption1.Tables[0].Rows[0]["ScheduleType"].ToString();
}
}
catch (Exception ex) { }
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmVideoPlayer());
// Application.SetCompatibleTextRenderingDefault(false);
// Application.Run(new frmNet());
return;
}
if (StaticClass.constr.State == ConnectionState.Open)
{
StaticClass.constr.Close();
}
StaticClass.constr.Open();
strOpt = "select ISNULL(IsCopyright,0) as Copyright, ISNULL(IsFitness,0) as Fitness, isnull(IsStream,0) as Stream,dealerCode, ISNULL(IsAdvt,0) as Advt, ISNULL(IsAdvtManual,0) as AdvtManual, ISNULL(IsBlockAdvt,0) as IsBlockAdvt, isnull(serviceid,0) as serviceid , isnull(cityid,0) as CityId , isnull(StateId,0) as StateId, isnull(CountryId,0) as CountryId, UserId, isnull(isStore,0) as isStore,isnull(IsStopControl,0) as IsLock , isnull(IsVedioActive,0) as VedioActive , isnull(AMPlayerTokens.ScheduleType,'0') as ScheduleType from AMPlayerTokens where TokenID=" + textline;
DataSet dsOption = new DataSet();
dsOption = objMainClass.fnFillDataSet(strOpt);
if (dsOption.Tables[0].Rows.Count > 0)
{
StaticClass.TokenServiceId = Convert.ToInt32(dsOption.Tables[0].Rows[0]["serviceid"]);
StaticClass.DealerCode = dsOption.Tables[0].Rows[0]["DealerCode"].ToString();
StaticClass.IsAdvtManual = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["AdvtManual"]);
StaticClass.IsAdvt = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["Advt"]);
StaticClass.IsBlockAdvt = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["IsBlockAdvt"]);
StaticClass.TokenUserId = Convert.ToInt32(dsOption.Tables[0].Rows[0]["userid"]);
StaticClass.AdvtCityId = Convert.ToInt32(dsOption.Tables[0].Rows[0]["CityId"]);
StaticClass.Stateid = Convert.ToInt32(dsOption.Tables[0].Rows[0]["Stateid"]);
StaticClass.CountryId = Convert.ToInt32(dsOption.Tables[0].Rows[0]["CountryId"]);
StaticClass.IsStore = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["IsStore"]);
StaticClass.IsLock = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["IsLock"]);
StaticClass.IsVedioActive = Convert.ToBoolean(dsOption.Tables[0].Rows[0]["VedioActive"]);
StaticClass.TokenId = textline;
StaticClass.ScheduleType = dsOption.Tables[0].Rows[0]["ScheduleType"].ToString();
str = "spGetTokenExpiryStatus_Copyright " + textline + ", " + dsOption.Tables[0].Rows[0]["Copyright"] + ", " + dsOption.Tables[0].Rows[0]["Fitness"] + ", " + dsOption.Tables[0].Rows[0]["Stream"];
DataSet dsExpire = new DataSet();
dsExpire = objMainClass.fnFillDataSet(str);
ExpiryCopyrightStatus = dsExpire.Tables[0].Rows[0]["ExpiryCopyrightStatus"].ToString();
LeftCopyrightDays = Convert.ToInt32(dsExpire.Tables[0].Rows[0]["LeftCopyrightDays"]);
StaticClass.StreamExpiryMessage = dsExpire.Tables[0].Rows[0]["ExpiryStreamStatus"].ToString();
StaticClass.LeftStreamtDays = Convert.ToInt32(dsExpire.Tables[0].Rows[0]["LeftStreamDays"]);
if (ExpiryCopyrightStatus == "NoLic")
{
MessageBox.Show("!! Purchase the subscription of music player !!", "Player");
Application.Exit();
return;
}
if (ExpiryCopyrightStatus == "Yes")
{
MessageBox.Show("!! The license of your music player is expired. Please contact your dealer. !!", "Player");
Application.Exit();
return;
}
if (ExpiryCopyrightStatus != "NoLic" && LeftCopyrightDays <= 10)
{
StaticClass.PlayerExpiryMessage = Convert.ToString(LeftCopyrightDays) + " days left to renewal of subscription";
StaticClass.IsCopyright = true;
}
else if (ExpiryCopyrightStatus != "NoLic" && LeftCopyrightDays == 0)
{
StaticClass.PlayerExpiryMessage = "Last day to renewal of subscription";
StaticClass.IsCopyright = true;
}
else
{
StaticClass.IsCopyright = true;
}
if (ExpiryCopyrightStatus == "Yes")
{
MessageBox.Show("!! Subscription is Expired.Please connect your vendor !!", "Player");
Application.Exit();
return;
}
else if (ExpiryCopyrightStatus == "Yes")
{
StaticClass.PlayerExpiryMessage = "Subscription is Expired.Please connect your vendor";
StaticClass.IsCopyright = false;
}
else if (ExpiryCopyrightStatus == "NoLic")
{
StaticClass.PlayerExpiryMessage = "You do not have license";
StaticClass.IsCopyright = false;
}
// str = "spGetTokenExpiryStatus_Copyleft " + Convert.ToInt32(textline) + ", " + dsOption.Tables[0].Rows[0]["Dam"] + ", " + dsOption.Tables[0].Rows[0]["Sanjivani"] + ", " + dsOption.Tables[0].Rows[0]["Stream"];
StaticClass.StreamExpiryMessage = dsExpire.Tables[0].Rows[0]["ExpiryStreamStatus"].ToString();
StaticClass.LeftStreamtDays = Convert.ToInt32(dsExpire.Tables[0].Rows[0]["LeftStreamDays"]);
str = "select *, ISNULL(IsBlock,0) as Is_Block, ISNULL(IsSuspend,0) as Is_Suspend from AMPlayerTokens where tokenid=" + textline;
DataSet ds = new DataSet();
string dbCode = "";
ds = objMainClass.fnFillDataSet(str);
dbCode = ds.Tables[0].Rows[0]["code"].ToString();
try
{
localCode = GenerateId.getKey(GenerateId._wvpaudi);
}
catch (Exception ex)
{
// dbCode = textline;
// localCode = textline;
}
if (dbCode == localCode)
{
StaticClass.dfClientId = ds.Tables[0].Rows[0]["ClientID"].ToString();
StaticClass.TokenId = ds.Tables[0].Rows[0]["TokenId"].ToString();
IsBlock = Convert.ToInt32(ds.Tables[0].Rows[0]["Is_Block"]);
IsSuspend = Convert.ToInt32(ds.Tables[0].Rows[0]["Is_Suspend"]);
if (IsBlock == 1)
{
MessageBox.Show("Your token is blocked by admin");
Application.Exit();
return;
}
else if (IsSuspend == 1)
{
MessageBox.Show("Your token is suspend by admin");
return;
}
// Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Clientlogin());
return;
}
else
{
// Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmStart());
return;
}
}
else
{
File.Delete(Application.StartupPath + "//tid.amp");
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmStart());
return;
}
}
else
{
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmStart());
return;
}
}
catch (Exception ex)
{
}
}