public Documents AddDocument(Documents ins) { //...Transaction... string strTrx = "Insert_Advertisement"; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); con.Open(); //...Command Interface... SqlCommand cmdI = con.CreateCommand(); SqlTransaction trx; trx = con.BeginTransaction(strTrx); cmdI.Connection = con; cmdI.Transaction = trx; try { //...Insert Record... cmdI.CommandText = "f_Admin_Insert_Document"; cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@DocumentName", ins.DocumentName); cmdI.Parameters.AddWithValue("@PathUrl", ins.PathUrl); cmdI.Parameters.AddWithValue("@ClientId", ins.ClientId); //...Return new ID ins.DocId = (int)cmdI.ExecuteScalar(); trx.Commit(); cmdI.Connection.Close(); } catch (SqlException ex) { if (trx != null) trx.Rollback(); //throw ex; //Console.WriteLine("Rollback Exception Type: {0}", ex.GetType()); //Console.WriteLine(" Message: {0}", ex.Message); } finally { //Check for close and respond accordingly if (con.State != ConnectionState.Closed) { con.Close(); } //Clean up con.Dispose(); cmdI.Dispose(); trx.Dispose(); } return ins; }
public ActionResult Save(IEnumerable<HttpPostedFileBase> attachments) { Functions functions = new Functions(); Documents ins = new Documents(); // The Name of the Upload component is "attachments" foreach (var file in attachments) { // Some browsers send file names with full path. This needs to be stripped. var fileName = Path.GetFileName(file.FileName); // Check if Path exsits string serverpath = Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Docs"); if (!Directory.Exists(serverpath)) { Directory.CreateDirectory(serverpath); } var physicalPath = Path.Combine(Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Docs"), fileName); file.SaveAs(physicalPath); string finalpath = physicalPath.ToString(); finalpath = finalpath.Substring(finalpath.IndexOf("Images")); finalpath = finalpath.Replace('\\', '/'); //...Save In DB... ins.DocumentName = fileName; ins.ClientId = Convert.ToInt32(HttpContext.Session["ClientId"]); ins.PathUrl = Constants.HTTPPath + finalpath; ins = DocRep.AddDocument(ins); } // Return an empty string to signify success if (ins.DocId != 0) return Json(new { status = ins.DocId.ToString() }, "text/plain"); else return Json(new { status = "0" }, "text/plain"); }
public List<Documents> GetDocuments(int ClientId, int LastId) { List<Documents> lsDocumentsList = new List<Documents>(); Documents ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM Documents WHERE ClientId =" + ClientId + " AND DocId > " + LastId, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new Documents(); ins.DocId = Convert.ToInt32(drI["DocId"]); ins.DocumentName = drI["DocumentName"].ToString(); ins.PathUrl = drI["PathUrl"].ToString(); ins.ClientId = Convert.ToInt32(drI["ClientId"]); lsDocumentsList.Add(ins); } } drI.Close(); con.Close(); return lsDocumentsList; }
public ActionResult _InsertDocument(Documents ins) { //...Fix... Documents getme = DocRep.GetDocument(ins.DocId); getme.DocumentName = ins.DocumentName; //ins.ClientId = Convert.ToInt32(HttpContext.Session["ClientId"]); //...Insert into Database... Documents ins2 = DocRep.UpdateDocument(getme); //...Notify... string regIds = AppRep.GetAllRegIds(ins.ClientId); List<string> reg = AppRep.GetAllRegIdsList(ins.ClientId); if (!regIds.Equals("")) { comrep.NewsyncData(regIds, "CMD_NEWDOC", reg, ins.ClientId); } //...Initialize List... List<Documents> lst = new List<Documents>(); //...Populate List... lst = DocRep.GetDocuments(Convert.ToInt32(HttpContext.Session["ClientId"])); //...Return List to Grid... return View(new GridModel(lst)); }
public Documents GetDocument(int id) { Documents ins = new Documents(); //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM Documents WHERE DocId =" + id, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins.DocId = Convert.ToInt32(drI["DocId"]); ins.DocumentName = drI["DocumentName"].ToString(); ins.PathUrl = drI["PathUrl"].ToString(); } } drI.Close(); con.Close(); return ins; }
public Documents UpdateDocument(Documents ins) { //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); con.Open(); SqlCommand cmdI = con.CreateCommand(); cmdI.Connection = con; //...Update Record... cmdI.Parameters.Clear(); cmdI.CommandText = "f_Admin_Update_Document"; cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@DocId", ins.DocId); cmdI.Parameters.AddWithValue("@DocumentName", ins.DocumentName); cmdI.Parameters.AddWithValue("@PathUrl", ins.PathUrl); cmdI.ExecuteNonQuery(); cmdI.Connection.Close(); return ins; }
public List<Documents> GetDocuments(int ClientId, int LastId) { List<Documents> lsDocumentsList = new List<Documents>(); Documents ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; StringBuilder w = new StringBuilder(); //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM Documents WHERE ClientId =" + ClientId + " AND DocId > " + LastId, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new Documents(); ins.DocId = Convert.ToInt32(drI["DocId"]); ins.DocumentName = drI["DocumentName"].ToString(); ins.PathUrl = drI["PathUrl"].ToString(); ins.ClientId = Convert.ToInt32(drI["ClientId"]); //ins.PathUrl = ins.PathUrl.Substring(ins.PathUrl.IndexOf("Images"),ins.PathUrl.Length - ins.PathUrl.IndexOf("Images")); //ins.PathUrl = ins.PathUrl.Replace('\\','/'); //w.Clear(); //w.Append("http://www.netintercom.co.za/").Append(ins.PathUrl); //ins.PathUrl = w.ToString(); lsDocumentsList.Add(ins); } } drI.Close(); con.Close(); return lsDocumentsList; }