//this is old one code
//public List<MdlADDRESSS> GetAllAddress()
//{
// var query = _dbFirms.ADDRESSSes.ToList();
// // List<MdlADDRESSS> modleobj = new List<MdlADDRESSS>();
// //AdressID, OrgDoc_ID, AdressType_ID, AdressDetails, Tehsil_ID, EnterByUser_ID, EntryDate, ModifyByUser_ID, ModifyByDate, IsActive, IsActiveDate
// var list = new List<MdlADDRESSS>();
// foreach (var item in query)
// {
// list.Add(new MdlADDRESSS()
// {
// AdressID=item.AdressID,
// OrgDoc_ID=item.OrgDoc_ID,
// AdressType_ID = item.AdressType_ID,
// AdressDetails = item.AdressDetails,
// Tehsil_ID = item.Tehsil_ID,
// EnterByUser_ID = item.EnterByUser_ID,
// // EntryDateString = Convert.ToDateTime(item.EntryDate).ToShortDateString(),
// // ModifyByUser_ID = int.Parse(item.ModifyByUser_ID.ToString()),
// // ModifyByDate =DateTime.Parse(item.ModifyByDate.ToString()),
// IsActive = item.IsActive,
// // IsActiveDate =DateTime.Parse(item.IsActiveDate.ToString())
// });
// }
// return list;
//}
public List <MdlADDRESSS> GetAllAddress(int id)
{
var query = _dbFirms.usp_GetAddressesofOrgType(id);
// List<MdlADDRESSS> modleobj = new List<MdlADDRESSS>();
//AdressID, OrgDoc_ID, AdressType_ID, AdressDetails, Tehsil_ID, EnterByUser_ID, EntryDate, ModifyByUser_ID, ModifyByDate, IsActive, IsActiveDate
var list = new List <MdlADDRESSS>();
foreach (var item in query)
{
list.Add(new MdlADDRESSS()
{
AdressID = item.AdressID,
OrgDoc_ID = item.OrgDoc_ID,
AdressType_ID = item.AdressType_ID,
AdressDetails = item.AdressDetails,
Tehsil_ID = item.Tehsil_ID,
EnterByUser_ID = item.EnterByUser_ID,
AdressTypeName = item.AdressTypeName,
TehsilName = item.TehsilName,
OrgName = item.OrgName,
UserName = item.UserName,
// EntryDateString = Convert.ToDateTime(item.EntryDate).ToShortDateString(),
// ModifyByUser_ID = int.Parse(item.ModifyByUser_ID.ToString()),
// ModifyByDate =DateTime.Parse(item.ModifyByDate.ToString()),
IsActive = item.IsActive,
// IsActiveDate =DateTime.Parse(item.IsActiveDate.ToString())
});
}
return(list);
}