public ActionResult Create(CreateChart Chart) { if (ModelState.IsValid) { string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;"; string CHART_ID; using (OracleConnection connection = new OracleConnection(connectionString)) { string number = null; number = ""; OracleCommand cmd1 = new OracleCommand(); cmd1.CommandType = CommandType.Text; cmd1.CommandText = "select nvl(max(substr(CHART_ID,7,3)),0) from KMIINTRANET_MASTER_CHART where substr(CHART_ID,1,6)='" + Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + "'"; cmd1.Connection = connection; connection.Open(); objDataReader = cmd1.ExecuteReader(); if (objDataReader.HasRows) { objDataReader.Read(); number = Convert.ToString(Convert.ToInt32(objDataReader[0]) + 1); if (number.Length == 1) { number = "00" + number; } else if (number.Length == 2) { number = "0" + number; } else if (number.Length == 3) { number = number; } } cmd1 = null; connection.Close(); OracleCommand cmd2 = new OracleCommand(); CHART_ID = Convert.ToDateTime(System.DateTime.Now).ToString("yyyyMM") + number; byte[] tempFile = new byte[Chart.ChartFile.InputStream.Length]; Chart.ChartFile.InputStream.Read(tempFile, 0, tempFile.Length); cmd2.CommandText = "INSERT INTO KMIINTRANET_MASTER_CHART(CHART_ID,CHART_TITLE,CHART_FILE,CREATE_BY,CREATE_DATE) VALUES (:chartid,:title,:chartfile,'" + Session["USER"] + "',sysdate)"; cmd2.CommandType = CommandType.Text; cmd2.Connection = connection; connection.Open(); cmd2.Parameters.Add(":chartfile", OracleType.Blob).Value = tempFile; cmd2.Parameters.Add(":title", OracleType.VarChar).Value = Chart.title.ToString(); cmd2.Parameters.Add(":chartid", OracleType.VarChar).Value = CHART_ID; cmd2.ExecuteNonQuery(); cmd2 = null; connection.Close(); return(RedirectToAction("Index")); } } return(View()); }
public MethodsEquationsForm() { InitializeComponent(); functions = new MethodsEquations(textBox1, textBox2, textBox3, textBox4); createChart = new CreateChart(ChartPanel); foreach (Control tbx in Controls) { if (tbx.GetType() == typeof(TextBox)) { tbx.TextChanged += tbx_TextChanged; } } textBox1.KeyDown += TextBox1_KeyDown; //textBox1.TextChanged += TextBox1_TextChanged; }