private Object darDeAltaRol() { SQLManager sqlManager = new SQLManager(); return sqlManager.generarSP("AltaRol"). agregarStringSP("@Nombre", txtNombre.Text). agregarListaSP("@Funcionalidades", funcionalidadesActuales()). ejecutarSP(); }
public GameManager(ScreenManager screenManager, ContentManager Content) { this.ScreenManager = screenManager; this.GraphicsDevice = screenManager.GraphicsDevice; this.Content = Content; this.random = new Random(); // Hacks. sql = new SQLManager(); //sql.CreateNewDatabase(); // More Hacks. //playerData = SaveManager.LoadData(); //SaveManager.SaveData(PlayerData); }
// Realiza el llamado al sp para registrar al usuario efectivamente, si es que no hubo errores // encripta la contraseña antes de enviarla private void registrarUsuario() { SQLManager manager = new SQLManager().generarSP("RegistrarUsuario") .agregarStringSP("@Usuario", txtUsuario) .agregarStringSP("@Contrasenia", Encriptador.encriptarSegunSHA256(txtPassword.Text)); try { manager.ejecutarSP(); MessageBox.Show("El usuario " + txtUsuario.Text + " ha sido registrado de forma correcta", "Registro exitoso", MessageBoxButtons.OK); this.Close(); } catch(Exception e) { MessageBox.Show(e.Message, "Error en el registro", MessageBoxButtons.OK); } }
// Realiza la cancelación de pasajes private void botonCancelar_Click(object sender, EventArgs e) { SQLManager manager = new SQLManager().generarSP("CancelarPasajesEncomiendasAeronave") .agregarStringSP("@Matricula", matricula) .agregarFechaSP("@FechaBaja", fechaBaja); if(llamadoDesdeBajaLogica){ manager = manager.agregarFechaNula("@FechaReinicio"); } else{ manager = manager.agregarFechaSP("@FechaReinicio",fechaReinicio); } manager.ejecutarSP(); this.Close(); }
public void darDeBajaLogica(DateTime fechaBaja) { string matricula = dg.Rows[indiceAeronaveElegida].Cells["Matrícula"].Value.ToString(); SQLManager manager = new SQLManager(); manager = manager.generarSP("DarDeBajaLogica").agregarStringSP("@Matricula", matricula) .agregarFechaSP("@FechaBaja", fechaBaja); try { manager.ejecutarSP(); MessageBox.Show("La fecha de baja de la aeronave fue cargada exitosamente", "Baja de aeronave", MessageBoxButtons.OK); } catch (Exception e) { if (e.Message.Contains("fuera de servicio")) { MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK); return; } new Form7(e.Message, matricula, true, fechaBaja, Program.fechaHoy()).ShowDialog(); } }
public void dejarFueraDeServicio(DateTime fechaReinicio, DateTime fechaBaja) { string matricula = dg.Rows[indiceAeronaveElegida].Cells["Matrícula"].Value.ToString(); SQLManager manager = new SQLManager(); manager = manager.generarSP("DejarAeronaveFueraDeServicio").agregarStringSP("@Matricula", matricula) .agregarFechaSP("@FechaBaja", fechaBaja) .agregarFechaSP("@FechaReinicio", fechaReinicio); try { manager.ejecutarSP(); MessageBox.Show("El período de fuera de servicio se ha cargado exitosamente", "Fuera de servicio", MessageBoxButtons.OK); } catch (Exception e) { if (e.Message.Contains("fuera de servicio")) { MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK); return; } new Form7(e.Message, matricula,false, fechaBaja, fechaReinicio).ShowDialog(); } }
void Update() { Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); if (mGetLcalTime > 0) { Debug.Log("mGetLcalTime = " + mGetLcalTime + " isGetlocalBegin=" + isGetlocalBegin + " isGetlocaled=" + isGetlocaled); } if (isGetlocalBegin && !isGetlocaled) { mGetLcalTime += Time.deltaTime; if (mGetLcalTime >= 10) { isGetlocaled = true; GameManager.getIntance().mInitStatus = 8; } return; } Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); if (mLoadingDec == null) { mLoadingDec = GameObject.Find("game_begin_loading_des").GetComponent <Text>(); } if (GameManager.getIntance().mInitStatus < 11) { mLoadingDec.text = GameManager.getIntance().mInitDec; } if (GameManager.getIntance().mInitStatus == -1) { return; } else if (GameManager.getIntance().mInitStatus == 10) { GameManager.getIntance().mInitDec = ""; mLoadingDec.text = GameManager.getIntance().mInitDec; GameManager.getIntance().mInitStatus = 11; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); if (SQLHelper.getIntance().isFristStartGame == -1) { SQLHelper.getIntance().updateVersionCode(GameManager.mVersionCode); Destroy(GameObject.Find("game_begin_loading")); GetComponentInChildren <TypewriterEffect>().init(JsonUtils.getIntance().getStringById(100001)); } else { AudioSource source = GameObject.Find("information").GetComponent <AudioSource>(); GameManager.getIntance().playBgm(source, "Sounds/关卡背景音"); Destroy(gameObject); GameObject.Find("Manager").GetComponent <LevelManager>().init(); } } else if (GameManager.getIntance().mInitStatus == 0) { GameManager.getIntance().mInitDec = "开始配置文件初始化"; GameManager.getIntance().mInitStatus = 1; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); #if UNITY_ANDROID || UNITY_IOS SQLManager.getIntance().initPathRoot(); SQLManager.getIntance().alterTableByVersion(); Thread th1 = new Thread(() => { JsonUtils.getIntance().initBefore(); JsonUtils.getIntance().init(); GameManager.getIntance().mInitStatus = 2; }); th1.Start(); #endif #if UNITY_STANDALONE SQLManager.getIntance().init(sqlName, tabName); SQLManager.getIntance().alterTableByVersion(); // GameManager.getIntance().mInitStatus = 8; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); JsonUtils.getIntance().initBefore(); JsonUtils.getIntance().init(); GameManager.getIntance().mInitStatus = 2; #endif } else if (GameManager.getIntance().mInitStatus == 2) { GameManager.getIntance().mInitDec = JsonUtils.getIntance().getStringById(100025); GameManager.getIntance().mInitStatus = 3; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); #if UNITY_ANDROID || UNITY_IOS Thread th1 = new Thread(() => { try { isUpdate = SQLManager.getIntance().initNoNet(); Debug.Log("isUpdate = " + isUpdate); SQLManager.getIntance().startThread(); if (isUpdate == 1) { GameManager.getIntance().mInitStatus = 4; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } else if (isUpdate == 2) { GameManager.getIntance().mInitStatus = 6; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } else if (isUpdate == 3) { GameManager.getIntance().mInitStatus = 6; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } } catch (System.Exception e) { Debug.Log("处理存档出错"); Debug.Log(e.Message); } }); th1.Start(); #endif #if UNITY_STANDALONE GameManager.getIntance().mInitStatus = 8; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); #endif } else if (GameManager.getIntance().mInitStatus == 4)//强制轮回 { GameManager.getIntance().mInitDec = JsonUtils.getIntance().getStringById(100029); GameManager.getIntance().mInitStatus = 5; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); GameObject.Find("lunhui_tips").GetComponent <LuiHuiTips>().showUi(JsonUtils.getIntance().getStringById(100002), LuiHuiTips.TYPPE_RETURN_START); GameObject.Find("lunhui_tips").GetComponent <LuiHuiTips>().showSelf(); } else if (GameManager.getIntance().mInitStatus == 6)//和网络同步数据 { GameManager.getIntance().mInitStatus = 7; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); Debug.Log(" SQLManager.getIntance().isUpdateed() = " + SQLManager.getIntance().isUpdateed()); Debug.Log(" Application.internetReachability == NetworkReachability.NotReachable = " + (Application.internetReachability == NetworkReachability.NotReachable)); if (!SQLManager.getIntance().isUpdateed() || Application.internetReachability == NetworkReachability.NotReachable || GameManager.isTestVersion) { GameManager.getIntance().mInitStatus = 8; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); return; } if (!isGetlocalBegin && !isGetlocaled) { isGetlocalBegin = true; Thread th1 = new Thread(() => { if (!NetServer.getIntance().getLocl(null, false, false)) { GameManager.getIntance().mInitStatus = 8; isGetlocaled = true; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } else { GameManager.getIntance().mInitStatus = 6; isGetlocaled = true; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } }); th1.Start(); return; } isUpdateEnd = true; bool isHaveNet = NetServer.getIntance().isHaveLocal(); Debug.Log("NetServer.getIntance().getLocal() isUpdate =" + isUpdate); if (isHaveNet) { if (isUpdate == 3) { Thread th1 = new Thread(() => { Debug.Log("NetServer.getIntance().getLocal();"); string local = NetServer.getIntance().getLocal(); Debug.Log(" NetServer.getIntance().getLocal()"); SQLManager.getIntance().saveLocal(local); Debug.Log(" SQLHelper.getIntance().saveLoacl(local);"); GameManager.getIntance().mInitStatus = 8; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); }); th1.Start(); } else if (isUpdate == 2 || isUpdate == 1) { GameObject.Find("lunhui_tips").GetComponent <LuiHuiTips>().showUi("检测到服务端有您的存档,需要进行同步吗", LuiHuiTips.TYPPE_UPDATE_LINE); GameObject.Find("lunhui_tips").GetComponent <LuiHuiTips>().showSelf(); //UiControlManager.getIntance().show(UiControlManager.TYPE_LUIHUI); } } else { GameManager.getIntance().mInitStatus = 8; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); } } else if (GameManager.getIntance().mInitStatus == 8) { GameManager.getIntance().mInitStatus = 9; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); GameManager.getIntance().mInitDec = JsonUtils.getIntance().getStringById(100030); #if UNITY_ANDROID || UNITY_IOS Thread th1 = new Thread(() => { if (isUpdateEnd) { Debug.Log(" SQLHelper.getIntance().updateIsUpdate(); "); SQLHelper.getIntance().updateIsUpdate(); Debug.Log(" SQLHelper.getIntance().updateIsUpdate(); end"); } Debug.Log("SQLHelper.getIntance().init();"); SQLHelper.getIntance().init(); int count = 0; if (SQLHelper.getIntance().mVocationCount == 0) { for (int i = 0; ; i++) { if (SQLHelper.getIntance().mPlayVocation.ContainsKey(i)) { count++; } else { break; } } if (count != 0) { SQLHelper.getIntance().updateVocationCount(count); } } Debug.Log("SQLHelper.getIntance().init(); end"); GameManager.getIntance().mInitStatus = 10; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); }); th1.Start(); #endif #if UNITY_STANDALONE SQLHelper.getIntance().init(); int count = 0; if (SQLHelper.getIntance().mVocationCount == 0) { for (int i = 0; ; i++) { if (SQLHelper.getIntance().mPlayVocation.ContainsKey(i)) { count++; } else { break; } } if (count != 0) { SQLHelper.getIntance().updateVocationCount(count); } } GameManager.getIntance().mInitStatus = 10; Debug.Log(" GameManager.getIntance().mInitStatus = " + GameManager.getIntance().mInitStatus); #endif } }
//SAVE public static string CU_Mst_Item(M_AT_Mst_ItemMasterBO ObjItem) { M_AT_Mst_ItemMasterBO ObjBOAT_Item = new M_AT_Mst_ItemMasterBO(); string strRetMst = ""; DataTable dt = new DataTable(); string var_ErrorMessage = ""; try { if (ObjItem.Item_Name.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Item Name Cannot Be Blank \n"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_ItemMaster", "MItem_ID", Convert.ToInt32("0" + ObjItem.MItem_ID), "Item_Name", ObjItem.Item_Name, " AND Fk_Company_ID=" + ObjItem.Fk_Company_ID + " AND Fk_Branch_ID=" + ObjItem.Fk_Branch_ID)) { var_ErrorMessage = var_ErrorMessage + "Item Already Exist. \n"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_ItemMaster", "MItem_ID", Convert.ToInt32("0" + ObjItem.MItem_ID), "HSNCode", ObjItem.HSNCode, " AND Fk_Company_ID=" + ObjItem.Fk_Company_ID + " AND Fk_Branch_ID=" + ObjItem.Fk_Branch_ID)) { var_ErrorMessage = var_ErrorMessage + "Item Already Exist. \n"; } if (ObjItem.Fk_UOM_ID <= 0) { var_ErrorMessage = var_ErrorMessage + "Select Unit Of Measurment \n"; } if (ObjItem.Item_Tax_GST_ID <= 0) { var_ErrorMessage = var_ErrorMessage + "Select Integrated Tax Rate\n"; } if (ObjItem.Item_Tax_GST_Effective_From.Length != 11) { var_ErrorMessage = var_ErrorMessage + "Invalid Integrated Tax Rate Effective From Date\n"; } if (ObjItem.Item_Code.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Invalid Item Code \n"; } if (var_ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(ObjItem.MItem_ID) == 0) { ObjBOAT_Item.Fk_Company_ID = ObjItem.Fk_Company_ID; ObjBOAT_Item.Fk_Branch_ID = ObjItem.Fk_Branch_ID; ObjBOAT_Item.Fk_Year_ID = ObjItem.Fk_Year_ID; ObjBOAT_Item.MDBSC_RowCreatedByUser_ID = ObjItem.MDBSC_RowCreatedByUser_ID; ObjBOAT_Item.MDBSC_RowCreatedByUserName = ObjItem.MDBSC_RowCreatedByUserName; ObjBOAT_Item.Item_SRNO = 0; ObjBOAT_Item.Fk_MIC_ID = 1; ObjBOAT_Item.Fk_IG_ID = 1; ObjBOAT_Item.Fk_ISG_ID = 1; ObjBOAT_Item.Item_Code = MEF.GenrateRefNo(ObjItem.Fk_Company_ID, ObjItem.Fk_Branch_ID, 0, "Item", "I-", "I-", "No", "", "", "", 0); } ObjBOAT_Item.MItem_ID = ObjItem.MItem_ID; ObjBOAT_Item.Item_Type = ObjItem.Item_Type; ObjBOAT_Item.Fk_UOM_ID = ObjItem.Fk_UOM_ID; ObjBOAT_Item.Item_Name = ObjItem.Item_Name; ObjBOAT_Item.HSNCode = ObjItem.HSNCode; ObjBOAT_Item.Fk_HSN_ID = ObjItem.Fk_HSN_ID; ObjBOAT_Item.HSN_Desc = ObjItem.HSN_Desc; ObjBOAT_Item.Item_Tax_GST_ID = ObjItem.Item_Tax_GST_ID; //decimal var_Tax_GST_Rate = Convert.ToDecimal(Item_Tax_GST_ID.SelectedItem.Text); //decimal var_Tax_SGST_Rate = Math.Round((var_Tax_GST_Rate / 2), 2); ObjBOAT_Item.Item_CGST_Rate = ObjItem.Item_CGST_Rate; ObjBOAT_Item.Item_SGST_Rate = ObjItem.Item_SGST_Rate; ObjBOAT_Item.Item_IGST_Rate = ObjItem.Item_IGST_Rate; if (ObjItem.Item_Tax_GST_Effective_From.Length == 11) { ObjBOAT_Item.Item_Tax_GST_Effective_From = ObjItem.Item_Tax_GST_Effective_From; } ObjBOAT_Item.Item_CESS_Rate = ObjItem.Item_CESS_Rate; ObjBOAT_Item.Item_Tax_CESS_ID = ObjItem.Item_Tax_CESS_ID; ObjBOAT_Item.Item_Selling_Rate = ObjItem.Item_Selling_Rate; ObjBOAT_Item.Item_Purchase_Rate = ObjItem.Item_Purchase_Rate; ObjBOAT_Item.Item_Desc = ObjItem.Item_Desc; ObjBOAT_Item.MDBSC_RowStatus = ObjItem.MDBSC_RowStatus; ObjBOAT_Item.MDBSC_RowLupdnByUser_ID = ObjItem.MDBSC_RowLupdnByUser_ID; ObjBOAT_Item.MDBSC_RowLupdnUserName = ObjItem.MDBSC_RowLupdnUserName; ObjBOAT_Item.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); var_ErrorMessage = ObjBOAT_Item.Insert_Update(ObjBOAT_Item); //ObjItem.MItem_ID =Convert.ToInt64( var_ErrorMessage.Substring((var_ErrorMessage.IndexOf("|") + 1), (var_ErrorMessage.Length - var_ErrorMessage.IndexOf("|") - 1))); //var_ErrorMessage = var_ErrorMessage.Substring((0), (var_ErrorMessage.IndexOf("|"))); scope.Complete(); } strRetMst = var_ErrorMessage; } else { strRetMst = var_ErrorMessage + "|" + ObjItem.MItem_ID.ToString(); } return(strRetMst); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 업적을 갱신합니다. (현재 수치와 커트라인을 비교). /// </summary> /// <param name="AUID"></param> /// <param name="AchievementCode1"></param> /// <param name="AchievementCode2">여러 개를 갱신할 때 입력.</param> /// <param name="AchievementCode3">여러 개를 갱신할 때 입력.</param> static public void UpdateAchievementWithNewValue(int AUID, int newValue, string AchievementCode1, string AchievementCode2 = null, string AchievementCode3 = null, string AchievementCode4 = null, string AchievementCode5 = null) { int maxAchievement = 5; string[] AchievementCode = new string[maxAchievement]; int[] oldCount = new int[maxAchievement]; int[] newCount = new int[maxAchievement]; int[] cutLine = new int[maxAchievement]; int[] Complete = new int[maxAchievement]; int index = 0; string SQL = string.Format("select * from UserAchievement where AUID='{0}' and (AchievementCode='{1}' or AchievementCode='{2}' or AchievementCode='{3}' or AchievementCode='{4}' or AchievementCode='{5}')", AUID, AchievementCode1, AchievementCode2, AchievementCode3, AchievementCode4, AchievementCode5); SqlDataReader reader = SQLManager.ExecuteReader(SQL); CSVReader excel = null; if (reader.HasRows) { while (reader.Read()) { AchievementCode[index] = reader["AchievementCode"].ToString(); Complete[index] = int.Parse(reader["Complete"].ToString()); if (Complete[index] == 0) { if (excel == null) { excel = new CSVReader("TbAchievement.txt"); } oldCount[index] = int.Parse(reader["Count"].ToString()); newCount[index] = newValue; cutLine[index] = int.Parse(ReadJSONData.ReadLine(excel.FindJSONData("AchievementCode", AchievementCode[index]))[3]); Debug.Log(CodeManager.GetMethodName() + AUID + " : " + AchievementCode[index]); } index++; } } reader.Close(); for (int i = 0; i < index; i++) { if (Complete[i] == 0) { if (newCount[i] >= cutLine[i]) { newCount[i] = cutLine[i]; SQL = string.Format("update UserAchievement set Count='{0}', Complete='1' where AUID='{1}' and AchievementCode='{2}'", newCount[i], AUID, AchievementCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); SQL = string.Format("insert into UserAchievementCompleteNotice values ('{0}','{1}');", AUID, AchievementCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + AchievementCode[i] + " 가 갱신되어서 커트라인을 달성했다."); } } else { SQL = string.Format("update UserAchievement set Count='{0}' where AUID='{1}' and AchievementCode='{2}'", newCount[i], AUID, AchievementCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + AchievementCode[i] + " 가 갱신되었다."); } } } else { if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + AchievementCode[i] + " 는 이미 커트라인을 달성했다."); } } } }
private Object modificarRuta() { SQLManager sqlManager = new SQLManager(); return sqlManager.generarSP("ModificarRuta").agregarIntSP("@IdRuta", idRuta) .agregarIntSP("@Codigo", txtCodigo) .agregarListaSP("@Servicios", listaServicios) .agregarStringSP("@CiudadOrigen", txtCiudadOrigenNueva) .agregarStringSP("@CiudadDestino", txtCiudadDestinoNueva) .agregarDecimalSP("@PrecioPasaje", enDecimal(txtPrecioPasajeNuevo.Text)) .agregarDecimalSP("@PrecioeEncomienda", enDecimal(txtPrecioEncomiendaNueva.Text)) .ejecutarSP(); }
private void createButton_Click(object sender, RoutedEventArgs e) { try { Candidate c = (Candidate)usersListView.SelectedItem; System.Windows.Forms.FolderBrowserDialog fbd = new System.Windows.Forms.FolderBrowserDialog(); if (fbd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Document doc = new Document(PageSize.A4, 72, 72, 72, 72); PdfWriter.GetInstance(doc, new FileStream(System.IO.Path.Combine(fbd.SelectedPath, c.UserName + "_CTVIAT_Report.pdf"), FileMode.Create)); doc.Open(); Paragraph p1 = new Paragraph(c.UserName); p1.Font.Size = 24; p1.Font.SetStyle(Font.ITALIC); doc.Add(p1); ArrayList tests = SQLManager.getAllTestsOfCandidate(c.UserID); if (tests.Count == 0) { doc.Add(new Paragraph("Candidate didn't solve any tests")); } else { int i = 1; foreach (Test t in tests) { String testInfo = "TEST " + i + "\nTEST ID: " + t.TestID + "\nTEST SUBJECT: " + t.Subject + "\nTEST DATE: " + t.Date + "\nTEST TAKE ORDER: " + t.TakeOrder + "\nTEST TIME: "; int time = t.Time; if (time / 3600 > 0) { if (time / 3600 == 1) { testInfo = testInfo + time / 3600 + " hour"; } else { testInfo = testInfo + time / 3600 + " hours"; } } if (time % 3600 / 60 > 0) { if (time % 3600 / 60 == 1) { testInfo = testInfo + time % 3600 / 60 + " minute"; } else { testInfo = testInfo + time % 3600 / 60 + " minutes"; } } if (time % 60 == 1) { testInfo = testInfo + time % 60 + " second\n"; } else { testInfo = testInfo + time % 60 + " seconds\n"; } if (t.IsNew) { testInfo = testInfo + "TEST COMPLETENESS: COMPLETED\n"; } else { testInfo = testInfo + "TEST COMPLETENESS: INCOMPLETED\nTEST START QUESTION NO: " + t.StartQuestionNo + "\n"; } Paragraph p = new Paragraph(testInfo); p.Font.SetStyle(Font.BOLD); doc.Add(p); foreach (Question q in t.Questions) { String questionInfo = "QUESTION\n" + q.QuestionText + "\nCANDIDATE ANSWER\n"; if (q is ObjectiveQuestion) { ObjectiveQuestion oq = (ObjectiveQuestion)q; if (oq.Submitted != null) { questionInfo = questionInfo + oq.Choices[oq.Submitted.Answer - 1] + "\n"; } else { questionInfo = questionInfo + "Candidate didn't answer the question\n"; } } else if (q is DescriptiveQuestion) { DescriptiveQuestion dq = (DescriptiveQuestion)q; if (dq.Submitted != null) { questionInfo = questionInfo + dq.Submitted.Answer; } else { questionInfo = questionInfo + "Candidate didn't answer the question\n"; } } else { ActionBasedQuestion aq = (ActionBasedQuestion)q; if (aq.Submitted != null) { questionInfo = questionInfo + "Candidate answered the question correctly"; } else { questionInfo = questionInfo + "Candidate didn't answer the question\n"; } } Paragraph questionParagraph = new Paragraph(questionInfo); doc.Add(questionParagraph); } i++; } } doc.Close(); MessageBox.Show("Report Creation is successful\n", "Report Creation", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { MessageBox.Show("Report Creation is failed\n" + ex.Message, "Report Creation", MessageBoxButton.OK, MessageBoxImage.Error); } }
public ImageBookBAL() { sql = new SQLManager(); }
public static string GenerateVideo(List <Interval> timeIntervals) { int i = 0; string outputFileName = null; List <string> outputs = new List <string>(); SQLManager sql = new SQLManager(); if (!Directory.Exists("MultipleTemp")) { Directory.CreateDirectory("MultipleTemp"); } System.IO.DirectoryInfo di = new DirectoryInfo("MultipleTemp/"); foreach (FileInfo file in di.GetFiles()) { file.Delete(); } foreach (Interval Time in timeIntervals) { i++; List <Video> vidFiles = sql.GetFiles(Time.cameraName, Time.startTime.ToString("hh:mm:ss"), Time.endTime.ToString("hh:mm:ss")); string file = i + ".mp4"; if (vidFiles.Count < 1) { //no video found return(null); } else if (vidFiles.Count == 1) { CutVideo(vidFiles[0].FileName, "Cut/" + file, Time.startTime.ToString("hh:mm:ss"), Time.endTime.ToString("hh:mm:ss"), vidFiles[0].StartTime.ToString("hh:mm:ss")); outputs.Add(file); } else { int count = vidFiles.Count; CutVideo(vidFiles[0].FileName, "MultipleTemp/" + "0.mp4", Time.startTime.ToString("hh:mm:ss"), vidFiles[0].EndTime.ToString("hh:mm:ss"), vidFiles[0].StartTime.ToString("hh:mm:ss")); CutVideo(vidFiles[count - 1].FileName, "MultipleTemp/" + "1.mp4", vidFiles[count - 1].StartTime.ToString("hh:mm:ss"), Time.endTime.ToString("hh:mm:ss"), vidFiles[0].StartTime.ToString("hh:mm:ss")); List <string> temp = new List <string>(); temp.Add("MultipleTemp/0.mp4"); for (int j = 1; j < count - 1; j++) { temp.Add(vidFiles[j].FileName); } temp.Add("MultipleTemp/1.mp4"); combinevidsList(temp, file); outputs.Add(file); } } if (!Directory.Exists(Global.VideoOutputDirectory)) { Directory.CreateDirectory(Global.VideoOutputDirectory); } DateTime time = DateTime.Now; outputFileName = "Output-" + time.ToString("hh:mm:ss") + ".mp4"; combinevidsList(outputs, outputFileName); return(outputFileName); }
// Método responsable de hacer toda la preparación de los datos para enviarlo como parámetro al SP/FUNCTION // que se encargan de dar de alta todos los registros asociados a una COMPRA. Por ejemplo, altas en compras, // en pasajes, en encomiendas, en tarjetas (si se pago de esa forma y la tarjeta no existe) etc. private void cargarDatosDeCompra(string codigoPNR) { int cliCod; int viajeCod; int dni; int tel; DateTime fechaNac; decimal precio; decimal peso; int butNro; int encontrado; int actualizar; int dniTxt; int.TryParse(txtDni.Text, out dniTxt); DataTable tablaPasajes = new DataTable(); tablaPasajes.Columns.Add("Código", typeof(int)); tablaPasajes.Columns.Add("DNI", typeof(int)); tablaPasajes.Columns.Add("Nombre", typeof(string)); tablaPasajes.Columns.Add("Apellido", typeof(string)); tablaPasajes.Columns.Add("Dirección", typeof(string)); tablaPasajes.Columns.Add("Teléfono", typeof(int)); tablaPasajes.Columns.Add("Mail", typeof(string)); tablaPasajes.Columns.Add("Fecha de nacimiento", typeof(DateTime)); tablaPasajes.Columns.Add("Código de viaje", typeof(int)); tablaPasajes.Columns.Add("Importe", typeof(decimal)); tablaPasajes.Columns.Add("Butaca", typeof(int)); tablaPasajes.Columns.Add("Matrícula", typeof(string)); tablaPasajes.Columns.Add("Encontrado", typeof(bool)); tablaPasajes.Columns.Add("Actualizar", typeof(bool)); tablaPasajes.Columns.Add("ES_COMPRADOR", typeof(int)); foreach (DataGridViewRow row in pasajes.Rows) { int.TryParse(row.Cells["Código"].Value.ToString(), out cliCod); int.TryParse(row.Cells["Código de viaje"].Value.ToString(), out viajeCod); int.TryParse(row.Cells["DNI"].Value.ToString(), out dni); int.TryParse(row.Cells["Teléfono"].Value.ToString(), out tel); DateTime.TryParse(row.Cells["Fecha de nacimiento"].Value.ToString(), out fechaNac); precio = enDecimal(row.Cells["Importe"].Value.ToString()); int.TryParse(row.Cells["Butaca"].Value.ToString(), out butNro); int esComprador; totalAAbonar = totalAAbonar + precio; if ((bool)row.Cells["Encontrado"].Value) { encontrado = 1; } else { encontrado = 0; } if ((bool)row.Cells["Actualizar"].Value) { actualizar = 1; } else { actualizar = 0; } if (dni == dniTxt) { esComprador = 1; } else { esComprador = 0; } tablaPasajes.Rows.Add(cliCod,dni, row.Cells["Nombre"].Value.ToString(), row.Cells["Apellido"].Value.ToString(), row.Cells["Dirección"].Value.ToString(), tel, row.Cells["Mail"].Value.ToString(), fechaNac,viajeCod, precio, butNro, row.Cells["Matrícula"].Value.ToString(), encontrado, actualizar, esComprador); } DataTable tablaEncomiendas = new DataTable(); tablaEncomiendas.Columns.Add("Código", typeof(int)); tablaEncomiendas.Columns.Add("DNI", typeof(int)); tablaEncomiendas.Columns.Add("Nombre", typeof(string)); tablaEncomiendas.Columns.Add("Apellido", typeof(string)); tablaEncomiendas.Columns.Add("Dirección", typeof(string)); tablaEncomiendas.Columns.Add("Teléfono", typeof(int)); tablaEncomiendas.Columns.Add("Mail", typeof(string)); tablaEncomiendas.Columns.Add("Fecha de nacimiento", typeof(DateTime)); tablaEncomiendas.Columns.Add("Código de viaje", typeof(int)); tablaEncomiendas.Columns.Add("Importe", typeof(decimal)); tablaEncomiendas.Columns.Add("Kilos", typeof(decimal)); tablaEncomiendas.Columns.Add("Matrícula", typeof(string)); tablaEncomiendas.Columns.Add("Encontrado", typeof(bool)); tablaEncomiendas.Columns.Add("Actualizar", typeof(bool)); tablaEncomiendas.Columns.Add("ES_COMPRADOR", typeof(int)); foreach (DataGridViewRow row in encomiendas.Rows) { int.TryParse(row.Cells["Código"].Value.ToString(), out cliCod); int.TryParse(row.Cells["Código de viaje"].Value.ToString(), out viajeCod); int.TryParse(row.Cells["DNI"].Value.ToString(), out dni); int.TryParse(row.Cells["Teléfono"].Value.ToString(), out tel); DateTime.TryParse(row.Cells["Fecha de nacimiento"].Value.ToString(), out fechaNac); precio = enDecimal(row.Cells["Importe"].Value.ToString()); peso = enDecimal(row.Cells["Kilos"].Value.ToString()); int esComprador; totalAAbonar = totalAAbonar + precio; if ((bool)row.Cells["Encontrado"].Value) { encontrado = 1; } else { encontrado = 0; } if ((bool)row.Cells["Actualizar"].Value) { actualizar = 1; } else { actualizar = 0; } if (dni == dniTxt) { esComprador = 1; } else { esComprador = 0; } tablaEncomiendas.Rows.Add(cliCod,dni, row.Cells["Nombre"].Value.ToString(), row.Cells["Apellido"].Value.ToString(), row.Cells["Dirección"].Value.ToString(), tel, row.Cells["Mail"].Value.ToString(), fechaNac,viajeCod, precio, peso, row.Cells["Matrícula"].Value.ToString(), encontrado, actualizar, esComprador); } int vencMes; int vencAnio; int cuotas; int.TryParse(cboMeses.Text, out vencMes); int.TryParse(cboAnios.Text, out vencAnio); int.TryParse(cboCuotas.Text, out cuotas); SQLManager manager = new SQLManager(); if (tarjetaNueva) { manager = manager.generarSP("ingresarDatosDeCompra") .agregarTableSP("@TablaPasajes", tablaPasajes) .agregarTableSP("@TablaEncomiendas", tablaEncomiendas) .agregarIntSP("@clienteCodigo", clienteCodigo) .agregarIntSP("@dni", txtDni) .agregarStringSP("@ape", txtApe) .agregarStringSP("@nombre", txtNom) .agregarStringSP("@direccion", txtDire) .agregarStringSP("@mail", txtMail) .agregarFechaSP("@fechanac", dp) .agregarIntSP("@telefono", txtTel) .agregarBooleanoSP("@encontroComprador", encontroCliente) .agregarBooleanoSP("@actualizarComprador", actualizarTabla) .agregarStringSP("@codigoPNR", codigoPNR) .agregarIntSP("@cuotas", cuotas) .agregarStringSP("@formaDePago", cboFormaPago) .agregarInt64SP("@nroTarjeta", txtNroTarjeta) .agregarIntSP("@codSeg", txtCodSeg) .agregarIntSP("@vencMes", vencMes) .agregarIntSP("@vencAnio", vencAnio) .agregarStringSP("@tipoTarjeta", cboTipoTarjeta) .agregarBooleanoSP("@agregarTarjeta", tarjetaNueva); } else { if (esEfectivo) { manager = manager.generarSP("ingresarDatosDeCompra") .agregarTableSP("@TablaPasajes", tablaPasajes) .agregarTableSP("@TablaEncomiendas", tablaEncomiendas) .agregarIntSP("@clienteCodigo", clienteCodigo) .agregarIntSP("@dni", txtDni) .agregarStringSP("@ape", txtApe) .agregarStringSP("@nombre", txtNom) .agregarStringSP("@direccion", txtDire) .agregarStringSP("@mail", txtMail) .agregarFechaSP("@fechanac", dp) .agregarIntSP("@telefono", txtTel) .agregarBooleanoSP("@encontroComprador", encontroCliente) .agregarBooleanoSP("@actualizarComprador", actualizarTabla) .agregarStringSP("@codigoPNR", codigoPNR) .agregarIntSP("@cuotas", 0) .agregarStringSP("@formaDePago", cboFormaPago) .agregarInt64SP("@nroTarjeta", 0) .agregarIntSP("@codSeg", 0) .agregarIntSP("@vencMes", 0) .agregarIntSP("@vencAnio", 0) .agregarStringSP("@tipoTarjeta", "nada") .agregarBooleanoSP("@agregarTarjeta", tarjetaNueva); } else { manager = manager.generarSP("ingresarDatosDeCompra") .agregarTableSP("@TablaPasajes", tablaPasajes) .agregarTableSP("@TablaEncomiendas", tablaEncomiendas) .agregarIntSP("@clienteCodigo", clienteCodigo) .agregarIntSP("@dni", txtDni) .agregarStringSP("@ape", txtApe) .agregarStringSP("@nombre", txtNom) .agregarStringSP("@direccion", txtDire) .agregarStringSP("@mail", txtMail) .agregarFechaSP("@fechanac", dp) .agregarIntSP("@telefono", txtTel) .agregarBooleanoSP("@encontroComprador", encontroCliente) .agregarBooleanoSP("@actualizarComprador", actualizarTabla) .agregarStringSP("@codigoPNR", codigoPNR) .agregarIntSP("@cuotas", cuotas) .agregarStringSP("@formaDePago", cboFormaPago) .agregarInt64SP("@nroTarjeta", txtNroTarjeta) .agregarIntSP("@codSeg", txtCodSeg) .agregarIntSP("@vencMes", vencMes) .agregarIntSP("@vencAnio", vencAnio) .agregarStringSP("@tipoTarjeta", cboTipoTarjeta) .agregarBooleanoSP("@agregarTarjeta", tarjetaNueva); } } try { manager.ejecutarSP(); MessageBox.Show("Se realizo la compra con éxito. Su codigo de PNR: " + codigoPNR + ". Monto a abonar: " + totalAAbonar.ToString() + ".", "Compra de pasajes y/o encomiendas", MessageBoxButtons.OK); } catch { MessageBox.Show("Fallo en la compra", "Fallo Compra", MessageBoxButtons.OK); this.Close(); return; } }
public PublisherBAL() { sql = new SQLManager(); }
public bool Supprimer(int id) { return(_BDD.ExecuterCommandeSQL(SQLManager.SupprimerUtilisateur(id))); }
private void suplantarAeronave() { SQLManager sqlManager = new SQLManager().generarSP("SuplantarAeronave") .agregarStringSP("@Matricula", matricula) .agregarFechaSP("@FechaBaja", fechaBaja); if (llamadoDesdeBajaLogica) sqlManager = sqlManager.agregarFechaNula("@FechaReinicio"); else sqlManager = sqlManager.agregarFechaSP("@FechaReinicio", fechaReinicio); sqlManager.ejecutarSP(); }
/* * Init checkbox fields to exclude the key column */ void InitCheckboxFields() { CheckBoxListInputColumns.DataSource = null; CheckBoxListInputColumns.DataBind(); CheckBoxListPredictColumns.DataSource = null; CheckBoxListPredictColumns.DataBind(); // execute query SQLManager manager = new SQLManager(sCatalog); DataTable objTable = new DataTable(); // handle errors //if (manager.GetQueryResult(sQueryText) == null) //{ // HandleQueryError(); // return; //} // exclude the key column string sQueryTextExclude = "SELECT COLUMN_NAME, ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + DropDownListTables.SelectedItem.ToString() + "' AND COLUMN_NAME <> '" + DropDownListKey.SelectedItem.ToString() + " 'ORDER BY ORDINAL_POSITION"; objTable.Load(manager.GetQueryResult(sQueryTextExclude)); CheckBoxListInputColumns.DataSource = objTable; CheckBoxListInputColumns.DataTextField = "COLUMN_NAME"; CheckBoxListInputColumns.DataValueField = "ORDINAL_POSITION"; CheckBoxListInputColumns.DataBind(); CheckBoxListPredictColumns.DataSource = objTable; CheckBoxListPredictColumns.DataTextField = "COLUMN_NAME"; CheckBoxListPredictColumns.DataValueField = "ORDINAL_POSITION"; CheckBoxListPredictColumns.DataBind(); manager.CloseConnection(); }
/* * Metodo que se encarga de invocar al SQLManager para armar la cadena que ejecuta * la procedure GenerarNuevoViaje, el cual inserta el nuevo registro en la tabla de viajes, * siempre y cuando se cumplan las restricciones del formulario, y siempre que la insercion * no haya sido fallida. En caso de no poder insertarse el registro (ya sea por fallo de constrains, * o algun otro fallo relacionado a la integridad de los datos), se lanzara una excepcion que se * cacheada en la aplicacion */ private Object insertarNuevoViaje() { SQLManager manejador = new SQLManager(); manejador.generarSP("GenerarNuevoViaje"); manejador.agregarStringSP("@salida", dateTimePicker1.Value.ToString()); manejador.agregarStringSP("@llegadaEstimada", dateTimePicker2.Value.ToString()); manejador.agregarIntSP("@ruta", txtRuta); manejador.agregarStringSP("@matricula", txtMatricula.Text); try { manejador.ejecutarSP(); return 1; } catch (System.Exception e) { MessageBox.Show(e.Message, "Erro al generar el nuevo viaje", MessageBoxButtons.OK); return null; } }
/* * Init all columns */ private void InitColumnsControlls() { // clear current query DropDownListKey.DataSource = null; DropDownListKey.DataBind(); // list selected table: to be removed //Label1.Text = ListBoxTables.SelectedItem.ToString(); string sQueryText = "SELECT COLUMN_NAME, ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + DropDownListTables.SelectedItem.ToString() + "'ORDER BY ORDINAL_POSITION"; // execute query SQLManager manager = new SQLManager(sCatalog); DataTable objTable = new DataTable(); // handle errors //if (manager.GetQueryResult(sQueryText) == null) //{ // HandleQueryError(); // return; //} objTable.Load(manager.GetQueryResult(sQueryText)); DropDownListKey.DataSource = objTable; DropDownListKey.DataTextField = "COLUMN_NAME"; DropDownListKey.DataValueField = "ORDINAL_POSITION"; DropDownListKey.DataBind(); manager.CloseConnection(); // init input columns InitCheckboxFields(); }
/* * Create mining structure with cusomt fields */ private MiningStructure CreateCustomMiningStructure(Database objDatabase, string sStructName, string sTableName, string sKeyColumn, List<string> lsInputColumns, List<string> lsPredictColumns, string sAlgorithm, List<bool> lbPredictColumns) { // drop the existing structures with the same name MiningStructure currentMiningStruct = objDatabase.MiningStructures.FindByName(sStructName); if (currentMiningStruct != null) currentMiningStruct.Drop(); // Initialize a new mining structure currentMiningStruct = new MiningStructure(sStructName, sStructName); currentMiningStruct.Source = new DataSourceViewBinding(objDatabase.DataSourceViews[0].Name); // get data type for the selected column string sQueryText = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + sTableName + "' AND COLUMN_NAME = '" + sKeyColumn + "'"; // execute query SQLManager manager = new SQLManager("MyDataBase"); DataTable objTable = new DataTable(); // get column data type objTable.Load(manager.GetQueryResult(sQueryText)); string sDataType = objTable.Rows[0][0].ToString(); manager.CloseConnection(); // create key column ScalarMiningStructureColumn StructKey = new ScalarMiningStructureColumn(sKeyColumn, sKeyColumn); StructKey.Type = GetColumnStructureType(sDataType); StructKey.Content = MiningStructureColumnContents.Key; StructKey.IsKey = true; StructKey.KeyColumns.Add("dbo_" + sTableName, sKeyColumn, GetColumnDataType(sDataType)); currentMiningStruct.Columns.Add(StructKey); // input columns for (int i = 0; i < lsInputColumns.Count; i++) { // get data type for the selected column sQueryText = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + sTableName + "' AND COLUMN_NAME = '" + lsInputColumns[i] + "'"; // get column data type objTable = new DataTable(); objTable.Load(manager.GetQueryResult(sQueryText)); sDataType = objTable.Rows[0][0].ToString(); // Generation column ScalarMiningStructureColumn Input = new ScalarMiningStructureColumn(lsInputColumns[i], lsInputColumns[i]); Input.Type = GetColumnStructureType(sDataType); if (Input.Type == MiningStructureColumnTypes.Long) Input.Content = MiningStructureColumnContents.Continuous; else Input.Content = MiningStructureColumnContents.Discrete; // Add data binding to the column Input.KeyColumns.Add("dbo_" + sTableName, lsInputColumns[i], GetColumnDataType(sDataType)); // Add the column to the mining structure currentMiningStruct.Columns.Add(Input); manager.CloseConnection(); } // add predict columns // input columns for (int i = 0; i < lsPredictColumns.Count; i++) { // if value = false (input & predict) then skip if (lbPredictColumns[i] == false) continue; // get data type for the selected column sQueryText = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + sTableName + "' AND COLUMN_NAME = '" + lsPredictColumns[i] + "'"; // get column data type objTable = new DataTable(); objTable.Load(manager.GetQueryResult(sQueryText)); sDataType = objTable.Rows[0][0].ToString(); // Generation column ScalarMiningStructureColumn Input = new ScalarMiningStructureColumn(lsPredictColumns[i], lsPredictColumns[i]); Input.Type = GetColumnStructureType(sDataType); // for double and long set to continous, else is discrete if (Input.Type == MiningStructureColumnTypes.Long || Input.Type == MiningStructureColumnTypes.Double) Input.Content = MiningStructureColumnContents.Continuous; else Input.Content = MiningStructureColumnContents.Discrete; // Add data binding to the column Input.KeyColumns.Add("dbo_" + sTableName, lsPredictColumns[i], GetColumnDataType(sDataType)); // Add the column to the mining structure currentMiningStruct.Columns.Add(Input); manager.CloseConnection(); } // Add the mining structure to the database objDatabase.MiningStructures.Add(currentMiningStruct); currentMiningStruct.Update(); return currentMiningStruct; }
/* * Init all table names into a listbox */ private void InitTableNames() { // show DB tables SQLManager manager = new SQLManager(sCatalog); string sQuery = "Select name, id from sysobjects where xtype='U'"; // handle errors //if (manager.GetQueryDataSet(sQuery) == null) //{ // HandleQueryError(); // return; //} DataSet objSet = manager.GetQueryDataSet(sQuery); DropDownListTables.DataSource = objSet; DropDownListTables.DataTextField = "name"; DropDownListTables.DataValueField = "id"; DropDownListTables.DataBind(); manager.CloseConnection(); }
private Object cancelarPasajesYEncomiendas() { SQLManager sqlManager = new SQLManager(); return sqlManager.generarSP("CancelarPasajesYEncomiendas"). agregarStringSP("@Codigo", txtCodigo.Text). agregarListaSP("@Pasajes", pasajes). agregarListaSP("@Encomiendas", encomiendas). agregarFechaSP("@FechaDevolucion", Program.fechaHoy()). agregarStringSP("@Motivo" , motivo). ejecutarSP(); }
/// <summary> /// Effectue la connexion avec la BDD /// </summary> /// <param name="sQLManager"></param> public ContratDAO(SQLManager sQLManager) : base(sQLManager) { }
void loadConfig(bool forDeploy = false) { log("Loading client configuration"); clientConfigManager = new ClientConfigManager(); rootPath = workingDirectory; binPath = rootPath + "bin\\" + branch + "\\"; if (!System.IO.Directory.Exists(rootPath + "bin\\")) { System.IO.Directory.CreateDirectory(rootPath + "bin\\"); } if (!System.IO.Directory.Exists(rootPath + "bin\\" + branch + "\\")) { System.IO.Directory.CreateDirectory(rootPath + "bin\\" + branch + "\\"); } string buildconf = "build"; if (rootPath.Contains("buildagent2")) { buildconf = "build2"; } clientConfigManager.load(rootPath + "config\\" + (forDeploy ? branch : buildconf) + "_" + "usp" + ".axc"); // rootPath + "config\\" + clientConfig); log("Client configuration loaded"); log("Loading server configuration"); serverConfigManager = new ServerConfigManager(); serverConfigManager.load(clientConfigManager.ServerName, clientConfigManager.PortNumber); log("Server configuration loaded"); mgr = new AOSManager() { ServerName = clientConfigManager.ServerName, // "april-ax-build", ServiceId = serverConfigManager.ServerServiceIdentifier, // "AOS60$01", TimeOutMinutes = 10 }; if (forDeploy) { mgr.TimeOutMinutes = 30; } client = new ClientManager(); client.AXClientBinPath = clientConfigManager.ClientBinPath; client.AXServerBinPath = serverConfigManager.ServerBinPath; client.AXConfigurationFile = rootPath + "config\\" + (forDeploy ? branch : buildconf) + "_" + "usp" + ".axc"; // rootPath + "config\\" + clientConfig; client.ModelManifest = rootPath + branch + "\\" + modelName + "\\Model.xml"; client.TimeOutMinutes = 60; model = new ModelManager() { AOSName = serverConfigManager.AOSName, SchemaName = "temp" }; sqlManager = new SQLManager(); sqlManager.DatabaseName = serverConfigManager.DatabaseName; sqlManager.Server = serverConfigManager.DatabaseServer; labelManager = new LabelManager(); }
public static void MyTestInitialize(TestContext testContext) { SettingsManager.context = testContext; Data = SettingsManager.Instance().Data; DbClient = new SQLManager(Data.StringConnection); }
public FacilityApplyResponse Post([FromBody] FacilityApplyRequest req) { FacilityApplyResponse resp = new FacilityApplyResponse(); try { if (req.starttime >= req.endtime) { resp.result = "fail"; return(resp); } //确保申请时间晚于当前 DateTime today = DateTime.Now; //获取当前时间 string applyHour = req.starttime.ToString("00"); //转换小时为字符串 string testTime = req.date.ToString("yyyy-MM-dd") + " " + applyHour + ":00:00"; //连接成申请时刻 if (DateTime.Compare(today, Convert.ToDateTime(testTime)) > 0) { resp.result = "fail"; return(resp); } MySqlConnection conn = SQLManager.getConn(); //连接数据库 conn.Open(); //打开数据库连接 MySqlCommand test = null; //创建查询指令 test = new MySqlCommand("select start_time,end_time,max_capacity,start_day,end_day " + "from facilities where facility_ID=?facility;", conn); test.Parameters.AddWithValue("?facility", req.facility); MySqlDataReader mdr = test.ExecuteReader();//查询设施信息 if (!mdr.HasRows) { resp.result = "wrong facility";//id错误 mdr.Close(); conn.Close(); return(resp); } else { mdr.Read(); FacilityInfo info = new FacilityInfo(); //存储设施信息类 info.start = Convert.ToInt32(mdr.GetValue(0)); //存储开放起始时间 info.end = Convert.ToInt32(mdr.GetValue(1)); //存储开放结束时间 info.capacity = Convert.ToInt32(mdr.GetValue(2)); //存储容量 info.startday = Convert.ToInt32(mdr.GetValue(3)); //开放起始日期 info.endday = Convert.ToInt32(mdr.GetValue(4)); //开放最后日期 mdr.Close(); if (req.starttime < info.start || req.endtime > info.end) //检查申请时间是否符合要求 { conn.Close(); resp.result = "invalid time"; return(resp); } int weekday = GetWeek(req.date); //转换int星期几 if (weekday < info.startday || weekday > info.endday) //检查日期是否符合要求 { conn.Close(); resp.result = "invalid date"; return(resp); } MySqlCommand cmd = null;//创建查询指令 //查询健康状态 cmd = new MySqlCommand("select currenthealth_status from student " + "where student_ID=@id;", conn); cmd.Parameters.AddWithValue("@id", req.id); mdr = cmd.ExecuteReader(); mdr.Read(); if (!mdr.HasRows) { resp.result = "wrong id";//id错误 mdr.Close(); conn.Close(); return(resp); } int health = Convert.ToInt32(mdr.GetValue(0)); mdr.Close(); if (health != 0)//若健康状态不为“健康”,申请失败 { conn.Close(); resp.result = "unqualified"; return(resp); } // 查询违约记录 cmd = new MySqlCommand("select count(*) from default_record " + "where applicant_ID=@id;", conn); cmd.Parameters.AddWithValue("@id", req.id); mdr = cmd.ExecuteReader(); mdr.Read(); int count = Convert.ToInt32(mdr.GetValue(0)); mdr.Close(); if (count != 0 && count % 3 == 0)//若违约次数为3的整数倍,检查是否在最近一周违约 { cmd = new MySqlCommand("select date from default_record " + "where applicant_ID=@id and count=@count;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@count", count); mdr = cmd.ExecuteReader(); mdr.Read(); DateTime lastdate = Convert.ToDateTime(mdr.GetValue(0)); mdr.Close(); DateTime current = DateTime.Now; TimeSpan ts1 = new TimeSpan(lastdate.Ticks); TimeSpan ts2 = new TimeSpan(current.Ticks); TimeSpan ts = ts1.Subtract(ts2).Duration(); int days = Convert.ToInt32(ts.Days.ToString()); if (days < 7)//最后一次违约记录在7天以内 { conn.Close(); resp.result = "unqualified"; return(resp); } } string date = req.date.ToString("yyyy-MM-dd"); //检查同一申请人申请时间段是否已有其他申请 cmd = new MySqlCommand("select applicant_ID from application " + "where applicant_ID=@id and date=@date and " + "((start_time>=@start and start_time<@end) or (end_time<=@end and end_time>@start));", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", req.starttime); cmd.Parameters.AddWithValue("@end", req.endtime); mdr = cmd.ExecuteReader(); if (mdr.HasRows)//已有其他申请 { mdr.Close(); conn.Close(); resp.result = "time overlap"; return(resp); } mdr.Close(); /* * int[] quantity;//存储每一时间段人数 * int hours = req.endtime - req.starttime; * quantity = new int[hours];*/ //查看每一时间段申请总人数 for (int i = req.starttime; i < req.endtime; i++) { cmd = new MySqlCommand("select count(*) from application " + "where facility_ID=@id and date=@date and start_time<=@start and end_time>=@end;", conn); cmd.Parameters.AddWithValue("@id", req.facility); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", i); cmd.Parameters.AddWithValue("@end", i + 1); mdr = cmd.ExecuteReader(); if (mdr.HasRows) { mdr.Read(); /* * quantity[i - req.starttime] = Convert.ToInt32(mdr.GetValue(0));*/ int number = Convert.ToInt32(mdr.GetValue(0)); if (number >= info.capacity) //若有时间段预约数已达到容量上限,预约失败 { mdr.Close(); conn.Close(); resp.result = "no left"; return(resp); } }/* * else * quantity[i - req.starttime] = 0;*/ mdr.Close(); } //所有条件符合,插入记录 cmd = new MySqlCommand("insert into application (applicant_ID,facility_ID,date,start_time,end_time)" + "values(@id,@facility,@date,@start,@end);", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@facility", req.facility); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", req.starttime); cmd.Parameters.AddWithValue("@end", req.endtime); cmd.Prepare(); cmd.ExecuteNonQuery();//执行insert语句 resp.result = "success"; } conn.Close();//关闭连接 } catch (Exception ex) { Console.WriteLine(ex); resp.result = "fail"; } return(resp); }
public void GetChecked(string msg) { int reqID; int id = 0; int userID = 0; string loc = ""; string cityCode = ""; int years = 0; int branchCtr = 0; string branchID = ""; foreach (GridViewRow gvrow in gvRequests.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("cbSelect"); if (chk != null && chk.Checked) { reqID = Convert.ToInt32(gvrow.Cells[1].Text); var cs = ConfigurationManager.ConnectionStrings["ZoomDB"]; string connection = cs.ConnectionString; SqlConnection sqlconnect = new SqlConnection(connection); SqlDataAdapter adapt = new SqlDataAdapter("Select * from ReqStatFranch", sqlconnect); DataSet dsReq = new DataSet(); adapt.Fill(dsReq, "ReqStatFranch"); DataTable tblReq; tblReq = dsReq.Tables["ReqStatFranch"]; foreach (DataRow row in tblReq.Rows) { if (reqID == Convert.ToInt32(row["id"].ToString())) { userID = Convert.ToInt32(row["userid"].ToString()); loc = row["location"].ToString(); cityCode = row["cityCode"].ToString(); years = Convert.ToInt32(row["years"].ToString()); break; } } adapt = new SqlDataAdapter("Select * from citytown", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "citytown"); tblReq = dsReq.Tables["citytown"]; foreach (DataRow row in tblReq.Rows) { if (cityCode == row["Code"].ToString()) { branchCtr = Convert.ToInt32(row["Branches"].ToString()); break; } } //*****************************COMMANDS TO UPDATE CUSTOMER TO OWNER && ADDING TO BRANCH TABLE branchID = cityCode + "-" + (branchCtr + 1).ToString(); SQLManager.SQLUpdateCustToOwner(userID); _Branch B = new _Branch(loc, userID, branchID, cityCode); SQLManager.SQLAddBranch(B); SQLManager.SQLUpdateCityCtr(branchCtr, cityCode); //*********************************ADD TO FRANCHISE TABLE adapt = new SqlDataAdapter("Select * from branch", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "branch"); tblReq = dsReq.Tables["branch"]; foreach (DataRow row in tblReq.Rows) { if (branchID == row["branchID"].ToString()) { id = Convert.ToInt32(row["id"].ToString()); break; } } sqlconnect.Close(); DateTime start = DateTime.Now; DateTime end = start.AddYears(years); _Franchise F = new _Franchise(id, start, end); SQLManager.SQLAddFranchise(F); SQLManager.DeleteReqStat(reqID); SQLManager.SQLAddNotif(msg, userID); } } }
public CategoryBAL() { sql = new SQLManager(); }
protected DAO(SQLManager sQLManager) { SQLManager = sQLManager; }
private void createQuestionButton_Click(object sender, RoutedEventArgs e) { if (questionTypes.SelectedIndex == 1) { if (String.IsNullOrEmpty(objectiveQuestion.Text)) { MessageBox.Show("Question Text cannot be empty\nPlease enter a question text", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if (String.IsNullOrEmpty(option1.Text) || String.IsNullOrEmpty(option2.Text) || String.IsNullOrEmpty(option3.Text) || String.IsNullOrEmpty(option4.Text)) { MessageBox.Show("Question Option cannot be empty\nPlease enter options of question", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if (correctChoiceComboBox.SelectedIndex == 0) { MessageBox.Show("Question Answer isn't selected\nPlease select correct choice", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else { try { SQLManager.addObjectiveQuestion(new ObjectiveQuestion(objectiveQuestion.Text, new String[4] { option1.Text, option2.Text, option3.Text, option4.Text }, new ObjectiveAnswer((byte)correctChoiceComboBox.SelectedIndex), -1, questionSubjects.SelectedIndex)); resetObjectiveQuestion(); resetQuestionTypeSelection(); MessageBox.Show("Question creation is successful\n", "Question Creation", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { MessageBox.Show("Question creation is failed\n" + ex.Message, "Question Creation", MessageBoxButton.OK, MessageBoxImage.Error); } } } else if (questionTypes.SelectedIndex == 2) { if (String.IsNullOrEmpty(descriptiveQuestion.Text)) { MessageBox.Show("Question Text cannot be empty\nPlease enter a question text", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if (String.IsNullOrEmpty(descriptiveAnswer.Text)) { MessageBox.Show("Question Answer cannot be empty\nPlease enter a question answer", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else { try { SQLManager.addDescriptiveQuestion(new DescriptiveQuestion(descriptiveQuestion.Text, new DescriptiveAnswer(descriptiveAnswer.Text), -1, questionSubjects.SelectedIndex)); resetDescriptiveQuestion(); resetQuestionTypeSelection(); MessageBox.Show("Question creation is successful\n", "Question Creation", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { MessageBox.Show("Question creation is failed\n" + ex.Message, "Question Creation", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { int selection = questionFunctionComboBox.SelectedIndex; if (selection < 1) { MessageBox.Show("Please choose a valid question function\n", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if ((selection == 1 || selection == 2 || selection == 3 || selection == 4) && !checkDirectoryOrFileName(actionName1TextBox.Text)) { MessageBox.Show("Diretory or File name isn't valid\nPlease enter a valid name\n", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if ((selection == 5 || selection == 6) && (!checkDirectoryOrFileName(actionName1TextBox.Text) || !checkDirectoryOrFileName(actionName1TextBox.Text))) { MessageBox.Show("Diretory or File names aren't valid\nPlease enter valid names\n", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if (selection == 7 && String.IsNullOrEmpty(actionText1TextBox.Text)) { MessageBox.Show("Entered Text cannot be empty\nPlease enter text", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else if (selection == 8 && String.IsNullOrEmpty(actionText2TextBox.Text)) { MessageBox.Show("Entered Texts cannot be empty\nPlease enter text", "Question Creation Error", MessageBoxButton.OK, MessageBoxImage.Error); } else { String questionText = null; String parameter1 = null; String parameter2 = null; if (selection == 1) { parameter1 = actionName1TextBox.Text; questionText = "Create a directory with name " + parameter1; } else if (selection == 2) { parameter1 = actionName1TextBox.Text; questionText = "Create a text file with name " + parameter1; } else if (selection == 3) { parameter1 = actionName1TextBox.Text; questionText = "Delete the directory with name " + parameter1; } else if (selection == 4) { parameter1 = actionName1TextBox.Text; questionText = "Delete the text file with name " + parameter1; } else if (selection == 5) { parameter1 = actionName1TextBox.Text; parameter2 = actionName2TextBox.Text; questionText = "Change the directory name from " + parameter1 + " to " + parameter2; } else if (selection == 6) { parameter1 = actionName1TextBox.Text; parameter2 = actionName2TextBox.Text; questionText = "Change the text file name from " + parameter1 + " to " + parameter2; } else if (selection == 7) { parameter1 = actionText1TextBox.Text; questionText = "Write " + parameter1 + " into text file with name enlightenment_test.txt"; } else if (selection == 8) { parameter1 = actionText1TextBox.Text; parameter2 = actionText2TextBox.Text; questionText = "Change " + parameter1 + " to " + parameter2 + " in text file with name enlightenment_test.txt"; } try { SQLManager.addActionBasedQuestion(new ActionBasedQuestion( questionText, selection, parameter1, parameter2, -1, questionSubjects.SelectedIndex)); resetActionBasedQuestion(); resetQuestionTypeSelection(); MessageBox.Show("Question creation is successful\n", "Question Creation", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { MessageBox.Show("Question creation is failed\n" + ex.Message, "Question Creation", MessageBoxButton.OK, MessageBoxImage.Error); } } } }
protected void btnsave_Click(object sender, System.EventArgs e) { try { //if (Fk_VendorID.SelectedIndex == 0) //{ // ErrorMessage = ErrorMessage + "Select Invoice.<br>"; //} if (ddlSEWB_Trn_Type.Text.Length == 0) { ErrorMessage = ErrorMessage + "Sub Type can not be Blank.<br>"; } if (SEWB_Doc_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Document No Cannot be Blank.<br>"; } if (SEWB_Doc_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Document Type Cannot Be Blank.<br>"; } if (SEWB_Doc_Date.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Vendor Document Date.<br>"; } if (SEWB_TranspoterName.Text.Length == 0) { ErrorMessage = ErrorMessage + "Transporter Name Cannot be Blank.<br>"; } if (SEWB_TransporterID.Text.Length == 0) { ErrorMessage = ErrorMessage + "TransporterId Cannot be Blank.<br>"; } if (SEWB_Distance.Text.Length == 0) { ErrorMessage = ErrorMessage + "Distance should be more than 100 km.<br>"; } if (SEWB_Trn_SubDesc.Text.Length == 0) { ErrorMessage = ErrorMessage + "SubDiscription be Blank.<br>"; } if (ddlSEWB_Trans_Mode.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Mode Of Transaction can not be blank<br>"; } if (SEWB_Trans_Doc_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Transaction doc no can not be blank<br>"; } if (SEWB_Trans_Doc_Date.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Transporter Doc Date.<br>"; } if (SEWB_ShippTo_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Supplier Place Of Supply<br>"; } if (SEWB_ShippFrom_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Recipient Place Of Supply<br>"; } if ((ddlSEWB_Trn_Type.Text.Length > 0) && (Fk_VendorID.SelectedIndex > 0)) { if (SQLManager.CheckDuplicateRecord("v_M_AT_Sales_SEWB_AHDR", "SEWB_HDR_ID", Convert.ToInt32("0" + SEWB_HDR_ID.Text), "SINV_No", ddlSEWB_Trn_Type.Text, " AND Fk_Branch_ID=" + SessionUserData.Company.BranchID + " AND Fk_VendorID=" + Fk_VendorID.Text)) { ErrorMessage = ErrorMessage + "Vendor Purchase Invoice Already Exist.<br>"; } } if ((Fk_VendorID.SelectedIndex > 0) && (Convert.ToInt32(SEWB_HDR_ID.Text) == 0)) { if (ddlSEWB_Trans_Mode.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Mode Of Transaction can not be blank<br>"; } if (SEWB_Trans_Doc_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Mode Of Transaction can not be blank<br>"; } if (SEWB_Trans_Doc_Date.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Vendor Transporter Doc Date Date.<br>"; } else { } } if ((Convert.ToInt32(SEWB_HDR_ID.Text) > 0) && (Convert.ToInt32(SEWB_CTL_ID.Text) > 0) && (DDlVehicle.SelectedIndex > 0)) { if (ddlSEWB_Trans_Mode.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Mode Of Transaction can not be blank<br>"; } if (SEWB_Trans_Doc_No.Text.Length == 0) { ErrorMessage = ErrorMessage + "Mode Of Transaction can not be blank<br>"; } if (SEWB_Trans_Doc_Date.Text.Length != 11) { ErrorMessage = ErrorMessage + "Invalid Vendor Transporter Doc Date Date.<br>"; } if (DDlVehicle.SelectedValue.Length == 0) { ErrorMessage = ErrorMessage + "Select Vehicle Type.<br>"; } else { } } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(SEWB_HDR_ID.Text) == 0) { ObjAT_SEWB_HDR.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjAT_SEWB_HDR.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; } SetValuesToBO_HDR(); ErrorMessage = ObjAT_SEWB_HDR.Insert_Update(ObjAT_SEWB_HDR); SEWB_HDR_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); if ((Convert.ToInt32(SEWB_HDR_ID.Text) > 0) && (DDlVehicle.SelectedIndex >= 0)) { if (Convert.ToInt32(SEWB_CTL_ID.Text) == 0) { ObjAT_SEWB_DTL.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_SEWB_DTL.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; } ObjAT_SEWB_TDTL.SEWB_CTL_ID = Convert.ToInt64("0" + SEWB_CTL_ID.Text); ObjAT_SEWB_TDTL.Fk_SEWB_HDR_ID = Convert.ToInt64("0" + SEWB_HDR_ID.Text); ObjAT_SEWB_TDTL.SEWB_Trans_Mode = ddlSEWB_Trans_Mode.SelectedValue; ObjAT_SEWB_TDTL.SEWB_Vehicle_Type = DDlVehicle.SelectedValue; ObjAT_SEWB_TDTL.SEWB_Vehicle_No = SEWB_Vehicle_No.Text; ObjAT_SEWB_TDTL.SEWB_Trans_Doc_No = SEWB_Trans_Doc_No.Text; ObjAT_SEWB_TDTL.SEWB_Trans_Doc_Date = SEWB_Trans_Doc_Date.Text; ObjAT_SEWB_DTL.SEWB_CGST_ID = 0; ObjAT_SEWB_DTL.SEWB_SGST_ID = 0; ObjAT_SEWB_DTL.SEWB_IGST_ID = 0; ObjAT_SEWB_DTL.SEWB_CESS_ID = 0; ObjAT_SEWB_TDTL.MDBSC_RowLupdnByUser_ID = SessionUserData.UserData.UserID; ObjAT_SEWB_TDTL.MDBSC_RowLupdnUserName = SessionUserData.UserData.UserName; ObjAT_SEWB_TDTL.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); ObjAT_SEWB_TDTL.Insert_Update(ObjAT_SEWB_TDTL); } scope.Complete(); } if (Convert.ToInt32("0" + SEWB_HDR_ID.Text) > 0) { MABL.SQLManager.SQLProcedureCall.USP_Update_Tbl_EWayBill(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID, Convert.ToInt32(SEWB_HDR_ID.Text)); SetValueToControls_Edit_HDR(Convert.ToInt32("0" + SEWB_HDR_ID.Text)); } // DisplayCustomMessageSummary(ErrorMessage); } else { // DisplayCustomMessageSummary(ErrorMessage); } Msg_ErrorMsg.Text = ErrorMessage; } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }
public BaseController() { this.dataManager = new SQLManager <T>(DataConnectionResource.LOCALMSSQLSERVER); }
public StudentCheckResponse Post([FromBody] StudentCheckRequest req) { StudentCheckResponse resp = new StudentCheckResponse(); try { MySqlConnection conn = SQLManager.getConn(); //连接数据库 conn.Open(); //打开数据库连接 MySqlCommand cmd = null; //sql语句 cmd = new MySqlCommand("select " + "student_name, Gender, department, grade, class_num, dorm_num, healthcode_color, " + "contact_way, emergency_contact, currenthealth_status " + "from student where student_ID = @id;", conn); cmd.Parameters.AddWithValue("@id", req.id); //绑定参数 MySqlDataReader mdr = cmd.ExecuteReader(); if (!mdr.HasRows) //查询无结果 { resp.result = "wrong id"; } else //查询成功 { mdr.Read(); resp.name = mdr[0].ToString(); int gen = Convert.ToInt32(mdr.GetValue(1)); resp.gender = gen == 0 ? "男" : "女"; resp.department = mdr[2].ToString(); resp.grade = mdr[3].ToString(); resp.classnum = mdr[4].ToString(); resp.dorm = mdr[5].ToString(); string color = mdr[6].ToString(); switch (color) { case "green": resp.healthcodecolor = "绿色"; break; case "red": resp.healthcodecolor = "红色"; break; case "yellow": resp.healthcodecolor = "黄色"; break; } resp.telephone = mdr[7].ToString(); resp.emergencyphone = mdr[8].ToString(); int health = Convert.ToInt32(mdr.GetValue(9)); switch (health) { case 0: resp.healthstatus = "健康"; break; case 1: resp.healthstatus = "发热"; break; case 2: resp.healthstatus = "疑似"; break; case 3: resp.healthstatus = "确诊"; break; } resp.result = "success"; } mdr.Close(); conn.Close();//关闭连接 } catch (Exception ex) { Console.WriteLine(ex); resp.result = "fail"; } return(resp); }
public static List <ModeloDTO> getAllModelos() { SqlDataReader reader = SQLManager.executeProcedureList("getModelos"); return(readerToListModelos(reader)); }
private void darDeBajaRuta(int idRuta) { SQLManager sqlManager = new SQLManager().generarSP("BajaRuta") .agregarIntSP("@IdRuta", idRuta); try { sqlManager.ejecutarSP(); } catch (Exception e) { MessageBox.Show(e.Message, "Error al dar de baja", MessageBoxButtons.OK); return; } MessageBox.Show("Se realizo la baja correctamente", "Informe", MessageBoxButtons.OK); }
//SAVE public static string CU_Mst_Vendor(M_AT_Mst_VendorBO mvObjVen) { M_AT_Mst_VendorBO ObjAT_Ven = new M_AT_Mst_VendorBO(); string strRetMst = ""; DataTable dt = new DataTable(); string var_ErrorMessage = ""; try { if (mvObjVen.MVen_RegType.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Pls Select Vendor Type<br>"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", mvObjVen.M_Ven_ID, "MVenCode", mvObjVen.MVen_Code, "")) { var_ErrorMessage = var_ErrorMessage + "Vendor Code Already Exist.<br>"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", mvObjVen.M_Ven_ID, "MVen_Name", mvObjVen.MVen_Name, "")) { var_ErrorMessage = var_ErrorMessage + "Vendor Name Already Exists.<br>"; } if (mvObjVen.MVen_Code.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Code No Cannot Be Blank.<br>"; } if (mvObjVen.MVen_Name.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Name Cannot Be Blank.<br>"; } if (mvObjVen.MVen_TradeName.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Trade Name Cannot Be Blank.<br>"; } if (mvObjVen.MVen_Reg_State_ID == 0) { var_ErrorMessage = var_ErrorMessage + "Select Customer State.<br>"; } if (mvObjVen.MVen_DispatchFrom_State_ID == 0) { var_ErrorMessage = var_ErrorMessage + "Select Customer Shipp To State.<br>"; } if (var_ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(mvObjVen.M_Ven_ID) == 0) { ObjAT_Ven.Fk_Company_ID = mvObjVen.Fk_Company_ID; ObjAT_Ven.Fk_Branch_ID = mvObjVen.Fk_Branch_ID; ObjAT_Ven.Fk_Year_ID = mvObjVen.Fk_Year_ID; ObjAT_Ven.MDBSC_RowCreatedByUser_ID = mvObjVen.MDBSC_RowCreatedByUser_ID; ObjAT_Ven.MDBSC_RowCreatedByUserName = mvObjVen.MDBSC_RowCreatedByUserName; ObjAT_Ven.MVen_Code = MaheshAF18.Application.MEF.GenrateRefNo(mvObjVen.Fk_Company_ID, mvObjVen.Fk_Branch_ID, 0, "Vendor", "Ven", "Ven", "No", "", "", "", 0); } ObjAT_Ven.M_Ven_ID = mvObjVen.M_Ven_ID; ObjAT_Ven.MVen_Name = mvObjVen.MVen_Name; ObjAT_Ven.MVen_DisplayName = mvObjVen.MVen_DisplayName; ObjAT_Ven.MVen_TradeName = mvObjVen.MVen_TradeName; ObjAT_Ven.MVen_RegType = mvObjVen.MVen_RegType; ObjAT_Ven.MVen_CreditDays = mvObjVen.MVen_CreditDays; ObjAT_Ven.MVen_Reg_Add1 = mvObjVen.MVen_Reg_Add1; ObjAT_Ven.MVen_Reg_Add2 = mvObjVen.MVen_Reg_Add2; ObjAT_Ven.MVen_Reg_Pincode = mvObjVen.MVen_Reg_Pincode; ObjAT_Ven.MVen_Reg_City = mvObjVen.MVen_Reg_City; ObjAT_Ven.MVen_Reg_State_ID = mvObjVen.MVen_Reg_State_ID; ObjAT_Ven.MVen_Reg_Country = mvObjVen.MVen_Reg_Country; ObjAT_Ven.MVen_BL_PANNO = mvObjVen.MVen_BL_PANNO; ObjAT_Ven.MVen_BL_GSTNO = mvObjVen.MVen_BL_GSTNO; ObjAT_Ven.MVen_Primary_Contact_Person = mvObjVen.MVen_Primary_Contact_Person; ObjAT_Ven.MVen_Primary_CP_MobileNo = mvObjVen.MVen_Primary_CP_MobileNo; ObjAT_Ven.MVen_Primary_CP_PhoneNo = mvObjVen.MVen_Primary_CP_PhoneNo; ObjAT_Ven.MVen_Primary_CP_EmailID = mvObjVen.MVen_Primary_CP_EmailID; ObjAT_Ven.MVen_DispatchFrom_CompanyName = mvObjVen.MVen_DispatchFrom_CompanyName; ObjAT_Ven.MVen_DispatchFrom_ContactPerson = mvObjVen.MVen_DispatchFrom_ContactPerson; ObjAT_Ven.MVen_DispatchFrom_CP_MobileNo = mvObjVen.MVen_DispatchFrom_CP_MobileNo; ObjAT_Ven.MVen_DispatchFrom_Add1 = mvObjVen.MVen_DispatchFrom_Add1; ObjAT_Ven.MVen_DispatchFrom_Add2 = mvObjVen.MVen_DispatchFrom_Add2; ObjAT_Ven.MVen_DispatchFrom_Pincode = mvObjVen.MVen_DispatchFrom_Pincode; ObjAT_Ven.MVen_DispatchFrom_City = mvObjVen.MVen_DispatchFrom_City; ObjAT_Ven.MVen_DispatchFrom_State_ID = mvObjVen.MVen_DispatchFrom_State_ID; ObjAT_Ven.MVen_DispatchFrom_Country = mvObjVen.MVen_DispatchFrom_Country; ObjAT_Ven.MVen_DispatchFrom_PANNO = mvObjVen.MVen_DispatchFrom_PANNO; ObjAT_Ven.MVen_DispatchFrom_GSTNO = mvObjVen.MVen_DispatchFrom_GSTNO; ObjAT_Ven.MDBSC_RowStatus = mvObjVen.MDBSC_RowStatus; ObjAT_Ven.MDBSC_RowLupdnByUser_ID = mvObjVen.MDBSC_RowLupdnByUser_ID; ObjAT_Ven.MDBSC_RowLupdnUserName = mvObjVen.MDBSC_RowLupdnUserName; ObjAT_Ven.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); ObjAT_Ven.MVen_Contact_FaxNo = mvObjVen.MVen_Contact_FaxNo; ObjAT_Ven.MVen_Contact_OfficeNo1 = mvObjVen.MVen_Contact_OfficeNo1; ObjAT_Ven.MVen_Contact_OfficeNo2 = mvObjVen.MVen_Contact_OfficeNo2; ObjAT_Ven.MVen_Contact_Email_Admin = mvObjVen.MVen_Contact_Email_Admin; ObjAT_Ven.MVen_Contact_Website = mvObjVen.MVen_Contact_Website; ObjAT_Ven.MVen_Primary_Contact_Designation = mvObjVen.MVen_Primary_Contact_Designation; var_ErrorMessage = ObjAT_Ven.Insert_Update(ObjAT_Ven); //ObjItem.MItem_ID =Convert.ToInt64( var_ErrorMessage.Substring((var_ErrorMessage.IndexOf("|") + 1), (var_ErrorMessage.Length - var_ErrorMessage.IndexOf("|") - 1))); //var_ErrorMessage = var_ErrorMessage.Substring((0), (var_ErrorMessage.IndexOf("|"))); scope.Complete(); } strRetMst = var_ErrorMessage; } else { strRetMst = var_ErrorMessage + "|" + mvObjVen.M_Ven_ID.ToString(); } return(strRetMst); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void Finalise() { SQLManager.ResetDatabase(); }
/// <summary> /// 일일퀘스트를 갱신합니다. /// </summary> /// <param name="AUID"></param> /// <param name="QuestCode1"></param> /// <param name="QuestCode2">여러 개를 갱신할 때 입력.</param> /// <param name="QuestCode3">여러 개를 갱신할 때 입력.</param> static public void UpdateDailyQuest(int AUID, string QuestCode1, string QuestCode2 = null, string QuestCode3 = null) { int maxQuest = 3; string[] QuestCode = new string[maxQuest]; int[] oldCount = new int[maxQuest]; int[] newCount = new int[maxQuest]; int[] cutLine = new int[maxQuest]; int[] Complete = new int[maxQuest]; int index = 0; string SQL = string.Format("select * from UserDailyQuest where AUID='{0}' and (QuestCode='{1}' or QuestCode='{2}' or QuestCode='{3}')", AUID, QuestCode1, QuestCode2, QuestCode3); SqlDataReader reader = SQLManager.ExecuteReader(SQL); CSVReader excel = null; if (reader.HasRows) { while (reader.Read()) { QuestCode[index] = reader["QuestCode"].ToString(); Complete[index] = int.Parse(reader["Complete"].ToString()); if (Complete[index] == 0) { if (excel == null) { excel = new CSVReader("TbQuest.txt"); } oldCount[index] = int.Parse(reader["Count"].ToString()); newCount[index] = oldCount[index] + 1; cutLine[index] = int.Parse(ReadJSONData.ReadLine(excel.FindJSONData("QuestCode", QuestCode[index]))[3]); //Debug.Log(CodeManager.GetMethodName() + AUID + " : " + QuestCode[index]); } index++; } } reader.Close(); for (int i = 0; i < index; i++) { if (Complete[i] == 0) { if (newCount[i] >= cutLine[i]) { newCount[i] = cutLine[i]; SQL = string.Format("update UserDailyQuest set Count='{0}', Complete='1' where AUID='{1}' and QuestCode='{2}'", newCount[i], AUID, QuestCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); SQL = string.Format("insert into UserDailyQuestCompleteNotice values ('{0}','{1}');", AUID, QuestCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + QuestCode[i] + " 가 갱신되어서 커트라인을 달성했다."); } } else { SQL = string.Format("update UserDailyQuest set Count='{0}' where AUID='{1}' and QuestCode='{2}'", newCount[i], AUID, QuestCode[i]); reader = SQLManager.ExecuteReader(SQL); reader.Close(); if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + QuestCode[i] + " 가 갱신되었다."); } } } else { if (showLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + QuestCode[i] + " 는 이미 커트라인을 달성했다."); } } } }
/// <summary> /// 에너지의 자연 회복을 갱신한다. /// </summary> /// <param name="AUID"></param> public void RefreshEnergy(int AUID) { isEnergyUp = false; finalEnergy = -1; int userLevel = -1; int userEnergy = -1; string SQL = string.Format("select * from UserInfo where AUID='{0}'", AUID); SqlDataReader reader = SQLManager.ExecuteReader(SQL); if (reader.HasRows) { reader.Read(); userLevel = int.Parse(reader["Level"].ToString()); userEnergy = int.Parse(reader["Energy"].ToString()); } reader.Close(); cutLine = userLevel + 49; SQL = string.Format("select * from Setting"); reader = SQLManager.ExecuteReader(SQL); if (reader.HasRows) { reader.Read(); MaxEnergy = int.Parse(reader["MaxEnergy"].ToString()); EnergyTime = int.Parse(reader["EnergyTime"].ToString()); } reader.Close(); SQL = "select convert(varchar(30), getdate(), 121) as currentTime"; reader = SQLManager.ExecuteReader(SQL); reader.Read(); // 현재 시각. DateTime cTime = Convert.ToDateTime(reader["currentTime"].ToString()); reader.Close(); SQL = string.Format("select * from UserEnergyTime where AUID='{0}'", AUID); reader = SQLManager.ExecuteReader(SQL); if (reader.HasRows) { reader.Read(); // 1 회복까지 남은 시간. lastTime = double.Parse(reader["LastTime"].ToString()); // 마지막으로 에너지가 변경된 시각. refreshTime = Convert.ToDateTime(reader["RefreshTime"].ToString()); reader.Close(); // 현재 시각 - 마지막으로 에너지가 변경된 시각 : 회복을 적용해야 하는 시간. TimeSpan ss = cTime.Subtract(refreshTime); double ts = ss.TotalMilliseconds; if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + ts / 1000 + " / refreshTime : " + refreshTime); } if (ts < EnergyTime) { // 회복은 없다. if (userEnergy < userLevel + 49) { lastTime = EnergyTime - ts; SQL = string.Format("update UserEnergyTime set LastTime='{0}' where AUID='{1}'", lastTime - lastTime % 1, AUID); SQLManager.ExecuteNonQuery(SQL); if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + "1 회복까지 앞으로 " + ((lastTime - lastTime % 1) / 1000) + " 초."); } } } else { // 에너지를 회복시킨다. bool isIncreaseEnergy = false; while (ts >= EnergyTime) { ts -= EnergyTime; if (userEnergy < userLevel + 49) { userEnergy++; isIncreaseEnergy = true; isEnergyUp = true; if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + "에너지 1 회복 : " + userEnergy + " / " + ts / 1000); } } if (userEnergy >= userLevel + 49) { ts = -1; break; } } if (isIncreaseEnergy) { SQL = string.Format("update UserInfo set Energy='{0}' where AUID='{1}'", userEnergy, AUID); SQLManager.ExecuteNonQuery(SQL); if (ts > -1) { lastTime = EnergyTime - ts; if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + "1 회복까지 앞으로 " + ((lastTime - lastTime % 1) / 1000) + " 초."); } } else { lastTime = -1; if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + "에너지가 만땅이 되었다!!"); } } //getdate() - (EnergyTime - lastTime) // DATEADD(millisecond, {1}, getdate()) // RefreshTime 은 현재 시각이 아니라 마지막으로 회복이 되는 시점을 넣어야 한다. SQL = string.Format("update UserEnergyTime set LastTime='{0}', RefreshTime=convert(varchar(30), DATEADD(millisecond, {1}, getdate()), 121) where AUID='{2}'", lastTime - lastTime % 1, -(EnergyTime - lastTime), AUID); //SQL = string.Format("update UserEnergyTime set LastTime='{0}', RefreshTime=convert(varchar(30), getdate(), 121) where AUID='{1}'", lastTime - lastTime % 1, AUID); SQLManager.ExecuteNonQuery(SQL); } else { // 이미 만땅이라서 회복이 되지 않았다. SQL = string.Format("update UserEnergyTime set LastTime='{0}' where AUID='{1}'", -1, AUID); SQLManager.ExecuteNonQuery(SQL); if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + AUID + " : " + "이미 만땅이라서 회복이 되지 않았다."); } } } } finalEnergy = userEnergy; reader.Close(); }
public void OnActionExecuting(ActionExecutingContext filterContext) { SQLManager manager = new SQLManager(); filterContext.Controller.ViewBag.userName = manager.SelectStudentName(filterContext.HttpContext.User.Identity.Name); }
/// <summary> /// 에너지 변경으로 인한 시간 계산을 시작하거나 끝낸다. /// </summary> /// <param name="AUID"></param> /// <param name="isLevelup"></param> /// <param name="userLevel"></param> /// <param name="oldEnergy"></param> /// <param name="newEnergy"></param> public void EnergyChanged(int AUID, bool isLevelup, int userLevel, int oldEnergy, ref int newEnergy) { cutLine = userLevel + 49; //SQLManager.DBOpen(); string SQL = string.Format("select * from Setting"); SqlDataReader reader = SQLManager.ExecuteReader(SQL); if (reader.HasRows) { reader.Read(); MaxEnergy = int.Parse(reader["MaxEnergy"].ToString()); EnergyTime = int.Parse(reader["EnergyTime"].ToString()); } reader.Close(); SQL = string.Format("select * from UserEnergyTime where AUID='{0}'", AUID); reader = SQLManager.ExecuteReader(SQL); if (reader.HasRows) { reader.Read(); lastTime = double.Parse(reader["LastTime"].ToString()); } reader.Close(); if (oldEnergy > newEnergy) { // 에너지가 감소했다. if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + "에너지가 감소했다."); } if (isLevelup) { // 레벨업을 했는데 에너지가 커트라인보다 낮으면 커트라인까지 회복시킨다. if (newEnergy < cutLine) { newEnergy = cutLine; } // 레벨업을 했는데 초기 에너지가 커트라인보다 높으면 유지시킨다. if (oldEnergy > cutLine) { newEnergy = oldEnergy; } } if (newEnergy >= cutLine) { // 최종 에너지가 커트라인 이상이면 계산을 중지한다. // 레벨업을 했으면 여기로 온다. lastTime = -1; } else { if (oldEnergy >= cutLine) { // 이제부터 계산을 시작한다. lastTime = EnergyTime; SQL = string.Format("update UserEnergyTime set LastTime='{0}', RefreshTime=convert(varchar(30), getdate(), 121) where AUID='{1}'", lastTime, AUID); SQLManager.ExecuteNonQuery(SQL); if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + oldEnergy + " -> " + newEnergy + " / lastTime : " + lastTime); } } } } else if (oldEnergy < newEnergy) { // 에너지가 증가했다. if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + "에너지가 증가했다."); } if (newEnergy > MaxEnergy) { newEnergy = MaxEnergy; } if (newEnergy >= cutLine) { // 최종 에너지가 커트라인 이상이면 계산을 중지한다. lastTime = -1; SQL = string.Format("update UserEnergyTime set LastTime='{0}' where AUID='{1}'", lastTime, AUID); SQLManager.ExecuteNonQuery(SQL); if (showJsonLog) { Debug.Log(CodeManager.GetMethodName() + oldEnergy + " -> " + newEnergy + " / lastTime : " + lastTime); } } } //SQLManager.DBClose(); }
protected void btnsave_Click(object sender, System.EventArgs e) { try { string var_GSTState = ""; string var_StateCode = ""; if (MVen_RegType.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Pls Select Vendor Type<br>"; } else { if ((MVen_RegType.Text == "Registered Taxpayer") || (MVen_RegType.Text == "Composite Taxpayer")) { if (MVen_BL_GSTNO.Text.Length != 15) { ErrorMessage = ErrorMessage + "Billing GST No Cannot Be Blank<br>"; } if (MVen_DispatchFrom_GSTNO.Text.Length != 15) { ErrorMessage = ErrorMessage + "Consigner GST No Cannot Be Blank<br>"; } if (MVen_Reg_State_ID.SelectedIndex > 0) { if (MVen_BL_GSTNO.Text.Length > 2) { var_GSTState = MVen_BL_GSTNO.Text.Substring(0, 2); } var_StateCode = MVen_Reg_State_ID.SelectedItem.Text.Substring(0, 2); if (var_GSTState != var_StateCode) { ErrorMessage = ErrorMessage + "Invlid Billing GST No For " + MVen_Reg_State_ID.SelectedItem.Text + " .<br>"; } } if (MVen_DispatchFrom_State_ID.SelectedIndex > 0) { if (MVen_DispatchFrom_GSTNO.Text.Length > 2) { var_GSTState = MVen_DispatchFrom_GSTNO.Text.Substring(0, 2); } var_StateCode = MVen_DispatchFrom_State_ID.SelectedItem.Text.Substring(0, 2); if (var_GSTState != var_StateCode) { ErrorMessage = ErrorMessage + "Invlid Consigner GST No For " + MVen_DispatchFrom_State_ID.SelectedItem.Text + " .<br>"; } } } if (MVen_RegType.Text == "Unregistered") { } } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", Convert.ToInt32("0" + M_Ven_ID.Text), "MVenCode", MVen_Code.Text, "")) { ErrorMessage = ErrorMessage + "Vendor Code Already Exist.<br>"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", Convert.ToInt32("0" + M_Ven_ID.Text), "MVenName", MVen_Name.Text, "")) { ErrorMessage = ErrorMessage + "Vendor Name Already Exists.<br>"; } if (MVen_Code.Text.Length == 0) { ErrorMessage = ErrorMessage + "Vendor Code No Cannot Be Blank.<br>"; } if (MVen_Name.Text.Length == 0) { ErrorMessage = ErrorMessage + "Vendor Name Cannot Be Blank.<br>"; } if (MVen_TradeName.Text.Length == 0) { ErrorMessage = ErrorMessage + "Vendor Trade Name Cannot Be Blank.<br>"; } if (MVen_Reg_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Vendor State.<br>"; } if (MVen_DispatchFrom_State_ID.SelectedIndex == 0) { ErrorMessage = ErrorMessage + "Select Vendor Shipp To State.<br>"; } if (ErrorMessage.Length == 0) { using (TransactionScope scope = new TransactionScope()) { if (Convert.ToInt32(M_Ven_ID.Text) == 0) { ObjAT_Ven.Fk_Company_ID = SessionUserData.Company.CompanyID; ObjAT_Ven.Fk_Branch_ID = SessionUserData.Company.BranchID; ObjAT_Ven.Fk_Year_ID = SessionUserData.Company.YearID; ObjAT_Ven.MDBSC_RowCreatedByUser_ID = SessionUserData.UserData.UserID; ObjAT_Ven.MDBSC_RowCreatedByUserName = SessionUserData.UserData.UserName; ObjAT_Ven.MVen_Code = MaheshAF18.Application.MEF.GenrateRefNo(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, 0, "Vendor", "VEN", "VEN", "No", "", "", "", 0); } SetValuesToBO(); ErrorMessage = ObjAT_Ven.Insert_Update(ObjAT_Ven); M_Ven_ID.Text = ErrorMessage.Substring((ErrorMessage.IndexOf("|") + 1), (ErrorMessage.Length - ErrorMessage.IndexOf("|") - 1)); ErrorMessage = ErrorMessage.Substring((0), (ErrorMessage.IndexOf("|"))); scope.Complete(); } SetValueToControls_Edit(Convert.ToInt64(M_Ven_ID.Text)); DisplayCustomMessageSummary(ErrorMessage); } else { DisplayCustomMessageSummary(ErrorMessage); } } catch (Exception ex) { DisplayCustomMessageSummary("Failed Save Data"); } }
protected void btnClear_Click(object sender, EventArgs e) { int reqID = -1; int brID = -1; int years = -1; int frID = -1; int uID = -1; string msg = "Your License renewal request has been denied"; DateTime expiry = DateTime.Now; foreach (GridViewRow gvrow in gvRequests.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("cbSelect"); if (chk != null && chk.Checked) { reqID = Convert.ToInt32(gvrow.Cells[1].Text); var cs = ConfigurationManager.ConnectionStrings["ZoomDB"]; string connection = cs.ConnectionString; SqlConnection sqlconnect = new SqlConnection(connection); SqlDataAdapter adapt = new SqlDataAdapter("Select * from renewalRequests", sqlconnect); DataSet dsReq = new DataSet(); adapt.Fill(dsReq, "renewalRequests"); DataTable tblReq; tblReq = dsReq.Tables["renewalRequests"]; foreach (DataRow row in tblReq.Rows) { if (reqID == Convert.ToInt32(row["id"].ToString())) { brID = Convert.ToInt32(row["brID"]); years = Convert.ToInt32(row["years"]); break; } } adapt = new SqlDataAdapter("Select * from franchise", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "franchise"); tblReq = dsReq.Tables["franchise"]; foreach (DataRow row in tblReq.Rows) { if (brID == Convert.ToInt32(row["BRANCH_ID"].ToString())) { frID = Convert.ToInt32(row["id"].ToString()); expiry = Convert.ToDateTime(row["FR_END"]); break; } } adapt = new SqlDataAdapter("Select * from branch", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "branch"); tblReq = dsReq.Tables["branch"]; foreach (DataRow row in tblReq.Rows) { if (brID == Convert.ToInt32(row["id"].ToString())) { uID = Convert.ToInt32(row["BR_OWNERID"].ToString()); break; } } sqlconnect.Close(); SQLManager.SQLDelLicenseReq(reqID); SQLManager.SQLAddNotif(msg, uID); } } Response.Redirect("RenewalRequest.aspx"); }
public AccountBAL() { sql = new SQLManager(); }
public void GetChecked(string msg) { int reqID = -1; int brID = -1; int years = -1; int frID = -1; int uID = -1; DateTime expiry = DateTime.Now; foreach (GridViewRow gvrow in gvRequests.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("cbSelect"); if (chk != null && chk.Checked) { reqID = Convert.ToInt32(gvrow.Cells[1].Text); var cs = ConfigurationManager.ConnectionStrings["ZoomDB"]; string connection = cs.ConnectionString; SqlConnection sqlconnect = new SqlConnection(connection); SqlDataAdapter adapt = new SqlDataAdapter("Select * from renewalRequests", sqlconnect); DataSet dsReq = new DataSet(); adapt.Fill(dsReq, "renewalRequests"); DataTable tblReq; tblReq = dsReq.Tables["renewalRequests"]; foreach (DataRow row in tblReq.Rows) { if (reqID == Convert.ToInt32(row["id"].ToString())) { brID = Convert.ToInt32(row["brID"]); years = Convert.ToInt32(row["years"]); break; } } adapt = new SqlDataAdapter("Select * from franchise", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "franchise"); tblReq = dsReq.Tables["franchise"]; foreach (DataRow row in tblReq.Rows) { if (brID == Convert.ToInt32(row["BRANCH_ID"].ToString())) { frID = Convert.ToInt32(row["id"].ToString()); expiry = Convert.ToDateTime(row["FR_END"]); break; } } adapt = new SqlDataAdapter("Select * from branch", sqlconnect); dsReq = new DataSet(); adapt.Fill(dsReq, "branch"); tblReq = dsReq.Tables["branch"]; foreach (DataRow row in tblReq.Rows) { if (brID == Convert.ToInt32(row["id"].ToString())) { uID = Convert.ToInt32(row["BR_OWNERID"].ToString()); break; } } sqlconnect.Close(); expiry = expiry.AddYears(years); SQLManager.SQLRenew(frID, expiry); SQLManager.SQLDelLicenseReq(reqID); SQLManager.SQLAddNotif(msg, uID); } } }
private Object darDeAltaRuta(List<string> listaServiciosAAgregar) { SQLManager sqlManager = new SQLManager(); return sqlManager.generarSP("AltaRuta") .agregarIntSP("@Codigo", txtCodigo) .agregarListaSP("@Servicios", listaServiciosAAgregar) .agregarStringSP("@CiudadOrigen", txtCiudadOrigen) .agregarStringSP("@CiudadDestino", txtCiudadDestino) .agregarDecimalSP("@PrecioPasaje", enDecimal(txtPrecioPasaje.Text)) .agregarDecimalSP("@PrecioeEncomienda", enDecimal(txtPrecioEncomienda.Text)) .ejecutarSP(); }
private Object darDeBajaRol(string nombre) { SQLManager sqlManager = new SQLManager(); return sqlManager.generarSP("BajaRol") .agregarStringSP("@Nombre", nombre) .ejecutarSP(); }