/// <summary> /// Created By :: Sakthivel.R /// Created On :: 15-9-2015 /// Comments :: Insertion function of UserPlan details. /// </summary> #region Insert_UserPlanCreation public string UserPlanInsert(UserPlan objUserPlan) { objEmailCampDataContext = new EmailCampDataContext(); int?totrow = 0; var Insert = (from cde in objEmailCampDataContext.spUserPlan_AllActions(objUserPlan.PK_UserPlanID, objUserPlan.FK_UserID, objUserPlan.FK_PlanID, objUserPlan.ActiveFrom, objUserPlan.ActiveTo, objUserPlan.IsActive, objUserPlan.CreatedBy, objUserPlan.CreatedOn, objUserPlan.UpdatedBy, objUserPlan.UpdatedOn, "i") select cde).ToList(); Insert = null; objEmailCampDataContext = null; return(totrow.ToString()); }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 15-9-2015 /// Comments :: Updation function of UserPlan details. /// </summary> #region Delete_UserPlanCreation public void UserPlanDelete(int UserPlanid) { try { objEmailCampDataContext = new EmailCampDataContext(); var Delete = (from cde in objEmailCampDataContext.spUserPlan_AllActions(UserPlanid, null, null, null, null, null, null, null, null, null, "d") select cde).ToList(); Delete = null; objUserPlan = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 15-9-2015 /// Comments :: Updation function of UserPlan details. /// </summary> #region Update_UserPlanCreation public void UserPlanUpdate(UserPlan objUserPlan) { try { objEmailCampDataContext = new EmailCampDataContext(); var Update = (from cde in objEmailCampDataContext.spUserPlan_AllActions(objUserPlan.PK_UserPlanID, objUserPlan.FK_UserID, objUserPlan.FK_PlanID, objUserPlan.ActiveFrom, objUserPlan.ActiveTo, objUserPlan.IsActive, objUserPlan.CreatedBy, objUserPlan.CreatedOn, objUserPlan.UpdatedBy, objUserPlan.UpdatedOn, "u") select cde).ToList(); Update = null; objUserPlan = null; objEmailCampDataContext = null; } catch (Exception ex) { ex.ToString(); } }
/// <summary> /// Created By :: Sakthivel.R /// Created On :: 15-9-2015 /// Comments :: Select all records for UserPlan details. /// </summary> #region Select_Records_CreateUserPlan public List <UserPlan> UserPlanSelect(int PK_UserPlanID) { objEmailCampDataContext = new EmailCampDataContext(); lstUserPlan = new List <UserPlan>(); var Select = (from cde in objEmailCampDataContext.spUserPlan_AllActions(PK_UserPlanID, null, null, null, null, true, null, null, null, null, "s") select cde).ToList(); if (Select.Count > 0) { lstUserPlan = new List <UserPlan>(); foreach (var item in Select) { objUserPlan = new UserPlan(); objUserPlan.ActiveFrom = item.ActiveFrom; objUserPlan.ActiveTo = item.ActiveTo; if (item.FK_PlanID != null) { objUserPlan.FK_PlanID = Convert.ToInt32(item.FK_PlanID); } objUserPlan.FK_UserID = item.FK_UserID; objUserPlan.IsActive = item.IsActive; objUserPlan.PK_UserPlanID = item.PK_UserPlanID; objUserPlan.CreatedOn = item.CreatedOn; objUserPlan.CreatedBy = item.CreatedBy; objUserPlan.UpdatedBy = item.UpdatedBy; objUserPlan.UpdatedOn = item.UpdatedOn; lstUserPlan.Add(objUserPlan); } } objEmailCampDataContext = null; objUserPlan = null; return(lstUserPlan); }