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