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