private void CreateReportandSaveToDB(string schoolYear, string schoolCode, string publishCycle, string GoalType, string schoolName, string schoolNameB)
{
string reportName = WebConfig.getValuebyKey("PublishDocumentName");
string userID = WorkingProfile.UserID;
string publishDate = DateFC.YMD(DateTime.Now);
Byte[] pdfReport = ReportRender.GetOneReport(reportName, userID, schoolYear, schoolCode, "1");
string result = PushToSP.PublishPLFtoSharePointSite("SLIP", pdfReport, schoolYear, schoolCode, schoolName, schoolNameB);
// UploadFileToSharePointSite.PushToSite("SLIP", pdfReport, schoolYear, schoolCode, schoolName, schoolNameB);
if (result == "Successful")
{
string action = btnReturn.Text;
string signOffResult = SignOff.Signature2(action, userID, schoolYear, schoolCode, "Publish", publishDate);
// SaveSLIPPublishDataToHistoryDirectory(schoolCode + ".PDF", pdfReport);
errorlabel.Text = "The School PLF has been published to School Web site.";
errorlabel.ForeColor = Color.Red;
// PushToSP.SaveFileToHistoryFolder(WorkingProfile.SchoolYear, schoolCode + ".PDF", pdfReport);
}
else
{
errorlabel.Text = "The School PLF published failed to School Web site.";
}
}
private void Assemblies_Title()
{
string userID = User.Identity.Name;
LabelSchoolyear.Text = DateFC.SchoolYearFrom("-", WorkingProfile.SchoolYear);
LabelSchool.Text = WorkingProfile.SchoolName;
LabelPrincipal.Text = WorkingProfile.SchoolPrincipal;
LabelSuperintendent.Text = WorkingProfile.UserArea;
hfSchoolcode.Value = WorkingProfile.SchoolCode;
hfSchoolyear.Value = WorkingProfile.SchoolYear;
hfUserRole.Value = WorkingProfile.UserRole;
hfUserID.Value = User.Identity.Name;
hfSignOff.Value = SignOff.Signature("Result", userID, WorkingProfile.UserRole, WorkingProfile.SchoolYear, WorkingProfile.SchoolCode, "School");
hfSignOffSO.Value = SignOff.Signature("Result", userID, WorkingProfile.UserRole, WorkingProfile.SchoolYear, WorkingProfile.SchoolCode, "SO");
hfPublish.Value = SignOff.Signature("Result", userID, WorkingProfile.UserRole, WorkingProfile.SchoolYear, WorkingProfile.SchoolCode, "Publish");
try
{
foreach (Control pControl in FormContent.Controls)
{
if (pControl is Label)
{
string code = pControl.ID.Replace("Label", "");
Label lbl = (Label)pControl;
lbl.Text = FormData.Title(code);
}
}
}
catch (Exception ex)
{
var ms = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// btnReturn.Visible = false;
string userID = User.Identity.Name;
string schoolyear = Page.Request.QueryString["yID"];
string schoolcode = Page.Request.QueryString["sID"];
string signType = Page.Request.QueryString["tID"];
string signOffResult = SignOff.Signature2("Result", userID, schoolyear, schoolcode, signType);
string actionName = "Sign Off";
if (signOffResult == "SignedOff")
{
actionName = "Undo SignOff";
}
btnReturn.Text = actionName;
string signOffName = "School Principal";
if (signType != "School")
{
signOffName = "Superintendent";
}
if (WorkingProfile.UserRole == "Superintendent")
{
signOffName = "Superintendent";
signType = "SO";
}
LabelSignOffTitle.Text = signOffName + " " + actionName;
txtUserName.Text = User.Identity.Name;
txtUserName.Enabled = false;
// btnReturn.Attributes.Add("OnClick", "javascript:ReturnVerify()");
SignOffDateDiv.Visible = false;
}
}
protected void btnReturn_Click(object sender, EventArgs e)
{
string userID = User.Identity.Name;
string schoolyear = Page.Request.QueryString["yID"];
string schoolcode = Page.Request.QueryString["sID"];
string signType = Page.Request.QueryString["tID"];
string action = btnReturn.Text;
string vDate = DateFC.YMD(DateTime.Now);
string signOffResult = SignOff.Signature2(action, userID, schoolyear, schoolcode, "Publish", vDate);
CreateReportandSaveToDB(schoolyear, schoolcode, "1", "All", WorkingProfile.SchoolName, WorkingProfile.SchoolNameB);
}
private void Assemblies_Title()
{
string userID = User.Identity.Name;
LabelSchoolyear.Text = DateFC.SchoolYearFrom("-", schoolYear);
LabelSchool.Text = WorkingProfile.SchoolName;
LabelPrincipal.Text = WorkingProfile.SchoolPrincipal;
LabelSuperintendent.Text = WorkingProfile.UserAreaSuperintendent;
hfSchoolcode.Value = schoolCode;
hfSchoolyear.Value = schoolYear;
hfUserRole.Value = WorkingProfile.UserRole;
hfUserID.Value = User.Identity.Name;
hfSignOff.Value = SignOff.Signature("Result", userID, "", schoolYear, schoolCode, "School");
hfSignOffSO.Value = SignOff.Signature("Result", userID, "", schoolYear, schoolCode, "SO");
hfPublish.Value = SignOff.Signature("Result", userID, "", schoolYear, schoolCode, "Publish");
hfComplete.Value = SignOff.Signature("Result", userID, "", schoolYear, schoolCode, "Complete");
}
internal static Message Read(Trx.Messaging.Iso8583.Iso8583Message isoMessage, out bool isSignOn)
{
Message result = null;
isSignOn = false;
ISO8583DataExtractor message = new ISO8583DataExtractor(isoMessage);
if (isoMessage.IsNetworkManagement())
{
if (isoMessage.Fields.Contains(FieldNos.F70_NetworkMgtInfoCode))
{
switch (isoMessage.Fields[FieldNos.F70_NetworkMgtInfoCode].Value.ToString())
{
//Sign On
case "001":
result = new SignOn(message);
isSignOn = true;
break;
//Sign Off
case "002":
result = new SignOff(message);
break;
//Echo
case "301":
result = new Echo(message);
isSignOn = true;
break;
default:
result = new Echo(message);
break;
}
}
}
else
{
result = new Echo(message);
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
// LabelTitle.Text = "PLF Publish Verify";
// btnReturn.Visible = false;
string actionName = "Publish";
string userID = User.Identity.Name;
string schoolyear = Page.Request.QueryString["yID"];
string schoolcode = Page.Request.QueryString["sID"];
string signType = Page.Request.QueryString["tID"];
string signOffResult = SignOff.Signature2("Result", userID, schoolyear, schoolcode, "SO");
txtUserName.Text = User.Identity.Name;
txtUserName.Enabled = false;
if (signOffResult != "SignedOff")
{
// btnReturn.Enabled = false;
errorlabel.Visible = true;
errorlabel.ForeColor = Color.Red;
errorlabel.Text = "Superintendent has to signed off first before you can publish the your school PLF.";
}
btnReturn.Text = actionName;
// string signOffName = "School Principal";
// LabelTitle.Text = signOffName + " " + actionName;
// btnReturn.Attributes.Add("OnClick", "javascript:ReturnVerify()");
SignOffDateDiv.Visible = false;
}
catch (Exception exp)
{
var sm = exp.Message;
}
}
}
protected void btnReturn_Click(object sender, EventArgs e)
{
try
{
string userID = User.Identity.Name;
string schoolyear = Page.Request.QueryString["yID"];
string schoolcode = Page.Request.QueryString["sID"];
string signType = Page.Request.QueryString["tID"];
if (WorkingProfile.UserRole == "Superintendent")
{
signType = "SO";
}
string action = btnReturn.Text;
DateTime cDate = DateTime.Now;
string vDate = DateFC.YMD(cDate);
string signOffResult = SignOff.Signature2("SignOff", userID, schoolyear, schoolcode, signType, vDate);
}
catch (Exception exp)
{
var em = exp.Message;
}
}
protected virtual void OnSignOff(TModel msg, object sender = null)
{
SignOff?.Invoke(sender ?? this, msg);
}
public ActionResult Create([Bind(Include = "ID,UserID,AuthorName,Title,Description,_Date,Open,GoLiveDate,SummaryDone,ServSpecDone,EOCDone,AppSupportDone,ChangeManDone,GISDone,NEDone,SCVDone,SREDone,DBADone,QADone,IAMDone,PBXDone,ITCSDone,SMODone,RisksDone,SignOffDone")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
project.Open = true;
var user = User.Identity.GetUserName();
if (user == "")
{
user = "******";
}
project.UserID = user;
project.AuthorName = user;
db.SaveChanges();
// when a new project is created, create all corresponding entities
AppsSupportReqs appsSupportReqs = new AppsSupportReqs();
appsSupportReqs.ProjectID = project.ID;
appsSupportReqs.ID = project.ID;
db.AppsSupportReqs.Add(appsSupportReqs);
ChangeManagementReqs changeManagementReqs = new ChangeManagementReqs();
changeManagementReqs.ProjectID = project.ID;
changeManagementReqs.ID = project.ID;
db.ChangeManagementReqs.Add(changeManagementReqs);
DBAReqs dbaReqs = new DBAReqs();
dbaReqs.ProjectID = project.ID;
dbaReqs.ID = project.ID;
db.DBAReqs.Add(dbaReqs);
EOCReqs eocReqs = new EOCReqs();
eocReqs.ProjectID = project.ID;
eocReqs.ID = project.ID;
db.EOCReqs.Add(eocReqs);
GISReqs gisReqs = new GISReqs();
gisReqs.ProjectID = project.ID;
gisReqs.ID = project.ID;
db.GISReqs.Add(gisReqs);
IAMReqs iamReqs = new IAMReqs();
iamReqs.ProjectID = project.ID;
iamReqs.ID = project.ID;
db.IAMReqs.Add(iamReqs);
ITCS itcs = new ITCS();
itcs.ProjectID = project.ID;
itcs.ID = project.ID;
db.ITCS.Add(itcs);
NEReqs neReqs = new NEReqs();
neReqs.ProjectID = project.ID;
neReqs.ID = project.ID;
db.NEReqs.Add(neReqs);
PBX pbx = new PBX();
pbx.ProjectID = project.ID;
pbx.ID = project.ID;
db.PBX.Add(pbx);
QAReqs qaReqs = new QAReqs();
qaReqs.ProjectID = project.ID;
qaReqs.ID = project.ID;
db.QAReqs.Add(qaReqs);
Risks risks = new Risks();
risks.ProjectID = project.ID;
risks.RisksWarrantyDate = project.GoLiveDate;
risks.RisksPreDate = project.GoLiveDate;
risks.ID = project.ID;
db.Risks.Add(risks);
SCVReqs scvReqs = new SCVReqs();
scvReqs.ProjectID = project.ID;
scvReqs.ID = project.ID;
db.SCVReqs.Add(scvReqs);
ServiceSpecifics serviceSpecifics = new ServiceSpecifics();
serviceSpecifics.ProjectID = project.ID;
serviceSpecifics.ID = project.ID;
db.ServiceSpecifics.Add(serviceSpecifics);
SignOff signOff = new SignOff();
signOff.ProjectID = project.ID;
signOff.SignOffDate = project.GoLiveDate;
signOff.ID = project.ID;
db.SignOffs.Add(signOff);
SMOReqs smoReqs = new SMOReqs();
smoReqs.ProjectID = project.ID;
smoReqs.ID = project.ID;
db.SMOReqs.Add(smoReqs);
SREReqs sreReqs = new SREReqs();
sreReqs.ProjectID = project.ID;
sreReqs.ID = project.ID;
db.SREReqs.Add(sreReqs);
Summary summary = new Summary();
summary.ProjectID = project.ID;
summary.ID = project.ID;
summary.GoLiveDate = project.GoLiveDate;
db.Summaries.Add(summary);
//generate history event recording project creation
Event newEvent = new Event();
newEvent.ProjectID = project.ID;
newEvent.EventBody = "New SORT Project \"" + project.Title + "\" with Number " + project.ID + " created by " + project.AuthorName;
newEvent.EventType = "New Project";
db.Events.Add(newEvent);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
