public static int InsertFromText(int CompanyID, int MedarbejderID, int TypeID, string Overskrift, string Filename, string Tekst, bool Ekstern = false) { Korrespondance Korr = new Korrespondance(); Korr.CompanyID = CompanyID; Korr.MedarbejderID = MedarbejderID; Korr.Type = TypeID; Korr.Overskrift = Overskrift; Korr.Status = 1; Korr.Ekstern = Ekstern; Korr.Mime = "text/html"; //text/plain ' getMimeFromFile(Filename) ' if (!Filename.Contains(".")) { Filename += ".txt"; } Korr.Filename = Filename; Korr.Ext = Filename.Substring(Filename.LastIndexOf(".") + 1); Korr.Size = Tekst.Length; byte[] bytes = System.Text.Encoding.ASCII.GetBytes(Tekst); Korr.Blob = bytes; return(Korrespondance.Insert(Korr)); }
public static int Update(Korrespondance n) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@ID", n.ID)); db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(n.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(n.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(n.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(n.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(n.Overskrift))); db.Parameters.Add(new SqlParameter("@Extern", Funktioner.ToBool(n.Ekstern))); db.Parameters.Add(new SqlParameter("@Mime", SQLfunctions.SQLstr(n.Mime))); db.Parameters.Add(new SqlParameter("@Filename", SQLfunctions.SQLstr(n.Filename))); db.Parameters.Add(new SqlParameter("@Ext", SQLfunctions.SQLstr(n.Ext))); db.Parameters.Add(new SqlParameter("@Size", Funktioner.ToInt(n.Size))); //Dim pictureParameter As SqlParameter = New SqlParameter("@Blob", SqlDbType.Image) //pictureParameter.Value = n.Blob //db.Parameters.Add(pictureParameter) // db.AddParameter("@Blob", Blob) db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); int retval = db.ExecuteNonQuery("Co2Db_Korrespondance_Update"); AddLog(Status: "Noter", Logtext: string.Format("Update Noter: ID:{0}", n.ID), Metode: "Update"); return(retval); }
public static int Insert(int Type, int CompanyID, int MedarbejderID, int Status, string Overskrift, bool Ekstern, string Mime, string Filename, string Ext, int Size, object Blob) { Korrespondance n = new Korrespondance(Type, CompanyID, MedarbejderID, Status, Overskrift, Ekstern, Mime, Filename, Ext, Size, Blob); return(Insert(n)); }
private static void AddParms(ref DBAccess db, Korrespondance k) { var with_1 = k; db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(k.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(k.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(k.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(k.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(k.Overskrift))); db.Parameters.Add(new SqlParameter("@Ekstern", Funktioner.ToBool(k.Ekstern))); db.Parameters.Add(new SqlParameter("@Mime", SQLfunctions.SQLstr(k.Mime))); db.Parameters.Add(new SqlParameter("@Filename", SQLfunctions.SQLstr(k.Filename))); db.Parameters.Add(new SqlParameter("@Ext", SQLfunctions.SQLstr(k.Ext))); db.Parameters.Add(new SqlParameter("@Size", Funktioner.ToInt(k.Size))); SqlParameter pictureParameter = new SqlParameter("@Blob", SqlDbType.Image); pictureParameter.Value = k.Blob; db.Parameters.Add(pictureParameter); // db.AddParameter("@Blob", Blob) AddParmsStandard(db, k); }
public static int Save(Korrespondance B) { int retval = 0; if (B.ID > 0) { retval = Update(B); } else { retval = Insert(B); } return(retval); }
public static int InsertFromDisk(int CompanyID, int MedarbejderID, int TypeID, string Overskrift, string Filename, bool DeleteFile = false, bool Ekstern = false) { if (!File.Exists(Filename)) { throw (new FileNotFoundException("Cannot create attachment because the file was not found : " + Filename, Filename)); } Korrespondance Korr = new Korrespondance(); Korr.CompanyID = CompanyID; Korr.MedarbejderID = MedarbejderID; Korr.Type = TypeID; Korr.Overskrift = Overskrift; Korr.Status = 1; Korr.Ekstern = Ekstern; Korr.Mime = FileIO.getMimeFromFile(Filename); // System.Net.Mime.MediaTypeNames.Application.Pdf ' Text.Plain // Load file from harddrive and load into database FileInfo fi = new FileInfo(Filename); Korr.Filename = fi.Name; Korr.Ext = fi.Extension.Replace(".", ""); Korr.Size = (int)fi.Length; fi = null; using (FileStream reader = new FileStream(Filename, FileMode.Open)) { byte[] blob = new byte[System.Convert.ToInt32(reader.Length - 1) + 1]; reader.Read(blob, 0, (int)reader.Length); reader.Close(); //reader.Dispose() Korr.Blob = blob; } if (DeleteFile == true) { try { File.Delete(Filename); } catch (Exception) { } } return(Korrespondance.Insert(Korr)); }
public static int Update(int Id, int Type, int CompanyID, int MedarbejderID, int Status, string Overskrift, bool Ekstern, string Mime, string Filename, string Ext, int Size) { Korrespondance n = Korrespondance.GetKorrespondance(Id); n.Type = Type; n.CompanyID = CompanyID; n.MedarbejderID = MedarbejderID; n.Status = Status; n.Overskrift = Overskrift; n.Ekstern = Ekstern; n.Mime = Mime; n.Filename = Filename; n.Ext = Ext; n.Size = Size; return(Update(n)); }
//Private Shared Sub PopulateKorrespondance(ByRef dr As SqlDataReader, ByRef n As Korrespondance) private static void Populate(SqlDataReader dr, Korrespondance n) { PopulateStandard(dr, n); var with_1 = n; with_1.Type = System.Convert.ToInt32(dr.DBtoInt("Type")); with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID")); with_1.MedarbejderID = System.Convert.ToInt32(dr.DBtoInt("MedarbejderID")); with_1.Status = System.Convert.ToInt32(dr.DBtoInt("Status")); with_1.Overskrift = dr.DBtoString("Overskrift"); with_1.Ekstern = System.Convert.ToBoolean(dr.DBtoBool("Ekstern")); with_1.Mime = dr.DBtoString("Mime"); with_1.Filename = dr.DBtoString("Filename"); with_1.Ext = dr.DBtoString("Ext"); with_1.Size = System.Convert.ToInt32(dr.DBtoString("Size")); //.Blob = dr.DBtoString("Blob") }
public static List <Korrespondance> GetKorrespondanceSearchList(int CompanyID, int MedarbejderID = -1, bool Ekstern = false, string Search = "") { DBAccess db = new DBAccess(); db.AddInt("CompanyID", CompanyID); db.AddInt("MedarbejderID", MedarbejderID); db.AddBoolean("Ekstern", Ekstern); db.AddNVarChar("Search", Search, 255); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader("Co2Db_Korrespondance_SearchAll")); //cmd.ExecuteReader() List <Korrespondance> list = new List <Korrespondance>(); while (dr.Read()) { Korrespondance Korr = new Korrespondance(); Populate(dr, Korr); list.Add(Korr); } return(list); }
public static List <Korrespondance> GetKorrespondancesByCriteria(string OrderBY, string criteria, params SqlParameter[] @params) { DBAccess db = new DBAccess(); //Dim conn As SqlConnection = DataFunctions.GetConnection() string query = ""; query += "SELECT "; if (OrderBY != "") { query += " TOP (100) PERCENT "; } query += " *"; query += " FROM vw_Co2Db_Korrespondance "; if (criteria != "") { query += " WHERE (" + criteria + ")"; } if (OrderBY != "") { query += " ORDER BY " + OrderBY; } //Dim cmd As New SqlCommand(query, conn) db.CommandType = CommandType.Text; db.CommandText = query; db.AddRange(@params); db.Open(); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); //cmd.ExecuteReader() List <Korrespondance> list = new List <Korrespondance>(); while (dr.Read()) { Korrespondance Korr = new Korrespondance(); Populate(dr, Korr); list.Add(Korr); } db.Dispose(); return(list); }
public static int Insert(Korrespondance k) { DBAccess db = new DBAccess(); SqlParameter ID = new SqlParameter("@ID", 0); ID.Direction = ParameterDirection.Output; db.Parameters.Add(new SqlParameter("@Type", Funktioner.ToInt(k.Type))); db.Parameters.Add(new SqlParameter("@CompanyID", Funktioner.ToInt(k.CompanyID))); db.Parameters.Add(new SqlParameter("@MedarbejderID", Funktioner.ToInt(k.MedarbejderID))); db.Parameters.Add(new SqlParameter("@Status", Funktioner.ToInt(k.Status))); db.Parameters.Add(new SqlParameter("@Overskrift", SQLfunctions.SQLstr(k.Overskrift))); db.Parameters.Add(new SqlParameter("@Ekstern", Funktioner.ToBool(k.Ekstern))); db.Parameters.Add(new SqlParameter("@Mime", SQLfunctions.SQLstr(k.Mime))); db.Parameters.Add(new SqlParameter("@Filename", SQLfunctions.SQLstr(k.Filename))); db.Parameters.Add(new SqlParameter("@Ext", SQLfunctions.SQLstr(k.Ext))); db.Parameters.Add(new SqlParameter("@Size", Funktioner.ToInt(k.Size))); SqlParameter pictureParameter = new SqlParameter("@Blob", SqlDbType.Image); pictureParameter.Value = k.Blob; db.Parameters.Add(pictureParameter); // db.AddParameter("@Blob", Blob) db.Parameters.Add(new SqlParameter("@RettetAf", SQLfunctions.SQLstr(CurrentUserName))); db.Parameters.Add(new SqlParameter("@RettetIP", SQLfunctions.SQLstr(CurrentUserIP))); db.Parameters.Add(ID); int retval = db.ExecuteNonQuery("Co2Db_Korrespondance_Insert"); if (retval == 1) { k.ID = int.Parse(ID.Value.ToString()); AddLog(Status: "Korrespondance", Logtext: string.Format("Create Korrespondance: ID:{0}", k.ID), Metode: "Insert"); return(k.ID); //Integer.Parse(ID.Value.ToString) } else { AddLog(Status: "Korrespondance", Logtext: string.Format("Failure to Create Korrespondance:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static Korrespondance GetKorrespondance(int ID) { DBAccess db = new DBAccess(); Korrespondance n = new Korrespondance(); db.Parameters.Add(new SqlParameter("@ID", ID)); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader("Co2Db_Korrespondance_SelectOne")); if (dr.HasRows) { while (dr.Read()) { Populate(dr, n); } } if (!dr.IsClosed) { dr.Close(); } return(n); }
public static int Delete(Korrespondance n) { return(Delete(n.ID)); }