public static Common.Models.Opportunities.OpportunityContact Enable(
Transaction t,
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users enabler)
{
return(Enable(model, enabler, t.Connection, false));
}
public static Common.Models.Opportunities.OpportunityContact Edit(
Transaction t,
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users modifier)
{
return(Edit(model, modifier, t.Connection, false));
}
public static Common.Models.Opportunities.OpportunityContact Create(
Transaction t,
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users creator)
{
return(Create(model, creator, t.Connection, false));
}
public static Common.Models.Opportunities.OpportunityContact Disable(
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users disabler,
IDbConnection conn = null,
bool closeConnection = true)
{
model.DisabledBy = disabler;
model.Disabled = DateTime.UtcNow;
DataHelper.Disable <Common.Models.Opportunities.OpportunityContact,
DBOs.Opportunities.OpportunityContact>("opportunity_contact", disabler.PId.Value, model.Id, conn, closeConnection);
return(model);
}
public static Common.Models.Opportunities.OpportunityContact Create(
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users creator,
IDbConnection conn = null,
bool closeConnection = true)
{
Common.Models.Opportunities.OpportunityContact orig =
DataHelper.Get <Common.Models.Opportunities.OpportunityContact, DBOs.Opportunities.OpportunityContact>(
"SELECT * FROM \"opportunity_contact\" WHERE\"opportunity_id\"=@OpportunityId AND \"contact_id\"=@ContactId",
new { OpportunityId = model.Opportunity.Id.Value, ContactId = model.Contact.Id.Value }, conn, closeConnection);
if (orig != null)
{
if (orig.Disabled.HasValue || orig.DisabledBy != null)
{
model.Id = orig.Id;
orig = Edit(model, creator, conn, false);
orig = Enable(model, creator, conn, false);
}
}
else
{
model.Created = model.Modified = DateTime.UtcNow;
model.CreatedBy = model.ModifiedBy = creator;
DBOs.Opportunities.OpportunityContact dbo = Mapper.Map <DBOs.Opportunities.OpportunityContact>(model);
conn = DataHelper.OpenIfNeeded(conn);
if (conn.Execute("INSERT INTO \"opportunity_contact\" (\"opportunity_id\", \"contact_id\", " +
"\"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " +
"VALUES (@OpportunityId, @ContactId, " +
"@UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)",
dbo) > 0)
{
model.Id = conn.Query <DBOs.Opportunities.OpportunityContact>("SELECT currval(pg_get_serial_sequence('opportunity_contact', 'id')) AS \"id\"").Single().Id;
}
}
DataHelper.Close(conn, closeConnection);
return(model);
}
public static Common.Models.Opportunities.OpportunityContact Edit(
Common.Models.Opportunities.OpportunityContact model,
Common.Models.Account.Users modifier,
IDbConnection conn = null,
bool closeConnection = true)
{
model.ModifiedBy = modifier;
model.Modified = DateTime.UtcNow;
DBOs.Opportunities.OpportunityContact dbo = Mapper.Map <DBOs.Opportunities.OpportunityContact>(model);
conn = DataHelper.OpenIfNeeded(conn);
conn.Execute("UPDATE \"opportunity_contact\" SET " +
"\"opportunity_id\"=@OpportunityId, \"contact_id\"=@ContactId, " +
"\"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId " +
"WHERE \"id\"=@Id", dbo);
DataHelper.Close(conn, closeConnection);
return(model);
}
public ActionResult Edit(long id, ViewModels.Opportunities.OpportunityViewModel viewModel)
{
Common.Models.Account.Users currentUser;
Common.Models.Opportunities.Opportunity model;
using (Data.Transaction trans = Data.Transaction.Create(true))
{
try
{
Common.Models.Leads.Lead lead;
currentUser = Data.Account.Users.Get(trans, User.Identity.Name);
Common.Models.Leads.Lead oldLead = Data.Leads.Lead.Get(trans, viewModel.Lead.Id.Value);
lead = Mapper.Map <Common.Models.Leads.Lead>(viewModel.Lead);
lead.Fee = Mapper.Map <Common.Models.Leads.LeadFee>(viewModel.Lead.Fee);
if (oldLead.Fee != null)
{
lead.Fee = Data.Leads.LeadFee.Edit(trans, lead.Fee, currentUser);
}
else
{
lead.Fee = Data.Leads.LeadFee.Create(trans, lead.Fee, currentUser);
}
lead = Data.Leads.Lead.Edit(trans, lead, currentUser);
model = Mapper.Map <Common.Models.Opportunities.Opportunity>(viewModel);
// Check the probability, is it percent or decimal?
if (model.Probability.HasValue && model.Probability.Value > 1)
{
model.Probability = model.Probability.Value / 100;
}
model = Data.Opportunities.Opportunity.Edit(trans, model, currentUser);
// Add new contacts
viewModel.Contacts.ForEach(x =>
{
if (x.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Contact = Mapper.Map <Common.Models.Contacts.Contact>(x),
Opportunity = model
};
oc = Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
});
// Handle deletions
Data.Opportunities.OpportunityContact.ListForOpportunity(trans, model.Id.Value).ForEach(x =>
{
if (!viewModel.Contacts.Any(vm =>
{
if (vm.Id.HasValue)
{
return(vm.Id.Value == x.Contact.Id.Value);
}
return(false);
}))
{
Data.Opportunities.OpportunityContact.Disable(trans, x, currentUser);
}
});
trans.Commit();
return(RedirectToAction("Details", new { Id = id }));
}
catch (Exception ex)
{
trans.Rollback();
return(Edit(id));
}
}
}
public ActionResult Convert(long id, ViewModels.Leads.LeadConvertViewModel viewModel)
{
Common.Models.Account.Users currentUser;
Common.Models.Opportunities.Opportunity model;
using (Data.Transaction trans = Data.Transaction.Create(true))
{
try
{
currentUser = Data.Account.Users.Get(trans, User.Identity.Name);
Common.Models.Leads.Lead oldLead = Data.Leads.Lead.Get(trans, id);
model = Mapper.Map <Common.Models.Opportunities.Opportunity>(viewModel.Opportunity);
model.Lead = Mapper.Map <Common.Models.Leads.Lead>(viewModel.Opportunity.Lead);
//model.Lead.Source = Mapper.Map<Common.Models.Leads.LeadSource>(viewModel.Lead.Source);
model.Lead.Fee = Mapper.Map <Common.Models.Leads.LeadFee>(viewModel.Opportunity.Lead.Fee);
if (oldLead.Fee != null)
{
model.Lead.Fee = Data.Leads.LeadFee.Edit(trans, model.Lead.Fee, currentUser);
}
else
{
model.Lead.Fee = Data.Leads.LeadFee.Create(trans, model.Lead.Fee, currentUser);
}
//model.Lead.Source = Data.Leads.LeadSource.Edit(trans, model.Lead.Source, currentUser);
model.Lead = Data.Leads.Lead.Edit(trans, model.Lead, currentUser);
// Check the probability, is it percent or decimal?
if (model.Probability.HasValue && model.Probability.Value > 1)
{
model.Probability = model.Probability.Value / 100;
}
model = Data.Opportunities.Opportunity.Create(trans, model, currentUser);
// Contacts involved
if (viewModel.Contact1 != null & viewModel.Contact1.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact1)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact2 != null & viewModel.Contact2.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact2)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact3 != null & viewModel.Contact3.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact3)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact4 != null & viewModel.Contact4.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact4)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact5 != null & viewModel.Contact5.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact5)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact6 != null & viewModel.Contact6.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact6)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact7 != null & viewModel.Contact7.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact7)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact8 != null & viewModel.Contact8.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact8)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact9 != null & viewModel.Contact9.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact9)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
if (viewModel.Contact10 != null & viewModel.Contact10.Id.HasValue)
{
Common.Models.Opportunities.OpportunityContact oc = new Common.Models.Opportunities.OpportunityContact()
{
Opportunity = new Common.Models.Opportunities.Opportunity()
{
Id = model.Id.Value
},
Contact = Mapper.Map <Common.Models.Contacts.Contact>(viewModel.Contact10)
};
Data.Opportunities.OpportunityContact.Create(trans, oc, currentUser);
}
trans.Commit();
return(RedirectToAction("Details", "Opportunities", new { Id = model.Id }));
}
catch (Exception ex)
{
trans.Rollback();
return(Edit(id));
}
}
}
