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);
}
