public List<ListContacts> ListContactsgrid()
{
objEmailCampDataContext = new EmailCampDataContext();
lstListContacts = new List<ListContacts>();
var Select = (from cde in objEmailCampDataContext.spListContacts_AllActions(null, null, null, null, null, null, null, null, "c")
select cde).ToList();
if (Select.Count > 0)
{
lstListContacts = new List<ListContacts>();
foreach (var item in Select)
{
objListContacts = new ListContacts();
objListContacts.ListName = item.ListName;
//objListContacts.TotalCount = item.;
objListContacts.CreatedOn = item.CreatedOn;
objListContacts.CreatedBy = item.CreatedBy;
objListContacts.UpdatedBy = item.UpdatedBy;
objListContacts.UpdatedOn = item.UpdatedOn;
objListContacts.PK_ContListID = item.PK_ContListID;
lstListContacts.Add(objListContacts);
}
}
objEmailCampDataContext = null;
objListContacts = null;
return lstListContacts;
}
public void ListContactsInsert(ListContacts objListContacts)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Insert = (from cde in objEmailCampDataContext.spListContacts_AllActions(objListContacts.PK_ContListID, objListContacts.ListName, objListContacts.Comments, objListContacts.CreatedBy, objListContacts.CreatedOn, objListContacts.UpdatedBy, objListContacts.UpdatedOn, objListContacts.FK_CompanyID, "i")
select cde).ToList();
Insert = null;
objListContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
public void ListContactsDelete(int ListContactsid)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Delete = (from cde in objEmailCampDataContext.spListContacts_AllActions(ListContactsid, null, null, null, null, null, null, null, "d")
select cde).ToList();
Delete = null;
objListContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
public List<ListContacts> ListContactsSelect(int PK_ContListID)
{
objEmailCampDataContext = new EmailCampDataContext();
lstListContacts = new List<ListContacts>();
var Select = (from cde in objEmailCampDataContext.spListContacts_AllActions(PK_ContListID, null, null, null, null, null, null, null, "a")
select cde).ToList();
if (Select.Count > 0)
{
lstListContacts = new List<ListContacts>();
foreach (var item in Select)
{
objListContacts = new ListContacts();
objListContacts.ListName = item.ListName;
objListContacts.Comments = item.comments;
objListContacts.CreatedOn = item.CreatedOn;
objListContacts.CreatedBy = item.CreatedBy;
objListContacts.UpdatedBy = item.UpdatedBy;
objListContacts.UpdatedOn = item.UpdatedOn;
objListContacts.FK_CompanyID = item.FK_CompanyID;
lstListContacts.Add(objListContacts);
}
}
objEmailCampDataContext = null;
objListContacts = null;
return lstListContacts;
}
public void AccessUpdateContacts(ListContacts objListContacts1)
{
objDL_ListContacts.ListContactsUpdate(objListContacts1);
}
//public void AccessExcelDataStore()
//{
// objDL_ListContacts.ListContactsExcelInsert();
//}
public void AccessInsertContacts(ListContacts objListContacts1)
{
objDL_ListContacts.ListContactsInsert(objListContacts1);
}