private async void TestUpdate()
{
ProgramDetails updateProgramDetails = listProgramDetails[0];
updateProgramDetails.LessonTheme = "Быть или не быть";
courseStorage.ProgramDetailsAddOrUpdate(updateProgramDetails);
ProgramDetails actualCours1 = await courseStorage.ProgramDetailsGetById((int)updateProgramDetails.Id);
Assert.AreEqual(updateProgramDetails, actualCours1);
ProgramDetails updateCourse1 = await courseStorage.ProgramDetailsGetById((int)listProgramDetails[1].Id);;
Assert.AreEqual(listProgramDetails[1], updateCourse1);
}
public async Task <ActionResult <int> > InsertNewProgramDetails([FromBody] ProgramDetails programDetails)
{
if (programDetails == null)
{
return(BadRequest("Model is empty"));
}
var result = await courseStorage.ProgramDetailsAddOrUpdate(programDetails);
if (result.Equals(null))
{
return(NotFound());
}
return(Ok(result));
}
// GET: ProgramDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProgramDetails programDetails = db.Programs.Find(id);
if (programDetails == null)
{
return(HttpNotFound());
}
return(View(programDetails));
}
public ProgramDetails getCurrentProgDetail()
{
ProgramDetails packs = new ProgramDetails();
using (incposdbEntities entity = new incposdbEntities())
{
packs = entity.ProgramDetails.ToList().FirstOrDefault();
// join p in entity.posSetting on S.id equals p.posSerialId
}
return(packs);
}
public async Task <int> ProgramDetailsAddOrUpdate(ProgramDetails programDetails)
{
try
{
if (programDetails.Id.HasValue)
{
var result = await connection.QueryAsync <decimal>(
SpName.ProgramDetailsUpdate,
new
{
programDetails.Id,
programDetails.CourseProgram,
programDetails.LessonNumber,
programDetails.LessonTheme
},
dbTransaction,
commandType : CommandType.StoredProcedure
);
return(decimal.ToInt32(result.FirstOrDefault()));
}
else
{
var result = await connection.QueryAsync <decimal>(
SpName.ProgramDetailsInsert,
new
{
programDetails.CourseProgram,
programDetails.LessonNumber,
programDetails.LessonTheme
},
dbTransaction,
commandType : CommandType.StoredProcedure
);
return(decimal.ToInt32(result.FirstOrDefault()));
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
public async Task <ProgramDetails> PublishAsync(ProgramDetails program, Package package)
{
Ensure.NotNull(program, nameof(program));
Ensure.NotNull(package, nameof(package));
using (var stream = new MemoryStream())
{
await package.ToZipStreamAsync(stream, leaveStreamOpen : true);
stream.Position = 0;
return(await api.PutStreamAsync <ProgramDetails>(
path : $"/programs/{program.Id}@{program.Version}",
contentType : "application/zip",
stream : stream,
properties : JsonObject.FromObject(program)
));
}
}
private Process GetProcessIfRunning(int SessionId, ProgramDetails pd, Process[] processes)
{
for (int i = 0; i < processes.Length; i++)
{
if (processes[i].SessionId != SessionId)
{
continue;
}
String name = processes[i].ProcessName;
// Console.WriteLine("Found a process: {0}", name);
if (name.ToLower().Equals(pd.ProcessName.ToLower()))
{
//LogMessage(String.Format("Hooray! {0} is running...", pd.ProcessName));
return(processes[i]);
}
}
return(null);
}
/*
*
* Instantiate the Program Details UI when the user clicks a list item
*
*/
public void OnPointerClick(PointerEventData Data)
{
Debug.Log("Showing Program Details");
// Instantiating the Details UI and setting the "Canvas" GameObject as it parent
GameObject program_details = GameObject.Instantiate(Resources.Load("program_details")) as GameObject;
program_details.transform.SetParent(GameLogic.Instance.canvas);
// Fixing the UI Scale and Position
RectTransform rt = program_details.GetComponent <RectTransform> ();
rt.offsetMax = Vector2.zero;
rt.offsetMin = Vector2.zero;
rt.localScale = Vector3.one;
// Passing the program values to show to the UI GameObject Script
ProgramDetails detailsScr = program_details.GetComponent <ProgramDetails> ();
detailsScr.program = program;
detailsScr.SetDetails();
}
public List <ProgramDetails> Details(int ProgramID)
{
List <ProgramDetails> List = new List <ProgramDetails>();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MUSIC_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[usr].[uspSearchProgramDetails]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter ParPID = new SqlParameter
{
ParameterName = "@ProgramID",
SqlDbType = SqlDbType.Int,
Value = ProgramID
};
SqlCmd.Parameters.Add(ParPID);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var Song = new ProgramDetails
{
SPID = Convert.ToInt32(dr["SPID"]),
ProgramID = Convert.ToInt32(dr["ProgramID"]),
SongID = Convert.ToInt32(dr["SongID"]),
AuthorID = Convert.ToInt32(dr["AuthorID"]),
ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"])
};
List.Add(Song);
}
}
foreach (var u in List)
{
SqlCmd = new SqlCommand("[usr].[uspSearchSong]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlCmd.Parameters.AddWithValue("@SongID", u.SongID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
u.SongsData.SongID = Convert.ToInt32(dr["SongID"]);
u.SongsData.SongName = dr["SongName"].ToString();
}
}
SqlCmd = new SqlCommand("[usr].[uspSearchAuthor]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlCmd.Parameters.AddWithValue("@AuthorID", u.AuthorID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
u.AuthorsData.AuthorID = Convert.ToInt32(dr["AuthorID"]);
u.AuthorsData.AuthorName = dr["AuthorName"].ToString();
}
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(List);
}
public bool AddSong(ProgramDetails pd, string insertuser)
{
return(PDDAL.AddSong(pd, insertuser));
}
/// <summary>
/// Parses the input file and initializes the necessary variables (watchdog.txt)
/// </summary>
/// <param name="inputFile"></param>
private void ReadInputFile(string inputFile)
{
using (StreamReader sr = new StreamReader(inputFile))
{
string line;
while ((line = sr.ReadLine()) != null)
{
try
{
//ignore lines starting with a hash (comments) and empty lines
if (line.StartsWith("#") || string.IsNullOrWhiteSpace(line))
continue;
if (line.StartsWith("MessageUploadUrl:", StringComparison.CurrentCultureIgnoreCase))
{
string[] words = line.Split(' ');
messageUploadUrl = words[1];
}
ProgramDetails pd = new ProgramDetails();
string[] data = line.Split(';');
if (data.Length > 1)
{
pd.ProcessName = data[0];
pd.ExeDir = inputDir + "\\" + data[1];
pd.ExeName = data[2];
pd.nSecondsRunDelay = Convert.ToInt32(data[3]);
pd.UpdateUri = data[4];
// add in args if any
if (data.Length > 5)
pd.Args = data[5];
pd.fRunningAtLastCheck = false;
pd.dtLastRun = DateTime.Now.AddHours(-1.0);
pd.lastUpdateCheck = DateTime.Now.AddHours(-1.0);
aPrograms.Add(pd);
}
}
catch (Exception e)
{
LogMessage(e.ToString(), true);
}
}
}
}
private void KillProcess(ProgramDetails pd)
{
Process ThisProcess = Process.GetCurrentProcess();
Process[] processes = System.Diagnostics.Process.GetProcesses();
// Is it running right now?
Process process = GetProcessIfRunning(ThisProcess.SessionId, pd, processes);
if (process != null)
{
//todo: need a way to gracefully shut down the process
//bool result = process.CloseMainWindow();
//LogInfo(String.Format("Result of CloseMainWindow on {0} is {1}", pd.ProcessName, result));
process.Kill();
process.Close();
}
else
{
LogMessage(String.Format("Tried to kill {0} but it is not running", pd.ProcessName));
}
}
private Process GetProcessIfRunning(int SessionId, ProgramDetails pd, Process[] processes)
{
for (int i = 0; i < processes.Length; i++)
{
if (processes[i].SessionId != SessionId)
continue;
String name = processes[i].ProcessName;
// Console.WriteLine("Found a process: {0}", name);
if (name.ToLower().Equals(pd.ProcessName.ToLower()))
{
//LogMessage(String.Format("Hooray! {0} is running...", pd.ProcessName));
return processes[i];
}
}
return null;
}
public override bool UpdateProgram(ProgramDetails program)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("wa_Programs_UpdateProgram", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProgramID", SqlDbType.Int).Value = program.ProgramID;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = program.Title;
cmd.Parameters.Add("@Abstract", SqlDbType.NVarChar).Value = program.Abstract;
cmd.Parameters.Add("@Body", SqlDbType.NText).Value = program.Body;
cmd.Parameters.Add("@Requirements", SqlDbType.NVarChar).Value = program.Requirements;
cmd.Parameters.Add("@EnableComments", SqlDbType.Bit).Value = program.EnableComments;
cmd.Parameters.Add("@OnlyForMembers", SqlDbType.Bit).Value = program.OnlyForMembers;
cmd.Parameters.Add("@OnlyForAdmins", SqlDbType.Bit).Value = program.OnlyForAdmins;
cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = program.CategoryID;
cmd.Parameters.Add("@ProgramUrl", SqlDbType.NVarChar).Value = program.ProgramUrl;
cmd.Parameters.Add("@ProgramImageUrl", SqlDbType.NVarChar).Value = program.ProgramImageUrl;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = program.CreatedBy;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = program.CreatedDate;
cmd.Parameters.Add("@BannerUrl", SqlDbType.NVarChar).Value = program.BannerUrl;
cmd.Parameters.AddWithValue(@"SizeMB", program.SizeMB);
cn.Open();
int ret = ExecuteNonQuery(cmd);
return (ret == 1);
}
}
public async Task <string> getRemainDayes(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
try
{
ProgramDetails packrow = new ProgramDetails();
packrow = getCurrentProgDetail();
daysremain daysModel = new daysremain();
int days = 0;
if (packrow.expireDate == null)
{
daysModel.expirestate = "n";
daysModel.days = 0;
return(TokenManager.GenerateToken(daysModel));//not regester =>no alert
}
DateTime expiredate = (DateTime)packrow.expireDate;
DateTime nowdate = DateTime.Now;
TimeSpan diffdate = expiredate - nowdate;
days = diffdate.Days;
// diffdate.Hours;
if (packrow.isLimitDate == false)
{
daysModel.expirestate = "u";
daysModel.days = 0;
return(TokenManager.GenerateToken(daysModel));//unlimited=> no alert
}
else
{
// daysModel.hours = diffdate.Hours;
daysModel.expirestate = "e";
daysModel.days = days;
if (days == 0)
{
daysModel.hours = diffdate.Hours;
if (daysModel.hours == 0)
{
daysModel.minute = diffdate.Minutes;
}
// daysModel.hours = diffdate.Hours;
}
//if (days > 10 )
// {
// return TokenManager.GenerateToken("-2");// no alert
// //return TokenManager.GenerateToken(days.ToString());// no alert
// }
// else
// {
return(TokenManager.GenerateToken(daysModel));//show alert with days
//}
}
}
catch (Exception ex)
{
// return TokenManager.GenerateToken("0");
return(TokenManager.GenerateToken(ex.ToString()));
}
}
}
public async void UserControl_Loaded(object sender, RoutedEventArgs e)
{//load
try
{
SectionData.StartAwait(grid_main);
#region translate
if (MainWindow.lang.Equals("en"))
{
MainWindow.resourcemanager = new ResourceManager("POS.en_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.LeftToRight;
//dpnl_branch.FlowDirection = FlowDirection.LeftToRight;
//dpnl_store.FlowDirection = FlowDirection.LeftToRight;
//dpnl_user.FlowDirection = FlowDirection.LeftToRight;
//dpnl_vendor.FlowDirection = FlowDirection.LeftToRight;
//dpnl_item.FlowDirection = FlowDirection.LeftToRight;
//dpnl_salesInv.FlowDirection = FlowDirection.LeftToRight;
//dpnl_customer.FlowDirection = FlowDirection.LeftToRight;
//dpnl_pos.FlowDirection = FlowDirection.LeftToRight;
}
else
{
MainWindow.resourcemanager = new ResourceManager("POS.ar_file", Assembly.GetExecutingAssembly());
grid_main.FlowDirection = FlowDirection.RightToLeft;
//dpnl_branch.FlowDirection = FlowDirection.RightToLeft;
//dpnl_store.FlowDirection = FlowDirection.RightToLeft;
//dpnl_user.FlowDirection = FlowDirection.RightToLeft;
//dpnl_vendor.FlowDirection = FlowDirection.RightToLeft;
//dpnl_item.FlowDirection = FlowDirection.RightToLeft;
//dpnl_salesInv.FlowDirection = FlowDirection.RightToLeft;
//dpnl_customer.FlowDirection = FlowDirection.RightToLeft;
//dpnl_pos.FlowDirection = FlowDirection.RightToLeft;
}
translate();
#endregion
progDetails = await progDetailsModel.getCurrentInfo();
#region unlimited
if (progDetails.branchCount == -1)
{
dpnl_branch.Visibility = Visibility.Collapsed; txt_branchUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_branch.Visibility = Visibility.Visible; txt_branchUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.storeCount == -1)
{
dpnl_store.Visibility = Visibility.Collapsed; txt_storeUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_store.Visibility = Visibility.Visible; txt_storeUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.vendorCount == -1)
{
dpnl_vendor.Visibility = Visibility.Collapsed; txt_vendorUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_vendor.Visibility = Visibility.Visible; txt_vendorUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.userCount == -1)
{
dpnl_user.Visibility = Visibility.Collapsed; txt_userUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_user.Visibility = Visibility.Visible; txt_userUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.customerCount == -1)
{
dpnl_customer.Visibility = Visibility.Collapsed; txt_customerUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_customer.Visibility = Visibility.Visible; txt_customerUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.posCount == -1)
{
dpnl_pos.Visibility = Visibility.Collapsed; txt_posUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_pos.Visibility = Visibility.Visible; txt_posUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.saleinvCount == -1)
{
dpnl_salesInv.Visibility = Visibility.Collapsed; txt_salesInvUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_salesInv.Visibility = Visibility.Visible; txt_salesInvUnlimited.Visibility = Visibility.Collapsed;
}
if (progDetails.itemCount == -1)
{
dpnl_item.Visibility = Visibility.Collapsed; txt_itemUnlimited.Visibility = Visibility.Visible;
}
else
{
dpnl_item.Visibility = Visibility.Visible; txt_itemUnlimited.Visibility = Visibility.Collapsed;
}
#endregion
if (SectionData.isSupportPermision())
{
col_upgrade.Width = col_extend.Width;
}
else
{
col_upgrade.Width = new GridLength(0);
}
this.DataContext = progDetails;
SectionData.EndAwait(grid_main);
}
catch (Exception ex)
{
SectionData.EndAwait(grid_main);
SectionData.ExceptionMessage(ex, this);
}
}
private async void Btn_upgrade_Click(object sender, RoutedEventArgs e)
{ //upgrade
int chk = 0;
string activationkey = progDetails.packageSaleCode; //get from info
if (progDetails.isOnlineServer.Value) //online
{
try
{
if (activationkey.Trim() != "".Trim())
{
AvtivateServer ac = new AvtivateServer();
chk = await ac.checkconn();
chk = await ac.StatSendserverkey(activationkey, "up");
// //change chk = 3;
//nochange chk = 2;
if (chk <= 0)
{
string message = "inc(" + chk + ")";
string messagecode = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(message));
string msg = MainWindow.resourcemanager.GetString("trUpgradeNotCompleted") + "(" +
MainWindow.resourcemanager.GetString("trErrorCode") + ":" + messagecode + ")";
Toaster.ShowWarning(Window.GetWindow(this), message: msg, animation: ToasterAnimation.FadeIn);
}
else
{
if (chk == 3)
{
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trUpgradeCompleted"), animation: ToasterAnimation.FadeIn);
progDetails = await progDetailsModel.getCurrentInfo();
this.DataContext = progDetails;
}
else if (chk == 2)
{
Toaster.ShowSuccess(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trNoChanges"), animation: ToasterAnimation.FadeIn);
}
}
}
}
catch (Exception ex)
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trServerNotFount"), animation: ToasterAnimation.FadeIn);
}
}
else//offline
{
// start activate
chk = 0;
string message = "";
try
{
bool isServerActivated = true;
AvtivateServer ac = new AvtivateServer();
string activeState = "up";
int activematch = 0;
string filepath = "";
openFileDialog.Filter = "INC|*.ac; ";
SendDetail customerdata = new SendDetail();
SendDetail dc = new SendDetail();
if (openFileDialog.ShowDialog() == true)
{
filepath = openFileDialog.FileName;
// bool resr = ReportCls.decodefile(filepath, @"D:\stringlist.txt");//comment
string objectstr = "";
objectstr = ReportCls.decodetoString(filepath);
dc = JsonConvert.DeserializeObject <SendDetail>(objectstr, new JsonSerializerSettings {
DateParseHandling = DateParseHandling.None
});
packagesSend pss = new packagesSend();
pss = dc.packageSend;
isServerActivated = dc.packageSend.isServerActivated;
pss.activeApp = "-";
dc.packageSend = pss;
// string activeState = "";
if (dc.packageSend.activeState == activeState)
{
activematch = 1;
customerdata = await ac.OfflineActivate(dc, activeState);
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: "The file isn't upgrade file", animation: ToasterAnimation.FadeIn);
}
}
// upload
if (activematch == 1)
{
if (customerdata.packageSend.result > 0)
{
// if first activate OR upgrade show save dialoge to save customer data in file
saveFileDialog.Filter = "File|*.ac;";
if (saveFileDialog.ShowDialog() == true)
{
string DestPath = saveFileDialog.FileName;
string myContent = JsonConvert.SerializeObject(customerdata);
bool res = false;
res = ReportCls.encodestring(myContent, DestPath);
if (res)
{
// //done
// MessageBox.Show("Success");
Toaster.ShowSuccess(Window.GetWindow(this), message: "Success", animation: ToasterAnimation.FadeIn);
}
else
{
Toaster.ShowWarning(Window.GetWindow(this), message: "Error", animation: ToasterAnimation.FadeIn);
// MessageBox.Show("Error");
}
}
}
else
{
// MessageBox.Show(customerdata.packageSend.result.ToString());
string msg = "NOT complete - " + customerdata.packageSend.result.ToString();
Toaster.ShowWarning(Window.GetWindow(this), msg, animation: ToasterAnimation.FadeIn);
}
}
else
{
//close
}
//end uploaa
}
catch (Exception ex)
{
Toaster.ShowWarning(Window.GetWindow(this), message: "The server Not Found", animation: ToasterAnimation.FadeIn);
}
//end activate
}
}
