public List <Paymentselect> GetPaymentDetails(long?CustID, string spName)
        {
            SqlParameter[]       parm      = new SqlParameter[3];
            SqlDataReader        reader    = null;
            List <Paymentselect> arrayList = new List <Paymentselect>();
            int?          intnull          = null;
            double?       floatnull        = null;
            SqlConnection connection       = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();
            connection.Open();
            try
            {
                parm[0]       = new SqlParameter("@i_FromCustID", SqlDbType.BigInt);
                parm[0].Value = CustID;
                reader        = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Paymentselect payment = new Paymentselect();
                        {
                            payment.MembershipName              = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null;
                            payment.Emp_Membership_ID           = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull;
                            payment.MemberShipDuration          = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull;
                            payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull;
                            payment.DiscountAmount              = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull;
                            payment.AllottedServicePoints       = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull;
                            payment.MembershipAmount            = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull;
                            payment.onlineaccess  = reader["onlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("onlineaccess")) : null;
                            payment.offlineaccess = reader["offlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("offlineaccess")) : null;
                            payment.Ppluspath     = reader["Ppluspath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppluspath")) : null;
                            payment.Ppath         = reader["Ppath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppath")) : null;
                        }
                        arrayList.Add(payment);
                    }
                }
                reader.NextResult();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Paymentselect payment = new Paymentselect();
                        {
                            payment.MembershipName              = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null;
                            payment.Emp_Membership_ID           = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull;
                            payment.MemberShipDuration          = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull;
                            payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull;
                            payment.DiscountAmount              = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull;
                            payment.AllottedServicePoints       = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull;
                            payment.AccessFeature    = reader["AccessFeature"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AccessFeature")) : intnull;
                            payment.MembershipAmount = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull;
                        }

                        arrayList.Add(payment);
                    }
                }
                reader.Close();
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), CustID, null, null);
            }
            finally
            {
                connection.Close();
            }
            return(arrayList);
        }
Beispiel #2
0
        public Tuple <EmpDetailsMl, List <MenuItem>, List <ScrollText>, List <StarRating>, int> ValidateLoginNew(string LoginName, string Password, string sMAC, string spName)
        {
            int intstatus = 0;

            SqlParameter[] param = new SqlParameter[5];

            SqlConnection connection = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();
            connection.Open();

            EmpDetailsMl empDetails = new EmpDetailsMl();

            List <MenuItem>   lstPagePermissions = new List <MenuItem>();
            List <ScrollText> lscroll            = new List <ScrollText>();
            List <StarRating> lstarrating        = new List <StarRating>();

            try
            {
                param[0]           = new SqlParameter("@LoginName", System.Data.SqlDbType.VarChar);
                param[0].Value     = LoginName;
                param[1]           = new SqlParameter("@Password", System.Data.SqlDbType.VarChar);
                param[1].Value     = Password;
                param[2]           = new SqlParameter("@Mac", System.Data.SqlDbType.VarChar);
                param[2].Value     = sMAC;
                param[3]           = new SqlParameter("@ErrorMsg", System.Data.SqlDbType.VarChar, 10000);
                param[3].Direction = ParameterDirection.Output;
                param[4]           = new SqlParameter("@Status", System.Data.SqlDbType.Int);
                param[4].Direction = ParameterDirection.Output;

                DataSet dsLogin = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, param);
                if (string.Compare(System.DBNull.Value.ToString(), param[4].Value.ToString()) == 0)
                {
                    intstatus = 0;
                }
                else
                {
                    intstatus = Convert.ToInt32(param[4].Value);
                }

                if (string.Compare(System.DBNull.Value.ToString(), param[4].Value.ToString()) == 0)
                {
                    intstatus = 0;
                }
                else
                {
                    if (param[4].Value.ToString() == "1")
                    {
                        int?     intNull      = null;
                        DateTime datetimeNull = Convert.ToDateTime(null);

                        DataTable dtLogin = dsLogin.Tables[0];
                        empDetails.EmpID            = Int64.Parse(dtLogin.Rows[0]["EmpID"].ToString());
                        empDetails.FirstName        = dtLogin.Rows[0]["FirstName"].ToString();
                        empDetails.LastName         = dtLogin.Rows[0]["LastName"].ToString();
                        empDetails.WorkingStartTIme = DateTime.Parse(dtLogin.Rows[0]["WorkingStartTime"].ToString());
                        empDetails.WorkingEndTIme   = DateTime.Parse(dtLogin.Rows[0]["WorkingEndTIme"].ToString());
                        empDetails.DesignationID    = int.Parse(dtLogin.Rows[0]["DesignationID"].ToString());
                        empDetails.ReportingMngrID  = (dtLogin.Rows[0]["ReportingMngrID"] != DBNull.Value) ? int.Parse(dtLogin.Rows[0]["ReportingMngrID"].ToString()) : 0;
                        empDetails.BranchID         = int.Parse(dtLogin.Rows[0]["BranchID"].ToString());
                        empDetails.LastLoginDate    = !string.IsNullOrEmpty(dtLogin.Rows[0]["LastLoginDate"].ToString()) ? DateTime.Parse(dtLogin.Rows[0]["LastLoginDate"].ToString()) : datetimeNull;
                        empDetails.Email            = dtLogin.Rows[0]["Email"].ToString();
                        empDetails.isAdmin          = !string.IsNullOrEmpty(dtLogin.Rows[0]["isAdmin"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["isAdmin"].ToString()) : -1;
                        empDetails.RegionID         = !string.IsNullOrEmpty(dtLogin.Rows[0]["Region"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["Region"].ToString()) : intNull;
                        empDetails.isManagement     = !string.IsNullOrEmpty(dtLogin.Rows[0]["isManagement"].ToString()) ? Convert.ToBoolean(dtLogin.Rows[0]["isManagement"].ToString()) : false;
                        empDetails.EmpPhotoPath     = !string.IsNullOrEmpty(dtLogin.Rows[0]["EmpPhotoPath"].ToString()) ? dtLogin.Rows[0]["EmpPhotoPath"].ToString() : null;

                        empDetails.Dashboard_Status = !string.IsNullOrEmpty(dtLogin.Rows[0]["Dashboard_Status"].ToString()) ? Convert.ToInt32(dtLogin.Rows[0]["Dashboard_Status"]) : intNull;
                        empDetails.UserID           = (dtLogin.Rows[0]["UserID"].ToString());
                    }
                    else
                    {
                        // intstatus = 0;
                    }
                }
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null);
            }
            finally
            {
                connection.Close();
            }

            return(new Tuple <EmpDetailsMl, List <MenuItem>, List <ScrollText>, List <StarRating>, int>(empDetails, lstPagePermissions, lscroll, lstarrating, intstatus));
        }
Beispiel #3
0
        public List <userLoginML> DGetLogininformationdetails(CustLoginMl Mobj)
        {
            int status = 0;
            List <userLoginML> userLogin  = null;
            SqlConnection      connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString());

            connection.Open();
            try
            {
                SqlCommand command = new SqlCommand("Usp_CheckCustLogin", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@Username", Mobj.Username);
                command.Parameters.AddWithValue("@Password", Commonclass.Encrypt(Mobj.Password));
                SqlParameter outputParamStatus = command.Parameters.Add("@Status", SqlDbType.Int);
                outputParamStatus.Direction = ParameterDirection.Output;

                SqlDataReader reader;

                reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        userLogin = new List <userLoginML>
                        {
                            new userLoginML
                            {
                                CustID = (reader["CustID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("CustID")) : 0,

                                FirstName = (reader["FirstName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("FirstName")) : null,

                                LastName = (reader["LastName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("LastName")) : null,

                                ReligionName = (reader["ReligionName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReligionName")) : null,

                                CasteName = (reader["CasteName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("CasteName")) : null,

                                CasteID = (reader["CasteID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CasteID")) : 0,

                                MotherTongueName = (reader["MotherTongueName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MotherTongueName")) : null,

                                GenderID = (reader["GenderID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : 0,

                                Email = (reader["Email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : null,

                                MotherTongueID = (reader["MotherTongueID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MotherTongueID")) : 0,

                                ReligionID = (reader["ReligionID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ReligionID")) : 0,

                                ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,

                                VerificationCode = (reader["VerificationCode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("VerificationCode")) : null,

                                FamilyID = (reader["FamilyID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("FamilyID")) : 0,

                                PaidStatus = (reader["PaidStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidStatus")) : 0,

                                PartnerCastedata = (reader["PartnerCastedata"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("PartnerCastedata")) : null,

                                PhotoStatus = (reader["PhotoStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoStatus")) : 0,

                                PhotoCount = (reader["PhotoCount"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoCount")) : 0,

                                ViewProfileFlag = (reader["ViewProfileFlag"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ViewProfileFlag")) : false,

                                ResigNophotoFlgPaid = (reader["ResigNophotoFlgPaid"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ResigNophotoFlgPaid")) : 0,

                                SuccessStoryFlag = (reader["SuccessStoryFlag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SuccessStoryFlag")) : 0,

                                Emailverified = (reader["Emailverified"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emailverified")) : 0,

                                strProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,

                                Flag = (reader["Flag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Flag")) : 0,

                                cust_emailid = (reader["cust_emailid"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_emailid")) : 0,

                                email = (reader["email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("email")) : null,

                                isemailverified = (reader["isemailverified"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isemailverified")) : false,

                                cust_contant_id = (reader["cust_contant_id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_contant_id")) : 0,

                                number = (reader["number"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("number")) : null,

                                isnumberverifed = (reader["isnumberverifed"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isnumberverifed")) : false,

                                MObileverficationcode = (reader["MObileverficationcode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MObileverficationcode")) : null,

                                ProfilePic = (reader["ProfilePic"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePic")) : null
                            },
                        };
                    }
                }

                reader.Close();
                status = (int)command.Parameters["@Status"].Value;
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog("Usp_CheckCustLogin", Convert.ToString(EX.Message), null, null, null);
            }
            finally
            {
                connection.Close();
            }
            return(userLogin);
        }
        public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML, string spName)
        {
            int?status = null;

            SqlDataReader           reader;
            List <Smtpemailsending> li         = new List <Smtpemailsending>();
            SqlConnection           connection = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();
            connection.Open();

            try
            {
                SqlParameter[] parm = new SqlParameter[5];
                parm[0]           = new SqlParameter("@cust_Id", SqlDbType.Int);
                parm[0].Value     = ExpML.FromCustID;
                parm[1]           = new SqlParameter("@empid", SqlDbType.BigInt);
                parm[1].Value     = ExpML.EmpID;
                parm[2]           = new SqlParameter("@TblDetails", SqlDbType.Structured);
                parm[2].Value     = ExpML.dtExpInt;
                parm[3]           = new SqlParameter("@emailaddress", SqlDbType.VarChar);
                parm[3].Value     = ExpML.emailaddress;
                parm[4]           = new SqlParameter("@Status", SqlDbType.Int);
                parm[4].Direction = ParameterDirection.Output;

                reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        li.Clear();
                        Smtpemailsending smtp = new Smtpemailsending();
                        {
                            smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
                            smtp.recipients   = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
                            smtp.body         = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
                            smtp.subject      = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
                            smtp.body_format  = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
                            smtp.Status       = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
                        }
                        li.Add(smtp);
                        Commonclass.SendMailSmtpMethod(li, "exp");
                    }
                }

                Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " ");

                reader.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }

            return(new Tuple <List <Smtpemailsending>, int?>(li, status));
        }
        public static bool S3upload(string filePath, string keyName)
        {
            //filePath = "D://KaakateeyaMainProject//Kaakateeya//Development_Kaakateeya//kaakateeyaWeb//access//Images//ProfilePics//KMPL_71668_Images//img2.jpg";

            string strpath = keyName.Replace("/", "//");

            //filePath = "C://inetpub//wwwroot//access//" + strpath;

            //filePath = "http://emp.kaakateeya.com//" + strpath;
            //filePath = "http://183.82.0.58:9030//" + strpath;

            //filePath = "D://EmployeeAngularSite//Employee//" + strpath;

            //filePath = "C://EmployeeAngularProject//Employee//" + strpath;
            filePath = "C://EmployeeAngularProject_New//EmployeeProject//" + strpath;
            try
            {
                TransferUtility fileTransferUtility = new
                                                      TransferUtility(new AmazonS3Client(Amazon.RegionEndpoint.APSouth1));

                //TransferUtility utility = new TransferUtility();
                //utility.UploadDirectory(directoryPath, bucketName);

                // 1. Upload a file, file name is used as the object key name.
                //fileTransferUtility.Upload(filePath, bucketName);
                //Console.WriteLine("Upload 1 completed");

                //// 2. Specify object key name explicitly.
                //fileTransferUtility.Upload(filePath,
                //                          bucketName, keyName);
                //Console.WriteLine("Upload 2 completed");

                //// 3. Upload data from a type of System.IO.Stream.
                //using (FileStream fileToUpload =
                //	new FileStream(filePath, FileMode.Open, FileAccess.Read))
                //{
                //	fileTransferUtility.Upload(fileToUpload,
                //                              bucketName, keyName);
                //}
                //Console.WriteLine("Upload 3 completed");

                // 4.Specify advanced settings/options.
                TransferUtilityUploadRequest fileTransferUtilityRequest = new TransferUtilityUploadRequest
                {
                    BucketName   = "kaakateeyaprod",
                    FilePath     = filePath,
                    StorageClass = S3StorageClass.ReducedRedundancy,
                    PartSize     = 6291456, // 6 MB.
                    Key          = keyName,
                    CannedACL    = S3CannedACL.PublicRead
                };
                fileTransferUtilityRequest.Metadata.Add("param1", "Value1");
                fileTransferUtilityRequest.Metadata.Add("param2", "Value2");
                fileTransferUtility.Upload(fileTransferUtilityRequest);
                return(true);
            }
            catch (AmazonS3Exception s3Exception)
            {
                Commonclass.ApplicationErrorLog("s3 Horo", Convert.ToString(s3Exception.Message), null, null, null);

                return(false);
            }
            finally
            {
                // SqlConnection.ClearAllPools();
            }
        }
Beispiel #6
0
        public int InsertExpressViewTicket(long?FromCustID, long?ToCustID, string EncriptedText, string strtypeOfReport, string spName)
        {
            int?                    Istatus    = null;
            int?                    inull      = null;
            SqlDataReader           reader     = null;
            int                     status     = 0;
            List <Smtpemailsending> li         = new List <Smtpemailsending>();
            SqlConnection           connection = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();
            connection.Open();
            SqlParameter[] parm = new SqlParameter[6];

            try
            {
                parm[0]           = new SqlParameter("@fromcust_id", SqlDbType.BigInt);
                parm[0].Value     = FromCustID;
                parm[1]           = new SqlParameter("@tocust_id", SqlDbType.BigInt);
                parm[1].Value     = ToCustID;
                parm[2]           = new SqlParameter("@EncriptedTextAccept", SqlDbType.VarChar);
                parm[2].Value     = EncriptedText;
                parm[3]           = new SqlParameter("@Typeofaction", SqlDbType.VarChar);
                parm[3].Value     = strtypeOfReport;
                parm[4]           = new SqlParameter("@Status", SqlDbType.Int);
                parm[4].Direction = ParameterDirection.Output;
                DataSet dsMessages = new DataSet();
                reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Smtpemailsending smtp = new Smtpemailsending();
                        {
                            smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
                            smtp.recipients   = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
                            smtp.body         = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
                            smtp.subject      = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
                            smtp.body_format  = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
                            Istatus           = smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : inull;
                        }
                        li.Add(smtp);
                    }
                    status = Istatus != null?Convert.ToInt32(Istatus) : 0;

                    Commonclass.SendMailSmtpMethod(li, "info");
                }
                else
                {
                    if (string.Compare(System.DBNull.Value.ToString(), parm[4].Value.ToString()) == 0)
                    {
                        status = 0;
                    }
                    else
                    {
                        status = Convert.ToInt32(parm[4].Value);
                    }
                }
                reader.Close();
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), FromCustID, null, null);
            }
            finally
            {
                connection.Close();
                //SqlConnection.ClearPool(connection);
                //SqlConnection.ClearAllPools();
            }
            return(status);
        }
Beispiel #7
0
        public List <CommunicationHistry> GetCustometMessagesCount(CommunicationHistoryReq Mobj, string spName)
        {
            SqlParameter[]             parm = new SqlParameter[7];
            SqlDataReader              reader;
            List <CommunicationHistry> arrayList = new List <CommunicationHistry>();
            Int64?        intNUll    = null;
            int?          intnull    = null;
            bool?         iboolean   = null;
            SqlConnection connection = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();
            connection.Open();
            try
            {
                parm[0]       = new SqlParameter("@CustID", SqlDbType.BigInt);
                parm[0].Value = Mobj.CustID;
                parm[1]       = new SqlParameter("@i_MessageStatusId", SqlDbType.Int);
                parm[1].Value = Mobj.MessageStatusID;
                parm[2]       = new SqlParameter("@i_MessageLinkId", SqlDbType.BigInt);
                parm[2].Value = Mobj.MessageLinkId;
                parm[3]       = new SqlParameter("@i_PageSize", SqlDbType.Int);
                parm[3].Value = Mobj.i_PageSize;
                parm[4]       = new SqlParameter("@i_PageNumber", SqlDbType.Int);
                parm[4].Value = Mobj.i_PageNumber;
                parm[5]       = new SqlParameter("@i_StartIndex", SqlDbType.Int);
                parm[5].Value = Mobj.i_StartIndex;
                parm[6]       = new SqlParameter("@i_EndIndex", SqlDbType.Int);
                parm[6].Value = Mobj.i_EndIndex;
                reader        = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        CommunicationHistry communicationHistory = new CommunicationHistry();
                        {
                            communicationHistory.Sender              = reader["Sender"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Sender")) : intNUll;
                            communicationHistory.Receiver            = reader["Receiver"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Receiver")) : intNUll;
                            communicationHistory.SenderName          = reader["SenderName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("SenderName")) : null;
                            communicationHistory.ReceiverName        = reader["ReceiverName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReceiverName")) : null;
                            communicationHistory.Body                = reader["Body"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : null;
                            communicationHistory.RequestDate         = reader["RequestDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RequestDate")) : null;
                            communicationHistory.IsReviewd           = reader["IsReviewd"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsReviewd")) : iboolean;
                            communicationHistory.Cust_MessageLink_Id = reader["Cust_MessageLink_Id"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageLink_Id")) : intNUll;
                            communicationHistory.MessageStatusID     = reader["MessageStatusID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MessageStatusID")) : intnull;
                            communicationHistory.loginCustid         = reader["loginCustid"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("loginCustid")) : intNUll;
                        }
                        arrayList.Add(communicationHistory);
                    }
                }
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.CustID, null, null);
            }
            finally
            {
                connection.Close();
                //SqlConnection.ClearPool(connection);
                //SqlConnection.ClearAllPools();
            }
            return(arrayList);
        }
Beispiel #8
0
        public List <TicketHistoryinfoResponse> GetTicketinformationDal(long?Ticketid, char Type, string spName)
        {
            List <TicketHistoryinfoResponse> details = new List <TicketHistoryinfoResponse>();
            SqlDataReader reader;
            DataSet       ds         = new DataSet();
            DataTable     dt         = new DataTable();
            string        Snull      = "--";
            Int64?        Lnull      = null;
            int?          inull      = null;
            SqlConnection connection = new SqlConnection();

            connection = SQLHelper.GetSQLConnection();

            try
            {
                SqlParameter[] parm = new SqlParameter[6];
                parm[0]       = new SqlParameter("@TicketID ", SqlDbType.BigInt);
                parm[0].Value = Ticketid;
                parm[1]       = new SqlParameter("@Type", SqlDbType.Char);
                parm[1].Value = Type;
                reader        = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        TicketHistoryinfoResponse sh = new TicketHistoryinfoResponse();
                        {
                            if (Type == 'I')
                            {
                                sh.Ticket             = reader["Ticket"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ticket")) : Snull;
                                sh.CustomerName       = reader["CustomerName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("CustomerName")) : Snull;
                                sh.HistoryLastUpdated = reader["HistoryLastUpdated"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("HistoryLastUpdated")) : Snull;
                                sh.TicketOwner        = reader["TicketOwner"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketOwner")) : Snull;
                                sh.TicketOwnerBranch  = reader["TicketOwnerBranch"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketOwnerBranch")) : Snull;
                                sh.TicketCreatedDate  = reader["TicketCreatedDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketCreatedDate")) : Snull;
                                sh.TicketStatus       = reader["TicketStatus"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketStatus")) : Snull;
                                sh.Email          = reader["Email"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : Snull;
                                sh.Number         = reader["Number"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Number")) : Snull;
                                sh.FromCustID     = reader["CustID"] != DBNull.Value ? Convert.ToInt64(reader["CustID"]) : Lnull;
                                sh.FromProfileID  = reader["ProfileID"] != DBNull.Value ? Convert.ToInt64(reader["ProfileID"]) : Lnull;
                                sh.TocustID       = reader["OppCustID"] != DBNull.Value ? Convert.ToInt64(reader["OppCustID"]) : Lnull;
                                sh.ToProfileID    = reader["OppProfileID"] != DBNull.Value ? Convert.ToInt64(reader["OppProfileID"]) : Lnull;
                                sh.FromName       = reader["Name"] != DBNull.Value ? reader["Name"].ToString() : null;
                                sh.Toname         = reader["OppName"] != DBNull.Value ? reader["OppName"].ToString() : null;
                                sh.TicketStatusID = reader["TicketStatusID"] != DBNull.Value ? Convert.ToInt32(reader["TicketStatusID"]) : inull;
                            }
                            else
                            {
                                sh.Body                    = reader["Body"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : Snull;
                                sh.TicketType              = reader["TicketType"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketType")) : Snull;
                                sh.EmployeeName            = reader["EmployeeName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmployeeName")) : Snull;
                                sh.HistoryDate             = reader["HistoryDate"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("HistoryDate")) : Snull;
                                sh.ContactNumber           = reader["ContactNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ContactNumber")) : Snull;
                                sh.Relation                = reader["Relation"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Relation")) : Snull;
                                sh.RelationName            = reader["RelationName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("RelationName")) : Snull;
                                sh.CallResult              = reader["CallResult"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("CallResult")) : Snull;
                                sh.TicketInfo              = reader["TicketInfo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TicketInfo")) : Snull;
                                sh.TicketCreatedDatehistry = reader["TicketCreated"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("TicketCreated"))).ToString() : Snull;
                            }
                        }

                        details.Add(sh);
                    }
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), Ticketid, null, null);
            }
            finally
            {
                connection.Close();
                //SqlConnection.ClearPool(connection);
                //SqlConnection.ClearAllPools();
            }
            return(details);
        }
Beispiel #9
0
        public List <DashboardRequestChats> DgetCustometExpressIntrestDashBoardchats(long?CustID, int?Status, int iStartIndex, int iEndIndex, string spName)
        {
            List <DashboardRequestChats> dropdownfilling = new List <DashboardRequestChats>();
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString());

            connection.Open();
            try
            {
                int?     iNULL        = null;
                Int64?   iNULL64      = null;
                DateTime?datetimenull = null;

                SqlCommand command = new SqlCommand(spName, connection);

                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@CustID", CustID);
                command.Parameters.AddWithValue("@Status", Status);
                command.Parameters.AddWithValue("@i_StartIndex", iStartIndex);
                command.Parameters.AddWithValue("@i_EndIndex", iEndIndex);
                SqlDataReader reader;
                reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        DashboardRequestChats dashboardchats = new DashboardRequestChats
                        {
                            ProfileID              = (reader["ProfileID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("ProfileID")) : iNULL64,
                            Cust_MessageLink_Id    = (reader["Cust_MessageLink_Id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageLink_Id")) : iNULL64,
                            Cust_MessageHistory_Id = (reader["Cust_MessageHistory_Id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_MessageHistory_Id")) : iNULL64,
                            NAME                = (reader["NAME"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null,
                            CustID              = (reader["CustID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CustID")) : iNULL,
                            DateOfBirth         = (reader["DateOfBirth"]) != DBNull.Value ? reader.GetDateTime(reader.GetOrdinal("DateOfBirth")) : datetimenull,
                            Age                 = (reader["Age"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Age")) : iNULL,
                            CasteID             = (reader["CasteID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CasteID")) : iNULL,
                            Caste               = (reader["Caste"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Caste")) : null,
                            HeightInCentimeters = (reader["HeightInCentimeters"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("HeightInCentimeters")) : null,
                            Education           = (reader["Education"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Education")) : null,
                            Profession          = (reader["Profession"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Profession")) : null,
                            IsAccepted          = (reader["IsAccepted"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IsAccepted")) : iNULL,
                            Body                = (reader["Body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Body")) : null,
                            RequestDate         = (reader["RequestDate"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("RequestDate")) : null,
                            IsReviewd           = (reader["IsReviewd"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IsReviewd")) : iNULL,
                            ReceiverId          = (reader["ReceiverId"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ReceiverId")) : iNULL,
                            GenderID            = (reader["GenderID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : iNULL,
                            MessageStatusID     = (reader["MessageStatusID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MessageStatusID")) : iNULL,
                            COUNT               = (reader["COUNT"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("COUNT")) : iNULL,
                            ViewedFlag          = (reader["ViewedFlag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ViewedFlag")) : iNULL,
                            LastRepliedBy       = (reader["LastRepliedBy"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("LastRepliedBy")) : iNULL64,
                            loginCustid         = (reader["loginCustid"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("loginCustid")) : iNULL,
                            Photo               = (reader["Photo"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null,
                            TotalRows           = (reader["TotalRows"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalRows")) : iNULL,
                            Totalpages          = (reader["Totalpages"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Totalpages")) : iNULL
                        };

                        dropdownfilling.Add(dashboardchats);
                    }
                }
                reader.Close();
            }
            catch (Exception EX)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), CustID, null, null);
            }
            finally
            {
                connection.Close();
                //SqlConnection.ClearPool(connection);
                //SqlConnection.ClearAllPools();
            }
            return(dropdownfilling);
        }
Beispiel #10
0
        public DashboardClass LandingCountsDal(int?CustID, string TypeOfReport, int pagefrom, int pageto, string spName)
        {
            DashboardClass land = new DashboardClass();
            List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>();

            SqlDataReader reader;
            DataSet       ds = new DataSet();
            DataTable     dt = new DataTable();

            int?                inull    = null;
            bool?               bnull    = null;
            SqlConnection       con      = null;
            Int64?              Lnull    = null;
            List <PersonalInfo> liPerson = new List <PersonalInfo>();

            try
            {
                SqlParameter[] parm = new SqlParameter[6];

                parm[0]       = new SqlParameter("@custID", SqlDbType.Int);
                parm[0].Value = CustID;

                parm[1]       = new SqlParameter("@TypeOfReport", SqlDbType.VarChar);
                parm[1].Value = TypeOfReport;
                parm[2]       = new SqlParameter("@pagefrom", SqlDbType.Int);
                parm[2].Value = pagefrom;
                parm[3]       = new SqlParameter("@pageto", SqlDbType.Int);
                parm[3].Value = pageto;

                using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString()))
                {
                    con.Open();
                    reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, spName, parm);

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            LandingPartnerMenu liCount = new LandingPartnerMenu();
                            {
                                liCount.SaveSearchCount       = reader["SavesSearchCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SavesSearchCount")) : inull;
                                liCount.WhobookmarkedCount    = reader["WhoBookmarkedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoBookmarkedCount")) : inull;
                                liCount.MybookMarkedProfCount = reader["BookmarkCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("BookmarkCount")) : inull;
                                liCount.RectViewedProfCount   = reader["ViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ViewedCount")) : inull;
                                liCount.RectWhoViewedCout     = reader["WhoViewedCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("WhoViewedCount")) : inull;
                                liCount.IgnoreProfileCount    = reader["IgnoreCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("IgnoreCount")) : inull;
                                //express and Counts Bind

                                liCount.ExpressIntSent     = reader["ExpressSentCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressSentCount")) : inull;
                                liCount.ExpressIntReceived = reader["ExpressReceiveCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressReceiveCount")) : inull;
                                liCount.ExpressAllcount    = reader["ExpressAllcount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ExpressAllcount")) : inull;

                                liCount.NewMsgs   = reader["NewMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("NewMessageCount")) : inull;
                                liCount.TotalMsgs = reader["TotalMessageCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("TotalMessageCount")) : inull;

                                liCount.SentPhotoRequestCount     = reader["PhotoRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestSentCount"))) : inull;
                                liCount.SentHoroRequestCount      = reader["HoroRequestSentCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestSentCount"))) : inull;
                                liCount.ReceivedPhotoRequestCount = reader["PhotoRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("PhotoRequestReceivedCount"))) : inull;
                                liCount.ReceivedHoroRequestCount  = reader["HoroRequestReceivedCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("HoroRequestReceivedCount"))) : inull;

                                liCount.SentProtectedReply      = reader["SentProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedNewCount"))) : inull;
                                liCount.SentProtectedAccept     = reader["SentProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedAcceptCount"))) : inull;
                                liCount.SentProtectedReject     = reader["SentProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("SentProtectedRejectCount"))) : inull;
                                liCount.ReceivedProtectedNew    = reader["ReceivedProtectedNewCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedNewCount"))) : inull;
                                liCount.ReceivedProtectedAccept = reader["ReceivedProtectedAcceptCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedAcceptCount"))) : inull;
                                liCount.ReceivedProtectedReject = reader["ReceivedProtectedRejectCount"] != DBNull.Value ? Convert.ToInt32(reader.GetString(reader.GetOrdinal("ReceivedProtectedRejectCount"))) : inull;
                                land.DashBoardCounts            = liCount;
                            }
                        }
                    }
                    reader.NextResult();

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            PersonalInfo Pcls = new PersonalInfo();
                            Pcls.TableName  = reader["TableName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("TableName")) : null;
                            Pcls.ProfileID  = reader["ProfileID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null;
                            Pcls.GenderID   = reader["GenderID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : inull;
                            Pcls.NAME       = reader["NAME"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("NAME")) : null;
                            Pcls.PaidMember = reader["PaidMember"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidMember")) : inull;
                            Pcls.ProfileLastModifieddate = reader["ProfileLastModifieddate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("ProfileLastModifieddate"))).ToString() : null;
                            Pcls.PhotoName                    = reader["PhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("PhotoName")) : null;
                            Pcls.PhotoName_Cust               = reader["PhotoName_Cust"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoName_Cust")) : inull;
                            Pcls.MsgReceivedFrom              = reader["MsgReceivedFrom"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MsgReceivedFrom")) : null;
                            Pcls.MsgReceivedDate              = reader["MsgReceivedDate"] != DBNull.Value ? (reader.GetDateTime(reader.GetOrdinal("MsgReceivedDate"))).ToString() : null;
                            Pcls.ProfilePhotoName             = reader["ProfilePhotoName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePhotoName")) : null;
                            Pcls.IsReviewed                   = reader["IsReviewed"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsReviewed")) : bnull;
                            Pcls.IsActive                     = reader["IsActive"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("IsActive")) : bnull;
                            Pcls.ProfileBattery               = reader["ProfileBattery"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ProfileBattery")) : inull;
                            Pcls.EmpID                        = reader["EmpID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("EmpID")) : Lnull;
                            Pcls.EmpPhone                     = reader["EmpPhone"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmpPhone")) : null;
                            Pcls.OfficialContactNumber        = reader["OfficialContactNumber"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("OfficialContactNumber")) : null;
                            Pcls.EmployeeName                 = reader["EmployeeName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmployeeName")) : null;
                            Pcls.EmailID                      = reader["EmailID"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("EmailID")) : null;
                            Pcls.PhotoViewCount               = reader["PhotoViewCount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoViewCount")) : inull;
                            Pcls.PartnetPrefernceLastOnemonth = reader["PartnetPrefernceLastOnemonth"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PartnetPrefernceLastOnemonth")) : inull;
                            Pcls.Photo                        = reader["Photo"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Photo")) : null;
                            Pcls.MaskDiv                      = (!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true && Pcls.IsActive == true)) ? " " : ((!string.IsNullOrEmpty(Pcls.ProfilePhotoName) && (Pcls.IsReviewed == true || Pcls.IsActive == true)) ? "divCSSclass clearfix" : "cssMaskupload clearfix");
                            land.PersonalInfo                 = Pcls;
                        }
                    }
                    reader.NextResult();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "Partner");
                            PartnerLi.Add(Partnercls);
                        }

                        land.PartnerProfilesnew = PartnerLi;
                    }

                    reader.Close();
                }
            }
            catch (Exception ex)
            {
                Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), CustID, null, null);
            }
            finally
            {
                con.Close();
                //SqlConnection.ClearPool(con);
                //SqlConnection.ClearAllPools();
            }
            return(land);
        }