public ActionResult DeletePo(string id) { dbHelper dbq = new dbHelper(); dbq.execSql("delete from jobPoes where poNo='" + id + "'"); return(RedirectToAction("Details", "Dep", new { id = Request["depNo"].ToString() })); }
internal void Process() { dbHelper helper = new dbHelper(); helper.UpdateMissedData(); FillSettings(); if (settings != null) { double timerInterval = 10; double.TryParse(settings["EmailSendInterval"], out timerInterval); int.TryParse(settings["ThreadCount"], out thread_count); if (timerInterval == 0) { timerInterval = 0.1; } collection = new List <mailDetails>(); emailerTimer = new System.Timers.Timer(); emailerTimer.Elapsed += new System.Timers.ElapsedEventHandler(GetMail); emailerTimer.Interval = 60000 * timerInterval; emailerTimer.Enabled = true; emailerTimer.AutoReset = true; emailerTimer.Start(); } }
protected void ButtonPlay_Click(object sender, EventArgs e) { if (Page.IsValid) { if (dt.Rows.Count > 0) { Flows playflow = SaveFlow(); if (playflow != null) { FlowInstances currentFlow = new FlowInstances(); dbHelper helper = new dbHelper(); DataRow firstRow = dt.Rows[0]; Actions startAction = helper.GetActionById(firstRow["Id"].ToString()); currentFlow.Actions = startAction; currentFlow.CurrentPosition = 1; currentFlow.Users = playflow.Users; currentFlow.Flows = playflow; helper.AddToModel(currentFlow); Session["currentInstance"] = currentFlow; Server.Transfer(currentFlow.Actions.ActionPage); } } } }
public void insertCar(dbHelper db) { Console.Write("Add new car:\n"); Console.Write("id:\n"); string id = Console.ReadLine(); Console.Write("brand:\n"); string brand = Console.ReadLine(); Console.Write("model:\n"); string model = Console.ReadLine(); Console.Write("price:\n"); int price; try { price = Convert.ToInt32(Console.ReadLine()); } catch (Exception e) { price = 100; } Console.Write("location:\n"); string location = Console.ReadLine(); Car car = new Car(); db.insertCar(id, brand, model, price, location, car); Console.Read(); Console.Read(); }
public void changeCar(dbHelper db) { Console.Write("Enter idCar for change:\n"); string id = Console.ReadLine(); db.selectCar(id); Console.Write("Enter new brand:\n"); string brand = Console.ReadLine(); Console.Write("Enter new model:\n"); string model = Console.ReadLine(); Console.Write("Enter new price:\n"); int price; try { price = Convert.ToInt32(Console.ReadLine()); } catch (Exception e) { price = 100; } Console.Write("Enter new location:\n"); string location = Console.ReadLine(); db.updateCar(id, brand, model, price, location); db.selectCar(id); Console.Read(); Console.Read(); }
public ActionResult DeleteSub(string hid, string hpid) { dbHelper dbh = new dbHelper(); dbh.execSql("delete from FlowDefSub where id='" + hid + "'"); return(RedirectToAction("SetupFlow", new { id = hpid })); }
public userService(dbHelper context, IRepository <userModel> userService, IAddressService addressService, IMapper mapper) { _dbContext = context; _userService = userService; _addressService = addressService; _mapper = mapper; }
public RentCar() { InitializeComponent(); db = new dbHelper(); db.openDb(); totalPrice = 0; }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (Page.IsValid) { if (e.CommandName == "Select") { Users newUser; dbHelper helper = new dbHelper(); newUser = helper.GetUserbyName(TextBoxUser.Text); if (newUser == null) { newUser = new Users(); newUser.UserName = TextBoxUser.Text; newUser.UserType = "local"; newUser.SNUserId = "local" + TextBoxUser.Text; helper.AddToModel(newUser); } Session["user"] = newUser; WebControl wc = e.CommandSource as WebControl; GridViewRow row = wc.NamingContainer as GridViewRow; Session["UseCaseStartTime"] = DateTime.Now; Session["UseCaseNumber"] = row.RowIndex + 1; Session["UseCaseText"] = row.Cells[1].Text; Server.Transfer("Design.aspx"); } } }
public ActionResult SaveList(int year, List <vwDayOffSum> data) { dbHelper dbh = new dbHelper(); DataTable tb = new DataTable(); tb = dbh.sql2tb("select workNo,m,v1 from dayOffSums where y = " + year.ToString() + " and sType='a'"); List <string> sqlList = new List <string>(); foreach (vwDayOffSum item in data) { List <decimal> vlist = new List <decimal>(); vlist.Add(item.m0a); vlist.Add(item.m1a); vlist.Add(item.m2a); vlist.Add(item.m3a); vlist.Add(item.m4a); vlist.Add(item.m5a); vlist.Add(item.m6a); vlist.Add(item.m7a); vlist.Add(item.m8a); vlist.Add(item.m9a); vlist.Add(item.m10a); vlist.Add(item.m11a); vlist.Add(item.m12a); for (int i = 0; i < vlist.Count; i++) { foreach (DataRow row in tb.Rows) { if (row["workNo"].ToString() == item.workNo && row["m"].ToString() == i.ToString() && ((Convert.ToDecimal(row["v1"]) - vlist[i]) != 0) ) { sqlList.Add( string.Format( "update dayOffSums set v1 = {0} where y = {1} and m = {2} and sType = 'a' and workNo = '{3}';", vlist[i], year, i, item.workNo ) ); break; } if (sqlList.Count == 10) { dbh.execSql(string.Join(" ", sqlList)); sqlList.Clear(); } } } } if (sqlList.Count > 0) { dbh.execSql(string.Join(" ", sqlList)); } dynamic r = new ExpandoObject(); r.success = true; return(Content(JsonConvert.SerializeObject(r), "application /json")); }
public App(string dbPath) { InitializeComponent(); dbHelper = new dbHelper(dbPath); MainPage = new NavigationPage(new MainPage()); }
public ActionResult Delete(string id) { dbHelper dbh = new dbHelper(); dbh.execSql("update dbo.AspNetUsers set status=0,workNo=workNo+'-remove' where Id='" + id + "'"); return(RedirectToAction("Index")); }
public ActionResult Delete(string hid) { dbHelper dbh = new dbHelper(); dbh.execSql("delete from jobpoes where depNo='" + hid + "'"); dbh.execSql("delete from deps where depNo='" + hid + "'"); //dbh.execSql("delete from PoUsers where poNo in (select poNo from jobPoes)"); return(RedirectToAction("Index")); }
public void deleteCar(dbHelper db) { Console.Write("Car's brand for removing:\n"); string brand = Console.ReadLine(); db.deleteCar(brand); Console.Read(); Console.Read(); }
protected void Button2_Click(object sender, EventArgs e) { dbHelper helper = new dbHelper(); Users currentUser = new Users(); currentUser = helper.GetTestUser(); Session["user"] = currentUser; Server.Transfer("Design.aspx"); }
public String GetActionOutput(String actionId) { dbHelper helper = new dbHelper(); List<ActionOutputs> outputs = helper.GetActionOutputsForAction(actionId); if (outputs.Count > 0) return outputs[0].OutputObject; else return String.Empty; }
public Auth() { InitializeComponent(); db = new dbHelper(); db.openDb(); passTextBox.MaxLength = 8; passTextBox.PasswordChar = '*'; passTextBox.CharacterCasing = CharacterCasing.Lower; }
public void findCar(dbHelper db) { Console.Write("Car's brand:\n"); string brand = Console.ReadLine(); List <Car> cars = new List <Car> { }; db.findCar(brand, cars); Console.Read(); Console.Read(); }
public Boolean isGMDep() { dbHelper dbh = new dbHelper(); string sql = @"select count(b.depNo) as cnt from PoUsers a inner join jobPoes b on a.poNO=b.poNo inner join deps c on b.depNo=c.depNo where a.UserId='@workno' and a.applicationUser_id is not null and b.depNo='001'"; sql = sql.Replace("@workno", this.emp.workNo); return(dbh.sql2count(sql) > 0); }
public void changeClientPhone(dbHelper db) { Console.Write("Client's passport:\n"); string id = Console.ReadLine(); Console.Write("New phone:\n"); string phone = Console.ReadLine(); db.changeClientDataPhone(id, phone); Console.Read(); Console.Read(); }
void updateDetails(mailDetails mail, bool Cancelled, Exception Error) { try { string error = null; var updateData = mail.mail; int int_failed_count = 0; if (updateData.int_failed_count != null) { int_failed_count = updateData.int_failed_count.Value; } int int_satues = 0; if (!Cancelled && Error == null) { updateData.dt_send_date = DateTime.Now; int_satues = 255; } else { int_satues = -1; logHelper.LogException(Error, main_path); if (Error != null) { if (Error.InnerException != null) { error = Error.InnerException.Message; } else { error = Error.Message; } } int_failed_count++; } updateData.str_error = error; updateData.int_status = int_satues; updateData.int_failed_count = int_failed_count; dbHelper helper = new dbHelper(); if (helper.UpdateData(updateData)) { collection.Remove(mail); } } catch (Exception er) { logHelper.LogException(er, main_path); } }
public Regist() { InitializeComponent(); db = new dbHelper(); db.openDb(); passdRegTextBox.MaxLength = 8; passdRegTextBox.PasswordChar = '*'; passdRegTextBox.CharacterCasing = CharacterCasing.Lower; confPassRegTextBox.MaxLength = 8; confPassRegTextBox.PasswordChar = '*'; confPassRegTextBox.CharacterCasing = CharacterCasing.Lower; }
public void changeCarLocation(dbHelper db) { Console.Write("Car's number:\n"); string num = Console.ReadLine(); Console.Write("New car's location:\n"); string loc = Console.ReadLine(); db.changeCarLocation(num, loc); Console.Read(); Console.Read(); }
private void WorkerThreadFunc() { if (settings != null && true) { dbHelper helper = new dbHelper(); string smtpEmailAddress = settings["SMTPUserName"]; string smtpPassword = settings["SMTPPassword"]; // string fromEmail = settings["FromEmail"]; // string fromDisplayName = settings["FromDisplayName"]; string smtpClientHost = settings["SMTPHostName"]; int smtoClientPort = int.Parse(settings["SMTPHostPort"]); bool enableSsl = bool.Parse(settings["EnableSSL"]); bool useDefaultCredentials = bool.Parse(settings["UseDefaultCredentials"]); int emailForBulk = 50, reTryTime = 5; int.TryParse(settings["EmailForBulk"], out emailForBulk); int.TryParse(settings["ReTryTime"], out reTryTime); var databundle = helper.GetmailBulk(DateTime.Now, emailForBulk); var notsendbundle = helper.GetFailedBulk(reTryTime); if (databundle != null) { databundle.AddRange(notsendbundle); } else { databundle = notsendbundle; } if (databundle != null) { helper.SetSettingFromKey("LastRunTime", DateTime.Now.ToString()); Parallel.ForEach(databundle, item => { string newGuid = Guid.NewGuid().ToString(); var mail = new mailDetails() { guid = newGuid, mail = item }; collection.Add(mail); sendEmail(mail, smtpEmailAddress, smtpPassword, smtpClientHost, smtoClientPort, enableSsl, useDefaultCredentials); }); } } current_thread_count--; if (!emailerTimer.Enabled) { emailerTimer.Start(); } }
public void deleteRent(dbHelper db) { Console.Write("Rent's num:\n"); try { int num = Convert.ToInt32(Console.ReadLine()); db.deleteRent(num); } catch (Exception e) { Console.Write("Not corrct data:\n"); } Console.Read(); Console.Read(); }
public void findCarById(dbHelper db) { Console.Write("Car's id:\n"); string location = Console.ReadLine(); Car car = db.findCar(location); if (car != null) { Console.Write(car.id + " " + car.location + "\n"); } else { Console.Write("Car doesn't exist\n"); } Console.Read(); Console.Read(); }
protected void ButtonNext_Click(object sender, EventArgs e) { dbHelper helper = new dbHelper(); FlowInstances currentFlow = (FlowInstances)Session["currentInstance"]; Actions next = helper.GetNextAction(currentFlow.Flows.FlowId, currentFlow.CurrentPosition); if (next == null) { Server.Transfer("End.aspx"); } else { FlowInstances flowInstance = helper.GetFlowInstanceById(currentFlow.FlowInstanceId); flowInstance.CurrentPosition++; flowInstance.Actions = next; helper.UpdateChanges(); Session["currentInstance"] = flowInstance; Server.Transfer(flowInstance.Actions.ActionPage); } }
public void rentCar(dbHelper db) { string passport = Console.ReadLine(); string fullName = Console.ReadLine(); string phone = Console.ReadLine(); db.addClient(passport, fullName, phone); string carId = Console.ReadLine(); int duration; try { duration = Convert.ToInt32(Console.ReadLine()); } catch (Exception e) { duration = 0; } string from = Console.ReadLine(); string to = Console.ReadLine(); db.createRent(passport, carId, this, from, to, duration); }
private void authButton_Click(object sender, EventArgs e) { String login = loginTextBox.Text; String pass = passTextBox.Text; User user = null; if (login.Equals("admin")) { user = new Admin(); user.login = login; user.password = pass; } else { user = new Manager(); user.login = login; user.password = pass; } if (db.getConn().State.ToString().Equals("Closed")) { db = new dbHelper(); db.openDb(); } if (db.authorisation(login, pass, user) != null) { user = db.authorisation(login, pass, user); new RentCar(user, this).Show(); db.close(); this.Hide(); } else { MessageBox.Show("Error! Not correct data"); loginTextBox.Text = ""; passTextBox.Text = ""; } }
private void createActionTable(String actionType, DataTable dt) { dbHelper helper = new dbHelper(); List<ActionInputs> actionsInput; List<ActionOutputs> actionsOutput; List<Actions> actionsType = helper.GetActionsByType(actionType); foreach (Actions itemAction in actionsType) { actionsInput = helper.GetActionInputsForAction(itemAction.ActionId); actionsOutput = helper.GetActionOutputsForAction(itemAction.ActionId); DataRow dr = dt.NewRow(); if (actionsInput.Count > 0) dr["Input"] = actionsInput[0].InputObject; else dr["Input"] = String.Empty; dr["Name"] = itemAction.ActionName; if (actionsOutput.Count > 0) dr["Output"] = actionsOutput[0].OutputObject; else dr["Output"] = String.Empty; dt.Rows.Add(dr); } }
void FillSettings() { dbHelper helper = new dbHelper(); var EmailSendInterval = helper.GetSettingFromKey("EmailSendInterval", "10"); var EmailForBulk = helper.GetSettingFromKey("EmailForBulk", "50"); var SMTPUserName = helper.GetSettingFromKey("SMTPUserName", ""); var SMTPPassword = helper.GetSettingFromKey("SMTPPassword", ""); var SMTPHostName = helper.GetSettingFromKey("SMTPHostName", ""); var SMTPHostPort = helper.GetSettingFromKey("SMTPHostPort", ""); var EnableSSL = helper.GetSettingFromKey("EnableSSL", "true"); var LastRunTime = helper.GetSettingFromKey("LastRunTime", ""); var ReTryTime = helper.GetSettingFromKey("ReTryTime", "5"); var UseDefaultCredentials = helper.GetSettingFromKey("UseDefaultCredentials", "false"); var ThreadCount = helper.GetSettingFromKey("ThreadCount", "1"); if (ReTryTime != "" && EmailSendInterval != "" && EmailForBulk != "" && SMTPUserName != "" && SMTPPassword != "" && SMTPHostName != "" && SMTPHostPort != "" && EnableSSL != "" && UseDefaultCredentials != "" && ThreadCount != "") { settings = new Dictionary <string, string>(); settings.Add("EmailSendInterval", EmailSendInterval); settings.Add("EmailForBulk", EmailForBulk); settings.Add("SMTPUserName", SMTPUserName); settings.Add("SMTPPassword", SMTPPassword); settings.Add("SMTPHostName", SMTPHostName); settings.Add("SMTPHostPort", SMTPHostPort); settings.Add("EnableSSL", EnableSSL); settings.Add("LastRunTime", LastRunTime); settings.Add("ReTryTime", ReTryTime); settings.Add("ThreadCount", ThreadCount); settings.Add("UseDefaultCredentials", UseDefaultCredentials); } else { logHelper.LogException(new Exception("Settings are invalid"), main_path); } }
public ActionResult Delete(FormCollection formCollection) { try { string[] ids = formCollection["ID"].Split(new char[] { ',' }); if (ids.Count() == 0) { return(RedirectToAction("ListAll")); } List <string> idList = new List <string>(); foreach (string s in ids) { idList.Add("'" + s + "'"); } string instr = string.Join(",", idList); dbHelper dbh = new dbHelper(); dbh.execSql("update flowmains set flowStatus=99 where id in (" + instr + ")"); return(RedirectToAction("ListAll")); } catch (Exception ex) { return(RedirectToAction("ListAll")); } }
public ActionResult Delete(string id) { dbHelper dbh = new dbHelper(); string filepath = dbh.sql2Str("select fileUrl from news where id='" + id + "'"); try { DirectoryInfo di = new DirectoryInfo(@"C:\inetpub\upload\" + id); while (di.GetFiles().Count() > 0) { di.GetFiles()[0].Delete(); } di.Delete(); } catch (Exception ex) { string exs = ex.Message; } dbh.execSql("delete from news where id='" + id + "'"); return(RedirectToAction("Index")); }
public JsonResult Get() { dbHelper helper = new dbHelper(); return(Json(helper.getTasks())); }
public ActionResult QueryReportA(string dt1, string dt2, string rdRpt) { dbHelper dbh = new dbHelper(); if (rdRpt == "1") { ExcelPackage ep = new ExcelPackage(); //建立第一個Sheet,後方為定義Sheet的名稱 ExcelWorksheet sheet = ep.Workbook.Worksheets.Add("請假單總表"); int col = 1; sheet.Cells[1, col++].Value = "申請日期"; sheet.Cells[1, col++].Value = "簽核日期"; sheet.Cells[1, col++].Value = "單號"; sheet.Cells[1, col++].Value = "工號"; sheet.Cells[1, col++].Value = "姓名"; sheet.Cells[1, col++].Value = "開始日期"; sheet.Cells[1, col++].Value = "結束日期"; sheet.Cells[1, col++].Value = "假別"; sheet.Cells[1, col++].Value = "時數"; sheet.Cells[1, col++].Value = "代理人工號"; sheet.Cells[1, col++].Value = "備註"; DataTable tb1 = new DataTable(); string sql = string.Format( @" select b.billdate,b.signDate, b.billno, b.senderNo, c.cname, a.dtBegin, a.dtEnd, a.dType, a.hours, a.jobAgent, a.sMemo from dayoffs a inner join flowmains b on a.flowid=b.id left join AspNetUsers c on b.senderNo=c.workno where b.billdate >='{0}' and b.billdate <= '{1}' and b.flowStatus=2 order by b.billDate asc ", dt1, dt2 ); tb1 = dbh.sql2tb(sql); int row = 2; foreach (DataRow r in tb1.Rows) { sheet.Cells[row, 1].Style.Numberformat.Format = "yyyy/mm/dd"; sheet.Cells[row, 2].Style.Numberformat.Format = "yyyy/mm/dd"; sheet.Cells[row, 6].Style.Numberformat.Format = "yyyy/mm/dd HH:MM:ss"; sheet.Cells[row, 7].Style.Numberformat.Format = "yyyy/mm/dd HH:MM:ss"; sheet.Cells[row, 1].Value = r[0]; sheet.Cells[row, 2].Value = r[1]; sheet.Cells[row, 3].Value = r[2]; sheet.Cells[row, 4].Value = r[3]; sheet.Cells[row, 5].Value = r[4]; sheet.Cells[row, 6].Value = r[5]; sheet.Cells[row, 7].Value = r[6]; sheet.Cells[row, 8].Value = r[7]; sheet.Cells[row, 9].Value = r[8]; sheet.Cells[row, 10].Value = r[9]; sheet.Cells[row, 11].Value = r[10]; row++; } for (col = 1; col < 12; col++) { sheet.Column(col).AutoFit(); } MemoryStream fileStream = new MemoryStream(); ep.SaveAs(fileStream); ep.Dispose(); //如果這邊不下Dispose,建議此ep要用using包起來,但是要記得先將資料寫進MemoryStream在Dispose。 fileStream.Position = 0; //不重新將位置設為0,excel開啟後會出現錯誤 return(File(fileStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "請假單總表" + ctx.getLocalTiime().ToString("yyyyMMddHHmmss") + ".xlsx")); } else { ExcelPackage ep = new ExcelPackage(); //建立第一個Sheet,後方為定義Sheet的名稱 ExcelWorksheet sheet = ep.Workbook.Worksheets.Add("加班單總表"); int col = 1; sheet.Cells[1, col++].Value = "申請日期"; sheet.Cells[1, col++].Value = "簽核日期"; sheet.Cells[1, col++].Value = "單號"; sheet.Cells[1, col++].Value = "工號"; sheet.Cells[1, col++].Value = "姓名"; sheet.Cells[1, col++].Value = "開始時間"; sheet.Cells[1, col++].Value = "結束時間"; sheet.Cells[1, col++].Value = "時數"; sheet.Cells[1, col++].Value = "加班事由"; DataTable tb1 = new DataTable(); string sql = string.Format( @" SELECT b.billDate,b.signDate,b.billno,b.senderNo,c.cname,a.dtbegin,a.dtend,a.hours,a.smemo FROM [seform].[dbo].[ReqOverTimes] a inner join flowmains b on a.flowid=b.id left join AspNetUsers c on b.senderNo=c.workno where b.billdate >= '{0}' and billdate<='{1}' and b.flowStatus=2 and b.flowname=N'加班申請單' order by b.billdate ", dt1, dt2 ); tb1 = dbh.sql2tb(sql); int row = 2; foreach (DataRow r in tb1.Rows) { sheet.Cells[row, 1].Style.Numberformat.Format = "yyyy/mm/dd"; sheet.Cells[row, 2].Style.Numberformat.Format = "yyyy/mm/dd"; sheet.Cells[row, 6].Style.Numberformat.Format = "yyyy/mm/dd HH:MM:ss"; sheet.Cells[row, 7].Style.Numberformat.Format = "yyyy/mm/dd HH:MM:ss"; sheet.Cells[row, 1].Value = r[0]; sheet.Cells[row, 2].Value = r[1]; sheet.Cells[row, 3].Value = r[2]; sheet.Cells[row, 4].Value = r[3]; sheet.Cells[row, 5].Value = r[4]; sheet.Cells[row, 6].Value = r[5]; sheet.Cells[row, 7].Value = r[6]; sheet.Cells[row, 8].Value = r[7]; sheet.Cells[row, 9].Value = r[8]; row++; } for (col = 1; col < 9; col++) { sheet.Column(col).AutoFit(); } MemoryStream fileStream = new MemoryStream(); ep.SaveAs(fileStream); ep.Dispose(); fileStream.Position = 0; return(File(fileStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "加班單總表" + ctx.getLocalTiime().ToString("yyyyMMddHHmmss") + ".xlsx")); } ViewBag.dt1 = dt1; ViewBag.dt2 = dt2; ViewBag.rdRpt = rdRpt; return(View()); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { dt = new DataTable(); MakeDataTable(); String lastNode = null; SetActionGrid(lastNode); dtOptions = new DataTable(); MakeDataTableOptions(); AddToDataTableOptions("Add Options..."); BindGridOptions(); dtImports = new DataTable(); MakeDataTableImports(); _listFlowActOpt = new List<FlowActionOptions>(); _listFlowActInput = new List<FlowActionInputs>(); _listFlowActOutput = new List<FlowActionOutputs>(); _listActOpt = new List<ActionOptions>(); _listFlowMultiOpt = new List<FlowMultiOptions>(); if (!Object.ReferenceEquals(Session["user"], null)) { _user = (Users)Session["user"]; } else { dbHelper helper = new dbHelper(); _user = helper.GetTestUser(); } if (!Object.ReferenceEquals(Session["UseCaseNumber"], null)) { _useCaseNumber = (int)Session["UseCaseNumber"]; } else { _useCaseNumber = 0; } if (!Object.ReferenceEquals(Session["UseCaseStartTime"], null)) { _useCaseStartTime = (DateTime)Session["UseCaseStartTime"]; } else { _useCaseStartTime = DateTime.Now; } if (!Object.ReferenceEquals(Session["UseCaseText"], null)) { LabelUseCaseTooltip.Text = (String)Session["UseCaseText"]; } else { LabelUseCaseTooltip.Text = "Implement a process that meet your needs. Give it a meaningful name when saving."; } //Panel1.Visible = false; } else { dt = (DataTable)ViewState["MainFlow"]; dtOptions = (DataTable)ViewState["TableOptions"]; dtImports = (DataTable)ViewState["DataImports"]; _listFlowActOpt = (List<FlowActionOptions>)ViewState["FlowActionOptions"]; _listFlowActInput = (List<FlowActionInputs>)ViewState["FlowActionInputs"]; _listFlowActOutput = (List<FlowActionOutputs>)ViewState["FlowActionOutputs"]; _listActOpt = (List<ActionOptions>)ViewState["ActionOptions"]; _listFlowMultiOpt = (List<FlowMultiOptions>)ViewState["FlowMultiOptions"]; _user = (Users)Session["user"]; _useCaseNumber = (int)Session["UseCaseNumber"]; _useCaseStartTime = (DateTime)Session["UseCaseStartTime"]; //Panel1.Visible = false; } ViewState["MainFlow"] = dt; ViewState["TableOptions"] = dtOptions; ViewState["DataImports"] = dtImports; ViewState["FlowActionOptions"] = _listFlowActOpt; ViewState["FlowActionInputs"] = _listFlowActInput; ViewState["FlowActionOutputs"] = _listFlowActOutput; ViewState["ActionOptions"] = _listActOpt; ViewState["FlowMultiOptions"] = _listFlowMultiOpt; //String selectedId = GridView1.DataKeys[row.RowIndex].Value.ToString(); Session["user"] = _user; Session["UseCaseNumber"] = _useCaseNumber; Session["UseCaseStartTime"] = _useCaseStartTime; }
private void LoadActionOptions(String actionId) { dbHelper helper = new dbHelper(); _listActOpt.Clear(); _listActOpt = helper.GetActionOptionsForAction(actionId); TextBox tx; CheckBox ck; RadioButtonList rd; DropDownList dd; if (MultiViewSpecific.GetActiveView() == ViewPostMessage) rd = RadioButtonListPostMessage; else rd = RadioButtonListPostComment; foreach (ActionOptions itemActOpt in _listActOpt) { if (itemActOpt.ControlName != null) { switch (itemActOpt.Options.OptionType) { case "textbox": tx = (TextBox)FindControl(itemActOpt.ControlName); if (tx != null) { tx.Text = itemActOpt.DefaultValue; } break; case "check": ck = (CheckBox)FindControl(itemActOpt.ControlName); if (ck != null) { if (itemActOpt.DefaultValue == "true") ck.Checked = true; else ck.Checked = false; } break; case "radio": if (itemActOpt.DefaultValue == "true") rd.SelectedValue = itemActOpt.ControlName; break; case "dropdown": dd = (DropDownList)FindControl(itemActOpt.ControlName); if (dd != null) { dd.SelectedValue = itemActOpt.DefaultValue; } break; } } } ViewState["ActionOptions"] = _listActOpt; }
private void LoadPreviousActionOptions(String actionId) { dbHelper helper = new dbHelper(); _listActOpt.Clear(); _listActOpt = helper.GetActionOptionsForAction(actionId); ActionOptions itemActOpt; TextBox tx; CheckBox ck; RadioButtonList rd; DropDownList dd; if (MultiViewSpecific.GetActiveView() == ViewPostMessage) rd = RadioButtonListPostMessage; else rd = RadioButtonListPostComment; foreach (FlowActionOptions itemFlowActOpt in _listFlowActOpt) { if (itemFlowActOpt.FlowPosition == dt.Rows.Count) { itemActOpt = itemFlowActOpt.ActionOptions; if (itemActOpt.ControlName != null) { switch (itemActOpt.Options.OptionType) { case "textbox": tx = (TextBox)FindControl(itemActOpt.ControlName); if (tx != null) { tx.Text = itemFlowActOpt.Value; } break; case "check": ck = (CheckBox)FindControl(itemActOpt.ControlName); if (ck != null) { if (itemFlowActOpt.Value == "true") ck.Checked = true; else ck.Checked = false; } break; case "radio": if (itemFlowActOpt.Value == "true") rd.SelectedValue = itemActOpt.ControlName; if (itemActOpt.ControlName == "MultOptCom" && itemFlowActOpt.Value == "true") { dtOptions.Clear(); foreach (FlowMultiOptions itemFlowMultiOpt in _listFlowMultiOpt) { if (itemFlowMultiOpt.FlowPosition == dt.Rows.Count) { AddToDataTableOptions(itemFlowMultiOpt.OptionValue); } } BindGridOptions(); } break; case "dropdown": dd = (DropDownList)FindControl(itemActOpt.ControlName); if (dd != null) { dd.SelectedValue = itemFlowActOpt.Value; } break; } } } } ViewState["ActionOptions"] = _listActOpt; }
private void SaveActionOptions(int position) { FlowActionOptions fao; FlowActionInputs faIn; FlowActionOutputs faOut; TextBox tx; CheckBox ck; RadioButtonList rd; DropDownList dd; _listFlowActOpt.RemoveAll(f => f.FlowPosition == position); _listFlowActInput.RemoveAll(f => f.FlowPosition == position); _listFlowActOutput.RemoveAll(f => f.FlowPosition == position); if (MultiViewSpecific.GetActiveView() == ViewPostMessage) rd = RadioButtonListPostMessage; else rd = RadioButtonListPostComment; foreach (ActionOptions itemActOpt in _listActOpt) { if (itemActOpt.ControlName != null) { fao = new FlowActionOptions(); fao.ActionOptions = itemActOpt; fao.FlowPosition = position; switch (itemActOpt.Options.OptionType) { case "textbox": tx = (TextBox)FindControl(itemActOpt.ControlName); if (tx != null) { fao.Value = tx.Text; } break; case "check": ck = (CheckBox)FindControl(itemActOpt.ControlName); if (ck != null) { if (ck.Checked) fao.Value = "true"; else fao.Value = "false"; } break; case "radio": if (rd.SelectedValue == itemActOpt.ControlName) fao.Value = "true"; else fao.Value = "false"; if (itemActOpt.ControlName == "MultOptCom" && fao.Value == "true") { FlowMultiOptions fmo; _listFlowMultiOpt.RemoveAll(fm => fm.FlowPosition == position); foreach (DataRow itemMultiOpt in dtOptions.Rows) { fmo = new FlowMultiOptions(); fmo.FlowPosition = position; fmo.OptionValue = itemMultiOpt["Option"].ToString(); _listFlowMultiOpt.Add(fmo); } if (dt.Rows.Count != position) { dtOptions.Clear(); AddToDataTableOptions("Add Options..."); BindGridOptions(); } } break; case "dropdown": dd = (DropDownList)FindControl(itemActOpt.ControlName); if (dd != null) { fao.Value = dd.SelectedValue; } break; } _listFlowActOpt.Add(fao); } } dbHelper helper = new dbHelper(); if (dt.Rows[position - 1].Field<String>("Input") != String.Empty) { List<ActionInputs> inputs = helper.GetActionInputsForAction(dt.Rows[position - 1].Field<String>("Id")); faIn = new FlowActionInputs(); faIn.FlowPosition = position; faIn.ActionInputs = inputs[0]; faIn.Value = dt.Rows[position - 1].Field<String>("Input"); _listFlowActInput.Add(faIn); } if (dt.Rows[position - 1].Field<String>("Output") != String.Empty) { List<ActionOutputs> outputs = helper.GetActionOutputsForAction(dt.Rows[position - 1].Field<String>("Id")); faOut = new FlowActionOutputs(); faOut.FlowPosition = position; faOut.ActionOutputs = outputs[0]; faOut.Value = dt.Rows[position - 1].Field<String>("Output"); _listFlowActOutput.Add(faOut); } }
public ActionResult Create(news model) { if (string.IsNullOrEmpty(model.newsType)) { initNewsTypeList(""); ModelState.AddModelError("newsType", "請選擇公告類別"); return(View(model)); } if (!ModelState.IsValid) { initNewsTypeList(model.newsType); return(View(model)); } var context = new ApplicationDbContext(); string ModelID = ""; if (string.IsNullOrEmpty(model.id)) { model.id = Guid.NewGuid().ToString(); ModelID = model.id; model.createTime2 = context.getLocalTiime(); //if (fileUrl != "") //{ // model.fileUrl = fileUrl; //} context.newsList.Add(model); } else { news currentModel = context.newsList.Where(x => x.id == model.id).FirstOrDefault(); ModelID = currentModel.id; currentModel.title = model.title; currentModel.createTime = DateTime.UtcNow.AddSeconds(28800); model.createTime2 = context.getLocalTiime(); currentModel.content = model.content; currentModel.ndate = model.ndate; currentModel.newsType = model.newsType; //if (fileUrl != "") //{ // currentModel.fileUrl = fileUrl; //} } try { context.SaveChanges(); } catch (Exception ex) { string s = ex.Message; ModelState.AddModelError("", ex.Message); return(View()); } dbHelper dbh = new dbHelper(); string sfilelist = dbh.sql2Str("select fileUrl from news where id='" + ModelID + "'"); JArray jlist = new JArray(); try { jlist = JArray.Parse(sfilelist); } catch (Exception ex) { jlist = new JArray(); } for (int idx = 0; idx < Request.Files.Count; idx++) { var file = Request.Files[idx]; if (file == null) { continue; } if (file.ContentLength > 0) { string originFileName = file.FileName; string filename = file.FileName.Replace("%", "").Replace(" ", "_"); string fileUrl = ModelID + @"/" + filename; var path = @"C:\inetpub\upload\" + ModelID + @"\"; DirectoryInfo di = new DirectoryInfo(path); if (di.Exists == false) { di.Create(); } path = path + @"\" + filename; try { file.SaveAs(path); JObject fileObj = new JObject(); fileObj["fileName"] = originFileName; fileObj["fileUrl"] = ModelID + @"\" + filename; jlist.Add(fileObj); } catch (Exception ex) { } } } dbh.execSql("update news set fileUrl=N'" + jlist.ToString() + "' where id='" + ModelID + "'"); return(RedirectToAction("Index")); }
private Flows SaveFlow() { if (dt.Rows.Count <= 0) { return null; } dbHelper helper = new dbHelper(); bool isUpdate = true; FlowActionOptions fao; FlowActionInputs faIn; FlowActionOutputs faOut; FlowMultiOptions fmo; ActionOptions actOpt; ActionInputs actInput; ActionOutputs actOutput; Users flowUser = helper.GetUserbyName(_user.UserName); Flows myflow = helper.GetFlowByName(TextBox1.Text, flowUser); if (myflow == null) { myflow = new Flows(); myflow.FlowName = TextBox1.Text; myflow.Users = flowUser; myflow.FlowUseCaseNumber = _useCaseNumber; myflow.FlowStartTime = _useCaseStartTime; myflow.FlowEndTime = DateTime.Now; isUpdate = false; } else { myflow.FlowEndTime = DateTime.Now; helper.DeleteFlowDetailsById(myflow.FlowId); } int rowCount = 0; FlowActions flowAction; Actions curAction; foreach (DataRow gridRow in dt.Rows) { rowCount++; curAction = helper.GetActionById(gridRow["Id"].ToString()); flowAction = new FlowActions(); flowAction.Actions = curAction; flowAction.Position = rowCount; myflow.FlowActions.Add(flowAction); } SaveActionOptions(dt.Rows.Count); foreach (FlowActionOptions itemFlowActOpt in _listFlowActOpt) { fao = new FlowActionOptions(); actOpt = helper.GetActionOptionById(itemFlowActOpt.ActionOptions.ActionOptionId); fao.ActionOptions = actOpt; fao.FlowPosition = itemFlowActOpt.FlowPosition; fao.Value = itemFlowActOpt.Value; myflow.FlowActionOptions.Add(fao); } foreach (FlowActionInputs itemFlowActIn in _listFlowActInput) { faIn = new FlowActionInputs(); actInput = helper.GetActionInputById(itemFlowActIn.ActionInputs.InputId); faIn.ActionInputs = actInput; faIn.FlowPosition = itemFlowActIn.FlowPosition; faIn.Value = itemFlowActIn.Value; myflow.FlowActionInputs.Add(faIn); } foreach (FlowActionOutputs itemFlowActOut in _listFlowActOutput) { faOut = new FlowActionOutputs(); actOutput = helper.GetActionOutputById(itemFlowActOut.ActionOutputs.OutputId); faOut.ActionOutputs = actOutput; faOut.FlowPosition = itemFlowActOut.FlowPosition; faOut.Value = itemFlowActOut.Value; myflow.FlowActionOutputs.Add(faOut); } foreach (FlowMultiOptions itemFlowMultiOpt in _listFlowMultiOpt) { fmo = new FlowMultiOptions(); fmo.FlowPosition = itemFlowMultiOpt.FlowPosition; fmo.OptionValue = itemFlowMultiOpt.OptionValue; myflow.FlowMultiOptions.Add(fmo); } if (isUpdate) { helper.UpdateChanges(); } else { helper.AddToModel(myflow); } return myflow; }
private void SetActionGrid(String LastNode) { String whereClause = String.Empty; dbHelper helper = new dbHelper(); List<String> nextNodes = helper.GetNextNodes(LastNode); foreach (String itemNode in nextNodes) { whereClause += " it.[ActionId] = '" + itemNode + "' OR"; } whereClause = whereClause.Substring(0, whereClause.Length - 2); SimpleFlowDS.Where = whereClause; }
private void InitializeApp() { dbHelper helper = new dbHelper(); ApplicationInfo appInfo = helper.GetAppInfo(); FacebookConnector fbApi = new FacebookConnector(appInfo.ApplicationURL, appInfo.ApplicationId, appInfo.RedirectURL, appInfo.ApplicationSecret, appInfo.PageId, appInfo.ApplicationAT, appInfo.PageOwnerId); Session["fbApi"] = fbApi; }