Exemplo n.º 1
0
        public List <ImportExportModels> GetPrintData(string ARCSCode)
        {
            GetBasicInfo objGBI           = new GetBasicInfo();
            List <ImportExportModels> lst = new List <ImportExportModels>();

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[GetPrintData]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                // com.Parameters.AddWithValue("@ARCSCode", ARCSCode);
                SqlDataReader rdr = com.ExecuteReader();
                while (rdr.Read())
                {
                    lst.Add(new ImportExportModels
                    {
                        OldRedgNo   = rdr["OldRegId"].ToString(),
                        UserName    = rdr["UserName"].ToString(),
                        Password    = rdr["Password"].ToString(),
                        SocietyName = rdr["SocietyName"].ToString(),
                    });
                }
                return(lst);
            }
        }
Exemplo n.º 2
0
        public List <ImportExportModels> GetUploadedData(string ARCSCode)
        {
            ARCSCode = "27";
            GetBasicInfo objGBI           = new GetBasicInfo();
            List <ImportExportModels> lst = new List <ImportExportModels>();

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[UploadExcelList]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                com.Parameters.AddWithValue("@ARCSCode", ARCSCode);
                SqlDataReader rdr = com.ExecuteReader();
                while (rdr.Read())
                {
                    lst.Add(new ImportExportModels
                    {
                        SocietyTransID = rdr["SocietyTransID"].ToString(),
                        OldRedgNo      = rdr["OldRedgNo"].ToString(),
                        SocietyName    = rdr["SocietyName"].ToString(),
                        UserName       = rdr["UserName"].ToString(),
                        Password       = rdr["Password"].ToString(),
                        CreateDate1    = rdr["CreateDate"].ToString(),
                    });
                }
                return(lst);
            }
        }
Exemplo n.º 3
0
        public List <ShareTransferDetail> GetbyShareMemberID(int ShareTransferID)
        {
            GetBasicInfo objGBI            = new GetBasicInfo();
            List <ShareTransferDetail> lst = new List <ShareTransferDetail>();

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[GetShareTransferMemberDetail]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                com.Parameters.AddWithValue("@ShareTransferID", ShareTransferID);
                SqlDataReader rdr = com.ExecuteReader();
                while (rdr.Read())
                {
                    lst.Add(new ShareTransferDetail
                    {
                        SocietyTransID            = rdr["SocietyTransID"].ToString(),
                        MemberName                = rdr["MemberName"].ToString(),
                        FatherName                = rdr["FatherName"].ToString(),
                        Gender                    = rdr["Gender"].ToString(),
                        ShareTransferID           = Convert.ToInt32(rdr["ShareTransferID"]),
                        Age                       = Convert.ToInt32(rdr["Age"]),
                        Address1                  = rdr["Address1"].ToString(),
                        Address2                  = rdr["Address2"].ToString(),
                        PostOffice                = rdr["PostOffice"].ToString(),
                        Pin                       = rdr["Pin"].ToString(),
                        RelationshipCode          = Convert.ToInt32(rdr["RelationshipCode"]),
                        DistCode                  = rdr["DistCode"].ToString(),
                        NoOfShares                = Convert.ToInt32(rdr["NoOfShares"]),
                        NomineeName               = rdr["NomineeName"].ToString(),
                        NomineeAge                = Convert.ToInt32(rdr["NomineeAge"]),
                        OldMemberId               = Convert.ToInt32(rdr["OldMemberId"]),
                        Mobile                    = rdr["Mobile"].ToString(),
                        AadharNo                  = objGBI.Decrypt(rdr["AadharNo"].ToString(), Convert.ToString(HttpContext.Current.Session["EncrptedDecruptedKey"])),
                        EmailId                   = rdr["EmailId"].ToString(),
                        RelationshipName          = rdr["RelationshipName"].ToString(),
                        DistrictName              = rdr["DistName"].ToString(),
                        OccupationVal             = rdr["OccupationVal"].ToString(),
                        Imgg                      = System.Text.Encoding.Unicode.GetBytes(rdr["img"].ToString()),
                        Fullpath                  = rdr["FullPath"].ToString(),
                        Flfile                    = rdr["flfile"].ToString(),
                        Dob                       = rdr["dob"].ToString(),
                        ShareTransferAppLetterNo  = rdr["ShareTransferAppLetterNo"].ToString(),
                        ShareTransferApprovalDate = rdr["ShareTransferApprovalDate"].ToString(),
                        DateofResolution          = rdr["DateofResolution"].ToString(),
                        FirstShareTrans           = rdr["FirstShareTrans"].ToString(),
                        CopyOfResolution          = rdr["CopyofResolution"].ToString(),
                    });
                }
                return(lst);
            }
        }
Exemplo n.º 4
0
        public List <ShareTransferDetail> NewSocietyMembersList(string SocietyTransID)
        {
            GetBasicInfo objGBI            = new GetBasicInfo();
            List <ShareTransferDetail> lst = new List <ShareTransferDetail>();

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[NewGetShareTransferMemberDetailsAllList]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                com.Parameters.AddWithValue("@SocietyTransID", SocietyTransID);
                SqlDataReader rdr = com.ExecuteReader();
                while (rdr.Read())
                {
                    lst.Add(new ShareTransferDetail
                    {
                        ShareTransferID           = Convert.ToInt32(rdr["ShareTransferID"]),
                        MemberName                = rdr["MemberName"].ToString(),
                        FatherName                = rdr["FatherName"].ToString(),
                        Gender                    = rdr["Gender"].ToString(),
                        Age                       = Convert.ToInt32(rdr["Age"]),
                        Address1                  = rdr["Address1"].ToString(),
                        Address2                  = rdr["Address2"].ToString(),
                        PostOffice                = rdr["PostOffice"].ToString(),
                        Pin                       = rdr["Pin"].ToString(),
                        DistCode                  = rdr["DistCode"].ToString(),
                        NoOfShares                = Convert.ToInt32(rdr["NoOfShares"]),
                        NomineeName               = rdr["NomineeName"].ToString(),
                        NomineeAge                = Convert.ToInt32(rdr["NomineeAge"]),
                        RelationshipCode          = Convert.ToInt32(rdr["RelationshipCode"]),
                        Mobile                    = rdr["Mobile"].ToString(),
                        EmailId                   = rdr["EmailId"].ToString(),
                        RelationshipName          = rdr["RelationshipName"].ToString(),
                        DistrictName              = rdr["DisName"].ToString(),
                        OccupationName            = rdr["OccupationVal"].ToString(),
                        Imgg                      = System.Text.Encoding.Unicode.GetBytes(rdr["imgg"].ToString()),
                        Imgsrc                    = Convert.ToBase64String(System.Text.Encoding.Unicode.GetBytes(rdr["imgg"].ToString()), 0, System.Text.Encoding.Unicode.GetBytes(rdr["imgg"].ToString()).Length),
                        Fullpath                  = rdr["FullPath"].ToString(),
                        ShareTransferAppLetterNo  = rdr["ShareTransferAppLetterNo"].ToString(),
                        ShareTransferApprovalDate = rdr["ShareTransferApprovalDate"].ToString(),
                        MemberId                  = Convert.ToInt32(rdr["OldMemberId"].ToString()),
                        OldMemberName             = rdr["OldMemberName"].ToString(),
                    });
                }
                return(lst);
            }
        }