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