public void AddEditDel_RegistrationDetails(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
conn = co.GetConnection();
//conn.Open();
cmd = new SqlCommand("scrl_InSertRegistrationSP", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@RegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 200).Value = objRegistration.FirstName;
cmd.Parameters.Add("@MiddleName", SqlDbType.VarChar, 200).Value = objRegistration.MiddleName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 200).Value = objRegistration.LastName;
cmd.Parameters.Add("@Sex", SqlDbType.VarChar, 200).Value = objRegistration.Sex;
cmd.Parameters.Add("@InstituteName", SqlDbType.VarChar, 200).Value = objRegistration.InstituteName;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 200).Value = objRegistration.UserName;
cmd.Parameters.Add("@Password", SqlDbType.VarChar, 200).Value = objRegistration.Password;
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 200).Value = objRegistration.Address;
cmd.Parameters.Add("@intPinCode", SqlDbType.Int).Value = objRegistration.Pin;
cmd.Parameters.Add("@City", SqlDbType.VarChar, 200).Value = objRegistration.City;
cmd.Parameters.Add("@State", SqlDbType.VarChar, 200).Value = objRegistration.State;
cmd.Parameters.Add("@Country", SqlDbType.VarChar, 200).Value = objRegistration.Country;
cmd.Parameters.Add("@RollNo", SqlDbType.Int).Value = objRegistration.RollNo;
cmd.Parameters.Add("@Batch", SqlDbType.VarChar, 200).Value = objRegistration.Batch;
cmd.Parameters.Add("@PoliticalView", SqlDbType.VarChar, 200).Value = objRegistration.PoliticalView;
cmd.Parameters.Add("@Languages", SqlDbType.VarChar, 200).Value = objRegistration.Languages;
cmd.Parameters.Add("@NonAchedemicInterest", SqlDbType.VarChar, 200).Value = objRegistration.NonAchedemicInterest;
cmd.Parameters.Add("@OtherPer", SqlDbType.VarChar, 200).Value = objRegistration.OtherPersonal;
cmd.Parameters.Add("@UserTypeID", SqlDbType.Int).Value = objRegistration.UserTypeId;
// cmd.Parameters.Add("@AddedOn", SqlDbType.DateTime).Value = objRegistration.AddedOn;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar, 200).Value = objRegistration.IpAddress;
//cmd.Parameters.Add("@ModifiedOn", SqlDbType.DateTime).Value = objRegistration.ModifiedOn;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.Int).Value = objRegistration.ModifiedBy;
cmd.Parameters.Add("@Phone", SqlDbType.BigInt).Value = objRegistration.Phone;
cmd.Parameters.Add("@Mobile", SqlDbType.BigInt).Value = objRegistration.Mobile;
cmd.Parameters.Add("@Designation", SqlDbType.VarChar, 200).Value = objRegistration.Designation;
cmd.Parameters.Add("@University", SqlDbType.VarChar, 200).Value = objRegistration.University;
cmd.Parameters.Add("@Alumni", SqlDbType.VarChar, 200).Value = objRegistration.Alunmi;
cmd.Parameters.Add("@CVPath", SqlDbType.VarChar, 200).Value = objRegistration.CVPath;
cmd.Parameters.Add("@AkineTostatic", SqlDbType.VarChar, 200).Value = objRegistration.AkineTostatic;
cmd.Parameters.Add("@WorkedAt", SqlDbType.VarChar, 200).Value = objRegistration.WorkedAt;
cmd.Parameters.Add("@ProfAchievements", SqlDbType.VarChar, 200).Value = objRegistration.ProfAchievements;
cmd.Parameters.Add("@Publishings", SqlDbType.VarChar, 200).Value = objRegistration.Publishings;
cmd.Parameters.Add("@SubOfInterest", SqlDbType.VarChar, 200).Value = objRegistration.SubOfInterest;
cmd.Parameters.Add("@Goals", SqlDbType.VarChar, 200).Value = objRegistration.Goals;
cmd.Parameters.Add("@ExtraCredit", SqlDbType.VarChar, 200).Value = objRegistration.ExtraCredit;
cmd.Parameters.Add("@Leadership", SqlDbType.VarChar, 200).Value = objRegistration.Leadership;
cmd.Parameters.Add("@Photopath", SqlDbType.VarChar, 200).Value = objRegistration.PhotoPath;
cmd.Parameters.Add("@ParentId", SqlDbType.BigInt).Value = objRegistration.ParentId;
cmd.Parameters.Add("@DeptId", SqlDbType.BigInt).Value = objRegistration.DeptId;
cmd.Parameters.Add("@InstituteId", SqlDbType.Int).Value = objRegistration.InstituteId;
cmd.Parameters.Add("@LawFirmId", SqlDbType.Int).Value = objRegistration.LawFirmId; //Added on 3 April 20 13
cmd.Parameters.Add("@intLawRelated", SqlDbType.Int).Value = objRegistration.intLawRelated;
cmd.Parameters.Add("@vchrRegistartionType", SqlDbType.VarChar, 2).Value = objRegistration.vchrRegistartionType;
cmd.Parameters.Add("@strOthers", SqlDbType.VarChar, 200).Value = objRegistration.strOthers;
cmd.Parameters.Add("@intNotificationCount", SqlDbType.Int).Value = objRegistration.intNotificationCount;
objRegistration.RegOutId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
}
public DataSet GetDataSet(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataSet dt = new DataSet();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("scrl_InSertRegistrationSP", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@RegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
da.SelectCommand.Parameters.Add("@RollNo", SqlDbType.Int).Value = objRegistration.RollNo;
da.SelectCommand.Parameters.Add("@Batch", SqlDbType.VarChar, 200).Value = objRegistration.Batch;
da.SelectCommand.Parameters.Add("@PoliticalView", SqlDbType.VarChar, 200).Value = objRegistration.PoliticalView;
da.SelectCommand.Parameters.Add("@Languages", SqlDbType.VarChar, 200).Value = objRegistration.Languages;
da.SelectCommand.Parameters.Add("@NonAchedemicInterest", SqlDbType.VarChar, 200).Value = objRegistration.NonAchedemicInterest;
da.SelectCommand.Parameters.Add("@OtherPer", SqlDbType.VarChar, 200).Value = objRegistration.OtherPersonal;
da.SelectCommand.Parameters.Add("@Phone", SqlDbType.BigInt).Value = objRegistration.Phone;
da.SelectCommand.Parameters.Add("@Mobile", SqlDbType.BigInt).Value = objRegistration.Mobile;
da.SelectCommand.Parameters.Add("@Designation", SqlDbType.VarChar, 200).Value = objRegistration.Designation;
da.SelectCommand.Parameters.Add("@University", SqlDbType.VarChar, 200).Value = objRegistration.University;
da.SelectCommand.Parameters.Add("@Alumni", SqlDbType.VarChar, 200).Value = objRegistration.Alunmi;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public DataTable GetDataTable(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("scrl_InSertRegistrationSP", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@RegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
da.SelectCommand.Parameters.Add("@UserTypeId", SqlDbType.Int).Value = objRegistration.UserTypeId;
da.SelectCommand.Parameters.Add("@FirstName", SqlDbType.VarChar, 2000).Value = objRegistration.FirstName;
da.SelectCommand.Parameters.Add("@RollNo", SqlDbType.Int).Value = objRegistration.RollNo;
da.SelectCommand.Parameters.Add("@Batch", SqlDbType.VarChar, 200).Value = objRegistration.Batch;
da.SelectCommand.Parameters.Add("@PoliticalView", SqlDbType.VarChar, 200).Value = objRegistration.PoliticalView;
da.SelectCommand.Parameters.Add("@Languages", SqlDbType.VarChar, 200).Value = objRegistration.Languages;
da.SelectCommand.Parameters.Add("@NonAchedemicInterest", SqlDbType.VarChar, 200).Value = objRegistration.NonAchedemicInterest;
da.SelectCommand.Parameters.Add("@OtherPer", SqlDbType.VarChar, 200).Value = objRegistration.OtherPersonal;
da.SelectCommand.Parameters.Add("@Phone", SqlDbType.BigInt).Value = objRegistration.Phone;
da.SelectCommand.Parameters.Add("@Mobile", SqlDbType.BigInt).Value = objRegistration.Mobile;
da.SelectCommand.Parameters.Add("@Designation", SqlDbType.VarChar, 200).Value = objRegistration.Designation;
da.SelectCommand.Parameters.Add("@University", SqlDbType.VarChar, 200).Value = objRegistration.University;
da.SelectCommand.Parameters.Add("@Alumni", SqlDbType.VarChar, 200).Value = objRegistration.Alunmi;
da.SelectCommand.Parameters.Add("@CVPath", SqlDbType.VarChar, 200).Value = objRegistration.CVPath;
da.SelectCommand.Parameters.Add("@AkineTostatic", SqlDbType.VarChar, 200).Value = objRegistration.AkineTostatic;
da.SelectCommand.Parameters.Add("@WorkedAt", SqlDbType.VarChar, 200).Value = objRegistration.WorkedAt;
da.SelectCommand.Parameters.Add("@ProfAchievements", SqlDbType.VarChar, 200).Value = objRegistration.ProfAchievements;
da.SelectCommand.Parameters.Add("@Publishings", SqlDbType.VarChar, 200).Value = objRegistration.Publishings;
da.SelectCommand.Parameters.Add("@SubOfInterest", SqlDbType.VarChar, 200).Value = objRegistration.SubOfInterest;
da.SelectCommand.Parameters.Add("@Goals", SqlDbType.VarChar, 200).Value = objRegistration.Goals;
da.SelectCommand.Parameters.Add("@ExtraCredit", SqlDbType.VarChar, 200).Value = objRegistration.ExtraCredit;
da.SelectCommand.Parameters.Add("@Leadership", SqlDbType.VarChar, 200).Value = objRegistration.Leadership;
da.SelectCommand.Parameters.Add("@SubjectOfTought", SqlDbType.VarChar, 200).Value = objRegistration.SubOfTought;
da.SelectCommand.Parameters.Add("@Legaldept", SqlDbType.VarChar, 200).Value = objRegistration.LegalDept;
da.SelectCommand.Parameters.Add("@OtherLegalProject", SqlDbType.VarChar, 200).Value = objRegistration.OtherLegalProj;
da.SelectCommand.Parameters.Add("@Photopath", SqlDbType.VarChar, 200).Value = objRegistration.PhotoPath;
da.SelectCommand.Parameters.Add("@ParentId", SqlDbType.BigInt).Value = objRegistration.ParentId;
da.SelectCommand.Parameters.Add("@DeptId", SqlDbType.BigInt).Value = objRegistration.DeptId;
da.SelectCommand.Parameters.Add("@InstituteId", SqlDbType.Int).Value = objRegistration.InstituteId; //Added on 1 April 20 13
da.SelectCommand.Parameters.Add("@LawFirmId", SqlDbType.Int).Value = objRegistration.LawFirmId; //Added on 3 April 20 13
da.SelectCommand.Parameters.Add("@intNotificationCount", SqlDbType.Int).Value = objRegistration.intNotificationCount;
da.SelectCommand.Parameters.Add("@InstituteName", SqlDbType.VarChar, 200).Value = objRegistration.InstituteName;
da.SelectCommand.Parameters.Add("@NotificationDateTime", SqlDbType.DateTime).Value = objRegistration.notificationdatetime;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public void AddEditDel_OrgRequest(DO_Registrationdetails objRegistration, OrgRegistrationDetails flag)
{
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditOrgDelRequests", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@intRegistrationId", SqlDbType.BigInt).Value = objRegistration.RegistrationId;
cmd.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = objRegistration.InvitedUserId;
cmd.Parameters.Add("@intRequestInvitaionId", SqlDbType.Int).Value = objRegistration.intRequestInvitaionId;
cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 200).Value = objRegistration.IpAddress;
cmd.ExecuteNonQuery();
co.CloseConnection(conn);
}
public void AddEditDel_FollowAll(DO_Registrationdetails objRegistration, MyProfileConnections flag)
{
conn = co.GetConnection();
//conn.Open();
cmd = new SqlCommand("Scrl_AddEditFollowAll", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.ConnectRegistrationId;
cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
cmd.Parameters.Add("@intModifiedBy", SqlDbType.Int).Value = objRegistration.ModifiedBy;
cmd.Parameters.Add("@intFollowId", SqlDbType.Int).Value = objRegistration.FollowId;
cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = objRegistration.IpAddress;
objRegistration.FollowId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
}
public void AddEditDel_RegistrationDetails(DO_Registrationdetails objRegistration, Login_1 flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
//conn.Open();
cmd = new SqlCommand("scrl_LoginUserSP", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@RegistrationId", SqlDbType.BigInt).Value = objRegistration.RegistrationId;
cmd.Parameters.Add("@Password", SqlDbType.VarChar, 200).Value = objRegistration.Password;
cmd.ExecuteNonQuery();
co.CloseConnection(conn);
}
public DataTable GetExistsRequest(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_AddEditDelRequests", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = objRegistration.InvitedUserId;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public DataTable GetDataTableRecord(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("scrl_InSertRegistrationSP", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 100).Value = objRegistration.UserName;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public DataTable GetStudentToApprove(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_AddEditDelProfile", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
// da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
da.SelectCommand.Parameters.Add("@intInstituteId", SqlDbType.Int).Value = objRegistration.InstituteId;
da.SelectCommand.Parameters.Add("@intLawFirmId", SqlDbType.Int).Value = objRegistration.LawFirmId;
da.SelectCommand.Parameters.Add("@IsApproved", SqlDbType.Int).Value = objRegistration.IsApproved;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public DataSet checkScorePulic(DO_Registrationdetails objRegistration, RegistrationDetails flag)
{
DataSet ds = new DataSet();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("scrl_InSertRegistrationSP", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@RegistrationId", SqlDbType.VarChar, 100).Value = objRegistration.RegistrationId;
da.SelectCommand.Parameters.Add("@isScorePrivate", SqlDbType.Bit, 10).Value = objRegistration.isScorePrivate;
//For Chatbot Question
da.SelectCommand.Parameters.Add("@nvchrQuestion", SqlDbType.NVarChar, 4000).Value = objRegistration.Question;
da.SelectCommand.Parameters.Add("@nvchrType", SqlDbType.NVarChar, 100).Value = objRegistration.Type;
da.Fill(ds);
co.CloseConnection(conn);
return(ds);
}
public DataTable GetOrgnizationName(DO_Registrationdetails objRegistration, OrganizationJoin flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_OrgAddEditOrgJoin", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.ConnectRegistrationId;
da.SelectCommand.Parameters.Add("@intOrgJoinId", SqlDbType.Int).Value = objRegistration.intOrgJoinId;
da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = objRegistration.intInvitedUserId;
da.SelectCommand.Parameters.Add("@intUserTypeID", SqlDbType.Int).Value = objRegistration.UserTypeId;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public DataTable GetFolowStatus(DO_Registrationdetails objRegistration, MyProfileConnections flag)
{
DataTable dt = new DataTable();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_AddEditFollowAll", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.ConnectRegistrationId;
da.SelectCommand.Parameters.Add("@intFollowId", SqlDbType.Int).Value = objRegistration.FollowId;
da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = objRegistration.AddedBy;
da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = objRegistration.intInvitedUserId;
// da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.RegistrationId;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
