private static void AddParms(ref DBAccess db, IncassoSag i)
{
var with_1 = i;
db.AddNVarChar("ContactEmail", with_1.ContactEmail, 250);
db.AddNVarChar("ContactName", with_1.ContactName, 50);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("InvoiceID", with_1.InvoiceID);
db.AddDateTime("IncassoDate", with_1.IncassoDate);
db.AddNVarChar("Notes", with_1.Notes, -1);
db.AddFloat("InvoiceTotal", with_1.InvoiceTotal);
db.AddFloat("RenterOpgjortAfKreditor", with_1.RenterOpgjortAfKreditor);
db.AddFloat("GebyrOpgjortAfKreditor", with_1.GebyrOpgjortAfKreditor);
db.AddFloat("RenteTilskrevetFraPaymentDatetilDD", with_1.RenteTilskrevetFraPaymentDatetilDD);
db.AddFloat("GebyrForDenneRykkerskrivelse", with_1.GebyrForDenneRykkerskrivelse);
db.AddFloat("IncassoTotal", with_1.IncassoTotal);
db.AddFloat("IncassoSalaer", with_1.IncassoSalaer);
db.AddFloat("Oversendelsesgebyr", with_1.Oversendelsesgebyr);
db.AddBoolean("Paid", with_1.Paid);
db.AddDateTime("PaidDate", with_1.PaidDate);
AddParmsStandard(db, i);
}
private static void AddParms(ref DBAccess db, CampaignCompany rec)
{
var with_1 = rec;
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("CampaignID", with_1.CampaignID);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddGuid("ResponsibleID", with_1.ResponsibleID);
db.AddNVarChar("ResponsibleName", with_1.ResponsibleName, 50);
db.AddNVarChar("ResponsibleEmail", with_1.ResponsibleEmail, 255);
db.AddNVarChar("ContactPerson", with_1.ContactPerson, 50);
db.AddBoolean("ContactedByPhone", with_1.ContactedByPhone);
db.AddBoolean("MeetingHeld", with_1.MeetingHeld);
db.AddBoolean("CampaignSale", with_1.CampaignSale);
db.AddMoney("CampaignSaleAmount", (double)with_1.CampaignSaleAmount);
db.AddBoolean("ExpectedSale", with_1.ExpectedSale);
db.AddMoney("ExpectedSaleAmount", (double)with_1.ExpectedSaleAmount);
db.AddNVarChar("Notes", with_1.Notes, -1);
AddParmsStandard(db, rec);
}
public static bool ChangeUserName(string ApplicationName, string oldUserName, string newUserName)
{
bool IsSuccsessful = false;
if (IsUserNameValid(newUserName))
{
DBAccess db = new DBAccess(MembershipConnectionString);
// db.Connection.Close()
//db.ConnectionString = MembershipConnectionString 'ConfigurationManager.ConnectionStrings("MembershipConnectionString").ConnectionString
//db.Connection.Open()
db.AddNVarChar("ApplicationName", ApplicationName, 256);
db.AddNVarChar("OldUserName", oldUserName, 256);
db.AddNVarChar("NewUserName", newUserName, 256);
try
{
int retval = db.ExecuteNonQuery("dbo.sproc_ChangeUserName");
IsSuccsessful = true;
}
catch (Exception)
{
IsSuccsessful = false;
}
}
else
{
IsSuccsessful = false;
}
return(IsSuccsessful);
}
//Protected Sub AddLog(ByVal Status As String, ByVal Logtext As String, Optional ByVal logtype As LogTypeEnum = LogTypeEnum.Normal)
// Log.AddLog(Status, Logtext, logtype)
//End Sub
#endregion
#region Standard Populate
protected static object AddParmsStandard(DBAccess db, BaseObject rec)
{
db.AddNVarChar("RettetAf", rec.CurUser, 50);
db.AddNVarChar("RettetIP", rec.CurIP, 15);
return(rec);
}
private static void AddParms(ref DBAccess db, Invoiceline c)
{
var with_1 = c;
db.AddInt("InvoiceID", with_1.InvoiceID);
db.AddInt("Pos", with_1.Pos);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("ItemID", with_1.ItemID);
db.AddNVarChar("ItemNo", with_1.ItemNo, 50);
db.AddNVarChar("ItemName", with_1.ItemName, 100);
db.AddNVarChar("LineText", with_1.LineText, 250);
db.AddNVarChar("SerialNo", with_1.SerialNo, 250);
db.AddDecimal("ItemPrice", with_1.ItemPrice);
db.AddDecimal("Discount", with_1.Discount);
db.AddDecimal("SalesPrice", with_1.SalesPrice);
db.AddDecimal("Quantity", with_1.Quantity);
db.AddDecimal("LineTotal", with_1.LineTotal);
db.AddBoolean("VAT", with_1.VAT);
db.AddDecimal("Freight", with_1.Freight);
db.AddDecimal("ProvisionRate", with_1.ProvisionRate);
db.AddDecimal("Provision", with_1.Provision);
db.AddDecimal("LineProvision", with_1.LineProvision);
AddParmsStandard(db, c);
}
public static DataSet GetEyeWash_SearchAll(string Postnr, string SerialNo)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
//Dim arr As String() = Search.Split(" "c)
//For Each s As String In arr
db.AddNVarChar("Postnr", Postnr, 50);
db.AddNVarChar("SerialNo", SerialNo, 50);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
// EXEC @return_value = [vicjos1_sysadm].[Co2Db_EyeWash_Search]
// @SerialNo = ''
// , @Postnr = '3400'
// , @IsAgent = 0
// , @AgentID = null
dsTemp = db.ExecuteDataSet(_SQLSearch);
db.Parameters.Clear();
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
return(ds);
}
public static int PageAccessDelete(string PageUrl, string ApplicationName)
{
DBAccess db = new DBAccess();
db.AddNVarChar("ApplicationName", ApplicationName, 256);
db.AddNVarChar("Page", PageUrl, 250);
return(db.ExecuteNonQuery(_SQLDelete));
}
private static void AddParms(ref DBAccess db, NewsGrp c)
{
var with_1 = c;
db.AddInt("ParentID", with_1.ParentID);
db.AddNVarChar("NewsGrpNr", with_1.NewsGrpNr, 50);
db.AddNVarChar("NewsGrpTekst", with_1.NewsGrpTekst, 50);
AddParmsStandard(db, c);
}
private static void AddParms(ref DBAccess db, Currency c)
{
var with_1 = c;
db.AddVarChar("CurrencyCode", with_1.CurrencyCode, 10);
db.AddNVarChar("CurrencyDesc", with_1.CurrencyDesc, 50);
db.AddDecimal("CurrencyRate", with_1.CurrencyRate);
db.AddDateTime("CurrencyDate", with_1.CurrencyDate);
db.AddNVarChar("CurrencySymbol", with_1.CurrencySymbol, 50);
AddParmsStandard(db, c);
}
//UPDATE [vicjos1_RescueTekniq].[vicjos1_sysadm].[Co2Db_Aiva]
// SET [CompanyID] = <CompanyID, int,>
// ,[Status] = <Status, int,>
// ,[ModelID] = <ModelID, int,>
// ,[SerialNo] = <SerialNo, nvarchar(50),>
// ,[InvoiceID] = <InvoiceID, nvarchar(50),>
// ,[SalesDate] = <SalesDate, datetime,>
// ,[OprettetAf] = <OprettetAf, nvarchar(50),>
// ,[OprettetDen] = <OprettetDen, datetime,>
// ,[OprettetIP] = <OprettetIP, nvarchar(15),>
// ,[RettetAf] = <RettetAf, nvarchar(50),>
// ,[RettetDen] = <RettetDen, datetime,>
// ,[RettetIP] = <RettetIP, nvarchar(50),>
// WHERE <Search Conditions,,>
//GO
private static void AddParms(ref DBAccess db, Aiva c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("ModelID", with_1.ModelID);
db.AddNVarChar("InvoiceID", with_1.InvoiceID, 50);
db.AddNVarChar("SerialNo", with_1.SerialNo, 50);
db.AddDateTime("SalesDate", with_1.SalesDate);
AddParmsStandard(db, c);
}
private static void AddParms(ref DBAccess db, Postnummer c)
{
var with_1 = c;
db.AddNVarChar("Postnr", with_1.Postnr, 10);
db.AddNVarChar("Bynavn", with_1.Bynavn, 50);
db.AddNVarChar("Gade", with_1.Gade, 50);
db.AddNVarChar("Firma", with_1.Firma, 50);
db.AddInt("Land", with_1.LandID);
db.AddBoolean("Provins", bool.Parse(with_1.Provins));
AddParmsStandard(db, c);
}
private static void AddParms(ref DBAccess db, LogLine c)
{
var with_1 = c;
db.AddNVarChar("Status", with_1.Status, 50);
db.AddNVarChar("Metode", with_1.Metode, 50);
db.AddNVarChar("Cvrnr", with_1.Cvrnr, 50);
db.AddNVarChar("LogText", with_1.LogText, -1);
db.AddNVarChar("ClientInfo", with_1.ClientInfo, 1023);
db.AddInt("LogType", (System.Int32)with_1.LogType);
AddParmsStandard(db, c);
}
private static void PopulateDBwithInfositePages(DBAccess db, Infosites po)
{
var with_1 = po;
db.AddBoolean("@Aktiv", with_1.Aktiv);
db.AddInt("Site_FK", with_1.Site_FK);
db.AddInt("Parent_ID", with_1.Parent_ID);
// db.AddInt("Sort", .Sort)
db.AddBoolean("@IncludeInMenu", with_1.IncludeInMenu);
db.AddBoolean("@Forside", with_1.Forside);
db.AddBoolean("@IsDisabled", with_1.IsDisabled);
db.AddBoolean("@IsDeleted", with_1.IsDeleted);
db.AddNVarChar("PageName", with_1.PageName, 50);
db.AddNVarChar("PageTitle", with_1.PageTitle, 50);
db.AddNVarChar("Description", with_1.Description, 250);
db.AddNVarChar("Keywords", with_1.Keywords, 250);
db.AddInt("Template_ID", with_1.Template_ID);
db.AddInt("Category_ID", with_1.Category_ID);
db.AddInt("LinkType_ID", with_1.LinkType_ID);
db.AddNVarChar("LinkUrl", with_1.LinkUrl, 250);
db.AddInt("LinkPage_ID", with_1.LinkPage_ID);
db.AddNVarChar("LinkTarget", with_1.LinkTarget, 50);
db.AddDateTime("OpenDate", with_1.OpenDate);
db.AddDateTime("ExpireDate", with_1.ExpireDate);
db.AddNVarChar("RettetAf", with_1.CurUser);
db.AddNVarChar("RettetIP", with_1.CurIP);
}
private static void AddParms(ref DBAccess db, tilbudHeader c)
{
db.AddInt("Status", (System.Int32)c.Status);
db.AddInt("CompanyID", c.CompanyID);
db.AddDateTime("Opretdato", c.Opretdato);
db.AddDateTime("Udlobdato", c.Udlobdato);
db.AddInt("AnsvarligID", c.AnsvarligID);
db.AddGuid("AnsvarligGUID", c.AnsvarligGUID);
db.AddNVarChar("KontaktEmail", c.KontaktEmail, 250);
db.AddNVarChar("KontaktPerson", c.KontaktPerson, 50);
db.AddNVarChar("Noter", c.Noter, -1);
db.AddNVarChar("TilbudsTillaeg", c.TilbudsTillaeg, -1);
db.AddDecimal("Transport", c.Transport);
AddParmsStandard(db, c);
}
public static void set_PageAccess(string PageUrl, string ApplicationName, string value)
{
DBAccess db = new DBAccess();
PageAccessClass p = new PageAccessClass();
db.AddNVarChar("ApplicationName", ApplicationName, 256);
db.AddNVarChar("Page", PageUrl, 250);
db.AddNVarChar("Access", value, 250);
db.AddNVarChar("RettetAF", p.RettetAf, 50);
db.AddNVarChar("RettetIP", p.RettetIP, 15);
db.addGetInt("ID");
db.ExecuteNonQuery(_SQLUpdate);
}
private static void AddParms(ref DBAccess db, News c)
{
var with_1 = c;
db.AddInt("NewsGrpID", with_1.NewsGrpID);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddNVarChar("Title", with_1.Title, 255);
db.AddNVarChar("Teaser", with_1.Teaser, 1023);
db.AddNVarChar("Body", with_1.Body, -1);
db.AddNVarChar("LinkUrl", with_1.Title, 250);
db.AddInt("LinkTarget", with_1.LinkTarget);
db.AddDateTime("PublishDate", with_1.PublishDate);
db.AddDateTime("ExpiredDate", with_1.ExpiredDate);
AddParmsStandard(db, c);
}
public static void LogUserActivity(Guid UserID, string action)
{
//Call the sproc_UpdateUsersCurrentActivity sproc
DBAccess db = new DBAccess(MembershipConnectionString);
db.AddGuid("UserID", UserID);
db.AddNVarChar("action", action, 256);
db.AddDateTime("ApplicationName", DateTime.UtcNow);
try
{
int retval = db.ExecuteNonQuery("dbo.sproc_UpdateUsersCurrentActivity");
}
catch (Exception)
{
}
//Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("MembershipConnectionString").ConnectionString)
// Dim myCommand As New SqlCommand("dbo.sproc_UpdateUsersCurrentActivity", myConnection)
// myCommand.CommandType = CommandType.StoredProcedure
// myCommand.Parameters.AddWithValue("@UserId", UserId)
// myCommand.Parameters.AddWithValue("@Action", action)
// myCommand.Parameters.AddWithValue("@CurrentTimeUtc", DateTime.UtcNow)
// 'Execute the sproc
// myConnection.Open()
// myCommand.ExecuteNonQuery()
// myConnection.Close()
//End Using
}
//EXEC [vicjos1_sysadm].[Co2Db_Invoice_Stats]
// @PeriodStart = '2000-01-01',
// @PeriodEnd = '2011-01-01',
// @CompanyID = null,
// @ItemID = null,
// @InvoicePaid = null,
// @VareVareNr = null
public static DataSet GetInvoiceStats(DateTime PeriodStart, DateTime PeriodEnd, int CompanyID = -2, int ItemID = -2, int InvoicePaid = -2, string VareVareNr = "-2")
{
DBAccess db = new DBAccess();
db.AddDateTime("PeriodStart", PeriodStart);
db.AddDateTime("PeriodEnd", PeriodEnd);
if (CompanyID != -2)
{
db.AddInt("CompanyID", CompanyID);
}
if (ItemID != -2)
{
db.AddInt("ItemID", ItemID);
}
if (InvoicePaid != -2)
{
db.AddInt("InvoicePaid", InvoicePaid);
}
if (VareVareNr != "-2")
{
db.AddNVarChar("VareVareNr", VareVareNr, 50);
}
DataSet ds = db.ExecuteDataSet(_SQLInvoiceStats);
return(ds);
}
public static DataSet Search_Currency(string Search)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
string[] arr = Search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 50);
dsTemp = db.ExecuteDataSet(_SQLSelectBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
return(ds);
}
public static DataSet Search_News(string Search, NewsStatusEnum Status, int NewsGrpID)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
string[] arr = Search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 250);
db.AddInt("Status", System.Convert.ToInt32(Status));
db.AddInt("NewsGrpID", NewsGrpID);
dsTemp = db.ExecuteDataSet(_SQLSelectBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
return(ds);
}
public static string UpdateClob(Dokumenter d)
{
DBAccess db = new DBAccess();
db.AddInt("ID", d.ID);
db.AddNVarChar("Clob", d.Clob, -1);
return(System.Convert.ToString(db.ExecuteNonQuery(_SQLUpdateClob)));
}
private static void AddParms(ref DBAccess db, KursusPolicy c)
{
var with_1 = c;
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddNVarChar("FirstAidTitle", with_1.FirstAidTitle, 250);
db.AddInt("FirstAidAftale", with_1.FirstAidAftale);
db.AddInt("FirstAidLeverandor", with_1.FirstAidLeverandor);
db.AddInt("FirstAidKursusType", with_1.FirstAidKursusType);
db.AddInt("FirstAidAdminAftale", with_1.FirstAidAdminAftale);
db.AddInt("FirstAidRepetition", with_1.FirstAidRepetition);
db.AddNVarChar("FirstAidMedarbInfo", with_1.FirstAidMedarbInfo, 50);
AddParmsStandard(db, c);
}
private static void AddParms(ref DBAccess db, Campaign rec)
{
db.AddInt("Status", (System.Int32)rec.Status);
db.AddBit("Active", rec.Active);
db.AddNVarChar("CampaignNo", rec.CampaignNo, 50);
db.AddNVarChar("Name", rec.Name, 255);
db.AddNVarChar("Description", rec.Description);
db.AddDateTime("StartDate", rec.StartDate);
db.AddDateTime("EndDate", rec.EndDate);
db.AddMoney("ExpectedImediateSale", (double)rec.ExpectedImediateSale);
db.AddMoney("ExpectedFollowUpSale", (double)rec.ExpectedFollowUpSale);
AddParmsStandard(db, rec);
}
private static void AddParms(ref DBAccess db, Dokumenter d)
{
var with_1 = d;
db.AddBit("Aktiv", with_1.Aktiv);
db.AddDateTime("Dato", with_1.Dato);
db.AddDateTime("ExpireDate", with_1.ExpireDate);
db.AddNVarChar("Name", with_1.Name, 250);
db.AddNVarChar("Mime", with_1.Mime, 100);
db.AddNVarChar("Beskrivelse", with_1.Beskrivelse, -1);
db.AddInt("Type", with_1.Type);
db.AddInt("Category", with_1.Category);
db.AddInt("Owner", with_1.Owner);
db.AddInt("MedArbGrpID", with_1.MedArbGrpID);
db.AddNVarChar("Filename", with_1.Filename, 250);
db.AddNVarChar("Ext", with_1.Ext, 50);
db.AddInt("Size", with_1.Size);
db.AddInt("Width", with_1.Width);
db.AddInt("Height", with_1.Height);
db.AddNVarChar("UserID", with_1.UserID, 50);
db.AddBlob("Blob", d.Blob);
db.AddNVarChar("Clob", with_1.Clob, -1);
AddParmsStandard(db, d);
}
//SELECT ID, KundeGrpNavn, status, sort, OprettetAf, OprettetDen, OprettetIP, RettetAf, RettetDen, RettetIP
//FROM Co2Db_KundeGrp
private static void AddParms(ref DBAccess db, KundeGrp c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddNVarChar("KundeGrpNavn", with_1.KundeGrpNavn, 50);
db.AddInt("Sort", with_1.Sort);
AddParmsStandard(db, c);
}
public static DataSet GetGetCampaignsByCampaignNo(string CampaignNo)
{
DBAccess db = new DBAccess();
db.AddNVarChar("CampaignNo", CampaignNo, 50);
DataSet ds = db.ExecuteDataSet(_SQLGetCampaignNo);
return(ds);
}
private static void AddParms(ref DBAccess db, Combobox c)
{
var with_1 = c;
db.AddNVarChar("Field", with_1.Field, 100);
db.AddNVarChar("Title", with_1.Title, 250);
db.AddNVarChar("Value", with_1.Value, 250);
db.AddNVarChar("Contents", with_1.Contents, -1);
db.AddBoolean("Hidden", with_1.Hidden);
db.AddBoolean("Valid", with_1.Valid);
db.AddInt("Idx", with_1.Idx);
db.AddNVarChar("ApplicationName", Roles.ApplicationName, 256);
//db.AddDateTime("Dato", .Dato)
//db.AddDecimal("Tal", .Tal)
//db.AddInt("FieldType", .FieldType)
AddParmsStandard(db, c);
}
private static void AddParms(ref DBAccess db, AED_Redning c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("AED_FK", with_1.AED_FK);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("RedningType", with_1.RedningType);
db.AddDateTime("RedningDate", with_1.RedningDate);
db.AddNVarChar("RedningNote", with_1.RedningNote, -1);
AddParmsStandard(db, c);
}
public static string get_PageAccess(string PageUrl, string ApplicationName)
{
string res = "";
DBAccess db = new DBAccess();
db.AddNVarChar("ApplicationName", ApplicationName, 256);
db.AddNVarChar("Page", PageUrl, 250);
//db.addGetString("Value")
SqlParameter value = new SqlParameter("@Access", 0);
value.Direction = ParameterDirection.Output;
value.SqlDbType = SqlDbType.NVarChar;
value.Size = 250;
db.AddParameter(value);
db.ExecuteNonQuery(_SQLGetOut);
res = Funktioner.ToDbString(value.Value);
return(res.Trim());
}
private static void AddParms(ref DBAccess db, KursusDeltager c)
{
AddParmsStandard(db, c);
var with_1 = c;
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddNVarChar("Fornavn", with_1.Fornavn, 50);
db.AddNVarChar("Efternavn", with_1.Efternavn, 50);
db.AddDateTime("Birthday", with_1.Birthday);
db.AddNVarChar("Cprnr", with_1.Cprnr, 4);
db.AddNVarChar("MedArbNr", with_1.MedArbNr, 15);
db.AddNVarChar("Lokation", with_1.Lokation, 250);
db.AddNVarChar("Stilling", with_1.Stilling, 100);
db.AddNVarChar("Adresse", with_1.Adresse, 250);
db.AddNVarChar("Postnr", with_1.Postnr, 50);
db.AddNVarChar("Bynavn", with_1.Bynavn, 50);
db.AddNVarChar("State", with_1.State, 50);
db.AddInt("Land", with_1.LandekodeID);
db.AddDateTime("FratradtDato", with_1.FratradtDato);
}
