public static List <InstScoreTable> getInstScore(string INSTNO, string itemNo, string evalYear) { List <InstScoreTable> listData = new List <InstScoreTable>(); try { MysqlDBA <InstScoreTable> dbaHRAlloc = new MysqlDBA <InstScoreTable>(FunctionController.CONNSTR); DataSet ds = dbaHRAlloc.getDataSet(string.Format("SELECT * FROM InstScoreTable WHERE INSTNO='{0}' AND EvalYear='{1}' AND ItemNo='{2}'", INSTNO, evalYear, itemNo)); foreach (DataRow row in ds.Tables[0].Rows) { InstScoreTable data = new InstScoreTable(); data.EvalYear = row["EvalYear"].ToString(); data.INSTNO = row["INSTNO"].ToString(); data.ItemNo = row["ItemNo"].ToString(); data.SelfScore = row["SelfScore"].ToString(); data.EvalScore = row["EvalScore"].ToString(); data.EvalDesc = row["EvalDesc"].ToString(); data.EvalDate = row["EvalDate"].ToString(); data.SelfDate = row["SelfDate"].ToString(); listData.Add(data); } } catch (Exception ex) { throw ex; } return(listData); }
public ActionResult Calc(FormCollection formData) { MysqlDBA <InstScoreTable> mysqlDBA = new MysqlDBA <InstScoreTable>(FunctionController.CONNSTR); try { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } string accountNo = Session["INSTNO"].ToString(); string year = (DateTime.Now.Year - 1911).ToString(); InstScoreTable instScore = new InstScoreTable(); foreach (var key in formData.AllKeys) { if (key.IndexOf("Score") != -1) { string value = formData[key].ToString(); if (!string.IsNullOrEmpty(value)) { double score = double.Parse(value); instScore = new InstScoreTable(); instScore.EvalYear = year; instScore.INSTNO = accountNo; instScore.ItemNo = key.Replace("Score", ""); instScore.SelfScore = score.ToString(); instScore.SelfDate = DateTime.Now.ToString("yyyy-MM-dd"); instScore.EvalScore = "0"; instScore.EvalDate = "1900-01-01"; mysqlDBA.InsertOrUpdate(instScore); } } } } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "SelfRate", null)); } return(RedirectToAction("Index", "Meeting")); }