//[System.Web.Services.WebMethod] //public static void GetComplaintItem(HttpContext context) //{ // //Get System properties from System table // ISystemRepository systemRepository = ObjectFactory.GetInstance<ISystemRepository>(); // SystemEntity sysEntity = systemRepository.GetBySysName(cmplEntity.SystemName); // //Get Item Path // string serverName = sysEntity.IP + (sysEntity.Port.Length>0 ? ":" + sysEntity.Port : ""); // string connStr = String.Format("server={0};database={1};uid={2};pwd={3};max pool size =1024000", // serverName, sysEntity.DBLocation, sysEntity.UserName, sysEntity.UserPwd); // string type = ((ComplaintTypeEnum)cmplEntity.Type).ToString(); // string path = complaintApp.GetComItem(connStr, sysEntity.Procedure, type, cmplEntity.TargetID); // HelpPath helpPath = new HelpPath(); // helpPath.Type = type; // helpPath.Path = path; // JavaScriptSerializer jss = new JavaScriptSerializer(); // context.Response.Write(jss.Serialize(helpPath)); // //if (type == "Photo") // //{ // // this.comImg.ImageUrl = path; // // this.comImg.Visible = true; // //} // //else if (type == "Video") // //{ // // //ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>setPlayerVideo();</script>"); // // context.Response.Write(path); // //} //} public void GetComplaintItem() { //Get System properties from System table ISystemRepository systemRepository = ObjectFactory.GetInstance <ISystemRepository>(); SystemEntity sysEntity = systemRepository.GetBySysName(cmplEntity.SystemName); //Get Item Path string serverName = sysEntity.IP + (sysEntity.Port.Length > 0 ? ":" + sysEntity.Port : ""); string connStr = String.Format("server={0};database={1};uid={2};pwd={3};max pool size =1024000", serverName, sysEntity.DBLocation, sysEntity.UserName, sysEntity.UserPwd); string type = ((ComplaintTypeEnum)cmplEntity.Type).ToString(); string result = complaintApp.GetComItem(connStr, sysEntity.Procedure, type, cmplEntity.TargetID); if (string.IsNullOrEmpty(result)) { comItem = new ComplaintItem(); return; } JavaScriptSerializer jss = new JavaScriptSerializer(); comItem = (ComplaintItem)jss.Deserialize(result, typeof(ComplaintItem)); if (type == "Photo") { this.comImg.Style["display"] = "inline"; } else if (type == "Video") { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "setPlayerVideo('" + comItem.Path + "');", true); } else if (type == "User") { this.comUser.Style["display"] = "inline"; } else if (type == "Group") { this.comGroup.Style["display"] = "inline"; } else if (type == "Post") { this.comPost.Style["display"] = "inline"; } }
public string GetComItem(string connStr, string spName, string type, int id) { Regex regex = new Regex("(?<=database=).*(?=;uid)"); string dbName = regex.Match(connStr).Value; //Add a connectionString if not existed Configuration config = WebConfigurationManager.OpenWebConfiguration("~"); ConnectionStringsSection csSection = config.ConnectionStrings; if (csSection.ConnectionStrings[dbName] == null) { ConnectionStringSettings connection = new ConnectionStringSettings(dbName, connStr, "System.Data.SqlClient"); csSection.ConnectionStrings.Add(connection); config.Save(ConfigurationSaveMode.Modified); ConfigurationManager.RefreshSection("connectionStrings"); } ComplaintItem com = new ComplaintItem(); Database db = new SqlDatabase(connStr); using (DbCommand dbCommand = db.GetStoredProcCommand(spName)) { try { db.AddInParameter(dbCommand, "Action", DbType.String, "View"); db.AddInParameter(dbCommand, "Type", DbType.String, type); db.AddInParameter(dbCommand, "ID", DbType.Int32, id); IDataReader reader = db.ExecuteReader(dbCommand); if (reader.Read()) { switch (type) { case "Photo": case "Video": com.Path = (string)reader["Path"]; break; case "User": com.UserName = (string)reader["UserName"]; com.UserEmail = (string)reader["UserEmail"]; break; case "Group": com.UserName = (string)reader["UserName"]; com.GroupName = (string)reader["GroupName"]; break; case "Post": com.UserName = (string)reader["UserName"]; com.Message = (string)reader["Message"]; break; } } JavaScriptSerializer jss = new JavaScriptSerializer(); return(jss.Serialize(com)); } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]", "GetTimesheetList", base.FormatParameters(dbCommand.Parameters), ex.Message)); return(""); } } }