private void FillBox()
{
ItemListSort = -1;
lstBoxSiblingItems.Items.Clear();
if (Item != null)
{
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
using (DataTable siblingItems = dbObj.RunSPReturnDataSet("_Item_GetSiblingItems", new System.Data.SqlClient.SqlParameter("@ItemId", Item.Id)).Tables[0])
{
dbObj.CloseConnection();
if (siblingItems != null && siblingItems.Rows.Count > 0)
{
lstBoxSiblingItems.Size = siblingItems.Rows.Count + 1;
}
if (siblingItems.Rows.Count > 14)
{
lstBoxSiblingItems.Size = 15;
}
for (int i = 0; i < siblingItems.Rows.Count; i++)
{
string itemName = siblingItems.Rows[i]["ItemName"].ToString();
string itemNumber = siblingItems.Rows[i]["ItemNumber"].ToString();
itemName = itemNumber.Length > 0 ? "[" + itemNumber + "] - " + itemName : itemName;
ListItem newItem = new ListItem("[" + siblingItems.Rows[i]["LevelId"].ToString() + "] - " + itemName, siblingItems.Rows[i]["ItemId"].ToString().ToString());
if (newItem.Text.Length > 80)
{
newItem.Text = newItem.Text.Substring(0, 49) + "...";
}
lstBoxSiblingItems.Items.Add(newItem);
}
}
}
}
}
/// <summary>
/// Display the selected term properties
/// </summary>
/// <param name="selTermId">TermId</param>
void UpdateDataEdit(string selTermId)
{
Session["PageIndexTerm"] = dg.DisplayLayout.Pager.CurrentPageIndex;
Session["TermType"] = DDL_TermTypeList.SelectedValue;
Session["FilterTerm"] = txtFilter.Text;
panelGrid.Visible = false;
webTab.EnableViewState = false;
webTab.Tabs.GetTab(0).ContentPane.TargetUrl = "./Termbase/Term_Properties.aspx?t=" + selTermId;
if (selTermId == "-1")
{
#region New Term
webTab.Tabs.GetTab(1).ContentPane.TargetUrl = "";
webTab.Tabs[1].Visible = false;
webTab.Tabs.GetTab(2).ContentPane.TargetUrl = "";
webTab.Tabs[2].Visible = false;
lbTitle.Text = "Term: New";
#endregion
}
else
{
#region Term selected
using (Term HCTerm = Term.GetByKey(Convert.ToInt32(selTermId)))
{
string termValue = HCTerm.Value.ToString();
if (termValue.Length > 50)
{
termValue = termValue.Substring(0, 50) + "...";
}
lbTitle.Text = "Term: " + termValue;
webTab.Tabs.GetTab(1).ContentPane.TargetUrl = "./Termbase/Term_Translations.aspx?t=" + selTermId;
webTab.Tabs.GetTab(2).ContentPane.TargetUrl = "./Termbase/Term_Containers.aspx?t=" + selTermId;
HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["Crystal_DB"].ConnectionString);
#region Translations Count
TermTranslationList tlist;
int TranslationsCount;
using (tlist = TermTranslation.GetAll(Convert.ToInt32(selTermId), "TermTypeCode='" + HCTerm.TermTypeCode + "'"))
{
TranslationsCount = tlist.Count - HCTerm.TranslationsMissingCount;
}
#endregion
webTab.Tabs.GetTab(1).Text = "Translations (" + TranslationsCount.ToString() + "/" + tlist.Count.ToString() + ")";
#region Containers Count
webTab.Tabs.GetTab(2).Visible = false;
using (ContainerList clist = HyperCatalog.Business.Container.GetAll("LabelId=" + selTermId))
{
if (clist.Count > 0)
{
webTab.Tabs.GetTab(2).Text = "Containers (" + clist.Count + ")";
webTab.Tabs.GetTab(2).Visible = true;
}
}
#endregion
}
#endregion
}
panelTabTerm.Visible = true;
webTab.SelectedTabIndex = 0;
}
protected DataSet GetSearchResults()
{
if (Session["SearchResult"] == null)
{
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
Session["SearchResult"] = dbObj.RunSPReturnDataSet("_Item_Search", new SqlParameter("@SearchString", searchString),
new SqlParameter("@UserId", SessionState.User.Id), new SqlParameter("@CultureCode", SessionState.Culture.Code),
new SqlParameter("@CompanyName", SessionState.CompanyName));
}
}
return((DataSet)Session["SearchResult"]);
}
protected void advancedToolBar_ButtonClicked(object sender, Infragistics.WebUI.UltraWebToolbar.ButtonEvent be)
{
advancedToolBar.ClientSideEvents.InitializeToolbar = "";
uwToolbar.Items.FromKeyButton("Export").Pressed(true);
switch (be.Button.Key)
{
case "TotalExport":
using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString))
{
string code = DDL_TermTypeList.SelectedIndex > 0 ? DDL_TermTypeList.SelectedValue.ToString() : string.Empty;
using (DataSet ds = dbObj.RunSPReturnDataSet("_Term_Export", new System.Data.SqlClient.SqlParameter("@TermTypeCode", code)))
{
code = code == string.Empty ? " " : code; // assigning the code to have empty space if it is empty
using (TermType tt = TermType.GetByKey(Convert.ToChar(code))) // If the code value is " ", then tt would be null
{
code = code != " " ? tt.Name : "All terms";
}
HyperCatalog.UI.Tools.Export.ExportTermReport(ds, code, this.Page);
}
}
break;
case "RunValidationReport":
using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString))
{
Infragistics.WebUI.WebSchedule.WebDateChooser startDate = (Infragistics.WebUI.WebSchedule.WebDateChooser)advancedToolBar.Items.FromKeyCustom("startDate").FindControl("startDate");
if (startDate != null)
{
using (DataSet ds = dbObj.RunSPReturnDataSet("_Term_GetChoicesValidationReport", new System.Data.SqlClient.SqlParameter("@DayNew", startDate.Value)))
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
HyperCatalog.UI.Tools.Export.ExportTermValidationReport(ds, (DateTime)startDate.Value, Page);
}
else
{
errorMsg.Text = "No activity since this date.";
errorMsg.Visible = true;
}
}
}
}
break;
default:
Response.Write("coucou");
break;
}
}
private void UpdateDataView()
{
//***************************************
// Retrieve Item info
//***************************************
dg.Visible = false;
lbResult.Visible = false;
if (item != null && culture != null)
{
// Update label for item name
lbItemName.Text = item.Name + " (" + item.Level.Name + ")";
if (item.Sku != string.Empty)
{
lbItemName.Text = item.Sku + "-" + lbItemName.Text;
}
//using (ChunkList itemChunks = item.Chunks(culture.Code))
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
string sSql = "EXECUTE dbo.QDE_GetItemCountryView " + item.Id + ", '" + culture.Code + "', 0 , 0";
using (DataSet ds = dbObj.RunSQLReturnDataSet(sSql, "chunks"))
{
if (ds != null)
{
dg.DataSource = ds.Tables[0];
Utils.InitGridSort(ref dg, false);
dg.DataBind();
lbcultureName.Text = culture.Name;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "cultureCode", "<script>l='" + culture.Name + "';</script>");
}
}
}
}
if (dg != null && dg.Rows != null && dg.Rows.Count > 0)
{
dg.Visible = true;
}
else
{
lbResult.Visible = true;
}
}
/// <summary>
/// Display TM expressions
/// </summary>
private void UpdateDataView()
{
string search = txtFilter.Text;
TMExpressionsList _tm;
string sSql = String.Empty;
#region Definition Search
if (search != string.Empty) // Search on all expressions
{
string cleanSearch = search.Replace("'", "''").ToLower();
cleanSearch = search.Replace("[", "[[]");
cleanSearch = search.Replace("_", "[_]");
cleanSearch = search.Replace("%", "[%]");
if (cbMatch.Checked)
{
sSql += " Lower(TMExpressionValue) = '" + cleanSearch.ToLower() + "' ";
}
else
{
sSql += " Lower(TMExpressionValue) like '%" + cleanSearch.ToLower() + "%' ";
}
}
#endregion
using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString))
{
using (System.Data.SqlClient.SqlDataReader rs = dbObj.RunSPReturnRS("_TM_GetAll",
new System.Data.SqlClient.SqlParameter("@Filter", sSql),
new System.Data.SqlClient.SqlParameter("@Mode", 1),
new System.Data.SqlClient.SqlParameter("@Company", SessionState.CompanyName)))
{
#region No result
rs.Read();
int c = Convert.ToInt32(rs["ResultCount"]);
if (c == 0)
{
lbNoresults.Text = "No record match your search (" + txtFilter.Text + ")";
lbNoresults.Visible = lbMessage.Visible = true;
dg.Visible = false;
}
#endregion
#region Results
else
{
#region Too much results
if (c > Convert.ToInt32(SessionState.CacheParams["TMMaxRows"].Value))
{
lbNoresults.Text = "There are " + c.ToString() + " expressions found over " + SessionState.CacheParams["TMMaxRows"].Value + ", please refine your search.";
lbNoresults.Visible = lbMessage.Visible = true;
dg.Visible = false;
}
#endregion
#region Display results
else
{
using (_tm = TMExpression.GetAll(sSql))
{
dg.DataSource = _tm;
dg.Columns[1].HeaderText = "TM [" + _tm.Count.ToString() + " item(s) found]";
dg.Bands[0].ColHeadersVisible = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes;
lbNoresults.Visible = lbMessage.Visible = false;
Utils.InitGridSort(ref dg);
dg.DataBind();
dg.Visible = true;
#region PageIndex session
if (SessionState.tmPageIndexExpression != string.Empty)
{
dg.DisplayLayout.Pager.CurrentPageIndex = Convert.ToInt32(SessionState.tmPageIndexExpression);
}
else
{
dg.DisplayLayout.Pager.CurrentPageIndex = 1;
SessionState.tmPageIndexExpression = string.Empty;
}
#endregion
}
}
#endregion
}
dg.Columns.FromKey("ModifyDate").Format = SessionState.User.FormatDate + ' ' + SessionState.User.FormatTime;
rs.Close();
#endregion
}
}
}
private bool SavePassiveApproval()
{
string countryCode = txtCountryCodeValue.Text;
bool success = true;
if (dgPVGrid != null && dgPVGrid.Rows != null && dgPVGrid.Rows.Count > 0)
{
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
System.Text.StringBuilder sbSQL = new System.Text.StringBuilder(string.Empty);
string classId = string.Empty;
string PLCode = string.Empty;
bool isActive = false;
int PassiveApprovalDay = 0;
bool ActiveApproval = false;
UltraGridRowsEnumerator ub = dgPVGrid.Bands[1].GetRowsEnumerator();
while (ub.MoveNext())
{
UltraGridRow dr = (UltraGridRow)ub.Current;
classId = dr.Cells.FromKey("ClassId").ToString();
if (dr.Cells.FromKey("Trigger").Value != null)
{
PassiveApprovalDay = (int)dr.Cells.FromKey("Trigger").Value;
}
else
{
PassiveApprovalDay = 0;
}
if (dr.Cells.FromKey("IsActive") != null)
{
ActiveApproval = (bool)dr.Cells.FromKey("IsActive").Value;
//Included for the QC 6660 for chardonnay release
if (ActiveApproval == true)
{
dr.Cells.FromKey("Trigger").Reset();
}
}
else
{
ActiveApproval = false;
}
PLCode = dr.Cells.FromKey("PLCode").ToString();
//Modified the below code to eliminate the null data in the passive trigger
//if (ActiveApproval == false && (PassiveApprovalDay == 0 || PassiveApprovalDay == null))
if (ActiveApproval == false && PassiveApprovalDay == null)
{
sbSQL.Append("DELETE FROM CountryApprovalTrigger WHERE CountryCode = '");
sbSQL.Append(countryCode);
sbSQL.Append("' AND ClassId = '");
sbSQL.Append(classId);
sbSQL.Append("' AND PLCode = '");
sbSQL.Append(PLCode);
sbSQL.Append("';");
}
else //if (ActiveApproval != false || PassiveApprovalDay != 0) Commented since this condition is of no use
{
if (ActiveApproval == true)
{
PassiveApprovalDay = 0;
}
sbSQL.Append("DELETE FROM CountryApprovalTrigger WHERE CountryCode = '");
sbSQL.Append(countryCode);
sbSQL.Append("' AND ClassId = '");
sbSQL.Append(classId);
sbSQL.Append("' AND PLCode = '");
sbSQL.Append(PLCode);
sbSQL.Append("';");
sbSQL.Append("INSERT INTO CountryApprovalTrigger VALUES('");
sbSQL.Append(countryCode);
sbSQL.Append("', ");
sbSQL.Append(classId);
sbSQL.Append(", ");
sbSQL.Append(PassiveApprovalDay);
sbSQL.Append(",");
sbSQL.Append(Convert.ToByte(ActiveApproval).ToString());
sbSQL.Append(",'");
sbSQL.Append(PLCode);
sbSQL.Append("');");
}
}
if (sbSQL != null && sbSQL.Length > 0)
{
Debug.Trace("Update CountryApprovalTrigger [" + sbSQL.ToString() + "]", DebugSeverity.Low);
dbObj.RunSQLQuery(sbSQL.ToString());
if (dbObj.LastError != null && dbObj.LastError.Length > 0)
{
Tools.UITools.SetMessage(mainMsgLbl, "Country \"" + txtCountryCodeValue.Text + "\" error when updating CountryApprovalTrigger [" + dbObj.LastError + "]", Tools.UITools.MessageLevel.Error);
return(false);
}
}
}
}
return(true);
}
private void UpdateDataEdit(string countryCode)
{
if (countryCode != string.Empty)
{
currentCountry = Business.Country.GetByKey(countryCode);
}
else
{
currentCountry = null;
}
txtRegionCodeValue.ClearSelection();
//using (ItemList classes = Item.GetAll("LevelId=1"))
//{
// classes.Sort("Sort");
// dgPVGrid.DataSource = classes;
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
//using (ds = dbObj.RunSQLReturnDataSet("SELECT * From CountryApprovalTrigger WHERE CountryCode = @CountryCode", HyperComponents.Data.dbAccess.Database.NewSqlParameter("@CountryCode", System.Data.SqlDbType.NVarChar, 50, countryCode)))
//{
string sql = "select I.ItemId as ClassId, dbo.GetItemName(I.ItemId) as [PRODUCT TYPE NAME] from Items I where I.LevelId = 1 ";
//sql += "SELECT * From CountryApprovalTrigger WHERE CountryCode = '" + countryCode + "'";
sql += "SELECT W.ItemId AS ClassId, W.PLCode AS PLCode, W.PLCode +' [' + BP.PLName + ']' AS ProductLine, CA.PassiveApprovalDay as [Trigger],CA.ActiveApproval as IsActive FROM Work_Item_ProductLines W ";
sql += "INNER JOIN Items I ON I.ItemId = W.ItemId AND I.LevelId = 1 ";
sql += "LEFT OUTER JOIN [CountryApprovalTrigger] CA ON CA.ClassId = W.ItemId AND CA.PLCode = W.PLCode AND CA.CountryCode = '" + countryCode + "' ";
sql += "INNER JOIN BPL BP ON BP.PLCode = W.PLCode";
//using (ds = dbObj.RunSQLReturnDataSet(sql.ToString()))
//{
//dbObj.CloseConnection();
ds = dbObj.RunSQLReturnDataSet(sql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
DataColumn parentColumn;
DataColumn childColumn;
DataRelation relation;
parentColumn = ds.Tables[0].Columns["ClassId"];
childColumn = ds.Tables[1].Columns["ClassId"];
relation = new System.Data.DataRelation("ClassId", parentColumn, childColumn);
ds.Relations.Add(relation);
}
}
if (currentCountry != null)
{
Debug.Trace("<br>txtCountryNameValue.Text=" + currentCountry.Name + ", txtRegionCodeValue.SelectedValue = " + currentCountry.RegionCode, DebugSeverity.Low);
txtCountryNameValue.Text = currentCountry.Name;
txtCountryCodeValue.Text = currentCountry.Code;
cbEditContent.Checked = currentCountry.CanLocalizeContent;
cbEditCP.Checked = currentCountry.CanCreateProductInLocalLanguage;
cbEditPLC.Checked = currentCountry.CanLocalizePLC;
cbEditMS.Checked = currentCountry.CanLocalizeMarketSegments;
cbEditCS.Checked = currentCountry.CanLocalizeCrossSells;
cbEditPublishers.Checked = currentCountry.CanLocalizePublishers;
cbTranslationPLC.Checked = currentCountry.PLCDrivenTranslation;
cbIsActive.Checked = currentCountry.IsActive;
cbPublishable.Checked = currentCountry.Publishable;
cbFallBackToEnglish.Checked = currentCountry.FallBackToEnglish;
txtRegionCodeValue.SelectedValue = currentCountry.RegionCode;
_countries = Business.Region.GetByKey(currentCountry.RegionCode).Countries;
txtCountryCodeValue.Enabled = false;
UITools.ShowToolBarButton(propertiesToolBar, "Delete");
UITools.ShowToolBarSeparator(propertiesToolBar, "DeleteSep");
}
else
{
cbIsActive.Checked = true;
txtCountryNameValue.Text = null;
txtCountryCodeValue.Text = null;
UITools.HideToolBarButton(propertiesToolBar, "Delete");
UITools.HideToolBarSeparator(propertiesToolBar, "DeleteSep");
if (regionList.SelectedValue != string.Empty)
{
txtRegionCodeValue.SelectedValue = regionList.SelectedValue;
}
txtCountryCodeValue.Enabled = true;
}
dgPVGrid.DataSource = ds.Tables[0].DefaultView;
//dgPVGrid.DataSource = ds;
dgPVGrid.DataBind();
dgPVGrid.Height = Unit.Empty;
dgPVGrid.Width = Unit.Empty;
Utils.InitGridSort(ref dgPVGrid, false);
foreach (UltraGridColumn use1 in dgPVGrid.Bands[1].Columns)
{
Response.Write(use1.Header.Title);
}
//}
dgPVGrid.Bands[0].Columns[2].Hidden = true;
dgPVGrid.Bands[1].Columns[5].Hidden = true;
setPropertiesVisible(true);
}
protected void BtnDeleteTR_Click(object sender, EventArgs e)
{
//if (txtTRId.Text == string.Empty)
//{
// txtTRMessage.Text = "Please provide a TR id.";
// txtTRMessage.CssClass = "hc_error";
// txtTRMessage.Visible = true;
// return;
//}
System.Int64 TRId = -1;
UserList usersList;
try
{
TRId = Convert.ToInt64(ddlCurrentTRs.SelectedValue);
#region Retrieve TR Users
usersList = HyperCatalog.Business.User.GetTRNotificationUsers(TRId, SessionState.User.Id);
#endregion
}
catch
{
txtTRMessage.Text = "The TR id you provided is not valid.";
txtTRMessage.CssClass = "hc_error";
txtTRMessage.Visible = true;
return;
}
//HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["Crystal_DB"].ConnectionString);
// QC 1232 CRYS : Issue when deleting TR (Increased the time-out parameter to 15 mins)
HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["Crystal_DB"].ConnectionString, 900);
dbObj.RunSPReturnInteger("_TR_Del",
new System.Data.SqlClient.SqlParameter("@TRId", TRId.ToString()),
new System.Data.SqlClient.SqlParameter("@UserId", SessionState.User.Id.ToString()),
new System.Data.SqlClient.SqlParameter("@DeleteChunks", 1));
if (dbObj.LastError != string.Empty)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "errTr", "<script>alert('An error occurred: " + dbObj.LastError + "');</script>");
}
else
{
#region Send mail
if (usersList != null)
{
string appName = SessionState.CacheParams["AppName"].Value.ToString();
string supportInfo = SessionState.CacheParams["SupportInfo"].Value.ToString();
string smtpServer = SessionState.CacheParams["TREmailSmtpServer"].Value.ToString();
string fromEmail = SessionState.CacheParams["TREmailFrom"].Value.ToString();
string mailConfidentiality = SessionState.CacheParams["MailConfidentiality"].Value.ToString();
string trPath = SessionState.CacheParams["TRPhysicalPath"].Value.ToString();
HyperComponents.Net.SMTP.EmailUtil m = new HyperComponents.Net.SMTP.EmailUtil();
m.FromEmail = fromEmail;
m.strBody = "The tr [" + TRId.ToString() + "] has been deleted by " + SessionState.User.FullName + ".\n<br>" + txtDeleteComment.Text + "\n<br>";
m.SmtpServer = smtpServer;
m.Subject = "[" + appName + "] - TR [" + TRId.ToString() + "] removed";
m.strWelcome = "Dear user,\n<br><br>\n";
m.strSignature = "<br>Your " + appName + " system administrator<br>\n";
m.strSignature += supportInfo.Replace(@"\n", @"<br/>");
m.strSignature += "<hr/>\n";
m.strSignature += "<FONT face='arial, helvetica, sans-serif' color=#5a7173 size=1>" + mailConfidentiality.Replace("\n", "<br>") + "</font>";
foreach (User u in usersList)
{
m.SendEmail(u.FullName, u.Email);
}
}
#endregion
txtTRMessage.Text = "TR [" + TRId.ToString() + "] deleted successfully.";
txtTRMessage.CssClass = "hc_success";
txtTRMessage.Visible = true;
LoadCurrentTRsToDelete();
}
}
private void Save()
{
using (HyperComponents.Data.dbAccess.Database dbObj = Utils.GetMainDB())
{
// Default value
lbError.Visible = false;
lbError.Text = string.Empty;
if (pnlMasterPublishing.Visible)
{
cbMasterPublishing.Visible = false;
}
bool isClosed = false;
string s = string.Empty;
if (rbDraft.Checked)
{
s = HyperCatalog.Business.ChunkStatus.Draft.ToString();
}
else if (rbFinal.Checked)
{
s = HyperCatalog.Business.ChunkStatus.Final.ToString();
}
Item curItem = item;
curItem.RegionCode = culture.Code;
if (item.GetRoll() != null && rdSoftRoll.Checked)
{
curItem = item.GetRoll();
}
if (s.Length > 0)
{
#region "Save Master publishing date if necessary"
if (cbMasterPublishing.Checked)
{
if (wdMasterPublishing.Value != null)
{
#region "Save Master Publishing Date Chunk"
if (SessionState.Culture.Type == HyperCatalog.Business.CultureType.Master)
{
// 69605 issue fix
// Use a SP to directly add/update the MPD chunk is ALL childs
DateTime d = (DateTime)wdMasterPublishing.Value;
string mpd = d.Month.ToString() + '/' + d.Day.ToString() + '/' + d.Year.ToString();
dbObj.RunSPReturnInteger("_Item_MPDAddUpd", new SqlParameter("@ItemId", curItem.Id), new SqlParameter("@IncludeChildren", cbWithChildren.Checked), new SqlParameter("@MasterPublishingDate", mpd), new SqlParameter("@UserId", SessionState.User.Id));
}
#endregion
}
else
{
// Error: missing Master Publishing Date
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MissingMasterPublishingDate", "<script>alert('Please provide a valid [master publishing date]');</script>");
return;
}
}
#endregion
//// Modified by Prabhu for ACQ 3.0 (PCF1: Regional Project Management)-- 18/May/09
//// Comment out as not needed after Regional Project Management
//// You cannot override a region project date from master.
#region "Save Project Dates"
/*
* // if item is already a project
* curItem.Milestones.ItemId = curItem.Id;
* curItem.Milestones.RegionCode = culture.Code;
* if (curItem.Milestones != null && culture.Type == CultureType.Regionale && inputFormId < 0)
* {
* if (!curItem.Milestones.Inherited)
* {
* bool updateProjectDate = false;
* // Force Master Acquisition Date to be NOW since the validation is done
* // The product can now be visibile at regional level
* if (curItem.Milestones.BeginningOfRegionalization == null)
* {
* curItem.Milestones.BeginningOfRegionalization = DateTime.UtcNow;
* updateProjectDate = true;
* }
* if ((curItem.Milestones.EndOfRegionalization.HasValue && curItem.Milestones.EndOfRegionalization > DateTime.UtcNow) || curItem.Milestones.EndOfRegionalization == null)
* {
* curItem.Milestones.EndOfRegionalization = DateTime.UtcNow;
* updateProjectDate = true;
* }
* if(updateProjectDate)
* {
* if (!curItem.Milestones.Save(user.Id))
* {
* lbError.CssClass = "hc_error";
* lbError.Text = HyperCatalog.Business.ItemDates.LastError;
* lbError.Visible = true;
* return;
* }
* }
* }
* }
*/
#endregion
//#region "Move status Draft, Rejected --> Final or Final, Rejected --> Draft, if possible" --Alternate for CR 5096
#region "Move status Draft --> Final or Final --> Draft, if possible"
HyperCatalog.Business.ChunkStatus status = (HyperCatalog.Business.ChunkStatus)Enum.Parse(typeof(HyperCatalog.Business.ChunkStatus), s);
if (!curItem.MoveContentToStatus(culture.Code, status, user.Id, cbWithChildren.Checked, inputFormId, containerMATFList))
{
lbError.CssClass = "hc_error";
lbError.Text = HyperCatalog.Business.Item.LastError;
lbError.Visible = true;
return;
}
else
{
if (culture.Code == SessionState.MasterCulture.Code && inputFormId < 0)
{
string includeChildren = cbWithChildren.Checked?"1":"0";
using (DataSet ds = dbObj.RunSQLReturnDataSet("NOTIFICATION_NotifyRegionalUsersMasterValidationOnMATF " + item.Id + ", " + includeChildren))
{
dbObj.CloseConnection();
if (dbObj.LastError != string.Empty)
{
lbError.CssClass = "hc_error";
lbError.Text = "System was not able to notify regional users [" + dbObj.LastError + "]";
lbError.Visible = true;
}
else
{
if (ds != null && ds.Tables.Count == 1)
{
string message = "New products are available at regional level, you can click <a href='";
message += HyperCatalog.Business.ApplicationSettings.Components["Crystal_UI"].URI;
message += "/UI/Collaborate/NPIReport.aspx'>here</a> to access the full list.";
foreach (DataRow dr in ds.Tables[0].Rows)
{
Utils.SendMail(dr["Email"].ToString(), dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), "New products in region notification", message, false);
}
}
}
}
}
}
#endregion
// ds contains all content
using (DataSet ds = dbObj.RunSPReturnDataSet("dbo._Item_GetAllContent", "Content",
new SqlParameter("@ItemId", curItem.Id),
new SqlParameter("@CultureCode", culture.Code),
new SqlParameter("@InputFormId", inputFormId),
new SqlParameter("@WithChildren", cbWithChildren.Checked),
new SqlParameter("@MoveStatus", 1)))
{
dbObj.CloseConnection();
if (dbObj.LastError.Length > 0)
{
lbError.CssClass = "hc_error";
lbError.Text = HyperCatalog.Business.Item.LastError;
lbError.Visible = true;
}
else
{
#region "Force translation to draft"
if (cbForceTranslation.Checked && ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string containerList = string.Empty;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["ContainerId"] != null)
{
if (containerList.Length > 0)
{
containerList += ",";
}
containerList += dr["ContainerId"].ToString();
}
}
if (containerList.Length > 0)
{
if (!curItem.ForceTranslationsToDraft(culture.Code, containerList, user.Id))
{
lbError.CssClass = "hc_error";
lbError.Text = HyperCatalog.Business.Item.LastError;
lbError.Visible = true;
return;
}
}
}
#endregion
#region "Generate report"
if (cbReport.Checked && ds != null)
{
// Create report
GenerateReport(ds, curItem.Id);
// Refresh frame content and close window
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "closePopup", "<script>window.close();</script>");
}
}
#endregion
}
SessionState.CurrentItem = null;
// Refresh frame content and close window
if (SessionState.CurrentItem != null && SessionState.User.LastVisitedItem != SessionState.CurrentItem.Id)
{
SessionState.User.LastVisitedItem = curItem.Id;
SessionState.User.QuickSave();
}
if (SessionState.QDEChunk != null)
{
SessionState.QDEChunk.Dispose();
}
if (SessionState.QDEContainer != null)
{
SessionState.QDEContainer.Dispose();
}
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "updateGrid", "<script>UpdateAndClose(1, " + inputFormId.ToString() + ");</script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MissingStatus", "<script>alert('Select the status (Draft or Final)');</script>");
}
}
}
//private int timeout = MIN_TIMEOUT;
protected void Page_Load(object sender, EventArgs e)
{
string reportId, reportName;
//BossLink.NavigateUrl = string.Empty;
//AccessLink.ForeColor = System.Drawing.Color.Blue;
reportId = Request.QueryString["reportId"];
reportName = Request.QueryString["reportName"];
DataSet ds = new DataSet();
dbObj = Utils.GetMainDB();
dbObj.OpenConnection();
dbQuery = dbObj.CreateSPQuery("Report_GetBossReports", new SqlParameter("@ReportName", reportName));
ds = dbQuery.RunAndReturnDataSet();
dbObj.CloseConnection();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string tablestring = "";
string header = "";
string _sCompany = "";
//Commeneted by Vidya 21/03/2016
//int hpiReport = 0;
//End
int hpeReport = 0;
tablestring = tablestring + "<table>";
_sCompany = ApplicationSettings.Parameters["BossReports"].Value.ToString();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["BossDescription"].ToString().Contains(_sCompany))
{
string strUrl = (string)HyperCatalog.Shared.SessionState.CacheParams["Boss_Link_HPI"].Value;
strUrl = strUrl + "&iDocID=" + dr["BossId"].ToString() + "&sDoc=" + dr["BossDescription"].ToString() + "&sType=wid&sRefresh=Y";
header = "<tr><th style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'>HPI Reports</tr></th>";
//Commeneted by Vidya 21/03/2016
//if (hpiReport ==0)
//tablestring = tablestring + header + "<tr><td style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'><a href=" + strUrl + " target='_blank'>" + dr["BossDescription"].ToString() + "</a></td></tr>";
//else
//tablestring = tablestring + "<tr><td style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'><a href=" + strUrl + " target='_blank'>" + dr["BossDescription"].ToString() + "</a></td></tr>";
//hpiReport = hpiReport + 1;
}
else
{
string strUrl = (string)HyperCatalog.Shared.SessionState.CacheParams["BOSS_Link"].Value;
strUrl = strUrl + "&iDocID=" + dr["BossId"].ToString() + "&sDoc=" + dr["BossDescription"].ToString() + "&sType=wid&sRefresh=Y";
header = "<tr><th style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'>HPE Reports</tr></th>";
if (hpeReport == 0)
{
tablestring = tablestring + header + "<tr><td style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'><a href=" + strUrl + " target='_blank'>" + dr["BossDescription"].ToString() + "</a></td></tr>";
}
else
{
tablestring = tablestring + "<tr><td style='font-size:80%';height='20%'; Font-Names:'Arial'; Font-Size:'Small'><a href=" + strUrl + " target='_blank'>" + dr["BossDescription"].ToString() + "</a></td></tr>";
}
hpeReport = hpeReport + 1;
}
}
tablestring = tablestring + "</table>";
divTable.InnerHtml = tablestring;
}
//BossLink.NavigateUrl = (strihow ng)HyperCatalog.Shared.SessionState.CacheParams["BOSS_Link"].Value;
//BossLink.NavigateUrl = "http://bosspro-ci.atlanta.hp.com/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID";
//BossLink.NavigateUrl = BossLink.NavigateUrl + "&reportId=" + reportId + "&reportName=" + reportName + "&sType=wid&sRefresh=Y";
}