public void insertDatatoLogin(string LoginId, string Password, string UserName, string Address)
{
try
{
string sql12 = "Select *from Login Where LoginId='" + LoginId + "'";
DataSet dset = cc.ExecuteDatasetEzeeTest(sql12);
if (dset.Tables[0].Rows.Count > 0)
{
}
else
{
SqlQuery = "Insert INTO [DBeZeeOnlineExam].[dbo].[Login](LoginId,UserName,Password,ContactNo,Address,DOJ,Role,CompanyId,Active,admintype,UserType,Category) Values " +
" ('" + LoginId + "',N'" + UserName + "',N'" + Password + "','" + LoginId + "',N'" + Address + "','" + System.DateTime.Now.ToString("yyyy-MM-dd") + "','10','5164','1','1','1','--Select--') ";
flag = cc.ExecuteNonQueryEzeeTest(SqlQuery);
//if (flag == 1)
//{
string sql = "SELECT MAX(Uid) AS LastID FROM [DBeZeeOnlineExam].[dbo].[Login]";
string Id1 = cc.ExecuteScalarEzeeTest(sql);
if (!(Id1 == null))
{
string Sql = "insert [DBeZeeOnlineExam].[dbo].[Admin_SubUser](loginid,loginname,uid,UnderUsername,roleid,rolename,DT,R1,R2,companyid)" +
"values('6182','9999999999'," + Id1 + ",'" + LoginId + "','10','Students','" + System.DateTime.Now.ToString("yyyy-MM-dd") + "','Admin','9999999999','5164')";
flag = cc.ExecuteNonQueryEzeeTest(Sql);
}
// }
}
}
catch (Exception)
{
}
}
