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) { } }