protected void Application_Start() { GlobalConfiguration.Configure(WebApiConfig.Register); AppInsightsTelemetryClient.GetInstance(); try { StringDictionary parameters = new StringDictionary { ["connectionString"] = ConfigurationManager.AppSettings["MongoDBStringConnection"], ["mongoDbName"] = ConfigurationManager.AppSettings["MongoDBName"], ["documentDbName"] = ConfigurationManager.AppSettings["DocumentDBName"], ["authKey"] = ConfigurationManager.AppSettings["DocumentDBAuthKey"], ["endPoint"] = ConfigurationManager.AppSettings["DocumentDBEndPoint"] }; if (Enum.TryParse <DAL.DBType>(ConfigurationManager.AppSettings["DBType"], out DAL.DBType dbt)) { SharedObjects.DatabaseManager = DBManagerFactory.GetInstance(dbt, parameters); } else { throw new ConfigurationErrorsException("Valor de DBType Incorrecto en el archivo de configuración"); } } catch (Exception ex) { Trace.TraceWarning($"El servicio de Bot funciona pero no la conexión a la base de datos de preguntas no fue posible: {ex}"); } }
private void UploadSelectedDocument(string sqlFrom, string whereClause, string taskId) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string relativePath = string.Empty; string basePath = HIT.OB.STD.Wrapper.CommonFunctions.GetDocBasePath("DocBasePath"); string task_dir = "TASKS" + System.IO.Path.DirectorySeparatorChar + taskId; //if (sqlFrom.ToUpper().Equals("TASKS")) //{ if (!System.IO.Directory.Exists(System.IO.Path.Combine(basePath, task_dir))) { System.IO.Directory.CreateDirectory(System.IO.Path.Combine(basePath, task_dir)); } relativePath = task_dir + System.IO.Path.DirectorySeparatorChar + fileUpload.FileName; //} //else //{ // DataTable dtRelFile = iWrapFunctions.GetRelativeFileName(sqlFrom, whereClause); // relativePath = dtRelFile.Rows[0]["relfilename"].ToString(); // relativePath = relativePath.Substring(0, relativePath.LastIndexOf('.')) + "_task_" + taskId + fileUpload.FileName.Substring(fileUpload.FileName.LastIndexOf('.')); //} string filePath = System.IO.Path.Combine(basePath, relativePath); fileUpload.SaveAs(filePath); }
protected void pickBtn_Click(object sender, EventArgs e) { try { Button pickBtn = (Button)sender; string targetFieldId = pickBtn.Attributes["targetFieldId"].ToString(); string fieldName = pickBtn.Attributes["inputFieldName"].ToString(); hdnCurTargetControlIdForGridvalue.Value = targetFieldId; Dictionary <string, PEValidator> validatorList = Session["validatorDictionary"] as Dictionary <string, PEValidator>; PEValidator curValidator = validatorList[fieldName]; IDatabaseFunctionsManager db = DBManagerFactory.GetDBManager(activeDB, conStringLOV_SQL); DataTable dt = db.GetDataTable(curValidator.LOVValue); DataTable dtCloned = CloneDataTableWithAllColumnStringDataType(dt); gvPopup.DataSource = dtCloned; Session["GridDataTable"] = dtCloned; gvPopup.DataBind(); modalGrid.Show(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "errorExists", "<script>$(document).ready(function(){alert('Cannot load the grid.\\nSQL in the LOVP is not correct for this field or Connection string invalid.')});</script>", false); } }
public IDataReader ExecuteReader(CommandType commandType, string commandText) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); idbCommand.Connection = this.Connection; PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); this.DataReader = idbCommand.ExecuteReader(); idbCommand.Parameters.Clear(); return(this.DataReader); }
public void BeginTransaction() { if (this.idbTransaction == null) { idbTransaction = DBManagerFactory.GetTransaction(this.ProviderType, this.Connection); } // this.idbCommand.Transaction =idbTransaction; }
public void Open() { idbConnection = DBManagerFactory.GetConnection(this.providerType); idbConnection.ConnectionString = this.ConnectionString; if (idbConnection.State != ConnectionState.Open) { idbConnection.Open(); } this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); }
public int ExecuteNonQuery(CommandType commandType, string commandText) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); int returnValue = idbCommand.ExecuteNonQuery(); idbCommand.Parameters.Clear(); return(returnValue); }
private void LoadRestrictions(string tableName, string groupName) { if (conString == "") { throw new Exception("CONN_STR_ERROR"); } IDatabaseFunctionsManager dbHlr = DBManagerFactory.GetDBManager(activeDB, conString); DataTable dt = dbHlr.GetDataTable(dbHlr.GetQuery(tableName, groupName)); Session["metadata"] = dt; }
protected void btnSubmit_Click(object sender, EventArgs e) { string summary = txtSummary.Text.Trim(); string description = txtDescription.Text.Trim(); string assignTo = lstUsers.SelectedItem.Text; try { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string openedBy = SecurityManager.GetUserName(SID.Value); string sqlFrom = SQLFROM.Value; string reportName = REPORTNAME.Value; string keyList = KEYLIST.Value; string valueList = VALUELIST.Value; string[] keyItems = keyList.Split(';'); string[] valueItems = valueList.Split(';'); string whereClause = string.Empty; for (int k = 0; k < keyItems.Length; k++) { whereClause += keyItems[k] + " = '" + valueItems[k] + "' & "; } whereClause = whereClause.TrimEnd(new char[] { '&', ' ' }).Replace("&", "AND"); string ref_info = sqlFrom + ";" + reportName + ";" + whereClause; if (reportName.ToUpper().Equals("TASKS")) { ref_info = string.Empty; } string taskId = iWrapFunctions.PostDocumentUpdate(summary, description, openedBy, assignTo, ref_info, fileUpload.FileName); if (fileUpload.PostedFile != null && fileUpload.PostedFile.FileName != "") { UploadSelectedDocument(sqlFrom, whereClause, taskId); } txtDescription.Text = ""; txtSummary.Text = ""; lstUsers.SelectedIndex = 0; } catch (Exception ex) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "error", "<script>alert('" + ex.Message + "')</script>"); } if (REPORTNAME.Value.ToUpper().Equals("TAKEN")) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "refreshPage", "<script>opener.OBSettings.RefreshPage();</script>"); } Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "error", "<script>self.close();</script>"); }
private void GetUsers() { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string projectCode = ConfigurationSettings.AppSettings["project_code"].ToString(); string query = "select * from project_user where project_code='" + projectCode + "'"; DataTable dt = iWrapFunctions.GetDataTable(query); lstUsers.DataTextField = "username"; lstUsers.DataValueField = "username"; lstUsers.DataSource = dt; lstUsers.DataBind(); }
public DataSet ExecuteDataSet(CommandType commandType, string commandText) { this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType); PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters); IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter (this.ProviderType); dataAdapter.SelectCommand = idbCommand; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); idbCommand.Parameters.Clear(); return(dataSet); }
void GetTaskDetails(string task_id) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string sql = "select * from tasks where task_id = '" + task_id + "'"; DataTable dt = iWrapFunctions.GetDataTable(sql); string assingedTo = dt.Rows[0]["assign_to"].ToString(); string taskStatus = dt.Rows[0]["item_status"].ToString(); GetUsers(assingedTo); txtSummary.Text = dt.Rows[0]["item_summary"].ToString(); txtDescription.Text = dt.Rows[0]["detailed_desc"].ToString(); lstTaskStatus.SelectedValue = taskStatus; }
public List <string> GetUsers() { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string projectCode = ConfigurationSettings.AppSettings["project_code"].ToString(); string query = "select * from project_user where project_code='" + projectCode + "'"; DataTable dt = iWrapFunctions.GetDataTable(query); List <string> userList = new List <string>(); foreach (DataRow dr in dt.Rows) { userList.Add(dr["username"].ToString()); } return(userList); }
public IDbDataParameter[] AttachParameters <T>(string spName, T entity) { List <Parameter> spParameters = new Parameters().GetParametersForStoredProcedure(spName); IDbDataParameter[] parameters = new IDbDataParameter[spParameters.Count]; parameters = DBManagerFactory.GetParameters(DataProvider.SqlServer, spParameters.Count); int index = 0; foreach (Parameter spParameter in spParameters) { parameters[index].ParameterName = spParameter.Name; //((System.Data.SqlClient.SqlParameter)parameters[index]).SqlDbType = GetDbType(spParameter.DataType); parameters[index++].Value = getCurrentValue(spParameter.Name.Replace("@", ""), entity); } return(parameters); }
public IDbDataParameter[] AttachParameters(string spName, List <QueryParameter> queryParameters) { List <Parameter> spParameters = new Parameters().GetParametersForStoredProcedure(spName); IDbDataParameter[] parameters = new IDbDataParameter[spParameters.Count]; parameters = DBManagerFactory.GetParameters(DataProvider.SqlServer, spParameters.Count); int index = 0; foreach (Parameter spParameter in spParameters) { parameters[index].ParameterName = spParameter.Name; parameters[index++].Value = (from QueryParameter queryParameter in queryParameters where queryParameter.Name.ToLower().Equals(spParameter.Name.Replace("@", "").ToLower()) select queryParameter.Value).First(); } return(parameters); }
protected void btnDelete_Click(object sender, EventArgs e) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string taskId = Request.QueryString["taskId"].ToString(); string xx = iWrapFunctions.DeleteTask(taskId); string basePath = HIT.OB.STD.Wrapper.CommonFunctions.GetDocBasePath("DocBasePath"); string task_dir = "TASKS" + System.IO.Path.DirectorySeparatorChar + taskId; //if (sqlFrom.ToUpper().Equals("TASKS")) //{ if (System.IO.Directory.Exists(System.IO.Path.Combine(basePath, task_dir))) { System.IO.Directory.Delete(System.IO.Path.Combine(basePath, task_dir), true); } Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Close", "<script>ReloadOpener();</script>"); }
private void btnLoad_Click(object sender, EventArgs e) { if (cbDatabase.SelectedItem.ToString().Equals("SQL Server")) { conString = ConfigurationManager.ConnectionStrings["EasyDataSQLSERVER"].ConnectionString; dbManagerFactory = new SQLDBManagerFactory(conString); storedProcMap = new SQLServerStoredProcMap(); pQueries = new PersonQueries(dbManagerFactory, storedProcMap); } else if (cbDatabase.SelectedItem.ToString().Equals("Oracle")) { conString = ConfigurationManager.ConnectionStrings["EasyDataOracle"].ConnectionString; dbManagerFactory = new OracleDBManagerFactory(conString); sqlMap = new OracleSQLMap(); sqlMap.GetAllPeople = "select * from people"; pQueries = new PersonQueries(dbManagerFactory, sqlMap); } PopulatePeopleGrid(); }
private void GetUsers(string assingedTo) { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string projectCode = ConfigurationSettings.AppSettings["project_code"].ToString(); string query = "select * from project_user where project_code='" + projectCode + "' order by username desc"; DataTable dt = iWrapFunctions.GetDataTable(query); lstUsers.DataTextField = "username"; lstUsers.DataValueField = "username"; lstUsers.DataSource = dt; try { lstUsers.DataBind(); lstUsers.SelectedItem.Text = assingedTo; } catch (Exception ex) { } }
bool CheckInputConsistentWithList(PEValidator validator, string value) { IDatabaseFunctionsManager db = DBManagerFactory.GetDBManager(activeDB, conStringLOV_SQL); DataTable dt = db.GetDataTable(validator.LOVValue); string fieldName = validator.FieldName; DataType curType = (DataType)Enum.Parse(typeof(DataType), validator.ValueType, true); bool fieldExists = false; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.ToLower() == fieldName.ToLower()) { fieldExists = true; break; } } if (fieldExists) { foreach (DataRow record in dt.Rows) { if (curType == DataType.Date) { if (record[fieldName].ToString().Trim() != Convert.ToDateTime(record[fieldName]).ToString("dd-MM-yyyy")) { return(true); } } else { if (record[fieldName].ToString() == value) { return(true); } } } } return(false); }
protected void btnSubmit_Click(object sender, EventArgs e) { string editedBy = SecurityManager.GetUserName(SID.Value); string label = txtSummary.Text.Trim(); string description = txtDescription.Text.Trim(); string assignedTo = lstUsers.SelectedItem.Text; string taskSatus = lstTaskStatus.SelectedValue; string taskId = Request.QueryString["taskId"].ToString(); try { DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); string xx = iWrapFunctions.UpdateDetailTask(taskId, assignedTo, editedBy, label, description, taskSatus); Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Close", "<script>ReloadOpener()</script>"); //Response.Write("<script type='text/javascript'>ReloadOpener();</script>"); } catch (Exception ex) { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "error", "<script>alert('" + ex.Message + "')</script>"); } }
protected void btnImport_Click(object sender, EventArgs e) { if (!fuExcelItem.FileName.Equals(string.Empty)) { string postedFile = this.fuExcelItem.PostedFile.FileName; string postedFileFullName = GetTempDir() + @"\" + postedFile; this.fuExcelItem.PostedFile.SaveAs(postedFileFullName); DataTable dtItems = HIT.OB.STD.RC.Wrapper.OLEDB.GetDataTableFromExcel(postedFileFullName, "Sheet1"); DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); try { iWrapFunctions.ImportExcelData(dtItems, "rc_item_hit"); } catch (Exception ex) { lblError.Text = ex.Message; lblError.Visible = true; } } if (!fuExcelPartlist.FileName.Equals(string.Empty)) { string postedFile = this.fuExcelPartlist.PostedFile.FileName; string postedFileFullName = GetTempDir() + @"\" + postedFile; this.fuExcelPartlist.PostedFile.SaveAs(postedFileFullName); DataTable dtItems = HIT.OB.STD.RC.Wrapper.OLEDB.GetDataTableFromExcel(postedFileFullName, "Sheet1"); DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunctions = dbManagerFactory.GetDBManager(); try { iWrapFunctions.ImportExcelData(dtItems, "rc_c_bomeng"); } catch (Exception ex) { lblError.Text = ex.Message; lblError.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { try { reportCode = Request.QueryString["report"].ToString(); string basePath = HIT.OB.STD.Wrapper.CommonFunctions.GetDocBasePath("DocBasePath"); DBManagerFactory dbManagerFactory = new DBManagerFactory(); IWrapFunctions iWrapFunc = dbManagerFactory.GetDBManager(); drReportConfig = iWrapFunc.GetReportConfigInfo(reportCode); keyField = drReportConfig["sql_keyfields"].ToString(); matCode = Request.QueryString[keyField].ToString(); keyList = keyField; valueList = matCode; sqlFrom = drReportConfig["sql_from"].ToString(); selectedFields = drReportConfig["detail_fieldsets"].ToString().Trim(new char[] { ';' }).Replace(';', ','); string fieldCaps = drReportConfig["field_caps"].ToString(); capsList = fieldCaps.Split(';'); string whereClause = " matcode='" + matCode + "'"; DataTable dtRelFile = iWrapFunc.GetRelativeFileName(sqlFrom, whereClause); string relativePath = dtRelFile.Rows[0]["relfilename"].ToString(); docPath = Path.Combine(basePath, relativePath); if (!File.Exists(docPath)) { docPath = ""; } else { docPath = docPath.Replace("\\", "@@@@"); } } catch (Exception ex) { } }
public DataTable GetDataTable(string sqlQuery) { DataTable datatable; bool xml = sqlQuery.StartsWith("#"); if (xml) { DataTable dt = new DataTable(); string tmpFileName = sqlQuery.Split('|')[0]; string fileName = tmpFileName.Substring(1); string groupName = sqlQuery.Split('|')[1]; try { XElement elements = XElement.Load(HttpContext.Current.Server.MapPath("database") + "\\" + fileName + ".xml"); var records = from recordData in elements.Descendants("record") select recordData; var record = records.First <XElement>(); var fields = from data in record.Elements() select data; foreach (var field in fields) { dt.Columns.Add(field.Name.LocalName); } DataRow dr; foreach (var rcord in records) { dr = dt.NewRow(); var columns = from data in rcord.Elements() select data; foreach (var field in columns) { dr[field.Name.LocalName] = field.Value; } dt.Rows.Add(dr); } } catch (Exception ex) { throw new HttpException("Cannot load XML metadata file :" + ex.ToString()); } DataRow[] rows = dt.Select("GROUPNAME='" + groupName + "'"); datatable = dt.Clone(); foreach (DataRow row in rows) { datatable.ImportRow(row); } } else { datatable = new DataTable(); IDatabaseFunctionsManager dbHlr; if (connectionString.IndexOf("Provider=OraOLEDB.Oracle") >= 0) { dbHlr = DBManagerFactory.GetDBManager("oracle", connectionString); } else { dbHlr = DBManagerFactory.GetDBManager("postgresql", connectionString); } datatable = dbHlr.GetDataTable(sqlQuery); } return(datatable); }
private ControlIDWithType CreateElement(string fieldName, string userInputValue, PEValidator validator) { ControlIDWithType idType = new ControlIDWithType(); string value = userInputValue; if (value.Trim() == string.Empty && validator.DefaultValue != null) { value = validator.DefaultValue.ToString(); } Label lbl = new Label(); lbl.ID = string.Concat("lbl", fieldName); lbl.Style.Add("width", "100%"); if (validator.Caption != string.Empty) { lbl.Text = validator.Caption.ToFirstCharUpper(); } else { lbl.Text = fieldName.ToFirstCharUpper(); } HtmlGenericControl divLabels = new HtmlGenericControl("div"); divLabels.Style.Add("padding-right", "10px"); divLabels.Style.Add("text-align", "right"); divLabels.Controls.Add(lbl); TextBox txtBx = new TextBox(); DropDownList ddl = new DropDownList(); HtmlGenericControl divControl = new HtmlGenericControl("div"); DataType curType = (DataType)Enum.Parse(typeof(DataType), validator.ValueType, true); if (validator.LovType == EnumLovType.Lovc || validator.LovType == EnumLovType.Lovcp) { ddl.ID = string.Concat("ddl", fieldName); ddl.ToolTip = validator.ToolTip; ddl.Attributes.Add("onchange", "SelectDDLValue(this,'txtddl" + fieldName + "')"); ddl.Style.Add("z-index", "-100"); hdnDrpIDs.Value += ddl.ID + ","; if (validator.LovType != EnumLovType.Lovc || (validator.LovType == EnumLovType.Lovc && validator.LOVValue.Trim().ToLower().StartsWith("select"))) { IDatabaseFunctionsManager db = DBManagerFactory.GetDBManager(activeDB, conStringLOV_SQL); DataTable dt = db.GetDataTable(validator.LOVValue); if (IsColumnExistInTable(dt, fieldName)) { if (curType != DataType.Date) { ddl.DataSource = dt; ddl.DataTextField = fieldName; ddl.DataValueField = fieldName; } else { List <string> dates = new List <string>(); foreach (DataRow record in dt.Rows) { if (record[fieldName].ToString().Trim() != "") { dates.Add(Convert.ToDateTime(record[fieldName]).ToString("dd-MM-yyyy")); } } ddl.DataSource = dates; } } } else { char delimiter = validator.LOVValue[0]; //if (validator.LOVValue.StartsWith("/")) // delimiter = '/'; //else if (validator.LOVValue.StartsWith(";")) // delimiter = ';'; //else delimiter = ','; string[] valueList = validator.LOVValue.Split(delimiter); ddl.DataSource = valueList.Where <string>(val => val != string.Empty).ToList <string>(); } ddl.DataBind(); for (int i = 0; i < ddl.Items.Count; i++) { if (ddl.Items[i].Value.ToLower() == userInputValue.ToLower()) { ddl.Items[i].Selected = true; break; } } divControl.Controls.Add(ddl); idType.ID = ddl.ID; idType.Type = ControlType.DropDownList; if (validator.AllowEdit && validator.LovType == EnumLovType.Lovcp) { ddl.Style.Add("width", validator.ActualLength - 14 + "px"); } else { ddl.Style.Add("width", validator.ActualLength + 4 + "px"); } if (validator.AllowEdit) { if (validator.LovType == EnumLovType.Lovcp) { CreatePickButton(ddl.ID, fieldName, ref divControl); } // Text box for editing dropdown list. txtBx.ID = string.Concat("txtddl", fieldName); txtBx.Style.Add("position", "absolute"); txtBx.Style.Add("display", "none"); txtBx.Style.Add("border-style", "none"); if (!userInputValue.Trim().Equals(string.Empty)) { if (ddl.SelectedValue != null && ddl.SelectedValue != "") { if (ddl.SelectedValue.Trim().ToLower() == userInputValue.Trim().ToLower()) { txtBx.Text = ddl.SelectedValue; } else { txtBx.Text = userInputValue; } } } else { txtBx.Text = ddl.SelectedValue; } divControl.Controls.Add(txtBx); txtBx.ToolTip = validator.ToolTip; } else { ddl.Enabled = false; } //if (!validator.IsInitialValueValid(value)) //{ // ddl.ForeColor = System.Drawing.Color.Red; //} } else { txtBx.ID = string.Concat("txt", fieldName); txtBx.Text = value; divControl.Controls.Add(txtBx); txtBx.ToolTip = validator.ToolTip; txtBx.Style.Add("width", validator.ActualLength + "px"); if (validator.AllowEdit && (validator.LovType == EnumLovType.Lovp || curType == DataType.Date)) { txtBx.Style.Add("width", validator.ActualLength - 18 + "px"); } else { txtBx.Style.Add("width", validator.ActualLength + "px"); } if (validator.AllowEdit) { if (validator.LovType == EnumLovType.Lovp) { CreatePickButton(txtBx.ID, fieldName, ref divControl); } } else { txtBx.ReadOnly = true; } switch (curType) { case DataType.Integer: if (validator.MinValueInt >= 0 && validator.MaxValueInt > 0 && validator.ErrorLevel == 2) { RangeValidator rv = new RangeValidator(); rv.ID = string.Concat("rv", fieldName); rv.Type = ValidationDataType.Integer; rv.MinimumValue = validator.MinValueInt.ToString(); rv.MaximumValue = validator.MaxValueInt.ToString(); rv.ControlToValidate = txtBx.ID; rv.ErrorMessage = string.Format("Value should be between {0} and {1}", validator.MinValueInt, validator.MaxValueInt); rv.ValidationGroup = "peValidation"; divControl.Controls.Add(rv); } break; case DataType.Float: if (validator.ErrorLevel == 2) { if (validator.MinValueInt > 0 && validator.MaxValueInt > 0) { RangeValidator rv = new RangeValidator(); rv.ID = string.Concat("rv", fieldName); rv.Type = ValidationDataType.Double; rv.MinimumValue = validator.MinValueFloat.ToString(); rv.MaximumValue = validator.MaxValueFloat.ToString(); rv.ControlToValidate = txtBx.ID; rv.ErrorMessage = string.Format("Value should be between {0} and {1}", validator.MinValueFloat, validator.MaxValueFloat); rv.ValidationGroup = "peValidation"; divControl.Controls.Add(rv); } } break; case DataType.String: //if (validator.MaxStringLength > 0) //{ // txtBx.MaxLength = validator.MaxStringLength; //} if (validator.ErrorLevel == 2) { CustomValidator cv = new CustomValidator(); cv.ID = string.Concat("cv", fieldName); cv.ValidationGroup = "peValidation"; cv.ControlToValidate = txtBx.ID; cv.ValidateEmptyText = true; cv.ServerValidate += new ServerValidateEventHandler(CustomValidator_Handler); divControl.Controls.Add(cv); } break; case DataType.Date: if (value.Trim() == string.Empty) { txtBx.Text = value = DateTime.Today.ToString("dd-MM-yyy"); } if (validator.AllowEdit == true && validator.LovType != EnumLovType.Lovp) { ImageButton imgBtn = new ImageButton(); imgBtn.ID = string.Concat("imgBtn", fieldName); imgBtn.ImageUrl = "Images/calendericon.png"; imgBtn.Attributes.Add("onmouseover", "ShowCalander(this)"); CalendarExtender calander = new CalendarExtender(); calander.ID = string.Concat("cal", fieldName); calander.TargetControlID = txtBx.ID; calander.PopupButtonID = imgBtn.ID; calander.Format = "dd-MM-yyyy"; divControl.Controls.Add(imgBtn); divControl.Controls.Add(calander); } if (validator.ErrorLevel == 2) { CustomValidator cv = new CustomValidator(); cv.ID = string.Concat("cv", fieldName); cv.ValidationGroup = "peValidation"; cv.ControlToValidate = txtBx.ID; cv.ValidateEmptyText = true; cv.ServerValidate += new ServerValidateEventHandler(CustomValidator_Handler); divControl.Controls.Add(cv); } break; default: break; } if (validator.Mandatory == EnumMandatory.Yes && validator.ErrorLevel != 3) { RequiredFieldValidator rfv = new RequiredFieldValidator(); rfv.ID = string.Concat("rfv", fieldName); rfv.ControlToValidate = txtBx.ID; rfv.ErrorMessage = "Required"; rfv.ValidationGroup = "peValidation"; divControl.Controls.Add(rfv); } idType.ID = txtBx.ID; idType.Type = ControlType.TextBox; } // Check Initail value is correct or has an error. // If error than make it Red color. bool foundError = false; if (validator.Mandatory == EnumMandatory.Lov && userInputValue.Trim() != string.Empty) { //if (validator.LovType != EnumLovType.Lovc && (validator.LovType == EnumLovType.Lovc && validator.LOVValue.ToLower().StartsWith("select"))) if (validator.LovType != EnumLovType.Lovp) { // dropdown control if (!CheckInputConsistentWithList(ref ddl, userInputValue.Trim())) { foundError = true; } } else if (!CheckInputConsistentWithList(validator, userInputValue.Trim())) { foundError = true; } } if (foundError || !validator.IsInitialValueValid(value)) { txtBx.ForeColor = System.Drawing.Color.Red; } HtmlGenericControl table = new HtmlGenericControl("table"); HtmlGenericControl row = new HtmlGenericControl("tr"); HtmlGenericControl firstCol = new HtmlGenericControl("td"); HtmlGenericControl secondCol = new HtmlGenericControl("td"); // By default labels length = 128px; Considered that we have max 15 chars. // For more char than 15 we add CharLength(7px) for each char. int labelLength = 228; if (lebalMaxChar > 35 && inputBoxMaxLength < MaxDisplayLength) { int availableSpace = MaxDisplayLength - inputBoxMaxLength; int extraLength = (lebalMaxChar - 35) * CharLength; if (extraLength <= availableSpace) { labelLength = labelLength + extraLength; } else { labelLength = labelLength + availableSpace; } } if (maxLabelLength < labelLength) { maxLabelLength = labelLength; } table.Attributes.Add("width", "100%"); firstCol.Style.Add("width", labelLength + "px"); firstCol.Attributes.Add("valign", "top"); secondCol.Attributes.Add("valign", "top"); table.Controls.Add(row); row.Controls.Add(firstCol); row.Controls.Add(secondCol); firstCol.Controls.Add(divLabels); secondCol.Controls.Add(divControl); pnlControl.Controls.Add(table); return(idType); }
public PersonQueries(DBManagerFactory dbManagerFactory, SQLMap sqlMap) : this(dbManagerFactory) { this.sqlMap = sqlMap; }
public PersonQueries(DBManagerFactory dbManagerFactory, StoredProcMap storedProcMap) : this(dbManagerFactory) { this.storedProcMap = storedProcMap; }
private PersonQueries(DBManagerFactory dbManagerFactory) { this.dbManagerFactory = dbManagerFactory; }
public void CreateParameters(int paramsCount) { idbParameters = new IDbDataParameter[paramsCount]; idbParameters = DBManagerFactory.GetParameters(this.ProviderType, paramsCount); }