private void LoadCompanyRemarks()
{
using (BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection)) {
tbxCompanyRemarks.Text = "";
PrevCompanyRemarks = "";
m_efeCompanyRemark = _efDbModel.sub_campaign_account_remarks.FirstOrDefault(i => i.sub_campaign_id == SubCampaignId && i.account_id == AccountId);
if (m_efeCompanyRemark == null) {
m_efeCompanyRemark = new sub_campaign_account_remarks() {
sub_campaign_id = SubCampaignId,
account_id = AccountId
};
_efDbModel.sub_campaign_account_remarks.AddObject(m_efeCompanyRemark);
_efDbModel.SaveChanges();
}
else {
if (m_efeCompanyRemark.remarks != null && m_efeCompanyRemark.remarks.Length > 0)
tbxCompanyRemarks.Text = m_efeCompanyRemark.remarks;
}
PrevCompanyRemarks = tbxCompanyRemarks.Text;
_efDbModel.Detach(m_efeCompanyRemark);
}
m_OriginalRemarks = tbxCompanyRemarks.Text;
m_RemarksSaved = true;
}
private void tbxCompanyRemarks_Leave(object sender, EventArgs e)
{
if (!m_RemarksChanged)
return;
this.RunAssync(() => {
BrightPlatformEntities _efDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
m_efeCompanyRemark = _efDbModel.sub_campaign_account_remarks.FirstOrDefault(i => i.sub_campaign_id == SubCampaignId && i.account_id == AccountId);
m_efeCompanyRemark.remarks = tbxCompanyRemarks.Text;
_efDbModel.sub_campaign_account_remarks.ApplyCurrentValues(m_efeCompanyRemark);
_efDbModel.SaveChanges();
PrevCompanyRemarks = tbxCompanyRemarks.Text;
m_EventBus.Notify(new EventFollowUpLogEvents.CompanyRemarksSaved.ManageCampaignBooking() {
CompanyRemarks = tbxCompanyRemarks.Text
});
m_EventBus.Notify(new EventFollowUpLogEvents.CompanyRemarksSaved.FrmSalesConsultant() {
CompanyRemarks = tbxCompanyRemarks.Text
});
//if (CompanyRemark_Saved != null)
// CompanyRemark_Saved(this, new CompanyRemarkSavedArgs() {
// CompanyRemarks = tbxCompanyRemarks.Text,
// SubCampaignId = SubCampaignId,
// AccountId = AccountId,
// FinalListId = FinalListId
// });
});
m_RemarksSaved = true;
m_RemarksChanged = false;
m_Timer.Stop();
m_Timer.Enabled = false;
m_SecondElapse = 5;
}
/// <summary>
/// Method to save company remarks
/// </summary>
/// <param name="SubCampignId"></param>
/// <param name="CompanyId"></param>
/// <param name="Remarks"></param>
public static void SaveCompanyRemarks(int SubCampignId, int CompanyId, string Remarks)
{
BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection);
sub_campaign_account_remarks objCompanyRemark = objDbModel.sub_campaign_account_remarks.FirstOrDefault(i => i.sub_campaign_id == SubCampignId && i.account_id == CompanyId);
if (objCompanyRemark != null)
{
objCompanyRemark.remarks = Remarks;
objDbModel.SaveChanges();
}
else
{
if (!string.IsNullOrEmpty(Remarks))
{
objCompanyRemark = null;
objCompanyRemark = new sub_campaign_account_remarks()
{
sub_campaign_id = SubCampignId,
account_id = CompanyId,
remarks = Remarks
};
objDbModel.sub_campaign_account_remarks.AddObject(objCompanyRemark);
objDbModel.SaveChanges();
}
}
}
