public NancyEngineFixture()
{
this.resolver = A.Fake<IRouteResolver>();
this.response = new Response();
this.route = new FakeRoute(response);
this.context = new NancyContext();
this.errorHandler = A.Fake<IErrorHandler>();
this.requestDispatcher = A.Fake<IRequestDispatcher>();
A.CallTo(() => this.requestDispatcher.Dispatch(A<NancyContext>._)).Invokes(x => this.context.Response = new Response());
A.CallTo(() => errorHandler.HandlesStatusCode(A<HttpStatusCode>.Ignored, A<NancyContext>.Ignored)).Returns(false);
contextFactory = A.Fake<INancyContextFactory>();
A.CallTo(() => contextFactory.Create()).Returns(context);
A.CallTo(() => resolver.Resolve(A<NancyContext>.Ignored)).Returns(new ResolveResult(route, DynamicDictionary.Empty, null, null, null));
var applicationPipelines = new Pipelines();
this.routeInvoker = A.Fake<IRouteInvoker>();
A.CallTo(() => this.routeInvoker.Invoke(A<Route>._, A<DynamicDictionary>._, A<NancyContext>._)).ReturnsLazily(arg =>
{
return (Response)((Route)arg.Arguments[0]).Action.Invoke((DynamicDictionary)arg.Arguments[1]);
});
this.engine =
new NancyEngine(this.requestDispatcher, contextFactory, new[] { this.errorHandler }, A.Fake<IRequestTracing>())
{
RequestPipelinesFactory = ctx => applicationPipelines
};
}
public override ODocument Response(Response response)
{
Dictionary<ORID, int> entries = new Dictionary<ORID, int>();
ODocument document = new ODocument();
if (response == null)
{
return document;
}
var reader = response.Reader;
if (response.Connection.ProtocolVersion > 26 && response.Connection.UseTokenBasedSession)
ReadToken(reader);
// (count:int)[(key:binary)(value:binary)]
var bytesLength = reader.ReadInt32EndianAware();
var count = reader.ReadInt32EndianAware();
for (int i = 0; i < count; i++)
{
// key
short clusterId = reader.ReadInt16EndianAware();
long clusterPosition = reader.ReadInt64EndianAware();
var rid = new ORID(clusterId, clusterPosition);
// value
var value = reader.ReadInt32EndianAware();
entries.Add(rid, value);
}
document.SetField<Dictionary<ORID, int>>("entries", entries);
return document;
}
private static void AddNegotiatedHeaders(Negotiator negotiator, Response response)
{
foreach (var header in negotiator.NegotiationContext.Headers)
{
response.Headers[header.Key] = header.Value;
}
}
public Response ActivateMeta(MetaSearchModel metaSearchModel)
{
var response = new Response { Success = true, Warning = false };
try
{
var deRowPost = new ET_DataExtensionRow
{
AuthStub = conexion.ETCliente,
DataExtensionName = "METASAPPBENEFICIOS",
};
deRowPost.ColumnValues.Add("ID", metaSearchModel.Id);
deRowPost.ColumnValues.Add("ACTIVED", "TRUE");
try
{
var postResponse = deRowPost.Patch();
response.Success = postResponse.Status;
response.Message = postResponse.Message;
response.Code = postResponse.Code;
}
catch (Exception exCreate)
{
response.Success = false;
response.Message = exCreate.Message;
}
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
public Response<List<PaidTimeOff>> ViewAllPtoRequests()
{
Response<List<PaidTimeOff>> response = new Response<List<PaidTimeOff>>();
List<PaidTimeOff> ptoList = _ptoRepo.ViewAllPtoRequests();
try
{
if (ptoList.Count > 0)
{
response.Data = ptoList;
response.Success = true;
}
else
{
response.Success = false;
response.Message = "There are no requests to display";
}
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
internal static Response FromFile(string path)
{
var result = new Response();
using (var reader = new StreamReader(path))
result.Content = reader.ReadToEnd();
return result;
}
public void ResponseMayHaveContentLength()
{
AppDelegate app = call =>
{
var response = new Response();
response.Headers.SetHeader("Content-Length", "12");
response.Write("Hello world.");
return response.EndAsync();
};
using (ServerFactory.Create(app, 8090, null))
{
var request = (HttpWebRequest)WebRequest.Create("http://localhost:8090/");
string text;
using (var response = request.GetResponse())
{
using (var stream = response.GetResponseStream())
{
using (var reader = new StreamReader(stream))
{
text = reader.ReadToEnd();
}
}
}
Assert.That(text, Is.EqualTo("Hello world."));
}
}
public Response<Order> DeleteOrder(OrderRequest request)
{
var response = new Response<Order>();
var orderRepo = new OrderRepository();
var listAll = orderRepo.ListAll(request.OrderDate);
try
{
if (listAll.Count > 0)
{
var orderInformation = listAll.First(x => x.OrderNumber == request.Order.OrderNumber);
response.Data = orderInformation;
orderRepo.RemoveOrder(request);
response.Success = true;
response.Message = "Order successfully deleted!";
}
else
{
response.Success = false;
response.Message = "There are no orders to delete for this date";
}
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
public IHttpActionResult PutResponse(int id, Response response)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != response.Id)
{
return BadRequest();
}
CITDataContext.Entry(response).State = EntityState.Modified;
try
{
CITDataContext.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ResponseExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public JsonFormatterExtensionsFixtures()
{
this.formatter = A.Fake<IResponseFormatter>();
A.CallTo(() => this.formatter.Serializers).Returns(new[] { new DefaultJsonSerializer() });
this.model = new Person { FirstName = "Andy", LastName = "Pike" };
this.response = this.formatter.AsJson(model);
}
public Response<Order> CreateOrder(OrderRequest orderToAddRequest)
{
var response = new Response<Order>();
try
{
var orders = _orderRepo.ListAll(orderToAddRequest.OrderDate);
if (orderToAddRequest.Order.OrderNumber == 0)
{
orderToAddRequest.Order.OrderNumber = GenerateOrderNumber(orders);
}
orderToAddRequest = GetTaxRate(orderToAddRequest);
orderToAddRequest = UpdateCosts(orderToAddRequest);
_orderRepo.Add(orderToAddRequest);
response.Success = true;
response.Data = orderToAddRequest.Order;
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
public Response<Player> CreatePlayer(Player player)
{
var response = new Response<Player>();
var players = _repo.GetAllPlayersByTeam(player.TeamID);
try
{
foreach (var p in players)
{
if (player.PlayerName == p.PlayerName)
{
response.Success = false;
response.Message = "That player already exists!";
return response;
}
}
_repo.CreatePlayer(player);
response.Success = true;
response.Message = "Successfully created player";
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
public IHttpActionResult Get(int CurrentPage)
{
//申明参数
int _pageSize = 10;
try
{
PageInfo pageInfo = new PageInfo()
{
PageIndex = CurrentPage,
PageSize = _pageSize,
OrderField = "POSTID",
Order = OrderEnum.asc
};
var list = bll.GetList(pageInfo);
Response<IEnumerable<V_tm_pm_post>> response = new Response<IEnumerable<V_tm_pm_post>>
{
Data = list,
PagesCount = pageInfo.Total / _pageSize
};
return Ok(response);
}
catch (Exception ex)
{
LogHelper.WriteInfo(ex.ToString());
return BadRequest("异常");
}
}
private static Response Execute(String args)
{
using (var process = new Process())
{
process.StartInfo = new ProcessStartInfo()
{
RedirectStandardOutput = true,
RedirectStandardError = true,
UseShellExecute = false,
CreateNoWindow = true,
FileName = SvnAdminPath,
Arguments = args
};
process.Start();
var response = new Response()
{
StandardOutput = process.StandardOutput.ReadToEnd(),
StandardError = process.StandardError.ReadToEnd()
};
process.WaitForExit();
if (response.StandardError != "")
throw new Exception(response.StandardError);
return response;
}
}
public Response<TradePlayer>TradePlayer(TradePlayer trader)
{
Response<TradePlayer> response = new Response<TradePlayer>();
try
{
if (trader.Player1ID == trader.Player2ID)
{
response.Success = false;
response.Message = "You cannot trade the same player!";
}
else if (trader.Team1ID == trader.Team2ID)
{
response.Success = false;
response.Message = "you cannot trade to the same team!";
}
else
{
_repo.TradePlayer(trader);
response.Success = true;
response.Message = "Successfully traded players.";
}
}
catch(Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
protected void ValidateProductResponse(Response<Product> result)
{
Assert.IsNotNull(result, "Expected a result");
Assert.IsNotNull(result.StatusCode, "Expected a status code");
Assert.IsTrue(result.StatusCode.HasValue, "Expected a status code");
Assert.AreEqual(HttpStatusCode.OK, result.StatusCode.Value, "Expected a 200 response");
Assert.IsNotNull(result.Result, "Expected a result");
Assert.IsNull(result.Error, "Expected no error");
Assert.IsFalse(string.IsNullOrEmpty(result.Result.Id), "Expected Id to be populated");
Assert.IsFalse(string.IsNullOrEmpty(result.Result.Name), "Expected Name to be populated");
Assert.AreNotEqual(Category.Unknown, result.Result.Category, "Expected Category to be set");
if (result.Result.Category == Category.Album)
{
Assert.That(result.Result.Tracks.Count, Is.AtLeast(1));
foreach (var track in result.Result.Tracks)
{
Assert.IsFalse(string.IsNullOrEmpty(track.Id), "Expected trackId to be populated");
Assert.IsFalse(string.IsNullOrEmpty(track.Name), "Expected trackName to be populated");
Assert.AreNotEqual(Category.Unknown, track.Category, "Expected trackCategory to be set");
}
}
}
public void Should_set_properties_when_creating_oauth_exception()
{
var dummyResponse = new Response(HttpStatusCode.BadRequest,"Test Body");
var result = new OAuthException(dummyResponse);
Assert.That(result.ResponseBody, Is.EqualTo(dummyResponse.Body));
Assert.That(result.StatusCode, Is.EqualTo(dummyResponse.StatusCode));
}
public static FnApp App()
{
return (env, fault, result) => {
var request = new Request(env);
var response = new Response(result);
var wilson = "left - right\r\n123456789012\r\nhello world!\r\n";
var href = "?flip=left";
if (request.GET["flip"] == "left") {
wilson = wilson.Split(new[] {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)
.Select(line => new string(line.Reverse().ToArray()))
.Aggregate("", (agg, line) => agg + line + Environment.NewLine);
href = "?flip=right";
}
response.Write("<title>Hutchtastic</title>");
response.Write("<pre>");
response.Write(wilson);
response.Write("</pre>");
if (request.GET["flip"] == "crash") {
throw new ApplicationException("Wilson crashed!");
}
response.Write("<p><a href='" + href + "'>flip!</a></p>");
response.Write("<p><a href='?flip=crash'>crash!</a></p>");
response.Finish();
};
}
public override ODocument Response(Response response)
{
ODocument document = new ODocument();
if (response == null)
{
return document;
}
var reader = response.Reader;
if (response.Connection.ProtocolVersion > 26 && response.Connection.UseTokenBasedSession)
ReadToken(reader);
// operation specific fields
byte existByte = reader.ReadByte();
if (existByte == 0)
{
document.SetField("Exists", false);
}
else
{
document.SetField("Exists", true);
}
return document;
}
public void SendMessageAsyncSendsMessage()
{
var action = "DoSomething";
var request = new ServerRequest
{
ServerName = "TestServer"
};
var url = "http://somewhere/";
var factory = new TestClientFactory((u, a, d) =>
{
Assert.AreEqual(url + "server/TestServer/RawXmlMessage.aspx", u.AbsoluteUri);
Assert.AreEqual("POST", a);
Assert.AreEqual(action, d["action"]);
Assert.AreEqual(request.ToString(), d["message"]);
var theResponse = new Response
{
RequestIdentifier = request.Identifier
};
return Encoding.UTF8.GetBytes(theResponse.ToString());
});
var connection = new HttpConnection(new Uri(url), factory);
var completed = false;
connection.SendMessageCompleted += (o, e) =>
{
completed = true;
Assert.IsFalse(e.Cancelled);
Assert.IsNull(e.Error);
};
connection.SendMessageAsync(action, request);
Assert.IsTrue(completed);
}
public void OnResponse(Response response)
{
if (onResponse != null)
{
onResponse(response);
}
}
public void Can_I_Generate_Conference_With_Dial()
{
var response = new Response();
response.Dial(Dial.Create(PhoneNumberToDial).Conference("conference"));
Assert.True(IsValidInboundXML(response.CreateXml()));
}
/// <summary>
/// Tries to handle request.
/// </summary>
/// <param name="request">
/// The request.
/// </param>
/// <returns>
/// The WebServer.BusinessLogic.Response.
/// </returns>
public override Response Handle(Request request)
{
if (request.HttpPath.EndsWith("/"))
{
string path = Configurator.Instance.RelativeWwwPath + request.HttpPath.Replace("/", "\\");
if(!Directory.Exists(path))
{
return NextHandler.Handle(request);
}
DirectoryInfo directory = new DirectoryInfo(path);
List<FileSystemInfo> descendants = new List<FileSystemInfo>();
descendants.AddRange(directory.GetFileSystemInfos());
if (descendants.Select(desc => desc.Name).Contains("index.html"))
{
request.HttpPath += "index.html";
return NextHandler.Handle(request);
}
string webPage = this.CreateWebPage(descendants, request);
Response toReturn = new Response("text/html", request.HttpVersion, Encoding.UTF8.GetBytes(webPage));
if (Configurator.Instance.UseResponseCompression && request.AcceptEncoding == EnumAcceptEncoding.Gzip)
{
toReturn.Data = GzipCompress(toReturn.Data);
toReturn.ContentEncoding = "gzip";
}
return toReturn;
}
return NextHandler.Handle(request);
}
public void HasDefaultMessage()
{
var response = new Response((HttpStatusCode)451, null, new Dictionary<string, string>(), "application/json");
var legalRestrictionException = new LegalRestrictionException(response);
Assert.Equal("Resource taken down due to a DMCA notice.", legalRestrictionException.Message);
}
public Boolean IsNew(Response response)
{
Int32? obs = response.Observe;
if (!obs.HasValue)
{
// this is a final response, e.g., error or proactive cancellation
return true;
}
// Multiple responses with different notification numbers might
// arrive and be processed by different threads. We have to
// ensure that only the most fresh one is being delivered.
// We use the notation from the observe draft-08.
DateTime T1 = Timestamp;
DateTime T2 = DateTime.Now;
Int32 V1 = Current;
Int32 V2 = obs.Value;
Int64 notifMaxAge = (_config ?? CoapConfig.Default).NotificationMaxAge;
if (V1 < V2 && V2 - V1 < 1 << 23
|| V1 > V2 && V1 - V2 > 1 << 23
|| T2 > T1.AddMilliseconds(notifMaxAge))
{
Timestamp = T2;
_number = V2;
return true;
}
else
{
return false;
}
}
public JsonFormatterExtensionsFixtures()
{
this.formatter = A.Fake<IResponseFormatter>();
this.model = new Person { FirstName = "Andy", LastName = "Pike" };
DefaultSerializersStartup.JsonSerializer = new DefaultJsonSerializer();
this.response = this.formatter.AsJson(model);
}
public Response<Post> AddPost(Post newPost)
{
Regex pattern = new Regex(@"#\w+", RegexOptions.IgnoreCase);
var cats = new List<string>();
List<Category> catList = new List<Category>();
foreach (Match match in pattern.Matches(newPost.Content))
{
string cat = match.Value;
cats.Add(cat.Substring(1, cat.Length - 1) + " ");
foreach (var c in cats)
{
catList.Add(new Category() { category = c });
}
}
newPost.Categories = catList;
var response = new Response<Post>();
try
{
_repo.AddPost(newPost);
response.Success = true;
response.Message = "Successfully added post.";
}
catch(Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return response;
}
public Response<List<Resumes>> DisplayFiles(string filePath)
{
var repo = new FileRepository();
var response = new Response<List<Resumes>>();
try
{
response.Data = repo.GetFiles(filePath);
if (response.Data != null)
{
response.Success = true;
}
else
{
response.Success = false;
response.Message = "There are no files to display.";
}
}
catch (Exception ex)
{
response.Message = ex.Message;
response.Success = false;
}
return response;
}
public void Should_not_parse_wrong_xml()
{
var response = new Response(HttpStatusCode.OK, XmlContentType(), XmlWrongDtoResponseText);
var deserializer = new ResponseDeserializer();
Assert.Throws<UnexpectedXmlContentException>(() => deserializer.DeserializeResponse<Status>(response, false));
}
public void SendMessageSendsAndReceivesAMessage()
{
var action = "DoSomething";
var request = new ServerRequest
{
ServerName = "TestServer"
};
var url = "http://somewhere/";
var factory = new TestClientFactory((u, a, d) =>
{
Assert.AreEqual(url + "server/TestServer/RawXmlMessage.aspx", u.AbsoluteUri);
Assert.AreEqual("POST", a);
Assert.AreEqual(action, d["action"]);
Assert.AreEqual(request.ToString(), d["message"]);
var theResponse = new Response
{
RequestIdentifier = request.Identifier
};
return Encoding.UTF8.GetBytes(theResponse.ToString());
});
var connection = new HttpConnection(new Uri(url), factory);
var response = connection.SendMessage(action, request);
Assert.IsInstanceOf<Response>(response);
Assert.AreEqual(request.Identifier, response.RequestIdentifier);
}
protected void homebtn_Click(object sender, EventArgs e)
{
Response.Redirect("~/Default.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Session["usuariologado"] = null;
Response.Redirect("Login.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Session.Clear();
Session.Abandon();
Response.Redirect("/login.aspx");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
Response.Redirect(NavigateURL(PortalUtils.USER_ID_PARAM, PanelSecurity.SelectedUserId.ToString()));
}
private void CreateHostingSpace()
{
if (!Page.IsValid)
return;
string spaceName = ddlPlans.SelectedItem.Text;
string ftpAccount = (rbFtpAccountName.SelectedIndex == 0) ? null : ftpAccountName.Text;
string domainName = txtDomainName.Text.Trim();
PackageResult result = null;
try
{
result = ES.Services.Packages.AddPackageWithResources(PanelSecurity.SelectedUserId,
Utils.ParseInt(ddlPlans.SelectedValue, 0),
spaceName,
Utils.ParseInt(ddlStatus.SelectedValue, 0),
chkPackageLetter.Checked,
chkCreateResources.Checked, domainName, false, chkCreateWebSite.Checked,
chkCreateFtpAccount.Checked, ftpAccount, chkCreateMailAccount.Checked, txtHostName.Text);
if (result.Result < 0)
{
ShowResultMessage(result.Result);
lblMessage.Text = PortalAntiXSS.Encode(GetExceedingQuotasMessage(result.ExceedingQuotas));
return;
}
else
{
if ((chkIntegratedOUProvisioning.Checked) & !string.IsNullOrEmpty(domainName))
{
UserInfo user = UsersHelper.GetUser(PanelSecurity.SelectedUserId);
if (user != null)
{
if (user.Role != UserRole.Reseller)
{
UserSettings settings = ES.Services.Users.GetUserSettings(user.UserId, UserSettings.EXCHANGE_POLICY);
string orgId = domainName.ToLower();
if (settings != null && settings["OrgIdPolicy"] != null)
{
orgId = GetOrgId(settings["OrgIdPolicy"], domainName, result.Result);
}
ES.Services.Organizations.CreateOrganization(result.Result, orgId, domainName.ToLower(), domainName.ToLower());
if (result.Result < 0)
{
ShowErrorMessage("USERWIZARD_CREATE_ACCOUNT");
return;
}
}
}
}
}
}
catch (Exception ex)
{
ShowErrorMessage("USERWIZARD_CREATE_ACCOUNT", ex);
return;
}
// Save addons
try
{
int spaceId = result.Result;
foreach (RepeaterItem item in repHostingAddons.Items)
{
PackageAddonInfo addon = new PackageAddonInfo();
addon.PackageAddonId = 0; //PanelRequest.PackageAddonID;
addon.PackageId = spaceId; //PanelSecurity.PackageId;
addon.Comments = "";
addon.PlanId = Utils.ParseInt(GetDropDownListSelectedValue(item, "ddlPlan"), 0);
addon.StatusId = Utils.ParseInt(ddlStatus.SelectedValue, 0);
addon.PurchaseDate = DateTime.Now;
addon.Quantity = Utils.ParseInt(GetTextBoxText(item, "txtQuantity"), 1);
PackageResult addonResult = ES.Services.Packages.AddPackageAddon(addon);
}
if (rbPackageQuotas.Checked)
{
//TODO: add logic to recalculate quota
//If checked rbPackageQuotas take all addons quota, sum it and replace to main hosting quota
//You can look the idea from SpaceEditDetails, but in SpaceEditDetails it is manually, need automatic here
//At this moment here is a lot of work, maybe later.
}
//PackageContext cntx = PackagesHelper.GetCachedPackageContext(spaceId);
//string resourceGroup = "VPS2012";
//if (cntx != null && cntx.Groups.ContainsKey(resourceGroup))
//{
// string pageId = "SpaceVPS2012";
// string pageUrl = PortalUtils.NavigatePageURL(
//pageId, PortalUtils.SPACE_ID_PARAM, spaceId.ToString(), null);
// Response.Redirect(pageUrl);
//}
}
catch
{
//If something happens here, just ignore it. Addons not so important that a Hosting Space
}
if (chkRedirectToCreateVPS.Checked)
{
string pageId = "SpaceVPS2012";
string pageUrl = PortalUtils.NavigatePageURL(
pageId, PortalUtils.SPACE_ID_PARAM, result.Result.ToString(), null);
Response.Redirect(pageUrl);
}
else
{
// go to space home
Response.Redirect(PortalUtils.GetSpaceHomePageUrl(result.Result));
}
}
private void btnReset_Click(object sender, System.EventArgs e)
{
// Re-call the same page so that the default search criteria values are shown
Response.Redirect(Request.RawUrl);
}
protected void btnBackToMain_Click(object sender, System.EventArgs e)
{
Response.Redirect("CPDEmailReport.aspx");
}
/*!
* \brief 当确认上传按钮按下，但是没有实际的图像文件被提交的时候触发此方法，并且拒绝上传文件。
*/
private void WarningNoImageUploaded()
{
Response.Write("没有上传任何图像");
}
protected void Page_Load(object sender, EventArgs e) {
Response.Redirect("VehicleType/VehicleTypeList.aspx");
}
protected void addcartbtn_Click(object sender, EventArgs e)
{
Response.Redirect("~/Cart/Cart.aspx");
}
private void RedirectOnFail()
{
Response.Redirect((User.Identity.IsAuthenticated) ? "~/Account/Manage" : "~/Account/Login");
}
/*!
* \brief 当图像信息已经更新到数据库中的时候，调用此方法来实际地存储图像文件到本地服务器上。
* \param newImgID 用以在服务器端保存用户图片的图片ID，形如"fdk3430-343-243004334-342.jpg"，扩展名不限。
*/
private void UploadImgSuccess(string newImgID)
{
imgFileUploadBtn.SaveAs(SAVE_PATH + newImgID);
// 上传完成，返回个人主页面
Response.Redirect("~\\PersonalPage.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("~/Account/Consults");
}
protected void cmd_submit_Click(object sender, EventArgs e)
{
if (Request.QueryString["rno"] != null)
{
//update
int rno = int.Parse(Request.QueryString["rno"]);
if (rno == int.Parse(Rollno.Text))
{
//no need to check duplication
}
else
{
//duplication check logic
String selqry = "SELECT * FROM stud WHERE rno =" + int.Parse(Rollno.Text);
cmd = new SqlCommand(selqry, cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
//record already exists
Response.Write("Rollno Already Exists");
return;
}
}
cn.Close();
cn.Open();
//record does not exists go to update
String updateqry = "UPDATE stud SET rno=" + int.Parse(Rollno.Text) + " ,";
updateqry += "sname = '" + Name.Text + "' , ";
updateqry += "Age =" + int.Parse(Age.Text) + " ,";
if (Male.Checked == true)
{
updateqry += "gender = 'Male'";
}
else
{
updateqry += "gender = 'Female'";
}
updateqry += " WHERE rno = " + rno;
cmd = new SqlCommand(updateqry, cn);
int res = cmd.ExecuteNonQuery();
}
else
{
//insert
//duplication check logic
String selqry = "SELECT * FROM stud WHERE rno =" + int.Parse(Rollno.Text);
cmd = new SqlCommand(selqry, cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
//record already exists
Response.Write("Rollno Already Exists");
return;
}
cn.Close();
cn.Open();
//record does not exists go to insert
String insertqry = "INSERT INTO stud VALUES (" + int.Parse(Rollno.Text) + ",'" + Name.Text + "' , " + int.Parse(Age.Text) + ",";
if (Male.Checked == true)
{
insertqry += "'Male'";
}
else
{
insertqry += "'Female'";
}
insertqry += " )";
cmd = new SqlCommand("addStud", cn);
int res = cmd.ExecuteNonQuery();
}
Response.Redirect("Viewstud.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("02-Inicio.aspx");
}
private void storeResult()
{
DateTime SubmitTime = DateTime.Now;
DateTime PageLoadTime = Convert.ToDateTime(Hidden_PageLoadTime.Value);
SatyamTaskTableEntry taskEntry = JSonUtils.ConvertJSonToObject <SatyamTaskTableEntry>(Hidden_TaskEntryString.Value);
string tracksString = TracksOutput_Hidden.Value;
Console.WriteLine(tracksString);
string urlList = Hidden_ImageURLList.Value;
string[] fields = urlList.Split(',');
DateTime start = DateTime.MinValue;
List <DateTime> frameTimes = new List <DateTime>();
//double frameTimeSpanInMiliseconds = (Convert.ToDouble(Hidden_ChunkDuration.Value) / (double)fields.Length) * 1000;
double frameTimeSpanInMiliseconds = (double)(1000) / Convert.ToDouble(fps_Hidden.Value);
for (int i = 0; i < fields.Length; i++)
{
DateTime t;
t = start.AddMilliseconds(frameTimeSpanInMiliseconds * i);
frameTimes.Add(t);
}
string s = Raw_VATIC_DVA_Crowdsourced_Track_Collection.Raw_VATIC_DVA_Crowdsourced_Track_Collection_ToTrackStrings(tracksString, frameTimes);
SatyamResult result = new SatyamResult();
result.TaskParametersString = taskEntry.TaskParametersString;
result.TaskStartTime = PageLoadTime;
result.TaskEndTime = SubmitTime;
result.TaskTableEntryID = taskEntry.ID;
AmazonTaskResultInfo amazonInfo = new AmazonTaskResultInfo();
amazonInfo.AssignmentID = "";
amazonInfo.WorkerID = "";
amazonInfo.HITID = "";
result.amazonInfo = amazonInfo;
result.TaskResult = s;
string resultString = JSonUtils.ConvertObjectToJSon <SatyamResult>(result);
SatyamResultsTableAccess resultdb = new SatyamResultsTableAccess();
resultdb.AddEntry(taskEntry.JobTemplateType, taskEntry.UserID, taskEntry.JobGUID, resultString, taskEntry.ID, PageLoadTime, SubmitTime);
resultdb.close();
//SatyamTaskTableAccess taskDB = new SatyamTaskTableAccess();
//taskDB.IncrementDoneScore(taskEntry.ID);
bool NotDone = getNewRandomJob();
if (NotDone == false)
{
Response.Redirect("AllJobsDone.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Session.Remove("usermane");
Response.Redirect("LoginRest.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("02.2-MainPage.aspx");
}
protected void btnBack_Click1(object sender, EventArgs e)
{
Response.Redirect("GroupUpdateView.aspx");
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("02-AgregarComida.aspx");
}
protected void SignOut_Click(object sender, EventArgs e)
{
Session.Clear();
Response.Redirect("~/SystemUser/UserLogin.aspx");
}
protected void btnNew_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("~/MainData/webArea.aspx");
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
DropDownList dlist = (DropDownList)(e.Item.FindControl("DropDownList1"));
Response.Redirect("Cart.aspx?id=" + e.CommandArgument.ToString() + "&productquantity=" + dlist.SelectedItem.ToString());
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Response.Redirect("GroupUpdateQuery.aspx");
}
protected void back_Click(object sender, EventArgs e)
{
Response.Redirect("/Default.aspx");
}
protected void lbLogout_Click(object sender, EventArgs e)
{
Session.Clear();
Response.Redirect("~/Web/Home.aspx");
}
protected override async Task OnPlayPausedEventAsync(Event ev, Session session, CancellationToken cancellationToken)
{
await DurableOrchestrationClient.TerminateAsync(session.User.UserId, "PlayPaused");
Response.AddText("腹話術を終了します。");
}
protected void save_Click(object sender, System.EventArgs e)
{
// if (Save()) Response.Redirect("JenisEdit.aspx?done=1&NoJenis=" + NoJenis);
if (valid())
{
int ada = Db.SingleInteger("SELECT COUNT(*) FROM REF_JENIS WHERE Jenis='" + jenis.Text + "' AND SN != " + NoJenis);
if (ada > 0)
{
string s = "";
Js.Alert(
this
, "Input Tidak Valid.\\n\\n"
+ "Aturan Proses :\\n"
+ "1. Tipe Unit Properti tidak boleh kosong.\\n"
+ "2. Nama Tipe Unit tidak boleh kosong.\\n"
+ "3. Tipe Unit Duplikat.\\n"
, "document.getElementById('" + s + "').focus();"
+ "document.getElementById('" + s + "').select();"
);
}
else
{
string strSql = "SELECT * FROM REF_JENIS WHERE SN = '" + NoJenis + "'";
DataTable rs = Db.Rs(strSql);
DataTable rsBef = Db.Rs("SELECT "
+ " Jenis"
+ ",Nama"
+ ",SN"
+ " FROM REF_JENIS "
+ " WHERE SN = '" + NoJenis + "'");
//relasi
Db.Execute("UPDATE MS_UNIT SET Jenis='" + jenis.Text + "' WHERE Jenis='" + rs.Rows[0]["Jenis"] + "'");
Db.Execute("UPDATE MS_KONTRAK SET Jenis='" + jenis.Text + "' WHERE Jenis='" + rs.Rows[0]["Jenis"] + "'");
Db.Execute("UPDATE MS_RESERVASI SET Jenis='" + jenis.Text + "' WHERE Jenis='" + rs.Rows[0]["Jenis"] + "'");
Db.Execute("UPDATE MS_RESERVASI_OBS SET Jenis='" + jenis.Text + "' WHERE Jenis='" + rs.Rows[0]["Jenis"] + "'");
Db.Execute("UPDATE REF_JENIS SET Jenis='" + jenis.Text + "',Nama='" + namajenis.Text + "' WHERE SN = '" + NoJenis + "'");
DataTable rsAft = Db.Rs("SELECT "
+ " Jenis"
+ ",Nama"
+ ",SN"
+ " FROM REF_JENIS "
+ " WHERE SN = '" + NoJenis + "'");
//Logfile
string Ket = "Jenis: " + jenis.Text + "<br>"
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogJenis"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoJenis + "'"
);
Response.Redirect("JenisEdit.aspx?done=1&NoJenis=" + NoJenis);
}
}
}
protected override void Render(HtmlTextWriter writer)
{
if (OverrideRender)
{
StringBuilder sbOut = new StringBuilder();
using (StringWriter swOut = new StringWriter(sbOut, CultureInfo.InvariantCulture))
{
UTF8Encoding enc = new UTF8Encoding(true);
swOut.Write(Encoding.UTF8.GetString(enc.GetPreamble()));
HtmlTextWriter htwOut = new HtmlTextWriter(swOut);
base.Render(htwOut);
string sOut = sbOut.ToString();
string szTempPath = Path.GetTempPath();
string szFileRoot = Guid.NewGuid().ToString();
string szOutputHtm = szTempPath + szFileRoot + ".htm";
string szOutputPDF = szTempPath + szFileRoot + ".pdf";
File.WriteAllText(szOutputHtm, sbOut.ToString());
const string szWkTextApp = "c:\\program files\\wkhtmltopdf\\bin\\wkhtmltopdf.exe"; // TODO: this needs to be in a config file
string szArgs = PageOptions.WKHtmlToPDFArguments(szOutputHtm, szOutputPDF);
Process p = null;
using (p = new Process())
{
try
{
p.StartInfo = new ProcessStartInfo(szWkTextApp, szArgs)
{
UseShellExecute = true
}; // for some reason, wkhtmltopdf runs better in shell exec than without.
p.Start();
bool fResult = p.WaitForExit(120000); // wait up to 2 minutes
if (!fResult || !File.Exists(szOutputPDF))
{
util.NotifyAdminEvent("Error saving PDF", String.Format(CultureInfo.CurrentCulture, "User: {0}\r\nOptions:\r\n{1}\r\n\r\nQuery:{2}\r\n",
CurrentUser.UserName,
JsonConvert.SerializeObject(PageOptions),
JsonConvert.SerializeObject(PrintOptions1.Options)), ProfileRoles.maskSiteAdminOnly);
Response.Redirect(Request.Url.PathAndQuery + (Request.Url.PathAndQuery.Contains("?") ? "&" : "?") + "pdfErr=1");
}
else
{
Page.Response.Clear();
Page.Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", String.Format(CultureInfo.CurrentCulture, @"attachment;filename=""{0}.pdf""", CurrentUser.UserFullName));
Response.WriteFile(szOutputPDF);
Page.Response.Flush();
// See http://stackoverflow.com/questions/20988445/how-to-avoid-response-end-thread-was-being-aborted-exception-during-the-exce for the reason for the next two lines.
Page.Response.SuppressContent = true; // Gets or sets a value indicating whether to send HTTP content to the client.
HttpContext.Current.ApplicationInstance.CompleteRequest(); // Causes ASP.NET to bypass all events and filtering in the HTTP pipeline chain of execution and directly execute the EndRequest event.
}
}
catch (MyFlightbookException) { throw; }
finally
{
File.Delete(szOutputHtm);
File.Delete(szOutputPDF);
if (p != null && !p.HasExited)
{
p.Kill();
}
}
}
}
}
else
{
base.Render(writer);
}
}
protected override async Task OnIntentRequestAsync(Intent intent, Session session, CancellationToken cancellationToken)
{
switch (intent.Name)
{
case "Clova.GuideIntent":
Response
.AddText("LINEに入力をした内容をしゃべります。。。" +
"LINEでセリフを事前にテンプレートとして登録したり、" +
"英語や韓国語への翻訳モードに変更することもできます。" +
"準備はいいですか？")
.KeepListening();
break;
case "Clova.YesIntent":
case "ReadyIntent":
// 友だち追加チェック
try
{
await LineMessagingClient.GetUserProfileAsync(session.User.UserId);
}
catch
{
Response.AddText("連携するLINEアカウントが友だち追加されていません。" +
"Clovaアプリの本スキルのページから、連携するLINEアカウントを友だち追加してください。");
break;
}
await DurableOrchestrationClient.StartNewAsync(nameof(ClovaFunction.WaitForLineInput), session.User.UserId, null);
Response.AddText("LINEに入力をした内容をしゃべります。好きな内容をLINEから送ってね。");
// 無音無限ループに入る
KeepClovaWaiting();
break;
case "Clova.PauseIntent":
case "PauseIntent":
// 無限ループ中の一時停止指示に対し、スキル終了をする
await DurableOrchestrationClient.TerminateAsync(session.User.UserId, "intent");
Response.AddText("腹話術を終了します。");
break;
case "Clova.NoIntent":
case "Clova.CancelIntent":
case "NotReadyIntent":
// オーケストレーターが起動していないなら終了
{
var status = await DurableOrchestrationClient.GetStatusAsync(session.User.UserId);
if (status?.RuntimeStatus != OrchestrationRuntimeStatus.ContinuedAsNew &&
status?.RuntimeStatus != OrchestrationRuntimeStatus.Pending &&
status?.RuntimeStatus != OrchestrationRuntimeStatus.Running)
{
Response.AddText("腹話術を終了します。");
}
else
{
KeepClovaWaiting();
}
break;
}
case "Clova.FallbackIntent":
case "NoActionIntent": // 「ね」が準備OKのインテントに振り分けられてしまったので別途インテントに定義しておく
default:
// オーケストレーター起動中なら無音無限ループ
// これを行わないとClovaが通常の返しをしてしまう
{
var status = await DurableOrchestrationClient.GetStatusAsync(session.User.UserId);
if (status?.RuntimeStatus == OrchestrationRuntimeStatus.ContinuedAsNew ||
status?.RuntimeStatus == OrchestrationRuntimeStatus.Pending ||
status?.RuntimeStatus == OrchestrationRuntimeStatus.Running)
{
KeepClovaWaiting();
}
break;
}
}
}
