public DataSet SelectUserContactsbasedonIDFilter(string ContactName, string Designation, string city, string state, string country, string emailid, string contactno, int FKid, string alpha)
{
objEmailCampDataContext = new EmailCampDataContext();
lstUserContacts = new List <UserContacts>();
var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, null, ContactName, Designation, alpha, city, state, country, emailid, null, contactno, FKid, null, null, null, null, "e")
select cde).ToList();
if (Select.Count > 0)
{
lstUserContacts = new List <UserContacts>();
foreach (var item in Select)
{
objUserContacts = new UserContacts();
objUserContacts.Addressline1 = Convert.ToString(item.Addressline1);
objUserContacts.City1 = Convert.ToString(item.City1);
objUserContacts.CreatedBy = item.CreatedBy;
objUserContacts.CreatedOn = item.CreatedOn;
objUserContacts.UpdatedBy = item.UpdatedBy;
objUserContacts.UpdatedOn = item.UpdatedOn;
objUserContacts.Email_id = item.email_id;
objUserContacts.FK_UserID = item.FK_UserID;
objUserContacts.ContactName = item.ContactName;
objUserContacts.PK_ContactID = Convert.ToInt16(item.PK_ContactID.ToString());
objUserContacts.State1 = item.State1;
objUserContacts.ContactNo = item.ContactNo;
objUserContacts.Country1 = item.Country1;
objUserContacts.Designation = item.Designation;
objUserContacts.MailContent = item.MailContent;
objUserContacts.DateofBirth = item.DateofBirth;
lstUserContacts.Add(objUserContacts);
}
}
objEmailCampDataContext = null;
objUserContacts = null;
DataSet converted = new DataSet();
if (lstUserContacts.Count > 0)
{
converted.Tables.Add(ListToDataSet.newTable(lstUserContacts));
return(converted);
}
else
{
converted.Tables.Add(ListToDataSet.newTableColumnAlone(lstUserContacts));
return(converted);
}
}
public int SelectUserContactsCountbasedonID(int FKid)
{
objEmailCampDataContext = new EmailCampDataContext();
var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, FKid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "a")
select cde).ToList();
int countrec = 0;
if (Select.Count > 0)
{
countrec = Select.Count;
}
objEmailCampDataContext = null;
return(countrec);
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Updation function of UserContacts details.
/// </summary>
#region Delete_UserContactsCreation
public void UserContactsDelete(int UserContactsid)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Delete = (from cde in objEmailCampDataContext.spUserContacts_AllActions(UserContactsid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "d")
select cde).ToList();
Delete = null;
objUserContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Updation function of UserContacts details.
/// </summary>
#region Update_UserContactsCreation
public void UserContactsUpdate(UserContacts objUserContacts)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Update = (from cde in objEmailCampDataContext.spUserContacts_AllActions(objUserContacts.PK_ContactID, objUserContacts.FK_UserID, objUserContacts.ContactName, objUserContacts.Designation, objUserContacts.Addressline1, objUserContacts.City1, objUserContacts.State1, objUserContacts.Country1, objUserContacts.Email_id, objUserContacts.MailContent, objUserContacts.ContactNo, objUserContacts.CreatedBy, objUserContacts.CreatedOn, objUserContacts.UpdatedBy, objUserContacts.UpdatedOn, objUserContacts.DateofBirth, "u")
select cde).ToList();
Update = null;
objUserContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 25-4-2015
/// Comments :: Delete duplicate mail id from UserContacts.
/// </summary>
#region Delete_DuplicateEmailid_Uploading
public void DeleteDuplicateEmailidUploading(int Contactlistid, int CreatedBy)
{
try
{
objEmailCampDataContext = new EmailCampDataContext();
var Delete = (from cde in objEmailCampDataContext.spUserContacts_AllActions(null, null, null, null, null, null, null, null, null, null, null, CreatedBy, null, null, null, null, "c")
select cde).ToList();
Delete = null;
objUserContacts = null;
objEmailCampDataContext = null;
}
catch (Exception ex)
{
ex.ToString();
}
}
/// <summary>
/// Created By :: Sakthivel.R
/// Created On :: 30-3-2015
/// Comments :: Select all records for UserContacts details.
/// </summary>
#region Select_All_Records_CreateUserContacts
public List <UserContacts> UserContactsSelectforgrid(int contlistid)
{
objEmailCampDataContext = new EmailCampDataContext();
lstUserContacts = new List <UserContacts>();
var Select = (from cde in objEmailCampDataContext.spUserContacts_AllActions(contlistid, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, "s")
select cde).ToList();
if (Select.Count > 0)
{
lstUserContacts = new List <UserContacts>();
foreach (var item in Select)
{
objUserContacts = new UserContacts();
objUserContacts.Addressline1 = Convert.ToString(item.Addressline1);
objUserContacts.City1 = Convert.ToString(item.City1);
objUserContacts.CreatedBy = item.CreatedBy;
objUserContacts.CreatedOn = item.CreatedOn;
objUserContacts.UpdatedBy = item.UpdatedBy;
objUserContacts.UpdatedOn = item.UpdatedOn;
objUserContacts.Email_id = item.email_id;
objUserContacts.FK_UserID = item.FK_UserID;
objUserContacts.ContactName = item.ContactName;
objUserContacts.PK_ContactID = Convert.ToInt16(item.PK_ContactID.ToString());
objUserContacts.State1 = item.State1;
objUserContacts.ContactNo = item.ContactNo;
objUserContacts.Country1 = item.Country1;
objUserContacts.Designation = item.Designation;
objUserContacts.MailContent = item.MailContent;
objUserContacts.DateofBirth = item.DateofBirth;
lstUserContacts.Add(objUserContacts);
}
}
objEmailCampDataContext = null;
objUserContacts = null;
return(lstUserContacts);
}