public Int32 BatchSqlTest()
{
List<String> sqls=new List<string>();
String sql = "";
StringBuilder builder=new StringBuilder();
for (int i = 0; i < 500; i++)
{
sql = String.Format("INSERT INTO BatchTest(ID, Code, [Name], CreatedTime) VALUES (newid(), '{0}', '{1}', getdate());",
"Code" + i, "Name" + i);
builder.Append(sql);
sqls.Add(sql);
}
Int32 result = 0;
using (DataBaseManager manager=new DataBaseManager())
{
try
{
_log.Debug("Time start one and one::");
foreach (String sqlstr in sqls)
{
manager.Exec(sqlstr);
}
_log.Debug("Time finish one and one::");
_log.Debug("Time start batch::");
result = manager.Exec(builder.ToString());
_log.Debug("Time finish batch::");
}
catch (Exception ex)
{
_log.Debug("BatchSqlTest::", ex);
}
}
return result;
}
public DataSet Query(String sql)
{
using (DataBaseManager manager = new DataBaseManager())
{
DataSet ds= manager.GetTable(sql,null);
}
return null;
}
void Start()
{
instance = this;
inventoryItemList = new List <Item>();
inventoryTapList = new List <Item>();
slots = tf.GetComponentsInChildren <InventorySlot>();
database = FindObjectOfType <DataBaseManager>();
ooc = FindObjectOfType <OkOrCancel>();
}
public void BeginTransaction()
{
if (this._idbhelper != null)
{
throw new Exception("您已经打开了一个事务，在一个事务管理实例中只能打开一次");
}
this._idbhelper = DataBaseManager.MainDb(_dbcFileName);
this._idbhelper.SetHandClose(true);
}
public UsersEditor(DataBaseManager dbm, List <Debt> debts, Main th)
{
InitializeComponent();
this.debts = debts;
this.dbm = dbm;
main = th;
PrintAllUsers();
}
public Model()
{
List <Product> initialDataBaseProducts = DataBaseManager.GetProductsFromProductTable();
_productsManager = new ProductsManager(initialDataBaseProducts);
_productTypesManager = new ProductTypesManager(initialDataBaseProducts);
_productsAndProductTypesManager = new ProductsAndProductTypesManager(_productsManager, _productTypesManager);
_order = new Order();
}
public void TestgetUserInfoReg()
{
DataBaseManager dataBaseManager = new DataBaseManager();
string userName = "******";
string passWord = "******";
bool isTrue = dataBaseManager.getUserInfoReg(userName, passWord);
Assert.IsTrue(isTrue);
}
public override void Initialize(AppController controller, Application app)
{
base.Initialize(controller, app);
_models = new AppModel();
if (!DataBaseManager.IsInitialized)
{
DataBaseManager.Initialize(timeOut, retries, retriesDelay, enableDebug);
}
}
private void InitDataBase()
{
_dataBaseManager = new DataBaseManager(_dataDir, _modelDir, _dataBaseDir,
_dataBaseName, _dilationPixel, _displayWindowNum, _isJumpMarkedData);
RefreshComboBox();
RefreshGerberWindows();
RefreshDisplayWindows();
//_aqDisplayGerberSideA.Image
}
private void LblNuevo_Click(object sender, EventArgs e)
{
this.Hide();
using (var transaction = DataBaseManager.Instance().Connection.BeginTransaction(IsolationLevel.Serializable))
{
var frmABMInsertUpdateEmpresa = new FrmABMInsertUpdateEmpresa(transaction);
frmABMInsertUpdateEmpresa.ShowDialog();
}
}
public EmployeeVM(Employee employee)
{
databaseManager = new DataBaseManager();
TakePhotoCommand = new Command(() => TakePhoto(),
() => !IsBusy);
SaveEmployeeCommand = new Command(() => SaveEmployee(),
() => !IsBusy);
SelectedEmployee = employee;
}
/// <summary>
/// 管理变量
/// </summary>
/// <param name="flowChartManager">绘图管理器</param>
/// <param name="logicData">逻辑数据</param>
/// <returns>是否操作成功</returns>
protected override bool LogicManageArguments(FlowChartManager flowChartManager, object logicData)
{
DataBaseManager dataBaseManager = DataBaseManager.GetDataBaseManager();
VarManager.Program varManager = new VarManager.Program();
varManager.Show(dataBaseManager.GetJx3webConnection());
return(true);
}
public BajaRol(ListaRol listaRol, DataBaseManager dbm, String rolname, int rolId)
{
_listaRol = listaRol;
_dbm = dbm;
_rolname = rolname;
_rolId = rolId;
InitializeComponent();
label3.Text = _rolname + "?";
}
public void TestgetUserInfoLogIn()
{
DataBaseManager dataBaseManager = new DataBaseManager();
string userName = "******";
string passWord = "******";
bool isFalse = dataBaseManager.getUserInfoLogIn(userName, passWord);
Assert.IsFalse(isFalse);
}
private void Filter_Change(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
if (FilterChips.SelectedItem != null)
{
switch (FilterChips.SelectedIndex)
{
case 0:
books.Clear();
data = DataBaseManager.BookList();
for (int i = 0; i < data.Rows.Count; i++)
{
books.Add(new Book()
{
Name = data.Rows[i][1].ToString(),
Author = data.Rows[i][2].ToString(),
Genre = data.Rows[i][3].ToString(),
PrintNumber = data.Rows[i][4].ToString(),
Count = (int)data.Rows[i][5]
});
}
break;
case 1:
books.Clear();
data = DataBaseManager.GetBorrowedBooks();
for (int i = 0; i < data.Rows.Count; i++)
{
books.Add(new Book()
{
Name = data.Rows[i][0].ToString(),
Author = data.Rows[i][1].ToString(),
Genre = data.Rows[i][2].ToString(),
PrintNumber = data.Rows[i][3].ToString(),
Count = (int)data.Rows[i][4]
});
}
break;
case 2:
books.Clear();
data = DataBaseManager.GetAvailableBooks();
for (int i = 0; i < data.Rows.Count; i++)
{
books.Add(new Book()
{
Name = data.Rows[i][0].ToString(),
Author = data.Rows[i][1].ToString(),
Genre = data.Rows[i][2].ToString(),
PrintNumber = data.Rows[i][3].ToString(),
Count = (int)data.Rows[i][4]
});
}
break;
}
}
}
private void OnOk(object parameter)
{
if (EditPersonalDetails.Password1 != EditPersonalDetails.Password2)
{
OneButtonScreen.ShowMessage("פרט שגוי", "הססמאות אינן זהות");
return;
}
if (!(EditPersonalDetails.Address.Length > 0 &&
EditPersonalDetails.Phone.Length > 0 &&
EditPersonalDetails.FirstName.Length > 0 &&
EditPersonalDetails.LastName.Length > 0))
{
OneButtonScreen.ShowMessage("פרט שגוי", "אחד או יותר מהפרטים שגויים");
return;
}
m_User.address = EditPersonalDetails.Address;
m_User.phone = EditPersonalDetails.Phone;
m_User.name = EditPersonalDetails.FirstName;
m_User.last_name = EditPersonalDetails.LastName;
if (EditPersonalDetails.Password1.Length > 0)
{
m_User.password = SecurePasswordHasher.Hash(EditPersonalDetails.Password1);
}
m_User = DataBaseManager.UpdateUser(m_User);
foreach (var item in EditPersonalDetails.LimitationsList)
{
try
{
if (item.HasChanged())
{
user_ref_limit ul = new user_ref_limit();
ul.user_id = m_User.user_id;
ul.limit_id = item.LimitID;
ul.Partial = item.LimitValue == 1;
if (item.LimitValue > 0)
{
DataBaseManager.UpdateUserPreference(ul);
}
else
{
DataBaseManager.RemoveUserPreference(ul);
}
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
m_MainWindow.GoToPrevPage();
}
IEnumerator Start()
{
player = Player.instance;
gameManager = GameManager.Instance;
dataBase = DataBaseManager.Instance;
yield return(new WaitUntil(() => rooms.Length != 0)); //wait till the game manager send the rooms to "rooms"
GenerateEnnemysSpawns();
LoadRoom("Room00", Door.Direction.none);
}
// public Button m_Bt;
// Start is called before the first frame update
void Start()
{
// m_Bt = this.transform.GetComponent<Button>();
slots = tf.GetComponentsInChildren <InventorySlot>();
theDB = FindObjectOfType <DataBaseManager>();
// m_Bt.onClick.AddListener(fClick);
usePanel.SetActive(usePanelActive);
inven = FindObjectOfType <Inventory>();
getSlotData();
}
private void Bind()
{
//string CS = ConfigurationManager.ConnectionStrings["LMSConnectionString"].ConnectionString;
//using (SqlConnection con = new SqlConnection(CS))
DataTable dt = DataBaseManager.GetEmployeeDataTable();
UserDetailsView.DataSourceID = null;
UserDetailsView.DataSource = dt;
UserDetailsView.DataBind();
}
bool IsValidUser(string username, string password)
{
dbm = new DataBaseManager((string)Session["DBpath"]);
string[] login = dbm.GetCustomerLogin(username);
if (password != login[1])
{
return(false);
}
return(true);
}
public ValidarCompra(DataBaseManager dbm, string userId, string codigoDeOferta, string precioDeOferta, string precioDeLista)
{
_dbm = dbm;
_userId = userId;
codigoOferta = codigoDeOferta;
precioOferta = precioDeOferta;
precioLista = precioDeLista;
InitializeComponent();
this.load();
}
public ProductTabPageItem(OrderForm orderFormData, Product productData)
{
_orderForm = orderFormData;
_product = productData;
_button = new Button()
{
Image = DataBaseManager.GetProductImageFromResources(_product.Id)
};
_button.Click += ClickButton;
}
public Categories()
{
category = new Category[0];
selectedOrder = null;
editMode = true;
allCategory = DataBaseManager.getInstance().getCategories();
currentPage = 1;
isFilterHide = false;
isInfoHide = false;
}
/// <summary>
/// コンストラクター
/// </summary>
public MainViewModel()
{
_bookList = WebScraping.GetWebData();
ViewChange = new ViewChangeCommand(this);
Delete = new DeleteCommand(this);
FavoriteView = false;
_dataBaseManager = new DataBaseManager();
_favoriteData = DBManager.DataBaseRead();
SetData();
}
public AltaYModifCliente(DataBaseManager dbm, String user, String pass, String rolId)
{
_dbm = dbm;
_user = user;
_pass = pass;
_rolId = rolId;
_id = -1;
InitializeComponent();
this.Text = "Alta de cliente";
}
public bool Update(ShareArticleEntity model)
{
var description = "更新分享文章";
try
{
var sql = @"update [dbo].[ShareArticle]
set
[Title]=@Title,
[ArticleUrl]=@ArticleUrl,
[ArticleType]=@ArticleType,
[CreatedTime]=@CreatedTime,
[UpdatedTime]=@UpdatedTime,
[Cover]=@Cover
Where Id=@Id
";
var sqlParameter = new List <SqlParameter> {
new SqlParameter("@Id", SqlDbType.BigInt)
{
Value = model.Id
},
new SqlParameter("@Title", SqlDbType.NVarChar)
{
Value = model.Title
},
new SqlParameter("@ArticleUrl", SqlDbType.NVarChar)
{
Value = model.ArticleUrl
},
new SqlParameter("@ArticleType", SqlDbType.Int)
{
Value = model.ArticleType
},
new SqlParameter("@CreatedTime", SqlDbType.DateTime)
{
Value = model.CreatedTime
},
new SqlParameter("@UpdatedTime", SqlDbType.DateTime)
{
Value = model.UpdatedTime
},
new SqlParameter("@Cover", SqlDbType.NVarChar)
{
Value = model.Cover
},
};
RPoney.Log.LoggerManager.Debug(GetType().Name, $"{description}sql:{sql},参数:model{model.SerializeToJSON()}");
return(DataBaseManager.MainDb().ExecuteNonQuery(sql, sqlParameter.ToArray()) > 0);
}
catch (Exception ex)
{
RPoney.Log.LoggerManager.Error(GetType().Name, $"{description}异常", ex);
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox1.Text;
string age = TextBox2.Text;
string mobile = TextBox3.Text;
string gender = RadioButtonList1.SelectedItem.Text;
string email = TextBox4.Text;
string password = TextBox5.Text;
CryptoGraphy cg = new CryptoGraphy();
password = cg.MD5Hash(password);
string specialmedical = TextBox6.Text;
Random rnd = new Random();
string otp = rnd.Next(100000, 999999).ToString();
bool otpstatus = false;
string date = DateTime.Now.ToString("MM/dd/yyyy");
string time = DateTime.Now.ToString("HH:mm:ss");
DataBaseManager dbm = new DataBaseManager();
string checkemail = "select * from RegistrationTbl where Email='" + email + "'";
DataTable dt = new DataTable();
dt = dbm.ExecuteSelect(checkemail);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('Email ID is already registered. Please use another Email ID')</script>");
}
else
{
string query = "insert into RegistrationTbl(Name,Age,Mobile,Gender,Email,Password,SpecialMedicalCondition,OTP,OTPStatus,Date,Time) values('" + name + "','" + age + "','" + mobile + "','" + gender + "','" + email + "','" + password + "','" + specialmedical + "','" + otp + "','" + otpstatus + "','" + date + "','" + time + "')";
if (dbm.ExecuteIUD(query))
{
// send OTP and Redirect to OTP Verification page
SMSSender sms = new SMSSender();
string message = "Dear " + name + ", Your OTP Verification Code is - " + otp;
bool smsst = sms.SendSMS(mobile, message);
// Create Session for OTP Verification
Session["RegEmail"] = email;
Response.Write("<script>alert('Data Saved. We have sent you OTP Code, Please enter to proceed.'); window.location.href='OTPVerification.aspx';</script>");
}
else
{
// Query Error
Response.Write("<script>alert('Something went wrong, please try again leter, some technical issue.')</script>");
}
}
}
/// <summary>
/// 选择确定
/// </summary>
/// <param name="sender">事件发送者</param>
/// <param name="e">事件参数</param>
private void buttonX1_Click(object sender, EventArgs e)
{
bool editSuccess = false;
DataBaseManager dataBaseManager = DataBaseManager.GetDataBaseManager();
chartName = textBoxX1.Text;
if (chartName != "")
{
string fullPath = string.Format("{0}\\{1}", currentPath, chartName);
if (radioButton1.Checked) // 创建新AI图
{
string originID = dataBaseManager.CreateNewDiagram(fullPath, false, "AI图");
chartID = originID;
string destinID = "311";
if (originID != null)
{
editSuccess = dataBaseManager.CopyDiagramData(originID, destinID);
}
}
else // 从模板复制
{
string modelName = comboBoxEx1.Text;
if (modelName != "")
{
string originID = dataBaseManager.CreateNewDiagram(fullPath, false, "AI图");
chartID = originID;
string destinID = modelTable[modelName] as string;
if (originID != null)
{
editSuccess = dataBaseManager.CopyDiagramData(originID, destinID);
}
}
else
{
MessageBox.Show("复制模板不能为空！", "新建绘图", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("绘图名称不能为空！", "新建绘图", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
if (editSuccess)
{
DialogResult = DialogResult.OK;
this.Close();
}
}
public void ClickToCheckAnswer()
{
DragNDropObject = new Refresh();
Debug.Log("Button Clicked!");
correctAnswer = FractionSelect.answerToBeChecked;
enteredAnswer = FractionIdentificator.enteredAnswer;
Debug.Log("Correct answer is: " + correctAnswer);
Debug.Log("Entered answer is: " + enteredAnswer);
if (correctAnswer == enteredAnswer)
{
Transform child = Numerator.gameObject.transform.GetChild(0);
child.SetParent(Numbers.transform);
Transform child2 = Denominator.gameObject.transform.GetChild(0);
child2.SetParent(Numbers.transform);
rightAnswerAudio.Play();
Debug.Log("Answer is Correct!");
foreach (GameObject i in dragNdDropComponentsToActivate)
{
i.SetActive(false);
}
foreach (Slider i in dragNdropReducedSliders)
{
i.gameObject.SetActive(false);
}
FractionSelect.stopwatchDnD.Stop();
FractionSelect.totalStopwatch.Stop();
float timeTaken = 0.001f * FractionSelect.stopwatchDnD.ElapsedMilliseconds;
float totalTimeTaken = 0.001f * FractionSelect.totalStopwatch.ElapsedMilliseconds;
FractionSelect.stopwatchDnD.Reset();
FractionSelect.totalStopwatch.Reset();
DataBaseManager.writeSuccess(UserClass.player.givenFraction, UserClass.player.enteredFraction, UserClass.player.enteredRFraction, enteredAnswer, 1, timeTaken, totalTimeTaken);
}
else
{
FractionSelect.stopwatchDnD.Stop();
FractionSelect.totalStopwatch.Stop();
float timeTaken = 0.001f * FractionSelect.stopwatchDnD.ElapsedMilliseconds;
FractionSelect.stopwatchDnD.Reset();
wrongAnswerAudio.Play();
Debug.Log("Answer is not correct!");
DataBaseManager.writeSuccess(UserClass.player.givenFraction, UserClass.player.enteredFraction, UserClass.player.enteredRFraction, enteredAnswer, 0, timeTaken, 0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ticket = Request["ticket"].ToString();
Session["DBPath"] = Server.MapPath(dbRelativePath);
dbm = new DataBaseManager((string)Session["DBpath"]);
GetCustomers();
DisplayCustomers();
GetSalesReceipts();
DisplaySalesReceipts();
SetTimer();
}
public void index(IOwinContext owinContext)
{
var response = owinContext.Response;
var request = owinContext.Request;
if (request.Method == "GET")
{
response.StatusCode = 200;
response.ContentType = "text/html;charset=UTF-8";
response.Write(File.ReadAllBytes("./index.html"));
}
else if (request.Method == "POST")
{
response.StatusCode = 200;
response.ContentType = "text/plain;charset=UTF-8";
using (var sr = new StreamReader(request.Body))
{
try
{
var database = DataBaseManager.CreateSingleInstace();
database.Server = ".";
database.UserName = "******";
database.PassWord = "******";
database.SqlType = SqlType.MsSql;
database.DataBaseName = "master";
database.ModelManager.Register(new TestModel());
var r = sr.ReadToEnd();
var forms = r.Split('&');
var dic = new Dictionary <string, string>();
foreach (var name in forms)
{
var param = name.Split('=');
dic.Add(param[0], HttpUtility.UrlDecode(param[1]));
}
if (dic.ContainsKey("create"))
{
database.Create(dic["databasename"]);
response.Write("完成创建数据库");
}
else
{
database.Upgrade(dic["databasename"]);
response.Write("完成升级数据库");
}
}
catch (Exception ex)
{
response.Write($"系统异常：{ex.Message}");
}
}
}
}
public AltaYModifProveedor(DataBaseManager dbm, String user, String pass, String rolId)
{
_dbm = dbm;
_user = user;
_pass = pass;
_rolId = rolId;
_id = -1;
InitializeComponent();
this.Text = "Alta de proveedor";
cargarRubros();
}
/// <summary>
/// 初始化数据
/// </summary>
private void InitData()
{
dataBaseManager = DataBaseManager.GetDataBaseManager();
lsTable = dataBaseManager.GetLSInformation();
scriptTable = dataBaseManager.GetScriptInformation();
if((lsTable != null) && (scriptTable != null)) // 数据表非空
{
// 添加下拉框内容
List<string> lsClassification = dataBaseManager.GetLSClassification();
foreach(string s in lsClassification)
{
comboBoxEx1.Items.Add(s);
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtEmail.Text != null & txtEmail.Text != null)
{
string email = txtEmail.Text;
string passHTML = txtPassword.Text;
DataBaseManager d = new DataBaseManager();
if (d.VerifyUserPass(email, passHTML))//(sql==txtPassword.Text)
{
Session["Email"] = email;
Response.Redirect("DashBoard.aspx");
}
else
{
Response.Write("<script LANGUAGE='JavaScript' >alert('שגיעת התחברות. נסה שנית..')</script>");
}
}
}
/// <summary>
/// call the db class to get all theexisting products in a category
/// </summary>
/// <param name="id">the category id</param>
/// <returns>dictionary of product name and uniq id</returns>
public Dictionary<string, int> GetAllCategoryProducts(string id)
{
DataBaseManager db = new DataBaseManager();
return db.GetAllCategoryProducts(id);
}
public int DeleteCampaign(int campaignId)
{
DataBaseManager db = new DataBaseManager();
return db.DeleteCampaign(campaignId);
}
/// <summary>
///call the db class to get the general users gender statistic
/// </summary>
/// <param name="managerEmail">manager's email for identification</param>
/// <returns>dictionary of male and female count</returns>
public Dictionary<string, int> getGenderStatistics(string email)
{
DataBaseManager db = new DataBaseManager();
return db.getGenderStatistics(email);
}
public int insertNewOrg(Manager m, Organization o)
{
DataBaseManager db = new DataBaseManager();
return db.insertNewOrg(m, o);
}
/// <summary>
/// calls the db class to get the campaigns share count
/// </summary>
/// <param name="managerEmail">manager's email for identification</param>
/// <returns>a list of campaigns and their share count</returns>
public Dictionary<string, int> getCampaignsShare(string managerEmail)
{
DataBaseManager db = new DataBaseManager();
Dictionary<string,int> campaigns = db.GetCampaignsShare(managerEmail);
return campaigns;
}
public string deleteProduct(string email, string productId)
{
DataBaseManager db = new DataBaseManager();
return db.deleteProduct(email, productId);
}
/// <summary>
/// call the db class to get the basic info (not incude properties) of all the existing products of an organization
/// </summary>
/// <param name="managerEmail">manager email for identification</param>
/// <returns>a list of product objects</returns>
public List<Product> GetAllProductInfoBasic(string email)
{
DataBaseManager db = new DataBaseManager();
return db.GetAllProductInfoBasic(email);
}
/// <summary>
/// call the db class to insert a new category to the db
/// </summary>
/// <param name="c">object of the new category</param>
/// <param name="lProperty">an array of the properties</param>
/// <param name="email">manager email for identification</param>
/// <returns>num of rows changed</returns>
public int insertNewCategory(Category c, string[] lProperty, string email)
{
DataBaseManager db = new DataBaseManager();
return db.insertNewCategory(c, lProperty, email);
}
/// <summary>
/// call the db class to get the history of products scan by users
/// </summary>
/// <param name="productCounter">the uniq id of the organization's product</param>
/// <returns>a gridview of the details</returns>
public GridView GetHistoryScan(int productCounter)
{
DataBaseManager db = new DataBaseManager();
return db.GetHistoryScan(productCounter);
}
private Double CalcRatio(String gameId, Int32 batterId, Int32 pitcherId)
{
String mon = gameId.Substring(4, 2);
try
{
dbMgr = new DataBaseManager();
// 1 투수를가져온다.
var players = dbMgr.SelectAll<Player>();
var pitcher = (from p in players
where p.PlayerId == pitcherId
select p).First();
// 타자를 가져온다.
var batter = (from p in players
where p.PlayerId == batterId
select p).First();
var matchs = dbMgr.SelectAll<Match>();
var schedules = dbMgr.SelectAll<Schedule>();
var ths = dbMgr.SelectAll<Th>();
var bats = dbMgr.SelectAll<Bat>();
var pitcherBats = from m in matchs
join s in schedules
on m.GameId equals s.GameId
join t in ths
on m.Id equals t.MatchId
join b in bats
on t.Id equals b.ThId
join ph in players
on b.HitterId equals ph.PlayerId
where b.PitcherId == pitcher.PlayerId && m.GameId.Substring(4, 2) == mon
&& ph.Hand.Substring(2, 2) == batter.Hand.Substring(2, 2)
select b;
// 투수 확률
var resultPitcher = from p in pitcherBats
group p by p.PitcherId into g
select new
{
HitCount = g.Sum(x => x.PResult == PResultType.Hit ? 1 : 0),
TotalCount = g.Sum(x => 1),
Ratio = Math.Round(g.Sum(x => x.PResult == PResultType.Hit ? 1 : 0) * 1.0
/ g.Sum(x => 1), 3, MidpointRounding.AwayFromZero)
};
var batterBats = from m in matchs
join s in schedules
on m.GameId equals s.GameId
join t in ths
on m.Id equals t.MatchId
join b in bats
on t.Id equals b.ThId
join pp in players
on b.PitcherId equals pp.PlayerId
where b.HitterId == batter.PlayerId
&& pp.Hand.Substring(0, 2) == pitcher.Hand.Substring(0, 2)
&& m.GameId.Substring(4, 2) == mon
select b;
// 타자 확률
var resultBatter = from p in batterBats
group p by p.HitterId into g
select new
{
HitCount = g.Sum(x => x.PResult == PResultType.Hit ? 1 : 0),
TotalCount = g.Sum(x => 1),
Ratio = Math.Round(g.Sum(x => x.PResult == PResultType.Hit ? 1 : 0) * 1.0
/ g.Sum(x => 1), 3, MidpointRounding.AwayFromZero)
};
Int32 분모 = 0;
double 분자 = 0;
if (resultPitcher.Count() > 0)
{
if (resultPitcher.First().TotalCount > 10)
{
분모++;
분자 += resultPitcher.First().Ratio;
}
}
if (resultBatter.Count() > 0)
{
if (resultBatter.First().TotalCount > 10)
{
분모++;
분자 += resultBatter.First().Ratio;
}
}
if (분모 == 1)
{
return (분자 / 분모) * 0.7;
}
else if (분모 == 2)
{
return (분자 / 분모);
}
}
catch
{
}
return 0;
}
private void button2_Click(object sender, EventArgs e)
{
dbMgr = new DataBaseManager();
var players = dbMgr.SelectAll<Player>();
// 1. 날짜를 읽어온다.
var pickResults = dbMgr.SelectAll<PickResult>();
var dates = from result in pickResults
group result by result.GameDate into g
select new
{
g.Key
};
List<Result> results = new List<Result>();
foreach(var date in dates)
{
Result result = new Result();
result.Picks = new List<string>();
result.Successes = new List<string>();
result.Date = date.Key;
var picks = from r in pickResults
join p in players
on r.PlayerId equals p.PlayerId
where r.GameDate == result.Date
select p;
foreach (var pick in picks)
{
result.Picks.Add(pick.Name);
// 결과 얻어오기
Int32 hitCount = GetHitCount(result.Date, pick);
result.Successes.Add(hitCount.ToString());
}
results.Add(result);
}
dgTest.DataSource = results;
}
/// <summary>
///call the db class to get all the existing industries
/// </summary>
/// <returns> returen a list of industries</returns>
public List<Industry> GetAllIndustries()
{
DataBaseManager db = new DataBaseManager();
return db.GetAllIndustries();
}
public string GetProductCounter(string email, string productID)
{
DataBaseManager db = new DataBaseManager();
return db.GetProductCounterWithEmail(email, productID);
}
/// <summary>
/// gets the 5 most scaned products
/// </summary>
/// <param name="managerEmail">manager email for identification</param>
/// <returns>a dictionary of product name and amount</returns>
public Dictionary<string, int> Top5ScanedProducts(string managerEmail)
{
DataBaseManager db = new DataBaseManager();
return db.Top5ScanedProducts(managerEmail);
}
/// <summary>
/// calls the db class to get a list of fb campaigns and their info from the db to show at the campaign table
/// </summary>
/// <param name="email">manager's email for identification</param>
/// <returns>a list of campaigns objects</returns>
public List<Campaign> GetCampaignList(string email)
{
DataBaseManager db = new DataBaseManager();
List<Campaign> campaigns = db.GetCampaignsList(email);
return campaigns;
}
/// <summary>
/// call the db class to get product most viewed properties
/// </summary>
/// <param name="productCounter">the uniq id of the organization's product</param>
/// <returns>grid view of the details</returns>
public GridView productPropertiesStatistics(int productCounter)
{
DataBaseManager db = new DataBaseManager();
return db.productPropertiesStatistics(productCounter);
}
/// <summary>
/// call the db class to gets the 5 most scaned categoreis
/// </summary>
/// <param name="managerEmail">manager email for identification</param>
/// <returns>a dictionary of category name and amount</returns>
public Dictionary<string, int> proc_5mostScanedCategories(string email)
{
DataBaseManager db = new DataBaseManager();
return db.proc_5mostScanedCategories(email);
}
/// <summary>
/// call the db class to insert a new product into the db && the properties description to the db
/// </summary>
/// <param name="product">new product's object</param>
/// <param name="categoryID">the category to which the product belong</param>
/// <param name="pp">the properties of the product</param>
/// <param name="emailManager">manager email for identification</param>
/// <returns>num of rows changed</returns>
public int insertNewProduct(Product product, int categoryName, Dictionary<int, string> pp, string emailManager)
{
DataBaseManager db = new DataBaseManager();
return db.insertNewProduct(product, categoryName, pp, emailManager);
}
/// <summary>
/// call the db class to get a gender count from the db of the users who shared a campiagn
/// </summary>
/// <param name="managerEmail">the manager's email for identification</param>
/// <returns>dictionary of male and female count</returns>
public Dictionary<string, int> GetCampignsShareGender(string email)
{
DataBaseManager db = new DataBaseManager();
return db.GetCampaignShareGender(email);
}
/// <summary>
/// call the db class to get general details about the users
/// </summary>
/// <param name="managerEmail">manager email for identification</param>
/// <returns>gridview of details</returns>
public GridView GeneralDetailsPlots(string managerEmail)
{
DataBaseManager db = new DataBaseManager();
return db.GeneralDetailsPlots(managerEmail);
}
/// <summary>
/// call the db class to gets all the proporties of an existing catagory
/// </summary>
/// <param name="categoryID">id of the specific category</param>
/// <returns>dictionary of property name and id</returns>
public Dictionary<string, int> getCategoryProperties(int categoryID)
{
DataBaseManager dbs = new DataBaseManager();
return dbs.getCategoryProperties(categoryID);
}
/// <summary>
/// calls the db class to get info about the current active campaign
/// </summary>
/// <param name="managerEmail">manager's email for identification</param>
/// <returns>a grid of data about the active campaign</returns>
public GridView getActiveCampaignStatistics(string managerEmail)
{
DataBaseManager db = new DataBaseManager();
return db.getActiveCampaignStatistics(managerEmail);
}
/// <summary>
/// call the db class to get the properties info of a specific product from the db
/// </summary>
/// <param name="managerEmail">manager's email for identification</param>
/// <param name="productId">to select a specific product from the db</param>
/// <returns>a list of the product info</returns>
public List<Property> GetProductPropertiesInfo(string managerEmail, int productId)
{
DataBaseManager db = new DataBaseManager();
return db.GetProductPropertiesInfo(managerEmail,productId);
}
/// <summary>
/// call the db class to get the existing catagories names
/// </summary>
/// <param name="managerEmail">manager email for identification</param>
/// <returns>dictionary of category name and id</returns>
public Dictionary<string, int> getCategoriesNames(string managerEmail)
{
DataBaseManager dbs = new DataBaseManager();
return dbs.getCategoriesNames(managerEmail);
}
/// <summary>
/// call the db class to get the profile info about the organization
/// </summary>
/// <param name="emailAddress">manager email for identification</param>
/// <returns>an organization object</returns>
public Organization getComapnyProfile(string emailAddress)
{
DataBaseManager db = new DataBaseManager();
Organization org = db.getComapnyProfile(emailAddress);
return org;
}
public int insertNewCampaign(Campaign campaign, string email)
{
DataBaseManager db = new DataBaseManager();
return db.insertNewCampaign(campaign, email);
}
