private void Page_Load(object sender, System.EventArgs e)
{
// 06/04/2006 Paul. NewRecord should not be displayed if the user does not have edit rights.
this.Visible = (SplendidCRM.Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!this.Visible)
{
return;
}
// 06/09/2006 Paul. Remove data binding in the user controls. Binding is required, but only do so in the ASPX pages.
//this.DataBind(); // Need to bind so that Text of the Button gets updated.
reqNAME.ErrorMessage = L10n.Term(".ERR_MISSING_REQUIRED_FIELDS") + " " + L10n.Term("Project.LBL_LIST_NAME") + "<br>";
if (!IsPostBack)
{
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
// 07/16/2005 Paul. Items.Insert is not working (but not failing).
lstASSIGNED_USER_ID.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
try
{
// Set default value to current user.
// 07/16/2005 Paul. Setting the default value is not working.
lstASSIGNED_USER_ID.SelectedValue = Security.USER_ID.ToString();
}
catch (Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstUSERS.DataSource = SplendidCache.AssignedUser();
lstUSERS.DataBind();
lstUSERS.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
}
Guid gUSER_ID = Sql.ToGuid(lstUSERS.SelectedValue);
if (!Sql.IsEmptyString(txtROLE_ID.Value) && !Sql.IsEmptyGuid(gUSER_ID))
{
try
{
SqlProcs.spUSERS_ACL_ROLES_MassUpdate(gUSER_ID, txtROLE_ID.Value);
// 05/03/2006 Paul. Don't redirect so that the selected user will not change.
//Response.Redirect("RolesByUser.aspx");
}
catch (Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
lblError.Text = ex.Message;
}
}
BindGrid();
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
if (!IsPostBack)
{
// 06/02/2006 Paul. Buttons should be hidden if the user does not have access.
int nACLACCESS_Delete = Security.GetUserAccess(m_sMODULE, "delete");
int nACLACCESS_Edit = Security.GetUserAccess(m_sMODULE, "edit");
btnDelete.Visible = (nACLACCESS_Delete >= 0);
btnUpdate.Visible = (nACLACCESS_Edit >= 0);
lstSTATUS.DataSource = SplendidCache.List("test_plan_status_dom");
lstSTATUS.DataBind();
lstSTATUS.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstTEST_PLAN_TYPE.DataSource = SplendidCache.List("test_plan_type_dom");
lstTEST_PLAN_TYPE.DataBind();
lstTEST_PLAN_TYPE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
lstASSIGNED_USER_ID.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
}
}
catch (Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstRESOLUTION.DataSource = SplendidCache.List("bug_resolution_dom");
lstRESOLUTION.DataBind();
lstRESOLUTION.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstRELEASE.DataSource = SplendidCache.Release();
lstRELEASE.DataBind();
lstRELEASE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstSTATUS.DataSource = SplendidCache.List("bug_status_dom");
lstSTATUS.DataBind();
lstSTATUS.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstTYPE.DataSource = SplendidCache.List("bug_type_dom");
lstTYPE.DataBind();
lstTYPE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstPRIORITY.DataSource = SplendidCache.List("bug_priority_dom");
lstPRIORITY.DataBind();
lstPRIORITY.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
// 06/03/2004 Paul. A Multiple-line ListBox does not need a NULL entry.
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
// 06/03/2004 Paul. A Multiple-line ListBox does not need a NULL entry.
}
}
private DataTable BuildChangesTable(DataTable dtAudit)
{
DataTable dtChanges = new DataTable();
DataColumn colFIELD_NAME = new DataColumn("FIELD_NAME", typeof(System.String));
DataColumn colBEFORE_VALUE = new DataColumn("BEFORE_VALUE", typeof(System.String));
DataColumn colAFTER_VALUE = new DataColumn("AFTER_VALUE", typeof(System.String));
DataColumn colCREATED_BY = new DataColumn("CREATED_BY", typeof(System.String));
DataColumn colDATE_CREATED = new DataColumn("DATE_CREATED", typeof(System.DateTime));
dtChanges.Columns.Add(colFIELD_NAME);
dtChanges.Columns.Add(colBEFORE_VALUE);
dtChanges.Columns.Add(colAFTER_VALUE);
dtChanges.Columns.Add(colCREATED_BY);
dtChanges.Columns.Add(colDATE_CREATED);
if (dtAudit.Rows.Count > 0)
{
StringDictionary dict = new StringDictionary();
dict.Add("AUDIT_ACTION", String.Empty);
dict.Add("AUDIT_DATE", String.Empty);
dict.Add("AUDIT_COLUMNS", String.Empty);
dict.Add("CSTM_AUDIT_COLUMNS", String.Empty);
dict.Add("ID", String.Empty);
dict.Add("ID_C", String.Empty);
dict.Add("DELETED", String.Empty);
dict.Add("CREATED_BY", String.Empty);
dict.Add("DATE_ENTERED", String.Empty);
dict.Add("MODIFIED_USER_ID", String.Empty);
dict.Add("DATE_MODIFIED", String.Empty);
DataRow rowLast = dtAudit.Rows[0];
for (int i = 1; i < dtAudit.Rows.Count; i++)
{
DataRow row = dtAudit.Rows[i];
foreach (DataColumn col in row.Table.Columns)
{
if (!dict.ContainsKey(col.ColumnName))
{
if (Sql.ToString(rowLast[col.ColumnName]) != Sql.ToString(row[col.ColumnName]))
{
DataRow rowChange = dtChanges.NewRow();
dtChanges.Rows.Add(rowChange);
rowChange["FIELD_NAME"] = col.ColumnName;
rowChange["CREATED_BY"] = SplendidCache.AssignedUser(Sql.ToGuid(row["MODIFIED_USER_ID"]));
rowChange["DATE_CREATED"] = row["AUDIT_DATE"];
rowChange["BEFORE_VALUE"] = rowLast[col.ColumnName];
rowChange["AFTER_VALUE"] = row [col.ColumnName];
}
}
}
rowLast = row;
}
}
return(dtChanges);
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstLEAD_SOURCE.DataSource = SplendidCache.List("lead_source_dom");
lstLEAD_SOURCE.DataBind();
lstLEAD_SOURCE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
// 06/03/2004 Paul. A Multiple-line ListBox does not need a NULL entry.
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstSTATUS.DataSource = SplendidCache.List("campaign_status_dom");
lstSTATUS.DataBind();
lstSTATUS.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstCAMPAIGN_TYPE.DataSource = SplendidCache.List("campaign_type_dom");
lstCAMPAIGN_TYPE.DataBind();
lstCAMPAIGN_TYPE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
lstINDUSTRY.DataSource = SplendidCache.List("industry_dom");
lstINDUSTRY.DataBind();
lstINDUSTRY.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstACCOUNT_TYPE.DataSource = SplendidCache.List("account_type_dom");
lstACCOUNT_TYPE.DataBind();
lstACCOUNT_TYPE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
// 06/03/2004 Paul. A Multiple-line ListBox does not need a NULL entry.
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// 06/04/2006 Paul. NewRecord should not be displayed if the user does not have edit rights.
this.Visible = (SplendidCRM.Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!this.Visible)
{
return;
}
if (!IsPostBack)
{
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
lstASSIGNED_USER_ID.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utils.SetPageTitle(Page, L10n.Term(".moduleList." + m_sMODULE));
// 06/04/2006 Paul. Visibility is already controlled by the ASPX page, but it is probably a good idea to skip the load.
this.Visible = (SplendidCRM.Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!this.Visible)
{
return;
}
try
{
// 01/21/2006 Paul. If there is an error sending the email, we want to make sure to reuse the ID,
// otherwise multiple emails get created as the user tries to resend.
gID = Sql.ToGuid(ViewState["ID"]);
if (Sql.IsEmptyGuid(gID))
{
gID = Sql.ToGuid(Request["ID"]);
}
if (!IsPostBack)
{
sEMAIL_TYPE = Sql.ToString(Request["TYPE"]).ToLower();
if (sEMAIL_TYPE != "archived")
{
sEMAIL_TYPE = "draft";
}
ctlEditButtons.Visible = !PrintView && (sEMAIL_TYPE != "draft");
ctlEmailButtons.Visible = !PrintView && (sEMAIL_TYPE == "draft");
if (Sql.IsEmptyGuid(gID))
{
ctlModuleHeader.EnableModuleLabel = false;
if (sEMAIL_TYPE == "archived")
{
ctlModuleHeader.Title = L10n.Term("Emails.LBL_ARCHIVED_MODULE_NAME") + ":";
}
else
{
ctlModuleHeader.Title = L10n.Term("Emails.LBL_COMPOSE_MODULE_NAME") + ":";
}
// 04/16/2006 Paul. The subject is not required.
//lblNAME_REQUIRED .Visible = (sEMAIL_TYPE == "archived");
//reqNAME.Enabled = lblNAME_REQUIRED.Visible;
ctlDATE_START.Visible = (sEMAIL_TYPE == "archived");
spnDATE_START.Visible = ctlDATE_START.Visible;
spnTEMPLATE_LABEL.Visible = (sEMAIL_TYPE == "draft");
lstEMAIL_TEMPLATE.Visible = spnTEMPLATE_LABEL.Visible;
trNOTE_SEMICOLON.Visible = (sEMAIL_TYPE == "draft");
trFROM.Visible = !trNOTE_SEMICOLON.Visible;
ViewState["TYPE"] = sEMAIL_TYPE;
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
}
lstASSIGNED_USER_ID.DataSource = SplendidCache.AssignedUser();
lstASSIGNED_USER_ID.DataBind();
lstASSIGNED_USER_ID.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
lstPARENT_TYPE.DataSource = SplendidCache.List("record_type_display");
lstPARENT_TYPE.DataBind();
if (lstEMAIL_TEMPLATE.Visible)
{
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
string sSQL;
sSQL = "select * " + ControlChars.CrLf
+ " from vwEMAIL_TEMPLATES_List" + ControlChars.CrLf
+ " order by NAME " + ControlChars.CrLf;
using (IDbCommand cmd = con.CreateCommand())
{
cmd.CommandText = sSQL;
using (DbDataAdapter da = dbf.CreateDataAdapter())
{
((IDbDataAdapter)da).SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
da.Fill(dt);
lstEMAIL_TEMPLATE.DataSource = dt.DefaultView;
lstEMAIL_TEMPLATE.DataBind();
lstEMAIL_TEMPLATE.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
}
}
}
}
}
// 07/29/2005 Paul. SugarCRM 3.0 does not allow the NONE option.
//lstPARENT_TYPE .Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
Guid gDuplicateID = Sql.ToGuid(Request["DuplicateID"]);
if (!Sql.IsEmptyGuid(gID) || !Sql.IsEmptyGuid(gDuplicateID))
{
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
string sSQL;
sSQL = "select * " + ControlChars.CrLf
+ " from vwEMAILS_Edit" + ControlChars.CrLf
+ " where ID = @ID " + ControlChars.CrLf;
using (IDbCommand cmd = con.CreateCommand())
{
cmd.CommandText = sSQL;
if (!Sql.IsEmptyGuid(gDuplicateID))
{
Sql.AddParameter(cmd, "@ID", gDuplicateID);
gID = Guid.Empty;
}
else
{
Sql.AddParameter(cmd, "@ID", gID);
}
con.Open();
#if DEBUG
Page.RegisterClientScriptBlock("SQLCode", Sql.ClientScriptBlock(cmd));
#endif
using (IDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title += Sql.ToString(rdr["NAME"]);
Utils.SetPageTitle(Page, L10n.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
ViewState["ID"] = gID;
txtNAME.Text = Sql.ToString(rdr["NAME"]);
ctlDATE_START.Value = T10n.FromServerTime(rdr["DATE_START"]);
txtPARENT_ID.Value = Sql.ToString(rdr["PARENT_ID"]);
txtPARENT_NAME.Text = Sql.ToString(rdr["PARENT_NAME"]);
txtFROM_NAME.Value = Sql.ToString(rdr["FROM_NAME"]);
txtFROM_ADDR.Text = Sql.ToString(rdr["FROM_ADDR"]);
txtTO_ADDRS.Text = Sql.ToString(rdr["TO_ADDRS"]);
txtCC_ADDRS.Text = Sql.ToString(rdr["CC_ADDRS"]);
txtBCC_ADDRS.Text = Sql.ToString(rdr["BCC_ADDRS"]);
txtTO_ADDRS_IDS.Value = Sql.ToString(rdr["TO_ADDRS_IDS"]);
txtTO_ADDRS_NAMES.Value = Sql.ToString(rdr["TO_ADDRS_NAMES"]);
txtTO_ADDRS_EMAILS.Value = Sql.ToString(rdr["TO_ADDRS_EMAILS"]);
txtCC_ADDRS_IDS.Value = Sql.ToString(rdr["CC_ADDRS_IDS"]);
txtCC_ADDRS_NAMES.Value = Sql.ToString(rdr["CC_ADDRS_NAMES"]);
txtCC_ADDRS_EMAILS.Value = Sql.ToString(rdr["CC_ADDRS_EMAILS"]);
txtBCC_ADDRS_IDS.Value = Sql.ToString(rdr["BCC_ADDRS_IDS"]);
txtBCC_ADDRS_NAMES.Value = Sql.ToString(rdr["BCC_ADDRS_NAMES"]);
txtBCC_ADDRS_EMAILS.Value = Sql.ToString(rdr["BCC_ADDRS_EMAILS"]);
// 04/16/2006 Paul. Since the Plug-in saves body in DESCRIPTION, we need to continue to use it as the primary source of data.
txtDESCRIPTION.Value = Sql.ToString(rdr["DESCRIPTION"]);
try
{
lstPARENT_TYPE.SelectedValue = Sql.ToString(rdr["PARENT_TYPE"]);
}
catch (Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
try
{
lstASSIGNED_USER_ID.SelectedValue = Sql.ToString(rdr["ASSIGNED_USER_ID"]);
}
catch (Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
// 11/17/2005 Paul. Archived emails allow editing of the Date & Time Sent.
sEMAIL_TYPE = Sql.ToString(rdr["TYPE"]).ToLower();
switch (sEMAIL_TYPE)
{
case "archived":
ctlModuleHeader.Title = L10n.Term("Emails.LBL_ARCHIVED_MODULE_NAME") + ":" + txtNAME.Text;
break;
case "out":
ctlModuleHeader.Title = L10n.Term("Emails.LBL_LIST_FORM_SENT_TITLE") + ":" + txtNAME.Text;
break;
default:
sEMAIL_TYPE = "draft";
ctlModuleHeader.Title = L10n.Term("Emails.LBL_COMPOSE_MODULE_NAME") + ":" + txtNAME.Text;
break;
}
if (sEMAIL_TYPE == "out")
{
// 01/21/2006 Paul. Editing is not allowed for sent emails.
Response.Redirect("view.aspx?ID=" + gID.ToString());
return;
}
// 04/16/2006 Paul. The subject is not required.
//lblNAME_REQUIRED .Visible = (sEMAIL_TYPE == "archived");
//reqNAME.Enabled = lblNAME_REQUIRED.Visible;
ctlDATE_START.Visible = (sEMAIL_TYPE == "archived");
spnDATE_START.Visible = ctlDATE_START.Visible;
spnTEMPLATE_LABEL.Visible = (sEMAIL_TYPE == "draft");
lstEMAIL_TEMPLATE.Visible = spnTEMPLATE_LABEL.Visible;
trNOTE_SEMICOLON.Visible = (sEMAIL_TYPE == "draft");
trFROM.Visible = !trNOTE_SEMICOLON.Visible;
ctlModuleHeader.EnableModuleLabel = false;
ctlEditButtons.Visible = !PrintView && (sEMAIL_TYPE != "draft");
ctlEmailButtons.Visible = !PrintView && (sEMAIL_TYPE == "draft");
ViewState["TYPE"] = sEMAIL_TYPE;
}
}
}
sSQL = "select * " + ControlChars.CrLf
+ " from vwEMAILS_Attachments" + ControlChars.CrLf
+ " where EMAIL_ID = @EMAIL_ID" + ControlChars.CrLf;
using (IDbCommand cmd = con.CreateCommand())
{
cmd.CommandText = sSQL;
Sql.AddParameter(cmd, "@EMAIL_ID", gID);
#if DEBUG
Page.RegisterClientScriptBlock("vwEMAILS_Attachments", Sql.ClientScriptBlock(cmd));
#endif
using (DbDataAdapter da = dbf.CreateDataAdapter())
{
((IDbDataAdapter)da).SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
da.Fill(dt);
ctlAttachments.DataSource = dt.DefaultView;
ctlAttachments.DataBind();
}
}
}
}
}
else
{
Guid gPARENT_ID = Sql.ToGuid(Request["PARENT_ID"]);
if (!Sql.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
SqlProcs.spPARENT_Get(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!Sql.IsEmptyGuid(gPARENT_ID))
{
txtPARENT_ID.Value = gPARENT_ID.ToString();
txtPARENT_NAME.Text = sPARENT_NAME;
try
{
lstPARENT_TYPE.SelectedValue = sPARENT_TYPE;
}
catch (Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
// 08/05/2006 Paul. When an email is composed from a Lead, automatically set the To address.
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
string sSQL;
sSQL = "select EMAIL1 " + ControlChars.CrLf
+ " from vwLEADS_Edit" + ControlChars.CrLf
+ " where ID = @ID " + ControlChars.CrLf;
using (IDbCommand cmd = con.CreateCommand())
{
cmd.CommandText = sSQL;
Sql.AddParameter(cmd, "@ID", gPARENT_ID);
con.Open();
#if DEBUG
Page.RegisterClientScriptBlock("vwLEADS_Edit", Sql.ClientScriptBlock(cmd));
#endif
using (IDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
txtTO_ADDRS.Text = Sql.ToString(rdr["EMAIL1"]);
}
}
}
}
}
}
try
{
lstASSIGNED_USER_ID.SelectedValue = Security.USER_ID.ToString();
}
catch (Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
}
}
else
{
// 12/02/2005 Paul. When validation fails, the header title does not retain its value. Update manually.
ctlModuleHeader.Title = Sql.ToString(ViewState["ctlModuleHeader.Title"]);
Utils.SetPageTitle(Page, L10n.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
sEMAIL_TYPE = Sql.ToString(ViewState["TYPE"]);
}
}
catch (Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message);
ctlEditButtons.ErrorText = ex.Message;
ctlEmailButtons.ErrorText = ex.Message;
}
}
private void OnDataBinding(object sender, EventArgs e)
{
Literal lbl = (Literal)sender;
DataGridItem objContainer = (DataGridItem)lbl.NamingContainer;
DataRowView row = objContainer.DataItem as DataRowView;
if (row != null)
{
// 04/30/2006 Paul. Use the Context to store pointers to the localization objects.
// This is so that we don't need to require that the page inherits from SplendidPage.
L10N L10n = HttpContext.Current.Items["L10n"] as L10N;
if (L10n == null)
{
// 04/26/2006 Paul. We want to have the AccessView on the SystemCheck page.
L10n = new L10N(Sql.ToString(HttpContext.Current.Session["USER_SETTINGS/CULTURE"]));
}
if (L10n != null)
{
if (row[sDATA_FIELD] != DBNull.Value)
{
string sList = sLIST_NAME;
// 01/18/2007 Paul. If AssignedUser list, then use the cached value to find the value.
if (sLIST_NAME == "AssignedUser")
{
lbl.Text = SplendidCache.AssignedUser(Sql.ToGuid(row[sDATA_FIELD]));
}
// 12/05/2005 Paul. The activity status needs to be dynamically converted to the correct list.
else if (sLIST_NAME == "activity_status")
{
string sACTIVITY_TYPE = String.Empty;
try
{
sACTIVITY_TYPE = Sql.ToString(row["ACTIVITY_TYPE"]);
switch (sACTIVITY_TYPE)
{
case "Tasks": sList = "task_status_dom"; break;
case "Meetings": sList = "meeting_status_dom"; break;
case "Calls":
// 07/15/2006 Paul. Call status is translated externally.
lbl.Text = Sql.ToString(row[sDATA_FIELD]);
return;
//sList = "call_status_dom" ; break;
case "Notes":
// 07/15/2006 Paul. Note Status is not normally as it does not have a status.
lbl.Text = L10n.Term(".activity_dom.Note");
return;
// 06/15/2006 Paul. This list name for email_status does not follow the standard.
case "Emails": sList = "dom_email_status"; break;
// 04/21/2006 Paul. If the activity does not have a status (such as a Note), then use activity_dom.
default: sList = "activity_dom"; break;
}
}
catch (Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
lbl.Text = Sql.ToString(L10n.Term("." + sList + ".", row[sDATA_FIELD]));
}
else
{
lbl.Text = Sql.ToString(L10n.Term("." + sList + ".", row[sDATA_FIELD]));
}
}
}
else
{
lbl.Text = Sql.ToString(row[sDATA_FIELD]);
}
}
else
{
lbl.Text = sDATA_FIELD;
}
}
