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 "";
}
