protected void bntApply_Click(object sender, EventArgs e)
{
int publicationID = Session["SelectedPublication"] != null?Globals.GetIDFromName("PublicationNameCache", (string)Session["SelectedPublication"]) : 0;
DateTime pubDate = Session["SelectedPubDate"] != null ? (DateTime)Session["SelectedPubDate"] : DateTime.MinValue;
int nEditionID = Globals.GetIDFromName("EditionNameCache", (string)Session["SelectedEdition"]);
int nSectionID = Globals.GetIDFromName("SectionNameCache", (string)Session["SelectedSection"]);
string errmsg = "";
CCDBaccess db = new CCDBaccess();
db.ApproveAll(publicationID, pubDate, nEditionID, nSectionID, (string)Session["Username"], txtComment.Text, (bool)Session["LogApprove"], out errmsg);
InjectScript.Text = "<script>RefreshParentPage()</" + "script>";
}
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.SelectedIndex = e.Item.ItemIndex;
if (e.CommandName == "Hold" || e.CommandName == "Go")
{
if ((bool)Session["MayRelease"] == false)
{
lblError.Text = "You do not have rights to hold/release products";
lblError.ForeColor = Color.OrangeRed;
return;
}
string Press = e.Item.Cells[PRESSRUN_FIELD_PRESS].Text;
int m = Press.IndexOf('(');
if (m != -1)
{
Press = Press.Substring(0, m);
}
Press = Press.Trim();
DateTime dt = String2PubDate(e.Item.Cells[PRESSRUN_FIELD_PUBDATE].Text);
string Publication = e.Item.Cells[PRESSRUN_FIELD_PUBLICATION].Text;
string Edition = e.Item.Cells[PRESSRUN_FIELD_EDITION].Text;
string Section = e.Item.Cells[PRESSRUN_FIELD_SECTION].Text;
CCDBaccess db = new CCDBaccess();
string errmsg = "";
if (e.CommandName == "Go")
{
if (db.ApproveAll(Globals.GetIDFromName("PublicationNameCache", Publication), dt, Globals.GetIDFromName("EditionNameCache", Edition), Globals.GetIDFromName("SectionNameCache", Section), (string)Session["Username"], "Bulk approval", true, out errmsg) == false)
{
lblError.Text = errmsg;
lblError.ForeColor = Color.Red;
}
else
{
DoDataBind();
}
}
else if (db.UnApproveAll(Globals.GetIDFromName("PublicationNameCache", Publication), dt, Globals.GetIDFromName("EditionNameCache", Edition), Globals.GetIDFromName("SectionNameCache", Section), (string)Session["Username"], "Bulk approval", true, out errmsg) == false)
{
lblError.Text = errmsg;
lblError.ForeColor = Color.Red;
}
else
{
DoDataBind();
}
}
else if (e.CommandName == "Retransmit")
{
int nNextIndex = 1;
string Press = Press = e.Item.Cells[nNextIndex++].Text;
int m = Press.IndexOf("(");
if (m != -1)
{
Press = Press.Substring(0, m).Trim();
}
nNextIndex += 1; // Skip state
DateTime dt = String2PubDate(e.Item.Cells[nNextIndex++].Text);
string Publication = e.Item.Cells[nNextIndex++].Text;
string Edition = e.Item.Cells[nNextIndex++].Text;
string Section = e.Item.Cells[nNextIndex++].Text;
nNextIndex++; // skip input
nNextIndex++; // skip approved
nNextIndex++; // skip output
string channeList = e.Item.Cells[nNextIndex++].Text;
string channelIDList = "";
string [] sch = channeList.Split(',');
foreach (string ch in sch)
{
int nch = Globals.GetIDFromName("ChannelNameCache", ch);
if (nch > 0)
{
if (channelIDList != "")
{
channelIDList += ",";
}
channelIDList += nch.ToString();
}
}
CCDBaccess db = new CCDBaccess();
string errmsg = "";
int nPublicationID = Globals.GetIDFromName("PublicationNameCache", Publication);
int nPressID = Globals.GetIDFromName("PressNameCache", Press);
int nProductionID = db.GetProductionID(ref nPressID, nPublicationID, dt, Globals.GetIDFromName("EditionNameCache", Edition), out errmsg);
/* if (db.RetransmitAll(Globals.GetIDFromName("PublicationNameCache",Publication),
* dt,
* Globals.GetIDFromName("EditionNameCache",Edition),
* Globals.GetIDFromName("SectionNameCache",Section), out errmsg) == false)
* {
* lblError.Text = errmsg;
* lblError.ForeColor = Color.Red;
* }
*/
prioString = "\"RetransmitChannels.aspx?MasterCopySeparationSet=0&Channels=" + channelIDList + "&ProductionID=" + nProductionID.ToString() + "&PublicationID=" + nPublicationID.ToString() + "\"";
Telerik.Web.UI.RadWindow mywindow = GetRadWindow("radWindowRetransmitChannels");
mywindow.NavigateUrl = "RetransmitChannels.aspx?Channels=" + channelIDList + "&ProductionID=" + nProductionID.ToString() + "&PublicationID=" + nPublicationID.ToString() + "&MasterCopySeparationSet=0";
mywindow.VisibleOnPageLoad = true;
DoDataBind();
}
else if (e.CommandName == "ChangeChannels")
{
if ((bool)Session["MayRelease"] == false)
{
lblError.Text = "You do not have rights to change channels";
lblError.ForeColor = Color.OrangeRed;
return;
}
int nNextIndex = 1;
string Press = e.Item.Cells[nNextIndex++].Text;
int m = Press.IndexOf("(");
if (m != -1)
{
Press = Press.Substring(0, m).Trim();
}
nNextIndex += 1; // Skip state
DateTime dt = String2PubDate(e.Item.Cells[nNextIndex++].Text);
string Publication = e.Item.Cells[nNextIndex++].Text;
string Edition = e.Item.Cells[nNextIndex++].Text;
string Section = e.Item.Cells[nNextIndex++].Text;
nNextIndex++; // skip input
nNextIndex++; // skip approved
nNextIndex++; // skip output
string channeList = e.Item.Cells[nNextIndex++].Text;
string channelIDList = "";
string [] sch = channeList.Split(',');
foreach (string ch in sch)
{
int nch = Globals.GetIDFromName("ChannelNameCache", ch);
if (nch > 0)
{
if (channelIDList != "")
{
channelIDList += ",";
}
channelIDList += nch.ToString();
}
}
//doPopupPrio = true;
CCDBaccess db = new CCDBaccess();
string errmsg = "";
int nPublicationID = Globals.GetIDFromName("PublicationNameCache", Publication);
int nPressID = Globals.GetIDFromName("PressNameCache", Press);
int nProductionID = db.GetProductionID(ref nPressID,
nPublicationID, dt, Globals.GetIDFromName("EditionNameCache", Edition), out errmsg);
prioString = "\"ChangeChannels.aspx?MasterCopySeparationSet=0&Channels=" + channelIDList + "&ProductionID=" + nProductionID.ToString() + "&PublicationID=" + nPublicationID.ToString() + "\"";
Telerik.Web.UI.RadWindow mywindow = GetRadWindow("radWindowChannels");
mywindow.NavigateUrl = "ChangeChannels.aspx?Channels=" + channelIDList + "&ProductionID=" + nProductionID.ToString() + "&PublicationID=" + nPublicationID.ToString() + "&MasterCopySeparationSet=0";
mywindow.VisibleOnPageLoad = true;
DoDataBind();
}
}