public UIControlDataType GetUIControlDataType(long lngDataTypeId)
{
UIControlDataType objDataType = new UIControlDataType();
ProcedureName = "pr_GetUIControlDataType";
using (DbCommand dbCommand = Database.GetStoredProcCommand(ProcedureName))
{
Database.AddInParameter(dbCommand, "@DataTypeId", DbType.Int64, lngDataTypeId);
using (DataSet ds = ExecuteDataSet(dbCommand))
{
if (ds.Tables[0].Rows.Count != 0)
{
DataRow drDataType = ds.Tables[0].Rows[0];
objDataType.DataTypeId = long.Parse(drDataType["DataTypeId"].ToString());
objDataType.Name = drDataType["Name"].ToString();
objDataType.Created = (drDataType["Created"] != DBNull.Value ? DateTime.Parse(drDataType["Created"].ToString()) : DateTime.Now);
objDataType.CreatedBy = (drDataType["CreatedBy"] != DBNull.Value ? long.Parse(drDataType["CreatedBy"].ToString()) : 0);
objDataType.Modified = (drDataType["Modified"] != DBNull.Value ? DateTime.Parse(drDataType["Modified"].ToString()) : DateTime.Now);
objDataType.ModifiedBy = (drDataType["ModifiedBy"] != DBNull.Value ? long.Parse(drDataType["ModifiedBy"].ToString()) : 0);
objDataType.Deleted = (drDataType["Deleted"] != DBNull.Value ? Int32.Parse(drDataType["Deleted"].ToString()) : 0);
}
}
}
return(objDataType);
}
public List <UIControlDataType> GetUIControlDataTypes()
{
List <UIControlDataType> oUIControlDataTypes = new List <UIControlDataType>();
ProcedureName = "pr_GetUIControlDataType";
using (DbCommand dbCommand = Database.GetStoredProcCommand(ProcedureName))
{
//Database.AddInParameter(dbCommand, "@DataTypeId", DbType.Int64, lngDataTypeId);
using (DataSet ds = ExecuteDataSet(dbCommand))
{
foreach (DataRow drDataType in ds.Tables[0].Rows)
{
UIControlDataType objDataType = new UIControlDataType();
objDataType.DataTypeId = long.Parse(drDataType["DataTypeId"].ToString());
objDataType.Name = drDataType["Name"].ToString();
objDataType.Created = (drDataType["Created"] != DBNull.Value ? DateTime.Parse(drDataType["Created"].ToString()) : DateTime.Now);
objDataType.CreatedBy = (drDataType["CreatedBy"] != DBNull.Value ? long.Parse(drDataType["CreatedBy"].ToString()) : 0);
objDataType.Modified = (drDataType["Modified"] != DBNull.Value ? DateTime.Parse(drDataType["Modified"].ToString()) : DateTime.Now);
objDataType.ModifiedBy = (drDataType["ModifiedBy"] != DBNull.Value ? long.Parse(drDataType["ModifiedBy"].ToString()) : 0);
objDataType.Deleted = (drDataType["Deleted"] != DBNull.Value ? Int32.Parse(drDataType["Deleted"].ToString()) : 0);
oUIControlDataTypes.Add(objDataType);
}
}
}
return(oUIControlDataTypes);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
UIControl oUIControl = new UIControl();
oUIControl.ControlId = long.Parse(txtControlId.Text.Trim());
oUIControl.LabelName = txtLabelName.Text.Trim();
oUIControl.LabelText = txtLabelText.Text.Trim();
oUIControl.ShortName = txtShortName.Text.Trim();
oUIControl.ControlName = txtControlName.Text.Trim();
oUIControl.ToolTipText = txtToolTipText.Text.Trim();
oUIControl.HTMLHelp = txtHTMLHelp.Text.Trim();
if (ddlDataType.SelectedValue != "-1")
{
UIControlDataType oUIControlDataType = new UIControlDataType();
oUIControlDataType.DataTypeId = Int64.Parse(ddlDataType.SelectedValue.ToString());
oUIControl.ControlDataType = oUIControlDataType;
}
oUIControl.ValidationRequired = (chkValRequiredField.Checked == true?1:0);
if (ddlValRegularExp.SelectedValue != "-1")
{
UIControlValidationRegularExp oUIControlValidationRegularExp = new UIControlValidationRegularExp();
oUIControlValidationRegularExp.RegularExpId = Int32.Parse(ddlValRegularExp.SelectedValue.ToString());
oUIControl.ValidationRegularExp = oUIControlValidationRegularExp;
}
oUIControl.ValidationCompareControl = txtValCompareControl.Text.Trim();
if (txtValMinLen.Text.Trim() != "")
{
oUIControl.ValidationMinLen = long.Parse(txtValMinLen.Text.Trim());
}
if (txtValMaxLen.Text.Trim() != "")
{
oUIControl.ValidationMaxLen = long.Parse(txtValMaxLen.Text.Trim());
}
oUIControl.ValidationRangeFrom = txtValRangeFrom.Text.Trim();
oUIControl.ValidationRangeTo = txtValRangeTo.Text.Trim();
oUIControl.ValidationCustomClientSideFunction = txtValClientSideFunName.Text.Trim();
oUIControl.ValidationCustomServerSideFunction = txtValServerSideFunName.Text.Trim();
oUIControl.ValidationMsg = txtValMsg.Text.Trim();
oUIControl.ModifiedBy = intProfile;
if (txtDisplayOrder.Text.Trim() != "")
{
oUIControl.DisplayOrder = long.Parse(txtDisplayOrder.Text);
}
oUIControl.Deleted = 0;
//oUIControl.ControlId = txtControlId.Text;
oUIFactory.UpdateUIControl(oUIControl);
LoadUIControlList();
}
