public static Common.Models.Activities.ActivityEmail Create( Transaction t, Common.Models.Activities.ActivityEmail model, Common.Models.Account.Users creator) { return(Create(model, creator, t.Connection, false)); }
public static Common.Models.Activities.ActivityEmail Create( Common.Models.Activities.ActivityEmail model, Common.Models.Account.Users creator, IDbConnection conn = null, bool closeConnection = true) { model.CreatedBy = model.ModifiedBy = creator; model.Created = model.Modified = DateTime.UtcNow; DBOs.Activities.ActivityEmail dbo = Mapper.Map <DBOs.Activities.ActivityEmail>(model); conn = DataHelper.OpenIfNeeded(conn); if (conn.Execute("INSERT INTO \"activity_email\" (\"type\", \"is_campaign_response\", \"subject\", \"body\", \"owner\", \"priority\", \"due\", \"state\", \"status_reason\", " + "\"sender\", \"recipient\", \"direction\", \"duration\", \"address\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Type, @IsCampaignResponse, @Subject, @Body, @Owner, @Priority, @Due, @State, @StatusReason, @Sender, @Recipient, @Direction, @Duration, @Address, " + "@UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo) > 0) { model.Id = conn.Query <DBOs.Activities.ActivityEmail>("SELECT currval(pg_get_serial_sequence('activity_base', 'id')) AS \"id\"").Single().Id; } DataHelper.Close(conn, closeConnection); return(model); }
public static Common.Models.Activities.ActivityEmail Edit( Transaction t, Common.Models.Activities.ActivityEmail model, Common.Models.Account.Users modifier) { return(Edit(model, modifier, t.Connection, false)); }
public ActionResult Details(long id) { ViewModels.Activities.ActivityEmailViewModel viewModel = new ViewModels.Activities.ActivityEmailViewModel(); using (IDbConnection conn = Data.Database.Instance.GetConnection()) { Common.Models.Activities.ActivityEmail model = Data.Activities.ActivityEmail.Get(id, conn, false); model.Direction = Data.Activities.ActivityDirection.Get(model.Direction.Id.Value, conn, false); model.Owner = Data.Contacts.Contact.Get(model.Owner.Id.Value, conn, false); model.Sender = Data.Contacts.Contact.Get(model.Sender.Id.Value, conn, false); model.Recipient = Data.Contacts.Contact.Get(model.Recipient.Id.Value, conn, false); model.Priority = Data.Activities.ActivityPriority.Get(model.Priority.Id.Value, conn, false); model.StatusReason = Data.Activities.ActivityStatusReason.Get(model.StatusReason.Id.Value, conn, false); model.Type = Data.Activities.ActivityType.Get(model.Type.Id.Value, conn, false); viewModel = Mapper.Map <ViewModels.Activities.ActivityEmailViewModel>(model); viewModel.Direction = Mapper.Map <ViewModels.Activities.ActivityDirectionViewModel>(model.Direction); viewModel.Owner = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Owner); viewModel.Sender = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Sender); viewModel.Recipient = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Recipient); viewModel.Priority = Mapper.Map <ViewModels.Activities.ActivityPriorityViewModel>(model.Priority); viewModel.StatusReason = Mapper.Map <ViewModels.Activities.ActivityStatusReasonViewModel>(model.StatusReason); viewModel.Type = Mapper.Map <ViewModels.Activities.ActivityTypeViewModel>(model.Type); Common.Models.Activities.ActivityRegardingType regtype = Data.Activities.ActivityRegardingType.GetFromActivityId(model.Id.Value, conn, false); if (regtype.Title == "Lead") { Common.Models.Activities.ActivityRegardingLead ar = Data.Activities.ActivityRegardingLead.GetFromActivityId(model.Id.Value, conn, false); ar.Lead = Data.Leads.Lead.Get(ar.Lead.Id.Value, conn, false); ar.Lead.Contact = Data.Contacts.Contact.Get(ar.Lead.Contact.Id.Value, conn, false); viewModel.RegardingLead = Mapper.Map <ViewModels.Activities.ActivityRegardingLeadViewModel>(ar); viewModel.RegardingLead.Lead = Mapper.Map <ViewModels.Leads.LeadViewModel>(ar.Lead); viewModel.RegardingLead.Lead.Contact = Mapper.Map <ViewModels.Contacts.ContactViewModel>(ar.Lead.Contact); viewModel.RegardingLead.Type = Mapper.Map <ViewModels.Activities.ActivityRegardingTypeViewModel>(regtype); } else { Common.Models.Activities.ActivityRegardingOpportunity ao = Data.Activities.ActivityRegardingOpportunity.GetFromActivityId(model.Id.Value, conn, false); ao.Opportunity = Data.Opportunities.Opportunity.Get(ao.Opportunity.Id.Value, conn, false); ao.Opportunity.Account = Data.Contacts.Contact.Get(ao.Opportunity.Account.Id.Value, conn, false); viewModel.RegardingOpportunity = Mapper.Map <ViewModels.Activities.ActivityRegardingOpportunityViewModel>(ao); viewModel.RegardingOpportunity.Opportunity = Mapper.Map <ViewModels.Opportunities.OpportunityViewModel>(ao.Opportunity); viewModel.RegardingOpportunity.Opportunity.Account = Mapper.Map <ViewModels.Contacts.ContactViewModel>(ao.Opportunity.Account); viewModel.RegardingOpportunity.Type = Mapper.Map <ViewModels.Activities.ActivityRegardingTypeViewModel>(regtype); } PopulateCoreDetails(viewModel, conn); } return(View(viewModel)); }
public static Common.Models.Activities.ActivityEmail Edit( Common.Models.Activities.ActivityEmail model, Common.Models.Account.Users modifier, IDbConnection conn = null, bool closeConnection = true) { model.ModifiedBy = modifier; model.Modified = DateTime.UtcNow; DBOs.Activities.ActivityEmail dbo = Mapper.Map <DBOs.Activities.ActivityEmail>(model); conn = DataHelper.OpenIfNeeded(conn); conn.Execute("UPDATE \"activity_email\" SET " + "\"type\"=@Type, \"is_campaign_response\"=@IsCampaignResponse, \"subject\"=@Subject, \"body\"=@Body, \"owner\"=@Owner, \"priority\"=@Priority, \"due\"=@Due, " + "\"state\"=@State, \"status_reason\"=@StatusReason, \"sender\"=@Sender, \"recipient\"=@Recipient, \"direction\"=@Direction, \"address\"=@Address, " + "\"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId " + "WHERE \"id\"=@Id", dbo); DataHelper.Close(conn, closeConnection); return(model); }
public ActionResult Edit(long id) { Common.Models.Account.Users currentUser; ViewModels.Activities.ActivityEmailViewModel viewModel = new ViewModels.Activities.ActivityEmailViewModel(); List <ViewModels.Activities.ActivityDirectionViewModel> directionList = new List <ViewModels.Activities.ActivityDirectionViewModel>(); List <ViewModels.Activities.ActivityStatusReasonViewModel> statusReasonList = new List <ViewModels.Activities.ActivityStatusReasonViewModel>(); List <ViewModels.Activities.ActivityPriorityViewModel> priorityList = new List <ViewModels.Activities.ActivityPriorityViewModel>(); using (IDbConnection conn = Data.Database.Instance.GetConnection()) { currentUser = Data.Account.Users.Get(User.Identity.Name, conn, false); Common.Models.Activities.ActivityEmail model = Data.Activities.ActivityEmail.Get(id, conn, false); model.Direction = Data.Activities.ActivityDirection.Get(model.Direction.Id.Value, conn, false); model.Owner = Data.Contacts.Contact.Get(model.Owner.Id.Value, conn, false); model.Sender = Data.Contacts.Contact.Get(model.Sender.Id.Value, conn, false); model.Recipient = Data.Contacts.Contact.Get(model.Recipient.Id.Value, conn, false); model.Priority = Data.Activities.ActivityPriority.Get(model.Priority.Id.Value, conn, false); model.StatusReason = Data.Activities.ActivityStatusReason.Get(model.StatusReason.Id.Value, conn, false); model.Type = Data.Activities.ActivityType.Get(model.Type.Id.Value, conn, false); viewModel = Mapper.Map <ViewModels.Activities.ActivityEmailViewModel>(model); viewModel.Owner = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Owner); viewModel.Sender = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Sender); viewModel.Recipient = Mapper.Map <ViewModels.Contacts.ContactViewModel>(model.Recipient); Common.Models.Activities.ActivityRegardingType regtype = Data.Activities.ActivityRegardingType.GetFromActivityId(model.Id.Value, conn, false); if (regtype.Title == "Lead") { Common.Models.Activities.ActivityRegardingLead ar = Data.Activities.ActivityRegardingLead.GetFromActivityId(model.Id.Value, conn, false); ar.Lead = Data.Leads.Lead.Get(ar.Lead.Id.Value, conn, false); ar.Lead.Contact = Data.Contacts.Contact.Get(ar.Lead.Contact.Id.Value, conn, false); viewModel.RegardingLead = Mapper.Map <ViewModels.Activities.ActivityRegardingLeadViewModel>(ar); viewModel.RegardingLead.Lead = Mapper.Map <ViewModels.Leads.LeadViewModel>(ar.Lead); viewModel.RegardingLead.Lead.Contact = Mapper.Map <ViewModels.Contacts.ContactViewModel>(ar.Lead.Contact); viewModel.RegardingLead.Type = Mapper.Map <ViewModels.Activities.ActivityRegardingTypeViewModel>(regtype); } else { Common.Models.Activities.ActivityRegardingOpportunity ao = Data.Activities.ActivityRegardingOpportunity.GetFromActivityId(model.Id.Value, conn, false); ao.Opportunity = Data.Opportunities.Opportunity.Get(ao.Opportunity.Id.Value, conn, false); ao.Opportunity.Account = Data.Contacts.Contact.Get(ao.Opportunity.Account.Id.Value, conn, false); viewModel.RegardingOpportunity = Mapper.Map <ViewModels.Activities.ActivityRegardingOpportunityViewModel>(ao); viewModel.RegardingOpportunity.Opportunity = Mapper.Map <ViewModels.Opportunities.OpportunityViewModel>(ao.Opportunity); viewModel.RegardingOpportunity.Opportunity.Account = Mapper.Map <ViewModels.Contacts.ContactViewModel>(ao.Opportunity.Account); viewModel.RegardingOpportunity.Type = Mapper.Map <ViewModels.Activities.ActivityRegardingTypeViewModel>(regtype); } Data.Activities.ActivityDirection.List(conn, false).ForEach(x => { ViewModels.Activities.ActivityDirectionViewModel vm = Mapper.Map <ViewModels.Activities.ActivityDirectionViewModel>(x); directionList.Add(vm); }); Data.Activities.ActivityStatusReason.List(conn, false).ForEach(x => { ViewModels.Activities.ActivityStatusReasonViewModel vm = Mapper.Map <ViewModels.Activities.ActivityStatusReasonViewModel>(x); statusReasonList.Add(vm); }); Data.Activities.ActivityPriority.List(conn, false).ForEach(x => { ViewModels.Activities.ActivityPriorityViewModel vm = Mapper.Map <ViewModels.Activities.ActivityPriorityViewModel>(x); priorityList.Add(vm); }); } ViewBag.DirectionList = directionList; ViewBag.StatusReasonList = statusReasonList; ViewBag.PriorityList = priorityList; return(View(viewModel)); }