public void ClientCaptureCallback ( byte[] bgrData, int imageWidth, int imageHeight ) { // Copy the captured data to a local buffer this.CopyDataFromCaptureDataToLocalBuffer(bgrData, imageWidth, imageHeight); // Process the image data this.ClassifyRegion( ); // Update the associated texture GR gr = this.mGR; gr.glBindTexture(GR.GL_TEXTURE_2D, this.mTextureOpenGLHandleBGR256x256); gr.glTexSubImage2D ( GR.GL_TEXTURE_2D, // target 0, // level 0, // xoffset 0, // yoffset 256, // width 256, // height GR.GL_BGR_EXT, // format GR.GL_UNSIGNED_BYTE, // type this.mTextureDataBGR256x256 // texel data ); }
private void BtnRemoveRow_Click(object sender, RoutedEventArgs e) { if (GR.Rows > 0) { GR.RemoveRow(); } }
public void UpdateRunnersBusinessFlowRunsList() { foreach (GingerRunner GR in GingerRunners) { GR.UpdateBusinessFlowsRunList(); } }
public void UpdateSize() { _CanRender = false; while (_IsRendering) { } switch (_DrawSize) { case DrawSize.Stretch: Screen_X = 0; Screen_Y = 0; Screen_W = Surface.Size.Width; Screen_H = Surface.Size.Height; break; case DrawSize.X1: Screen_X = (Surface.Size.Width / 2) - 128; Screen_Y = (Surface.Size.Height / 2) - (_ScanLines / 2); Screen_W = 256; Screen_H = _ScanLines; break; case DrawSize.X2: Screen_X = (Surface.Size.Width / 2) - 256; Screen_Y = (Surface.Size.Height / 2) - _ScanLines; Screen_W = 512; Screen_H = _ScanLines * 2; break; } GR = Surface.CreateGraphics(); GR.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.NearestNeighbor; GR.Clear(Color.Black); CanRender = true; }
public void SetRunnersEnv(ProjEnvironment defualtEnv, ObservableList <ProjEnvironment> allEnvs) { foreach (GingerRunner GR in Runners) { GR.SetExecutionEnvironment(defualtEnv, allEnvs); } }
protected void imgbtndiscard_Click(object sender, EventArgs e) { Int32 MsgId = 0; DataTable dtMain = new DataTable(); if (gridDelete.Rows.Count > 0) { foreach (GridViewRow GR in gridDelete.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgDetailId = Convert.ToInt32(gridDelete.DataKeys[GR.RowIndex].Value); dtMain = clsMessage.SelectMsgIdUsingMsgDetailId(MsgDetailId); if (dtMain.Rows.Count > 0) { MsgId = Convert.ToInt32(dtMain.Rows[0]["MsgId"].ToString()); } bool MsgMasterDelete = clsMessage.DeleteMsgMaster(MsgId); if (MsgMasterDelete == true) { lblmsg.Visible = true; lblmsg.Text = "Record deleted successfully"; SelectMsgforDeleteBox(); } } } } }
protected void Button1_Click(object sender, EventArgs e) { foreach (GridViewRow GR in GridView1.Rows) { if (GR.RowType == DataControlRowType.DataRow) { // You can also find grid view inside controls here TextBox goods_id = (TextBox)GR.FindControl("lbl_GoodId"); TextBox goods_unit = (TextBox)GR.FindControl("lbl_ItemUnit"); TextBox goods_qty = (TextBox)GR.FindControl("lbl_ItemQty"); TextBox goods_price = (TextBox)GR.FindControl("lbl_ItemPrice"); int g_id = Convert.ToInt32(goods_id.Text.ToString()); string g_unit = Convert.ToString(goods_unit.Text.ToString()); string g_qty = Convert.ToString(goods_qty.Text.ToString().Replace(",", ".")); string g_price = Convert.ToString(goods_price.Text.ToString().Replace(",", ".")); int LastInsertedId2 = 3261; int transaction_type = 1; con.Open(); string str3 = "insert into tenders_items (waybill_id, goods_id, unit_name, quantity, price, tr_type) Values ('" + LastInsertedId2 + "', '" + g_id + "', N'" + g_unit + "', '" + g_qty + "', '" + g_price + "', '" + transaction_type + "')"; SqlCommand strCmd3 = new SqlCommand(str3, con); strCmd3.ExecuteNonQuery(); con.Close(); } } }
protected void Button2_Click(object sender, EventArgs e) { int amount = Convert.ToInt32(this.TextBox2.Text); int tagindex = -1; foreach (GridViewRow GR in this.GridView1.Rows) { CheckBox CB = (CheckBox)GR.FindControl("CheckBox1"); if (CB.Checked) { tagindex = GR.RowIndex; } } int bookamount = Convert.ToInt32(this.GridView1.Rows[tagindex].Cells[5].Text); int decrease = bookamount - amount; DataManage dm = new DataManage(); if (decrease > 0) { string sql = "update [Library].[library].[Book] set [Bamount] =" + decrease + "where [Bname] like '" + this.GridView1.Rows[tagindex].Cells[1].Text + "' and [Btype] like '" + this.GridView1.Rows[tagindex].Cells[2].Text + "' and [Bwriter] like '" + this.GridView1.Rows[tagindex].Cells[3].Text + "' and [Bpublish] like '" + this.GridView1.Rows[tagindex].Cells[4].Text + "'"; dm.ExecuteSql(sql); } else { string sql = "delete from [Library].[library].[Book] where [Bname] like '" + this.GridView1.Rows[tagindex].Cells[1].Text + "' and [Btype] like '" + this.GridView1.Rows[tagindex].Cells[2].Text + "' and [Bwriter] like '" + this.GridView1.Rows[tagindex].Cells[3].Text + "' and [Bpublish] like '" + this.GridView1.Rows[tagindex].Cells[4].Text + "'"; dm.ExecuteSql(sql); } Response.Write("<script>alert('出库成功!')</script>"); databind(); }
private void BtnRemoveColumn_Click(object sender, RoutedEventArgs e) { if (GR.Columns > 0) { GR.RemoveColumn(); } }
protected void Button1_Click(object sender, EventArgs e) { foreach (GridViewRow GR in GridView1.Rows) { if (GR.RowType == DataControlRowType.DataRow) { // You can also find grid view inside controls here Label MobileNum = (Label)GR.FindControl("mobile"); string str = MobileNum.Text; string other_nums = string.Empty; if (MobileNum.Text != null) { for (int i = 1; i < str.Length; i++) { if (Char.IsDigit(str[i])) { other_nums += str[i]; } var f_num = str[0].ToString(); var first_num = Convert.ToString(f_num.Replace("8", "5")); MobileNum.Text = first_num + other_nums; } } } } }
private void Selects(StateMachine.RuleStateEventArgs e) { try { GR.SelectCurrent(e.StateObject); MainStrip.SetLine(stateMachine.GetStrip); MainStrip.Select(stateMachine.Selected); } catch { } }
public void OpenGLStarted(GRControl grControl) { GR gr = grControl.GetGR( ); if (null == gr) { return; } // ... }
/// <summary> /// Método para ubicar puntos /// </summary> /// <param name="x">Coordenada del eje X</param> /// <param name="y">Coordenada del eje Y</param> /// <param name="img">Imagen</param> /// <returns>Imagen con los puntos</returns> private Image ubicar_puntos(int x, int y, Image img) { Graphics GR; Bitmap BM = new Bitmap(img); Pen penTest = new System.Drawing.Pen(Brushes.Red); using (GR = Graphics.FromImage(img)) { GR.DrawEllipse(penTest, x, y, 5, 5); } return(img); }
private void SetupHeader(GR role, GridViewModel <GovernorModel> grid, GovernorDisplayPolicy displayPolicy, bool includeEndDate) { grid.AddHeaderCell("Name", displayPolicy.FullName, "name", "sortText") .AddHeaderCell("Shared with", role.OneOfThese(GR.LocalGovernor, GR.ChairOfLocalGoverningBody), "shared", "sortText") .AddHeaderCell("GID", displayPolicy.Id, "gid") .AddHeaderCell("Appointed by", displayPolicy.AppointingBodyId, "appointed", "sortText") .AddHeaderCell("From", displayPolicy.AppointmentStartDate, "fromDate", "sortDate") .AddHeaderCell(role == GR.Member ? "Date stepped down" : "To", includeEndDate, "toDate", "sortDate") .AddHeaderCell("Postcode", displayPolicy.PostCode) .AddHeaderCell("Date of birth", displayPolicy.DOB) .AddHeaderCell("Previous name", displayPolicy.PreviousFullName) .AddHeaderCell("Email address", displayPolicy.EmailAddress) .AddHeaderCell("Telephone", displayPolicy.TelephoneNumber); }
static void check_whq_global_totals(string min_code, string min_id, string perm_link,string period, ref GR gr) { //prod lmi_total_send_mult_disc // Console.WriteLine(""); //onsole.WriteLine(perm_link + ":"); foreach(string mcc in ids.mcc_code.Values ){ var measurement = gr.GetMeasurements(min_id, period, period, "", "", false, "&filters[perm_link]=" + perm_link + "&filters[dimension]=" + mcc).FirstOrDefault(); if (measurement.measurements.Count > 0) { Console.WriteLine(min_code + " " + mcc + ":" + measurement.measurements.First().Value); }else{ Console.WriteLine(min_code + " " + mcc + ": 0"); } } }
private void BtnStart_Click(object sender, RoutedEventArgs e) { ResBox.Document.Blocks.Clear(); if (string.IsNullOrWhiteSpace(WordInput.Text)) { MessageBox.Show("Can't start with null word"); return; } if (stateMachine.IsBusy) { MessageBox.Show("Machine is already running!"); return; } stateMachine.Start(GR.GetCurrentStates(), GetPureSelSpeed()); }
private void Clear( ) { mSTVideoCapture = null; mGR = null; mTextureDataBGR256x256 = null; mTextureOpenGLHandleBGR256x256 = 0; mVideoLUT256 = null; mProcessXMin = 32; mProcessYMin = 160; mProcessXMax = 96; mProcessYMax = 224; mCurrentClassification = (-1); }
public MainWindow() { InitializeComponent(); MinWidth = 800; MinHeight = 450; InitHandlers(); stateMachine = new StateMachine(); InitStrip(); GR.Loaded += (s, e) => GR.SetControls(stateMachine.Rules); App.Current.DispatcherUnhandledException += Current_DispatcherUnhandledException; if (!string.IsNullOrEmpty(Tools.StartupHelper)) { stateMachine.Load(Tools.StartupHelper); } }
private static void MakeFontTexture(GR gr) { byte[] rgbaBuffer = new byte[128 * 128 * 4]; // fill in buffer with RGBA version of font pixels byte val = (byte)0; int k = 0; for (int j = 0; j < 128; j++) { for (int i = 0; i < 128; i++) { k = 4 * ((128 * (127 - j)) + i); val = Courier10FontBitmap[(16 * j) + (i >> 3)]; val <<= (i & 0x7); // 0..7 if (0 != (val & 0x80)) { // opaque white rgbaBuffer[k + 0] = 255; // R rgbaBuffer[k + 1] = 255; // G rgbaBuffer[k + 2] = 255; // B rgbaBuffer[k + 3] = 255; // A } else { // transparent rgbaBuffer[k + 0] = 0; // R rgbaBuffer[k + 1] = 0; // G rgbaBuffer[k + 2] = 0; // B rgbaBuffer[k + 3] = 0; // A } } } // create an OpenGL texture and transfer data to the texture int[] temp = new int[1]; gr.glGenTextures(1, temp); mFontTextureName = temp[0]; gr.glBindTexture(GR.GL_TEXTURE_2D, mFontTextureName); gr.glTexParameteri(GR.GL_TEXTURE_2D, GR.GL_TEXTURE_MAG_FILTER, GR.GL_NEAREST); gr.glTexParameteri(GR.GL_TEXTURE_2D, GR.GL_TEXTURE_MIN_FILTER, GR.GL_NEAREST); gr.glTexImage2D(GR.GL_TEXTURE_2D, 0, GR.GL_RGBA, 128, 128, 0, GR.GL_RGBA, GR.GL_UNSIGNED_BYTE, rgbaBuffer); }
private void BtnAddRow_Click(object sender, RoutedEventArgs e) { var dialog = new Controls.PromptDialog() { Title = "Enter row name" }; if (dialog.ShowDialog() == true) { if (string.IsNullOrEmpty(dialog.ResponseText)) { MessageBox.Show("Failed to add empty name", "Failed", MessageBoxButton.OK, MessageBoxImage.Error); return; } GR.AddRow(dialog.ResponseText[0]); } }
private void UpdateGrid() { int IndexRow = 0; int IndexMes = 0; string UnidValue = ""; int CodProducto = 0; string msgResultado = string.Empty; int CodProyecto = HttpContext.Current.Session["codProyecto"] == null?0: Convert.ToInt32(HttpContext.Current.Session["codProyecto"]); int TiempoProyeccion = HttpContext.Current.Session["TiempoProyeccion"] == null ? 0 : Convert.ToInt32(HttpContext.Current.Session["TiempoProyeccion"]); CodProducto = Request.QueryString["Id_Producto"] == null ? 0 : Convert.ToInt32(Request.QueryString["Id_Producto"]); CrearActualizarProductoVentas(TiempoProyeccion, CodProyecto, ref msgResultado, ref CodProducto); if (CodProducto > 0) { int TotalColl = _dttProductos.Columns.Count - 2; foreach (GridViewRow GR in GridView1.Rows) { string QueryUpdate = ""; if (IndexRow < 12) { for (int IndexCol = 1; IndexCol <= TiempoProyeccion; IndexCol++) { string FieldAnio = _dttProductos.Columns[IndexCol].ColumnName; FieldAnio = FieldAnio.Substring(3, 2).TrimStart(); string NomTextBox = "TextBox" + FieldAnio; if (GR.RowType == DataControlRowType.DataRow) { string FieldMes = _dttProductos.Columns[IndexCol].ColumnName; IndexMes = Convert.ToInt32(_dttProductos.Rows[IndexRow]["Periodos_"]); TextBox TextBoxValue = (TextBox)GR.FindControl(NomTextBox); TextBoxValue.Text = (TextBoxValue.Text == "" ? "0" : TextBoxValue.Text); UnidValue = TextBoxValue.Text.Replace(",", ""); } QueryUpdate += "UPDATE ProyectoProductoUnidadesVentas SET Unidades =" + UnidValue + " WHERE Codproducto=" + CodProducto + " and Mes=" + IndexMes + " and Ano=" + FieldAnio + "\n"; } IndexRow++; InsertUpdateProductos(QueryUpdate); } } precios(CodProducto.ToString(), TiempoProyeccion); } ClientScriptManager cm = this.ClientScript; cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'> alert('" + msgResultado + "'); location.href = '../Proyecto/PProyectoMercadoProyecciones.aspx' </script>"); }
protected void imgbtnmovetoInbox_Click(object sender, EventArgs e) { bool Gcheck = false; bool UpdateMsgDetail = false; if (gridDelete.Rows.Count > 0) { foreach (GridViewRow GR in gridDelete.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Gcheck = true; break; } } if (Gcheck == false) { lblmsg.Text = "Please select atleast one deleted Message to move to Inbox."; lblmsg.Visible = true; return; } else { if (gridDelete.Rows.Count > 0) { foreach (GridViewRow GR in gridDelete.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgDetailId = Convert.ToInt32(gridDelete.DataKeys[GR.RowIndex].Value); UpdateMsgDetail = clsMessage.UpdateMsgDetail(MsgDetailId, 1); } } if (UpdateMsgDetail == true) { lblmsg.Visible = true; lblmsg.Text = "Messages are Successfully moved to Inbox."; SelectMsgforDeleteBox(); } } } } }
protected void imgbtndiscard_Click(object sender, EventArgs e) { bool Gcheck = false; if (gridDraft.Rows.Count > 0) { foreach (GridViewRow GR in gridDraft.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Gcheck = true; break; } } if (Gcheck == false) { lblmsg.Text = "Please select atleast one Draft Message to Delete."; pnlmsg.Visible = true; return; } else { bool MsgMasterDelete = false; foreach (GridViewRow GR in gridDraft.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgId = Convert.ToInt32(gridDraft.DataKeys[GR.RowIndex].Value); bool MsgDetailDelete = clsMessage.DeleteMsgDetail(MsgId); bool FileDelete = clsMessage.DeleteMsgFileAttachDetail(MsgId); MsgMasterDelete = clsMessage.DeleteMsgMaster(MsgId); } } if (MsgMasterDelete == true) { lblmsg.Visible = true; pnlmsg.Visible = true; lblmsg.Text = "Message Deleted Successfully."; SelectMsgforDraft(); } } } }
protected void imgbtnsend_Click(object sender, EventArgs e) { bool Gcheck = false; bool UpdateMsg = false; if (gridDraft.Rows.Count > 0) { foreach (GridViewRow GR in gridDraft.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Gcheck = true; break; } } if (Gcheck == false) { lblmsg.Text = "Please select atleast one Draft Message to send."; pnlmsg.Visible = true; return; } else { foreach (GridViewRow GR in gridDraft.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgId = Convert.ToInt32(gridDraft.DataKeys[GR.RowIndex].Value); bool UpdateMsgMaster = clsMessage.UpdateMsgMasterforDraftSend(MsgId); UpdateMsg = clsMessage.UpdateMsgDetailusingMsgId(MsgId, 1); } } if (UpdateMsg == true) { pnlmsg.Visible = true; lblmsg.Visible = true; lblmsg.Text = "Message Sent Successfully."; SelectMsgforDraft(); } } } }
public void Terminate( ) { if (null != this.mSTVideoCapture) { this.mSTVideoCapture.Terminate( ); } if (0 != mTextureOpenGLHandleBGR256x256) { GR gr = this.mGR; // Delete OpenGL texture object int[] temp = new int[1]; temp[0] = this.mTextureOpenGLHandleBGR256x256; gr.glDeleteTextures(1, temp); } this.Clear( ); }
static void deleteAllMeasurements(string period_from, string period_to, ref GR gr, string mcc) { Console.WriteLine(mcc); var everything = gr.GetMeasurements("", period_from, period_to, "", "", false, "&filters[perm_link]=lmi_local%25&show_detail=true&filters[dimension]=" + mcc + "&per_page=100"); //int i = 0; foreach (var row1 in everything) { Console.WriteLine("Deleting " + row1.PermLink); foreach (var row in row1.measurements.Where(c => c.CreatedBy == "46df52a6-e71e-11e3-a5a1-12768b82bfd5")) { Console.Write("."); gr.DeleteMeasuerment(row.ID); //i++; } } }
protected void imgbtndiscard_Click(object sender, EventArgs e) { if (gridInbox.Rows.Count > 0) { foreach (GridViewRow GR in gridInbox.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgDetailId = Convert.ToInt32(gridInbox.DataKeys[GR.RowIndex].Value); clsMessage.UpdateMsgDetail(MsgDetailId, 4); lblmsg.Text = "Message Discard Successfully"; lblmsg.Visible = true; pnlmsg.Visible = true; } } SelectMsgforInbox(); } }
protected void SaveWaybill_Click(object sender, ImageClickEventArgs e) { foreach (GridViewRow GR in GridView2.Rows) { if (GR.RowType == DataControlRowType.DataRow) { // You can also find grid view inside controls here HiddenField goods_id = (HiddenField)GR.FindControl("HiddenField_GoodId"); Label goods_unit = (Label)GR.FindControl("lbl_ItemUnit"); Label goods_qty = (Label)GR.FindControl("lbl_ItemQty"); Label goods_price = (Label)GR.FindControl("lbl_ItemPrice"); int g_id = Convert.ToInt32(goods_id.Value.TrimStart()); string g_unit = Convert.ToString(goods_unit.Text.ToString()); string g_qty = Convert.ToString(goods_qty.Text.ToString().Replace(",", ".")); string g_price = Convert.ToString(goods_price.Text.ToString().Replace(",", ".")); Response.Write("<script type='text/javascript'>alert('" + g_id + "')</script>"); } } }
protected void imgbtndiscard_Click(object sender, EventArgs e) { if (grdSentMailList.Rows.Count > 0) { foreach (GridViewRow GR in grdSentMailList.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkMsg"); if (chk.Checked == true) { Int32 MsgId = Convert.ToInt32(grdSentMailList.DataKeys[GR.RowIndex].Value); bool del = clsMessage.UpdateMsgMasterforSendDeleteExt(MsgId, "Deleted"); if (del == true) { pnlmsg.Visible = true; lblmsg.Text = "Record Discard Successfully"; lblmsg.Visible = true; } } } SelectMsgforSendBox(); } }
protected void Button2_Click(object sender, EventArgs e) { string str1 = ""; con.Close(); con.Open(); string str = " SELECT DISTINCT COUNT(dbo.MassEmailDetail.BusinessEmailID) AS Expr1, dbo.MassEmailDetail.BusinessEmailID FROM dbo.MassEmailDetail INNER JOIN dbo.MassemailMaster ON dbo.MassEmailDetail.MassemailMasterID = dbo.MassemailMaster.MassemailMasterID GROUP BY dbo.MassEmailDetail.BusinessEmailID "; str = "SELECT DISTINCT COUNT(dbo.MassEmailDetail.BusinessEmailID) AS Expr1, dbo.MassEmailDetail.BusinessEmailID, dbo.MassemailMaster.date, dbo.MassemailMaster.Message, dbo.MassemailMaster.AttachmentURL, dbo.MassemailMaster.MasterEmailSentSubject, dbo.MassemailMaster.Mail_message_FormatName FROM dbo.MassEmailDetail INNER JOIN dbo.MassemailMaster ON dbo.MassEmailDetail.MassemailMasterID = dbo.MassemailMaster.MassemailMasterID GROUP BY dbo.MassEmailDetail.BusinessEmailID, dbo.MassemailMaster.date, dbo.MassemailMaster.Message, dbo.MassemailMaster.AttachmentURL, dbo.MassemailMaster.MasterEmailSentSubject, dbo.MassemailMaster.Mail_message_FormatName"; SqlCommand cmd = new SqlCommand(str, con); SqlDataAdapter da = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); da.Fill(dt); GridView2.DataSource = dt; GridView2.DataBind(); con.Close(); con.Open(); foreach (GridViewRow GR in GridView1.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkSelect"); Label BusinessEmailID = (Label)GR.FindControl("lbl_email"); Label lbl_Message = (Label)GR.FindControl("lbl_Message"); Label lbl_Master_EmailSentSubject = (Label)GR.FindControl("lbl_Master_EmailSentSubject"); if (chk.Checked == true) { Session["lbl_Message"] = lbl_Message.Text; Session["lbl_Master_EmailSentSubject"] = lbl_Master_EmailSentSubject.Text; mail = BusinessEmailID.Text; SendMail(); con.Close(); con.Open(); } } lbl_msg.Text = "Mail Send Successfully"; }
protected void btntoExcel_Click(object sender, EventArgs e) { MyNewTest(); foreach (GridViewRow GR in GridView2.Rows) { if (GR.RowType == DataControlRowType.DataRow) { // You can also find grid view inside controls here TextBox goods_name = (TextBox)GR.FindControl("lbl_ItemName"); TextBox goods_code = (TextBox)GR.FindControl("lbl_ItemCode"); TextBox goods_qty = (TextBox)GR.FindControl("lbl_ItemQty"); TextBox goods_price = (TextBox)GR.FindControl("lbl_ItemPrice"); string g_name = Convert.ToString(goods_name.Text.ToString()); string g_code = Convert.ToString(goods_code.Text.ToString()); string g_qty = Convert.ToString(goods_qty.Text.ToString().Replace(",", ".")); string g_price = Convert.ToString(goods_price.Text.ToString().Replace(",", ".")); using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Expoted_Files\\gridview.xls;Extended Properties='Excel 12.0;HDR=Yes'")) { conn.Open(); OleDbCommand cmd = new OleDbCommand("INSERT INTO [Sheet1$] ([name], [code], [qty], [price]) values ('" + g_name + "', '" + g_code + "', '" + g_qty + "', '" + g_price + "')", conn); exp = cmd.ExecuteNonQuery(); } } } if (exp > 0) { Response.Write("<script type='text/javascript'>alert('Excel-ის ფაილის ექსპორტი განხორციელდა წარმატებით C: დისკზე, დირექტორიაში Expoted_Files')</script>"); } }
protected void buttondual_Click(object sender, EventArgs e) { if (buttondual.Text == "Select") { foreach (GridViewRow GR in GridView2.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkParty"); if (GR.RowIndex == 0) { chk.Enabled = false; buttondual.Text = "Go"; } else { chk.Enabled = true; buttondual.Text = "Go"; } } } if (buttondual.Text == "Go") { foreach (GridViewRow GR in GridView2.Rows) { CheckBox chk = (CheckBox)GR.FindControl("chkParty"); if (chk.Checked == true) { Label lbl1 = (Label)GR.FindControl("Label13"); ViewState["lb"] = lbl1.Text; SelectMsgforSendBox(); } } } }
public override TimedPlay TimedPlayOnRoll(GameState gamestate, List<GR.Gambling.Backgammon.Tools.PlayHint> hints, GR.Gambling.Backgammon.Venue.VenueUndoMethod undo_method) { bool is_race = gamestate.Board.IsPureRace(); bool is_bearoff = (gamestate.Board.LastChequer(gamestate.PlayerOnRoll) < 6); int total_sleep_before_first = 0; if (gamestate.Board.CapturedCount(gamestate.PlayerOnRoll) != hints[0].Play.Count) { if (!is_race) { total_sleep_before_first += random.Next(750, 1750); if (random.Next(10) == 0) total_sleep_before_first += random.Next(2500); } else { if (!is_bearoff) total_sleep_before_first += random.Next(250, 750); if (random.Next(20) == 0) total_sleep_before_first += random.Next(1000); if (random.Next(40) == 0) total_sleep_before_first += random.Next(2500); if (random.Next(60) == 0) total_sleep_before_first += random.Next(5000); } } int last_slot = -5; int last_dest = -5; int on_bar = gamestate.Board.CapturedCount(gamestate.PlayerOnRoll); TimedPlay play = new TimedPlay(); int[] dice = gamestate.Dice; Play p = hints[0].Play; for (int i = 0; i < p.Count; i++) { int slot = p[i].From; int before = 0; int after = 0; int die = p[i].From - p[i].To; if (!(die == dice[0] || die == dice[1])) die = System.Math.Max(dice[0], dice[1]); if (i == 0) before += total_sleep_before_first; if (i == (p.Count - 1) && random.Next(15) == 0) after += random.Next(300, 1300); if (on_bar > 0) { if (random.Next(8) == 0) before += random.Next(500, 1000); } else if (!is_bearoff && i > 0 && slot != last_slot && (slot - die >= 0) && slot != last_dest && !p[i].IsEnter && (slot - die != last_dest)) { int diff = System.Math.Abs(slot - last_slot); if ((last_slot >= 12 && slot < 12) || (slot >= 12 && last_slot < 12)) diff = 10; if (diff <= 1) before += random.Next(25, 75); else if (diff <= 3) before += random.Next(50, 350); else if (diff <= 6) before += random.Next(100, 500); else before += random.Next(150, 900); } else { } play.Add(new TimedMove(hints[0].Play[i], before, after)); last_slot = slot; last_dest = p[i].To; on_bar--; } return play; }
static void push_whq_data(Boolean stage = false, Boolean dev = false, int months = 5, Boolean reset = false, Boolean new_model_only = false) { var d = new WHQtoGR.App_Code.whq2grDataContext(); GR gr = null; ids = new gr_ids(stage); string whq_system = ""; if (stage) { gr = new GR(ConfigurationManager.AppSettings["whq_stage_api_key"], ConfigurationManager.AppSettings["gr_stage_server"], false); // gr.MeasApi = "http://*****:*****@"SELECT CAST( DATE_FORMAT(`gma_directorreport`.`directorreport_endDate`, '%Y-%m-01') as DATE) AS `Date`, `gma_locationtrans`.`location_name` AS `Area`, `gma_organizationdata`.`organization_countryCode` AS `Country`, `gma_measurementlbl`.`measurementlbl_name` AS `LMI`, `gma_strategylbl`.`strategylbl_name` AS `MCC`, SUM( `gma_directordata`.`directordata_value` ) AS `Value` FROM `gma_directordata` JOIN `gma_directorreport` ON `gma_directordata`.`directorreport_id` = `gma_directorreport`.`directorreport_id` JOIN `gma_measurement` ON `gma_directordata`.`measurement_id` = `gma_measurement`.`measurement_id` JOIN `gma_newmeasurementdetails` ON `gma_measurement`.`measurement_details_id` = `gma_newmeasurementdetails`.`measurement_details_id` JOIN `gma_measurementlbl` ON `gma_measurement`.`measurementlbl_id` = `gma_measurementlbl`.`measurementlbl_id` JOIN `gma_organizationdata` ON `gma_measurement`.`organization_id` = `gma_organizationdata`.`organization_id` JOIN `gma_strategydata` ON `gma_newmeasurementdetails`.`strategy_id` = `gma_strategydata`.`strategy_id` JOIN `gma_strategylbl` ON `gma_strategydata`.`strategylbl_id` = `gma_strategylbl`.`strategylbl_id` JOIN `gma_locationtrans` ON `gma_organizationdata`.`location_id` = `gma_locationtrans`.`location_id` WHERE `gma_organizationdata`.`version_id` = 2 AND `gma_strategydata`.`version_id` = 2 AND `gma_locationtrans`.`language_id` = 1 AND `gma_organizationdata`.`organization_leftIndex` + 1 = `gma_organizationdata`.`organization_rightIndex` AND MONTH(`gma_directorreport`.`directorreport_endDate`)= MONTH(CURDATE() - INTERVAL " + i + @" MONTH ) AND YEAR(`gma_directorreport`.`directorreport_endDate`)= YEAR(CURDATE() - INTERVAL " + i + @" MONTH ) and Not `gma_locationtrans`.`location_name` = 'NONE' and Not `gma_locationtrans`.`location_name` = 'TEST' And `gma_directordata`.`directordata_value` >0 GROUP BY `Date`, `Area`, `Country`, `LMI`, `MCC`"; var dt = new DataTable(); var da = new MySqlDataAdapter(cmd); da.Fill(dt); //get all measurements // Console.WriteLine(dt.Rows.Count); var rows = dt.AsEnumerable().Where(row => (d.wierd_countries.Where(c => c.whq_code == row["Country"].ToString() && c.min_code == null).Count() == 0) && ids.m.ContainsKey(row["LMI"].ToString()) && (d.mid_lookups.Where(c => (c.country == row["Country"].ToString()) && c.etl && (c.stage == stage)).Count() == 0 || (row["LMI"].ToString().Contains("actualreportingnodes") || row["LMI"].ToString().Contains("actualreportingnodes")))).ToArray(); //Console.WriteLine("before: " + rows.Where(row => row["Country"].ToString() == "EGY").Count().ToString()); //filter out ETL Active rows and only //now some tests int delta = rows.Count() / 10; int count = 0; var flat_list = new Dictionary<string, double>(); var flat_list_mt = new Dictionary<string, string>(); //The flatlist contains a name/value list of all measurements (from whq), where the name contains ministry_id : measurement_type_id : dimension. This allows me to lookup a value and see if it has changed. if (rows.Count() > 0) { var everything = gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_win_%25" + m_filter).ToList(); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_build_%25" + m_filter).ToList()); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_send_%25" + m_filter).ToList()); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_movements_%25" + m_filter).ToList()); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_nbr_%25" + m_filter).ToList()); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_actual_reporting_nodes" + m_filter).ToList()); everything.AddRange(gr.GetMeasurements("", ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), ((DateTime)rows.First()["Date"]).ToString("yyyy-MM"), "", "", false, "&filters[perm_link]=lmi_local_possible_reporting_nodes" + m_filter).ToList()); foreach (MeasurementType row in everything) { foreach (Measurement m in row.measurements) { flat_list.Add(m.RelatedEntityId + ":" + row.ID + ":" + m.Dimension, m.Value); flat_list_mt.Add(m.RelatedEntityId + ":" + row.ID + ":" + m.Dimension, m.ID ) ; } } } // Console.WriteLine("rows: " + rows.Count().ToString()); // Console.WriteLine("flatlist count: " + flat_list.Count); int c_changed = 0; int c_not_changed = 0; Console.Write("processing data:"); foreach (DataRow row in rows) { count++; if (delta > 0) { if (count % delta == 1) Console.Write("\rprocessing data for " + ((DateTime)row["Date"]).ToString("yyyy-MM") + ": " + ((int)(100 * count / rows.Count())).ToString() + "% complete."); } string min_id = (from c in d.mid_lookups where c.country == row["Country"].ToString() && c.stage == stage select c.ministry_id).FirstOrDefault(); if (string.IsNullOrEmpty(min_id)) { var nms_wierd = (from c in d.wierd_countries where c.whq_code == row["Country"].ToString() select c.min_code); Entity nms_ministry = null; if (nms_wierd.Count() > 0 ) { nms_ministry = gr.GetEntities("ministry", "&filters[owned_by]=all&filters[min_code]=" + nms_wierd.First() + "&fields=min_code", 0, 0, ref totalPage).FirstOrDefault(); } if (nms_ministry == null) { nms_ministry = gr.GetEntities("ministry", "&filters[owned_by]=all&filters[iso_country:relationship][iso3_code]=" + row["Country"].ToString() + "&filters[area:relationship][area_code]=" + ids.areas[row["Area"].ToString()] + "&fields=min_code", 0, 0, ref totalPage).FirstOrDefault(); } min_id = nms_ministry.ID; App_Code.mid_lookup insert = new App_Code.mid_lookup(); insert.ministry_id = min_id; insert.stage = stage; insert.country = row["Country"].ToString(); d.mid_lookups.InsertOnSubmit(insert); d.SubmitChanges(); } Boolean changed=true; string perm_link = row["LMI"].ToString().ToLower().Replace("fa_", "lmi_local_").Replace("fr_", "lmi_local_").Replace("movements", "lmi_local_movements").Replace("actualreportingnodes", "lmi_local_actual_reporting_nodes").Replace("possiblereportingnodes", "lmi_local_possible_reporting_nodes").Replace("nbr_staff_reporting", "lmi_local_nbr_staff_reporting").Replace("nbr_nonstaff_reporting", "lmi_local_nbr_nonstaff_reporting"); if (perm_link.StartsWith("lmi_local")) { MeasurementType this_mt = ids.nms.Where(c => c.PermLink == perm_link).FirstOrDefault(); if (this_mt == null) { //get the measurement // var cache = new WHQtoGR.App_Code.meas_cacheDataContext(); this_mt = gr.GetMeasurements("", "3000-01", "3000-01", "", "", false, "&filters[perm_link]=" + perm_link).FirstOrDefault(); if (this_mt != null) { // Console.WriteLine(perm_link); ids.nms.Add(this_mt); } } if (this_mt != null) { string key = min_id + ":" + this_mt.ID + ":" + ids.mcc_code[row["MCC"].ToString()] + "_gma" ; if (flat_list.ContainsKey(key )) { changed = (flat_list[key] != System.Convert.ToDouble(row["Value"])); flat_list.Remove(key); flat_list_mt.Remove(key); //the remaining items need to be deleted, as they exist in GR but not in WHQ } if (changed) { this_mt.addMeasurement(min_id, ((DateTime)row["Date"]).ToString("yyyy-MM"), System.Convert.ToDouble(row["Value"]), ids.mcc_code[row["MCC"].ToString()] + "_gma"); c_changed++; } else c_not_changed++; //Console.WriteLine(row["Country"].ToString() + " " + row["MCC"].ToString().ToLower() + " " + perm_link + " : " + System.Convert.ToDouble(row["Value"])); } else { Console.WriteLine("could not create measurement_type"); } } else Console.WriteLine("could not find " + perm_link); } //Console.WriteLine("changed: " + c_changed); //Console.WriteLine("not_changed: " + c_not_changed); //Console.WriteLine("updloading " + ids.nms.Sum(c => c.measurements.Count()) + " into New Msasurement Model"); //TODO: DELETE ALL MEAUREMENTS THAT ARE LEFT IN THE FLATLIST Console.WriteLine("extra (to be delete): " + flat_list_mt.Count()); foreach(var m in flat_list_mt) { gr.DeleteMeasuerment(m.Value); //need to get measurement_id into flatlist key } da.Dispose(); dt.Dispose(); } //dt.Dump(); } Console.WriteLine("Finished generating measurmenets"); Console.WriteLine("updloading " + ids.nms.Sum(c => c.measurements.Count()) + " into New Msasurement Model"); var tasks = new List<Task>(); foreach (MeasurementType mt in ids.nms) { tasks.Add(System.Threading.Tasks.Task.Factory.StartNew(() => { gr.AddUpdateMeasurement(mt, true, 100); })); } System.Threading.Tasks.Task.WaitAll(tasks.ToArray<Task>()); Console.WriteLine("Finished "); // Console.ReadKey(); }