internal string GestioneRicerca(string strRicerca, string user) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Ricerca"; dbp[0].DbType = DbType.Xml; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = strRicerca; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Utente"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = user; sco.SPParams = dbp; sco.SPName = "[Utility].[SP_ArchivioRicerca_Insert]"; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return proc; }
internal DataTable getFromActiveDirectory(string username) { try { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "UserID"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = username; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Utenti_ADData_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; } catch (Exception ex) { throw ex; } }
internal string DeleteRelazione(int idRelazione, int idTipoDealer) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDRelazione"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idRelazione; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "IDTipoDealer"; dbp[1].DbType = DbType.Int32; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = idTipoDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_RelazioniDealer_Delete"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal DataTable GetAllDealerRelazioni(string codiceDealer, string ragioneSocialeDealer,int idTipoDealer) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[3]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "CodiceDealer"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = codiceDealer; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "RagioneSocialeDealer"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = ragioneSocialeDealer; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "IdTipoDealer"; dbp[2].DbType = DbType.Int32; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = idTipoDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_RelazioniDealer_GetDealer"; sco.SPParams = dbp; DataTable dt; sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal DataTable Dealer_CaricaValoriMultipliSelected(int idDealer, string nomeCampo) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDDealer"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idDealer; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "NomeCampo"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = nomeCampo; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_CaricaValoriMultipliSelected"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string DeleteProfilo(int idObj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDProfilo"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idObj; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Profilo_Delete"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal DataTable AutorizzazioneCampi_Get(int myIDProfilo, int myIDDealer) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDProfilo"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = myIDProfilo; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "IDDealer"; dbp[1].DbType = DbType.Int32; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = myIDDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_AutorizzazioneCampi_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string GestioneRicerca(string user) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Utente"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = user; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Ricerca"; dbp[1].DbType = DbType.Xml; dbp[1].Direction = ParameterDirection.Output; sco.SPParams = dbp; sco.SPName = "[Utility].[SP_ArchivioRicerca_Get]"; DataTable dt; List<ExpandoObject> outputList = new List<ExpandoObject>(); string proc = sqlop.ExecuteProcedure(sco, out dt, out outputList); IEnumerable<dynamic> Ricerca = outputList.Cast<dynamic>().Where(x => x.Nome.Contains("@Ricerca")); return Convert.ToString(Ricerca.First().Value); }
public void ReadAllPeopleRecords() { var ops = new SqlOperations(TestCatalog, true); var dt = ops.ReadPeople(); Assert.IsTrue(dt.Rows.Count == peopleRowCount, $"Expected {peopleRowCount} rows"); }
public void ValidateServerIsAvailable() { var backEndOperations = new SqlOperations(); var smo = new SmoOperations(); Assert.IsNotNull(smo.LocalServers().FirstOrDefault(server => server.Name == backEndOperations.Server), $"Expected server {backEndOperations.Server} to be available"); }
public void AddMultiplePersonsWithBadGender() { var ops = new SqlOperations(TestCatalog); var peopleList = new List <Person>(MockedPersonList()); peopleList.FirstOrDefault().Gender = 4; ops.AddPersonList(peopleList); }
private async Task MessageReceivedAsync(IDialogContext context) { if (Luis.intent == Intents.EmailCalendarAccess) { RootDialog.BotResponse = SqlOperations.ForBotReply(Luis.intent); await context.PostAsync(RootDialog.BotResponse); SqlOperations.ForConversationLog(RootDialog.message, RootDialog.BotResponse); } else if (Luis.intent == Intents.EmailMimecastRelease) { RootDialog.BotResponse = SqlOperations.ForBotReply(Luis.intent); await context.PostAsync(RootDialog.BotResponse); SqlOperations.ForConversationLog(RootDialog.message, RootDialog.BotResponse); } else if (Luis.intent == Intents.EmailInboxBlockSpam) { RootDialog.BotResponse = SqlOperations.ForBotReply(Luis.intent); await context.PostAsync(RootDialog.BotResponse); SqlOperations.ForConversationLog(RootDialog.message, RootDialog.BotResponse); } else if (Luis.intent == Intents.EmailOutlookSignatureCreation) { RootDialog.BotResponse = SqlOperations.ForBotReply(Luis.intent); await context.PostAsync(RootDialog.BotResponse); SqlOperations.ForConversationLog(RootDialog.message, RootDialog.BotResponse); } else if (Luis.intent == Intents.EmailAutoReplySetup) { for (int i = 0; i < Entities.EmailAutoReplySetup.Count; i++) { if (RootDialog.Email.Contains(Entities.EmailAutoReplySetup[i])) { string Entity = Entities.EmailAutoReplySetup[i]; RootDialog.BotResponse = SqlOperations.ForBotReplywithEntity(Luis.intent, Entity); string message = RootDialog.BotResponse.Replace("{Name}", RootDialog.Name); await context.PostAsync(message); SqlOperations.ForConversationLog(RootDialog.message, message); break; } } } else if (Luis.intent == Intents.SelfServiceRequestHardwareType) { RootDialog.BotResponse = SqlOperations.ForBotReplywithEntity(Luis.intent, Luis.entity); string message = RootDialog.BotResponse.Replace("{Name}", RootDialog.Name); await context.PostAsync(message); SqlOperations.ForConversationLog(RootDialog.message, message); } RootDialog rootDialog = new RootDialog(); await rootDialog.StartAsync(context); }
internal string UpdateUtente(Utente obj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[6]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDUtente"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = obj.IDUtente; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Nome"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = obj.Nome; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "Cognome"; dbp[2].DbType = DbType.String; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = obj.Cognome; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "Email"; dbp[3].DbType = DbType.String; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = obj.Email; dbp[4] = new SqlParameter(); dbp[4].ParameterName = "UserID"; dbp[4].DbType = DbType.String; dbp[4].Direction = ParameterDirection.Input; dbp[4].Value = obj.UserID; dbp[5] = new SqlParameter(); dbp[5].ParameterName = "IDProfilo"; dbp[5].DbType = DbType.Int32; dbp[5].Direction = ParameterDirection.Input; dbp[5].Value = obj.IDProfilo; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Utenti_Update"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) { return(proc); } return(""); }
public void ExecutingRowCountTest() { string command = @"SELECT TOP 1000 * FROM [SampleDb].[dbo].[Books]"; var executingRowCount = new SqlOperations <TestModels.TestModule>() .BeginOperation(x => x.CreateOptions(command)) .GetCommand() .ExecuteNonQuery(); }
private void ReaderToGenericListButton_Click(object sender, EventArgs e) { textBox1.Text = ""; dataGridView1.DataSource = null; var operations = new SqlOperations(); dataGridView1.DataSource = operations.ReaderToList(); }
public void DeleteSinglePerson() { var ops = new SqlOperations(TestCatalog); int personIdentifier = peopleRowCount + 1000; Assert.IsFalse(ops.RemovePerson(personIdentifier), "Expected not to delete record"); }
private async Task WiserChangeForm(IDialogContext context) { RootDialog.BotResponse = SqlOperations.GetResponseFromBot("ToFetchBotsReply", Intents.FootPrintsWiserIssueTicketing, "EndOfWiser"); SqlOperations.ForConversationLog(UserInput, RootDialog.BotResponse); await context.PostAsync(RootDialog.BotResponse); await rootDialog.StartAsync(context); }
public void ValidateServerIsNotAvailable() { var backEndOperations = new SqlOperations(); var smo = new SmoOperations(); var badServerName = "BadBadServerName"; Assert.IsNull(smo.LocalServers().FirstOrDefault(server => server.Name == badServerName), $"Expected not to find {badServerName}"); }
public void ValidateGendersExists() { var ops = new SqlOperations(TestCatalog); Assert.IsTrue(ops.GenderList.Count == genderRowCount, "Expected three gender items"); Assert.IsTrue(GenderList().All(gender => gender.IsDeepEqual(gender)), "Expected to find all genders"); }
private async Task CaptureUserIssue(IDialogContext context, IAwaitable <object> result) { var UserInput = await result as Activity; context.ConversationData.SetValue(StateKeys.UserIssue, UserInput); SqlOperations.ForConversationLog(message, "User's Issue"); await Proceed(context, result); }
private void BtnTest_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(TxtServer.Text) || String.IsNullOrEmpty(TxtUsername.Text) || String.IsNullOrEmpty(TxtPassword.Text)) { MessageBox.Show("Server information cannot be empty."); return; } SqlOperations.ConnectTest(TxtServer.Text, TxtUsername.Text, TxtPassword.Text); }
private void SaveCurrentButton_Click(object sender, EventArgs e) { if (_productsBindingSource.Current != null) { var success = SqlOperations.SaveProduct((Product)_productsBindingSource.Current); if (!success) { MessageBox.Show("Your message for failed to update"); } } }
internal async Task RiseTicketForFault(IDialogContext context, IAwaitable <object> result) { RootDialog.BotResponse = SqlOperations.GetResponseFromBot("ToFetchBotsReply", Intents.FootPrintsWiserIssueTicketing, "EndForFault"); await context.PostAsync(RootDialog.BotResponse); Email.SendEmail(RootDialog.Email); SqlOperations.ForConversationLog(RootDialog.BotResponse, "Email has been sent"); context.Wait(Luis.IdentifyUserQueryUsingLuis); }
internal DataTable GetAllProfili() { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Profilo_GetAll"; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string UpdateDealer(int IDUtente, DealerUpdate myDealerUpdate) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDUtente"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = IDUtente; XDocument DealerUpdateXml = new XDocument( new XElement("DealerUpdate", new XElement("Dealer", new XAttribute("IDDealer", myDealerUpdate.IDDealer), new XElement("Variazioni")))); foreach (DealerUpdateFields myDealerUpdateFields in myDealerUpdate.DealerUpdateFieldsList) { if (myDealerUpdateFields.IsDatoModificato) { XElement newElement = DealerUpdateXml.Element("DealerUpdate").Element("Dealer").Element("Variazioni"); newElement.Add(new XElement("Variazione", new XAttribute("NomeCampo", myDealerUpdateFields.NomeCampo), new XAttribute("DatoVecchio", myDealerUpdateFields.DatoVecchio), new XAttribute("DatoNuovo", myDealerUpdateFields.DatoNuovo))); } } dbp[1] = new SqlParameter(); dbp[1].ParameterName = "DealerUpdateXml"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = DealerUpdateXml.ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_Dealer_Update"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) { return(proc); } return("Scheda Dealer aggiornata con successo"); }
public void InvalidConnection() { var ops = new SqlOperations("BadServerName"); var dt = ops.ReadPeople(); /* * Normally one would use an Assert.IsTrue as commented out * below but in this case we can use ExpectedException Attribute, * see link above in seealso in method header comments. */ //Assert.IsTrue(ops.HasSqlException); }
public void DefaultCatalogExists() { var ops = new SqlOperations(TestCatalog); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(ops.ConnectionString); var catalog = builder.InitialCatalog; var smo = new SmoOperations(); var results = smo.DatabaseExists(catalog); Assert.IsTrue(smo.DatabaseExists(catalog)); }
internal DataTable GetAllUtenti() { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Utenti_GetAll"; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return(dt); }
private async Task Proceed(IDialogContext context, IAwaitable <object> result) { if (UserRequest == "Change") { context.ConversationData.TryGetValue(StateKeys.PinAndName, out string message); RootDialog.BotResponse = SqlOperations.GetResponseFromBot("ToFetchBotsReply", Intents.FootPrintsWiserIssueTicketing, "AskingToProceed"); SqlOperations.ForConversationLog(message, RootDialog.BotResponse); } PromptDialog.Choice(context, EndOfFlow, new List <string>() { "Yes", "No" }, RootDialog.BotResponse, "Please select from given Options"); }
public async Task AskForPinAndName(IDialogContext context, IAwaitable <object> result) { List <string> ListOfQusetions = new List <string>(); ListOfQusetions = SqlOperations.GetList("OptionsForFaultWiser"); context.ConversationData.TryGetValue(StateKeys.ChangeRequest, out message); SqlOperations.ForConversationLog(message, ListOfQusetions[1]); await context.PostAsync(ListOfQusetions[1]); context.Wait(CapturePinAndRegistrant); }
public void BetweenDatesFromPeopleTable() { var ops = new SqlOperations(TestCatalog); var expectedRowCount = 374; var startDate = new DateTime(1974, 1, 2, 1, 12, 0); var endDate = new DateTime(1984, 1, 2, 1, 12, 0); var dtPeople = ops.FindBetweenBirthDay(startDate, endDate); Assert.IsTrue(dtPeople.Rows.Count == expectedRowCount, $"Expected {expectedRowCount} rows but" + $"returned {dtPeople.Rows.Count} rows"); }
private async Task FaultOrChange(IDialogContext context, IAwaitable <string> result) { UserRequest = await result; if (UserRequest == "Fault") { context.Call(new WiserFaultDialog(), RiseTicketForFault); } else if (UserRequest == "Change") { SqlOperations.ForConversationLog(UserRequest, "Options for change"); context.Call(new WiserChangeDialog(), AskForPinAndName); } }
public void RowCountTest() { int rowCount = 1000; string query = $@"SELECT TOP {rowCount} * FROM [SampleDb].[dbo].[Books]"; var datas = new SqlOperations <TestModule>() .BeginOperation(x => x.CreateOptions(query)) .GetQuery <BookModel, BookModelMapper>() .GetData(); Assert.IsNotNull(datas); Assert.AreEqual(rowCount, datas.Count()); }
internal async Task InCaseOfValidation(IDialogContext context, IAwaitable <object> result) { var Input = await result as Activity; if (String.IsNullOrEmpty(PinAndFullName)) { PinAndFullName = Input.Text; SqlOperations.ForConversationLog("these are * required", ListOfQusetions[1]); await context.PostAsync(ListOfUnAnsweredQuestion[index]); index++; context.Wait(InCaseOfValidation); } else if (String.IsNullOrEmpty(TaskAttemptedWhileIssue)) { TaskAttemptedWhileIssue = Input.Text; SqlOperations.ForConversationLog(PinAndFullName, ListOfQusetions[2]); await context.PostAsync(ListOfUnAnsweredQuestion[index]); index++; context.Wait(InCaseOfValidation); } else if (String.IsNullOrEmpty(DisplayedErrorMessage)) { DisplayedErrorMessage = Input.Text; SqlOperations.ForConversationLog(DisplayedErrorMessage, ListOfQusetions[3]); await context.PostAsync(ListOfUnAnsweredQuestion[index]); index++; context.Wait(InCaseOfValidation); } else if (String.IsNullOrEmpty(NosOfUserImpacted)) { NosOfUserImpacted = Input.Text; SqlOperations.ForConversationLog(NosOfUserImpacted, ListOfQusetions[4]); WiserRootDialog.UserIncomplete = true; WiserRootDialog wiserRootDialog = new WiserRootDialog(); await wiserRootDialog.RiseTicketForFault(context, result); } }
internal async Task RiseTicketForFault(IDialogContext context, IAwaitable <object> result) { //context.ConversationData.TryGetValue(StateKeys.AdditionalInfo, out string message); RootDialog.BotResponse = SqlOperations.GetResponseFromBot("ToFetchBotsReply", Intents.FootPrintsWiserIssueTicketing, "EndForFault"); //SqlOperations.ForConversationLog(message, RootDialog.BotResponse); await context.PostAsync(RootDialog.BotResponse); Email.SendEmail(RootDialog.Email); context.Wait(Luis.IdentifyUserQueryUsingLuis); }
public void InsertNewDataRowForPerson() { var ops = new SqlOperations(TestCatalog); var dt = ops.ReadPeople(); DataRow row = dt.NewRow(); row["FirstName"] = "Karen"; row["LastName"] = "Payne"; row["Gender"] = 1; row["BirthDay"] = new DateTime(1960, 8, 20); Assert.IsTrue(ops.Add(row)); Assert.IsTrue(PersonExists(row.Field <string>("FirstName"), row.Field <string>("LastName"))); }
internal string InserRelazioneDealer(Relazioni rel) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[4]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "NomeRelazione"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = rel.NomeRelazione; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "IDTipoDealer"; dbp[1].DbType = DbType.Int32; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = rel.IDTipoDealer; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "IDDealer1"; dbp[2].DbType = DbType.Int32; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = rel.IDDealerConsumer; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "IDDealer2"; dbp[3].DbType = DbType.Int32; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = rel.IDDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_RelazioniDealer_Insert"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) { return(proc); } return(""); }
public void InsertPersonWithInvalidGender() { var ops = new SqlOperations(TestCatalog); var badGenderId = ops.GenderIdentifiers.Max() + 10; Person p = new Person() { FirstName = "Virginia", LastName = "Clime", Gender = badGenderId, BirthDay = new DateTime(1920, 10, 20) }; ops.Add(p); Assert.IsTrue(ops.HasException); }
private async Task EndOfFlow(IDialogContext context, IAwaitable <string> result) { UserInput = await result; if (UserInput == "Yes") { await WiserChangeForm(context); } if (UserInput == "No") { SqlOperations.ForConversationLog(UserInput, "Ok thank you"); await context.PostAsync("Ok thank you"); await rootDialog.StartAsync(context); } }
internal List<AutorizzazioneCampi> AutorizzazioneCampi_GetList(int myIDProfilo, int myIDDealer) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDProfilo"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = myIDProfilo; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "IDDealer"; dbp[1].DbType = DbType.Int32; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = myIDDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_AutorizzazioneCampi_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); List<AutorizzazioneCampi> myAutorizzazioneCampiList = new List<AutorizzazioneCampi>(); foreach (DataRow myDataRow in dt.Rows) { AutorizzazioneCampi myAutorizzazioneCampi = new AutorizzazioneCampi(); myAutorizzazioneCampi.IDAutorizzazioneCampi = Convert.ToInt32(myDataRow["IDAutorizzazioneCampi"]); myAutorizzazioneCampi.Autorizzazione = Convert.ToInt32(myDataRow["Autorizzazione"]); myAutorizzazioneCampi.IDCampoDati = Convert.ToInt32(myDataRow["IDCampoDati"]); myAutorizzazioneCampi.NomeCampo = Convert.ToString(myDataRow["NomeCampo"]); myAutorizzazioneCampi.NomeCampoFrontEnd = Convert.ToString(myDataRow["NomeCampoFrontEnd"]); myAutorizzazioneCampi.NomeTabella = Convert.ToString(myDataRow["NomeTabella"]); myAutorizzazioneCampi.TipoWebControl = Convert.ToString(myDataRow["TipoWebControl"]); myAutorizzazioneCampi.TipoDato = Convert.ToString(myDataRow["TipoDato"]); myAutorizzazioneCampi.LunghezzaMassima = Convert.ToInt32(myDataRow["LunghezzaMassima"]); myAutorizzazioneCampiList.Add(myAutorizzazioneCampi); } return myAutorizzazioneCampiList; }
internal DataTable GetAllDealersCode(string pre) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "DealerCode"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = pre; sco.SPParams = dbp; sco.SPName = "[Dealer].[SP_RicercaDealerCode_Get]"; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal DataTable GetAllExport(int fileType) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "FileType"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = fileType; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Export.ExportedFiles_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal DataTable Dealer_OrarioApertura_Get(int idObj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDDealer"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idObj; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_OrarioApertura_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal DataTable GetStorico(int idObj, string tipologia) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDDealer"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idObj; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Tipologia"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = tipologia; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_Storico_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string InsertDealerImport(string idObj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; //dbp[0] = new SqlParameter(); //dbp[0].ParameterName = "IDDealer"; //dbp[0].DbType = DbType.Int32; //dbp[0].Direction = ParameterDirection.Input; //dbp[0].Value = idObj; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Codice"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idObj; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Import.SP_EccezioniImport_Insert"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal string UpdateDealer(int IDUtente, DealerUpdate myDealerUpdate) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDUtente"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = IDUtente; XDocument DealerUpdateXml = new XDocument( new XElement("DealerUpdate", new XElement("Dealer", new XAttribute("IDDealer", myDealerUpdate.IDDealer), new XElement("Variazioni")))); foreach (DealerUpdateFields myDealerUpdateFields in myDealerUpdate.DealerUpdateFieldsList) { if (myDealerUpdateFields.IsDatoModificato) { XElement newElement = DealerUpdateXml.Element("DealerUpdate").Element("Dealer").Element("Variazioni"); newElement.Add(new XElement("Variazione", new XAttribute("NomeCampo", myDealerUpdateFields.NomeCampo), new XAttribute("DatoVecchio", myDealerUpdateFields.DatoVecchio), new XAttribute("DatoNuovo", myDealerUpdateFields.DatoNuovo))); } } dbp[1] = new SqlParameter(); dbp[1].ParameterName = "DealerUpdateXml"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = DealerUpdateXml.ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_Dealer_Update"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return "Scheda Dealer aggiornata con successo"; }
internal string UpdateDealerBusiness(DealerBusiness obj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[4]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDDealerBusiness"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = obj.IDDealerBusiness; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Codice"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = obj.Codice; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "Nome"; dbp[2].DbType = DbType.String; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = obj.Nome; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "Indirizzo"; dbp[3].DbType = DbType.String; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = obj.Indirizzo; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_DealerBusiness_Update"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal Boolean InsertUtente(Utente obj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[8]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Nome"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = obj.Nome; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Cognome"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = obj.Cognome; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "Email"; dbp[2].DbType = DbType.String; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = obj.Email; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "UserID"; dbp[3].DbType = DbType.String; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = obj.UserID; dbp[4] = new SqlParameter(); dbp[4].ParameterName = "IDProfilo"; dbp[4].DbType = DbType.Int32; dbp[4].Direction = ParameterDirection.Input; dbp[4].Value = obj.IDProfilo; dbp[5] = new SqlParameter(); dbp[5].ParameterName = "Attivo"; dbp[5].DbType = DbType.Boolean; dbp[5].Direction = ParameterDirection.Input; dbp[5].Value = obj.Attivo; dbp[6] = new SqlParameter(); dbp[6].ParameterName = "IDUtente"; dbp[6].DbType = DbType.Int32; dbp[6].Direction = ParameterDirection.Output; dbp[6].Value = obj.IDUtente; dbp[7] = new SqlParameter(); dbp[7].ParameterName = "Esiste"; dbp[7].DbType = DbType.Boolean; dbp[7].Direction = ParameterDirection.Output; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Utenti_Insert"; sco.SPParams = dbp; DataTable dt; List<ExpandoObject> outputList = new List<ExpandoObject>(); string proc = sqlop.ExecuteProcedure(sco, out dt, out outputList); IEnumerable<dynamic> esiste = outputList.Cast<dynamic>().Where(x => x.Nome.Contains("@Esiste")); return Convert.ToBoolean(esiste.First().Value); }
internal DataTable GetLocalita(string pre,string prov, string regione) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); DbParameter[] dbp = new DbParameter[3]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Localita"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = pre; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Provincia"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = prov; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "Regione"; dbp[2].DbType = DbType.String; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = regione; sco.SPName = "[Dealer].[SP_RicercaLocalita_Get]"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string InserRelazioneDealer(Relazioni rel) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[4]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "NomeRelazione"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = rel.NomeRelazione; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "IDTipoDealer"; dbp[1].DbType = DbType.Int32; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = rel.IDTipoDealer; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "IDDealer1"; dbp[2].DbType = DbType.Int32; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = rel.IDDealerConsumer; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "IDDealer2"; dbp[3].DbType = DbType.Int32; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = rel.IDDealer; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_RelazioniDealer_Insert"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal DataTable GetAllDealerImport() { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_DealerImport_GetAll"; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (dt.Rows.Count == 0) { //dt.Columns.Add("IDDealer", typeof(int)); dt.Columns.Add("Codice", typeof(string)); } return dt; }
internal DataTable IsCodRuoloActive(int idObj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDProfilo"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = idObj; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utility.SP_Is_CodRuolo_Active"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal string InsertProfilo(Profilo myProfilo, List<TipoDealer> myTipoDealerList, List<AutorizzazioneCampi> myAutorizzazioneCampiList) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[11]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "NomeProfilo"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = myProfilo.NomeProfilo; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "ArchivioDatabase"; dbp[1].DbType = DbType.Boolean; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = myProfilo.ArchivioDatabase; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "ArchivioCruscotto"; dbp[2].DbType = DbType.Boolean; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = myProfilo.ArchivioCruscotto; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "ReportAnomalie"; dbp[3].DbType = DbType.Boolean; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = myProfilo.ReportAnomalie; dbp[4] = new SqlParameter(); dbp[4].ParameterName = "ReportScarti"; dbp[4].DbType = DbType.Boolean; dbp[4].Direction = ParameterDirection.Input; dbp[4].Value = myProfilo.ReportScarti; dbp[5] = new SqlParameter(); dbp[5].ParameterName = "Portafoglio"; dbp[5].DbType = DbType.Boolean; dbp[5].Direction = ParameterDirection.Input; dbp[5].Value = myProfilo.Portafoglio; dbp[6] = new SqlParameter(); dbp[6].ParameterName = "Amministrazione"; dbp[6].DbType = DbType.Boolean; dbp[6].Direction = ParameterDirection.Input; dbp[6].Value = myProfilo.Amministrazione; dbp[7] = new SqlParameter(); dbp[7].ParameterName = "RagioniSocialiCorrelate"; dbp[7].DbType = DbType.Int32; dbp[7].Direction = ParameterDirection.Input; dbp[7].Value = myProfilo.RagioniSocialiCorrelate; dbp[8] = new SqlParameter(); dbp[8].ParameterName = "Eccezioni"; dbp[8].DbType = DbType.Boolean; dbp[8].Direction = ParameterDirection.Input; dbp[8].Value = myProfilo.Eccezioni; XElement tipoDealerXml = new XElement("Dealer", from TipoDealer in myTipoDealerList select new XElement("TipoDealer", new XElement("IDTipoDealer", TipoDealer.IDTipoDealer) ) ); dbp[9] = new SqlParameter(); dbp[9].ParameterName = "TipoDealerXml"; dbp[9].DbType = DbType.String; dbp[9].Direction = ParameterDirection.Input; dbp[9].Value = tipoDealerXml.ToString(); XElement autorizzazioneCampiXml = new XElement("Autorizzazioni", from AutorizzazioneCampi in myAutorizzazioneCampiList select new XElement("AutorizzazioneCampi", new XElement("IDAutorizzazioneCampi", AutorizzazioneCampi.IDAutorizzazioneCampi), new XElement("Autorizzazione", AutorizzazioneCampi.Autorizzazione), new XElement("IDCampoDati", AutorizzazioneCampi.IDCampoDati) ) ); dbp[10] = new SqlParameter(); dbp[10].ParameterName = "AutorizzazioneCampiXml"; dbp[10].DbType = DbType.String; dbp[10].Direction = ParameterDirection.Input; dbp[10].Value = autorizzazioneCampiXml.ToString(); SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Profilo_Insert"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }
internal DataTable GetUtente(string username) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Username"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = username; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_UtentiFromUsername_Get"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal DataTable GetAllTipoDealer(string utente = null) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "utente"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = utente; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_TipoDealer_GetAll"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (dt.Rows.Count == 0) { dt.Columns.Add("IDTipoDealer", typeof(int)); dt.Columns.Add("NomeTipoDealer", typeof(string)); } return dt; }
internal DataTable GetInfoDealer(string info, string param, string utente) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[1]; SqlCommandObject sco = new SqlCommandObject(); switch (info) { case "S": sco.SPName = "[Dealer].[SP_StatoDealer_GetAll]"; break; case "T": dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Utente"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = utente; sco.SPParams = dbp; sco.SPName = "[Dealer].[SP_TipoDealer_GetAll]"; break; case "Z": sco.SPName = "[Utility].[SP_Zone_GetAll]"; break; case "C": dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "TipoDealer"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = param; sco.SPParams = dbp; sco.SPName = "[Dealer].[SP_Canali_GetAll]"; break; case "R": sco.SPName = "[Utility].[SP_Regioni_Get]"; dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDZona"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = (param == "" ? "0" : param); sco.SPParams = dbp; break; case "P": sco.SPName = "[Utility].[SP_Province_Get]"; dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDRegione"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = (param == "" ? "0" : param); sco.SPParams = dbp; break; case "L": sco.SPName = "[Utility].[SP_Comuni_Get]"; dbp = new DbParameter[1]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDProvincia"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = (param == "" ? "0" : param); sco.SPParams = dbp; break; case "A": sco.SPName = "[Utility].[SP_AreaManager_GetAll]"; break; case "O": sco.SPName = "[Area].[SP_Operativita_GetAll]"; break; case "F": sco.SPName = "[Importo].[SP_Funzionario_GetAll]"; break; case "V": sco.SPName = "[Negozio].[SP_ModelloVendita_GetAll]"; break; case "G": sco.SPName = "[Utility].[SP_SegmentazioneCanale_GetAll]"; break; case "CL": sco.SPName = "[Negozio].[SP_Cluster_GetAll]"; break; case "AC": sco.SPName = "[Area].[SP_AreaCompetenza_GetAll]"; break; case "TA": sco.SPName = "[Negozio].[SP_CentroAssistenzaTecnica_GetAll]"; break; } DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); return dt; }
internal Boolean ExistsDealerBusiness(string obj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[2]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "Codice"; dbp[0].DbType = DbType.String; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = obj; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Esiste"; dbp[1].DbType = DbType.Boolean; dbp[1].Direction = ParameterDirection.Output; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Dealer.SP_DealerBusiness_Exists"; sco.SPParams = dbp; DataTable dt; List<ExpandoObject> output; string proc = sqlop.ExecuteProcedure(sco, out dt, out output); IEnumerable<dynamic> idDealerBusiness = output.Cast<dynamic>().Where(x => x.Nome.Contains("@Esiste")); return idDealerBusiness.First().Value; }
internal string UpdateUtente(Utente obj) { sqlop = new SqlOperations(); sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString(); DbParameter[] dbp = new DbParameter[6]; dbp[0] = new SqlParameter(); dbp[0].ParameterName = "IDUtente"; dbp[0].DbType = DbType.Int32; dbp[0].Direction = ParameterDirection.Input; dbp[0].Value = obj.IDUtente; dbp[1] = new SqlParameter(); dbp[1].ParameterName = "Nome"; dbp[1].DbType = DbType.String; dbp[1].Direction = ParameterDirection.Input; dbp[1].Value = obj.Nome; dbp[2] = new SqlParameter(); dbp[2].ParameterName = "Cognome"; dbp[2].DbType = DbType.String; dbp[2].Direction = ParameterDirection.Input; dbp[2].Value = obj.Cognome; dbp[3] = new SqlParameter(); dbp[3].ParameterName = "Email"; dbp[3].DbType = DbType.String; dbp[3].Direction = ParameterDirection.Input; dbp[3].Value = obj.Email; dbp[4] = new SqlParameter(); dbp[4].ParameterName = "UserID"; dbp[4].DbType = DbType.String; dbp[4].Direction = ParameterDirection.Input; dbp[4].Value = obj.UserID; dbp[5] = new SqlParameter(); dbp[5].ParameterName = "IDProfilo"; dbp[5].DbType = DbType.Int32; dbp[5].Direction = ParameterDirection.Input; dbp[5].Value = obj.IDProfilo; SqlCommandObject sco = new SqlCommandObject(); sco.SPName = "Utenti.SP_Utenti_Update"; sco.SPParams = dbp; DataTable dt; string proc = sqlop.ExecuteProcedure(sco, out dt); if (proc != string.Empty) return proc; return ""; }