public string SaveAttribute(AttributeSettingsData oliveDoc, out string AttrIdOut)
{
object result = new object();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_save_attr", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
OracleParameter p_msg = new OracleParameter("p_msg", OracleType.VarChar, 1000);
p_msg.Direction = ParameterDirection.Output;
OracleParameter AttributeId = new OracleParameter("AttributeId", OracleType.VarChar, 1000);
AttributeId.Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("an_attr_id", (object)oliveDoc.AttributeId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_attr_name", Convert.ToString(oliveDoc.AttributeName));
objCmd.Parameters.AddWithValue("as_data_type", (object)oliveDoc.AttributeType ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_status", (object)Common.GetBoolToStringStatus(oliveDoc.AttributeStatus) ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.User ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_style", (object)oliveDoc.Style ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_description", (object)oliveDoc.Description ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_default_val_flag", (object)Common.GetBoolToString(oliveDoc.DefaultValFlag) ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_default_val", (object)oliveDoc.DefaultVal ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_library_id", (object)oliveDoc.LibraryId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_val_man", (object)Common.GetBoolToString(oliveDoc.IsValueMandatory) ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_inh_man", (object)Common.GetBoolToString(oliveDoc.IsInhMandatory) ?? (object)DBNull.Value);
objCmd.Parameters.Add(p_msg);
objCmd.Parameters.Add(AttributeId);
objCmd.ExecuteNonQuery();
result = p_msg.Value;
AttrIdOut = AttributeId.Value.ToString();
objConn.Close();
}
return(result.ToString());
}
public List <AttributeSettingsData> GetAttributesListValues(int AttributeId)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("p_get_attribute_list_val", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_attr_id", OracleType.Int32).Value = AttributeId;
objCmd.Parameters.Add("p_cur_group", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.ListVal = Convert.ToString(dr["val"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
protected void grdGroup_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("select_one"))
{
Clear();
int RowIndex;
RowIndex = int.Parse(e.CommandArgument.ToString());
BindAttributes(RowIndex);
HiddenField hfLibraryId = (HiddenField)grdGroup.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("hfLibraryId");
ViewState["LibraryId"] = hfLibraryId.Value;
}
if (e.CommandName.Equals("Delete"))
{
string strMsg;
int RowIndex, GroupId;
RowIndex = int.Parse(e.CommandArgument.ToString());
GroupId = (int)this.grdGroup.DataKeys[RowIndex]["GroupId"];
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oData = new AttributeSettingsData();
oData.GroupId = GroupId;
strMsg = oClient.DeleteAttributeGroupMaster(oData);
SearchGridFill();
Common.ErrorMessage(this, strMsg);
}
}
// For Attributes fill in Attributes group by group id
public List <AttributeSettingsData> GetAttributeGroupById(int GroupId)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("p_get_attr_group_byId", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_group_id", OracleType.VarChar).Value = GroupId;
objCmd.Parameters.Add("p_cur_group", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.GroupId = Convert.ToInt32(dr["group_id"]);
outTemp.GroupName = Convert.ToString(dr["group_name"]);
outTemp.AttributeStatus = Common.GetStringToBoolAttribute(Convert.ToString(dr["status"]));
outTemp.LibraryId = Convert.ToInt32(dr["library_id"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
public List <AttributeSettingsData> GetObjectAttributeList(int ObjectId)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("p_get_object_attr_list", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_object_id", OracleType.VarChar).Value = ObjectId;
objCmd.Parameters.Add("p_cur_attr", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.GroupId = Convert.ToInt32(dr["group_id"]);
outTemp.GroupName = Convert.ToString(dr["group_name"]);
outTemp.AttributeId = Convert.ToInt32(dr["attr_id"]);
outTemp.AttributeName = Convert.ToString(dr["attr_name"]);
outTemp.AttributeType = Convert.ToString(dr["data_type"]);
outTemp.AttributeValue = Convert.ToString(dr["attr_val"]);
outTemp.CurrentVersion = Convert.ToInt32(dr["version_number"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
public List <AttributeSettingsData> GetSysAttributeGroupByLibraryId(int LibraryId, bool Status)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("P_GET_LIBRARY_ATTR_GROUP_LIST", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_library_id", OracleType.Int32).Value = LibraryId;
objCmd.Parameters.Add("as_is_system_attr", OracleType.VarChar).Value = Common.GetBoolToString(Status);
objCmd.Parameters.Add("p_cur_group", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.GroupId = Convert.ToInt32(dr["group_id"]);
outTemp.GroupName = Convert.ToString(dr["group_name"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
public string SaveAttributeGroupMaster(AttributeSettingsData oliveDoc, out string GroupIdOut)
{
object result = new object();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_save_attr_group_master", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
OracleParameter p_msg = new OracleParameter("p_msg", OracleType.VarChar, 1000);
p_msg.Direction = ParameterDirection.Output;
OracleParameter GroupId = new OracleParameter("GroupId", OracleType.VarChar, 1000);
GroupId.Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("an_group_id", (object)oliveDoc.GroupId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_group_name", (object)oliveDoc.GroupName ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_library_id", (object)oliveDoc.LibraryId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_status", Common.GetBoolToStringStatus(oliveDoc.AttributeStatus));
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.User ?? (object)DBNull.Value);
objCmd.Parameters.Add(p_msg);
objCmd.Parameters.Add(GroupId);
objCmd.ExecuteNonQuery();
result = p_msg.Value;
GroupIdOut = GroupId.Value.ToString();
objConn.Close();
}
return(result.ToString());
}
private void FillDetails()
{
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
int GroupId = ViewState["GroupId"].ToString().ToInt();
lstAllAttribute.DataSource = oClient.GetGroupAttributes(GroupId, 0, "A");
lstAllAttribute.DataTextField = "AttributeName";
lstAllAttribute.DataValueField = "AttributeId";
lstAllAttribute.DataBind();
for (int i = 0; i < lstAllAttribute.Items.Count; i++)
{
if (i % 2 == 0)
{
lstAllAttribute.Items[i].Attributes.Add("style", "color:Black;background-color:#f2f2f2;");
}
}
lstGroupAttribute.DataSource = oClient.GetGroupAttributes(GroupId, 0, "Y");
lstGroupAttribute.DataTextField = "AttributeName";
lstGroupAttribute.DataValueField = "AttributeId";
lstGroupAttribute.DataBind();
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
AttributeSettingsDataTemp = oClient.GetAttributeGroupById(ViewState["GroupId"].ToString().ToInt());
if (AttributeSettingsDataTemp.Count > 0)
{
txtGroupName.Text = AttributeSettingsDataTemp[0].GroupName;
}
if (AttributeSettingsDataTemp[0].AttributeStatus)
{
chkbxStatus.Checked = true;
}
}
private void FillSystemGroups()
{
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
AttributeSettingsDataTemp = oClient.GetSysAttributeGroupByLibraryId(ViewState["LibraryId"] == null ? 0 : ViewState["LibraryId"].ToString().ToInt(), true);
cblGroup.DataSource = AttributeSettingsDataTemp;
cblGroup.DataTextField = "GroupName";
cblGroup.DataValueField = "GroupId";
cblGroup.DataBind();
}
//public void GetAttributeList(int CurrentIndex)
//{
// if (grdAttribute.Rows.Count > 0)
// {
// Clear();
// GridViewRow row = grdAttribute.Rows[0];
// Label txtAttributeIdItem = (Label)grdAttribute.Rows[CurrentIndex].FindControl("lblAttributeId");
// Label txtAttributeNameItem = (Label)grdAttribute.Rows[CurrentIndex].FindControl("lblAttributeName");
// Label lblAttributeTypeItem = (Label)grdAttribute.Rows[CurrentIndex].FindControl("lblAttributeType");
// CheckBox chkAttributeStatusItem = (CheckBox)grdAttribute.Rows[CurrentIndex].FindControl("chkAttributeStatus");
// Label lblDescription = (Label)grdAttribute.Rows[CurrentIndex].FindControl("lblDescription");
// HiddenField hfStyle = (HiddenField)grdAttribute.Rows[CurrentIndex].FindControl("hfStyle");
// HiddenField hfDefaultVal = (HiddenField)grdAttribute.Rows[CurrentIndex].FindControl("hfDefaultVal");
// HiddenField hfDefaultValFlag = (HiddenField)grdAttribute.Rows[CurrentIndex].FindControl("hfDefaultValFlag");
// HiddenField hfValueMan = (HiddenField)grdAttribute.Rows[CurrentIndex].FindControl("hfIsValueMandatory");
// HiddenField hfInhMan = (HiddenField)grdAttribute.Rows[CurrentIndex].FindControl("hfIsInhMandatory");
// ViewState["AttributeId"] = txtAttributeIdItem.Text;
// txtAttributeName.Text = txtAttributeNameItem.Text;
// ddlAttributeType.SelectedItem.Text = lblAttributeTypeItem.Text;
// chkAttributeStatus.Checked = chkAttributeStatusItem.Checked;
// txtDescription.Text = lblDescription.Text;
// ddlStyle.SelectedValue = hfStyle.Value;
// if (hfDefaultValFlag.Value == "True")
// {
// chkDefault.Checked = true;
// txtDefaultValue.Text = hfDefaultVal.Value;
// }
// else
// {
// chkDefault.Checked = false;
// defaultVal.Visible = false;
// }
// if (hfValueMan.Value == "True")
// {
// chkValMan.Checked = true;
// }
// if (hfInhMan.Value == "True")
// {
// chkInhMand.Checked = true;
// }
// string a = string.Empty;
// AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
// AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
// List<AttributeSettingsData> AttributeSettingsDataTemp = new List<AttributeSettingsData>();
// AttributeSettingsDataTemp = oClient.GetAttributesListValues(ViewState["AttributeId"].ToString().ToInt());
// if (AttributeSettingsDataTemp.Count > 0)
// {
// string strText = string.Empty;
// for (int i = 0; i < AttributeSettingsDataTemp.Count; i++)
// {
// strText += AttributeSettingsDataTemp[i].ListVal + "\n";
// }
// txtListValues.Text = strText;
// listVal.Visible = true;
// txtListValues.Visible = true;
// }
// }
//}
private void FillDetails()
{
MVAttribute.SetActiveView(VWAdd);
FillStyle();
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
AttributeSettingsDataTemp = oClient.GetAttributeListById(ViewState["AttributeId"].ToString());
if (AttributeSettingsDataTemp.Count > 0)
{
ViewState["LibraryId"] = AttributeSettingsDataTemp[0].LibraryId;
txtAttributeName.Text = AttributeSettingsDataTemp[0].AttributeName;
ddlAttributeType.SelectedItem.Text = AttributeSettingsDataTemp[0].AttributeType;
chkAttributeStatus.Checked = AttributeSettingsDataTemp[0].AttributeStatus;
txtDescription.Text = AttributeSettingsDataTemp[0].Description;
ddlStyle.SelectedValue = AttributeSettingsDataTemp[0].StyleVal;
if (AttributeSettingsDataTemp[0].DefaultValFlag)
{
chkDefault.Checked = true;
txtDefaultValue.Text = AttributeSettingsDataTemp[0].DefaultVal;
}
else
{
chkDefault.Checked = false;
DivdefaultVal.Visible = false;
}
if (AttributeSettingsDataTemp[0].IsValueMandatory)
{
chkValMan.Checked = true;
}
if (AttributeSettingsDataTemp[0].IsInhMandatory)
{
chkInhMand.Checked = true;
}
string a = string.Empty;
AttributeService.AttributeSettingsClient oClientd = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsDatad = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTempList = new List <AttributeSettingsData>();
AttributeSettingsDataTempList = oClient.GetAttributesListValues(ViewState["AttributeId"].ToString().ToInt());
if (AttributeSettingsDataTempList.Count > 0)
{
string strText = string.Empty;
for (int i = 0; i < AttributeSettingsDataTempList.Count; i++)
{
strText += AttributeSettingsDataTempList[i].ListVal + "\n";
}
txtListValues.Text = strText;
listVal.Visible = true;
txtListValues.Visible = true;
}
}
}
/// <summary>
/// Its for Saving groups to GroupMaster and save its attrubutes to perticular
/// </summary>
protected void SaveAttributeGroup()
{
//First to add group ID to the Group Master tables
string strMsg, NewGroupId;
AttributeService.AttributeSettingsData objData = new AttributeSettingsData();
objData.GroupId = ViewState["GroupId"] == null ? 0 : Convert.ToInt16(ViewState["GroupId"].ToString());
objData.GroupName = txtGroupName.Text;
// By default library id saving as 0
objData.LibraryId = ViewState["LibraryId"] == null ? 0 : Convert.ToInt16(ViewState["LibraryId"].ToString());
if (chkbxStatus.Checked == true)
{
objData.AttributeStatus = true;
}
else
{
objData.AttributeStatus = false;
}
objData.User = Session["UserId"].ToString();
AttributeService.AttributeSettingsClient objSave = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
strMsg = objSave.SaveAttributeGroupMaster(objData, out NewGroupId);
//if the new Group ID is invalid / Having any validations error it should return from here.
if (NewGroupId == "0")
{
Common.ErrorMessage(this, strMsg);
return;
}
//second to Add perticular attributes to group
AttributeService.AttributeSettingsClient objClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
string DeleteFlag = "Y";
objData.GroupId = ViewState["GroupId"] == null ? 0 : Convert.ToInt16(ViewState["GroupId"].ToString());
objData.AttributeId = 0;
objData.DeleteFlag = DeleteFlag;
objClient.SaveAttributeGroup(objData);
foreach (ListItem itm in lstGroupAttribute.Items)
{
int AttributeId = Convert.ToInt16(itm.Value);
int GroupId = Convert.ToInt16(NewGroupId);
objData.GroupId = GroupId;
objData.AttributeId = AttributeId;
objData.DeleteFlag = DeleteFlag;
if (DeleteFlag == "Y")
{
DeleteFlag = "F";
}
objClient.SaveAttributeGroup(objData);
}
SearchClear();
Common.SavedMessage(this, strMsg);
}
/// <summary>
/// Its for adding or saving Group
/// </summary>
/// <param name="oliveDoc"></param>
public void SaveAttributeListVal(AttributeSettingsData oliveDoc)
{
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_save_attr_list_val", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_attr_id", Convert.ToInt32((object)oliveDoc.AttributeId ?? (object)DBNull.Value));
objCmd.Parameters.AddWithValue("as_val", (object)oliveDoc.ListVal ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.Updatedby ?? (object)DBNull.Value);
objCmd.ExecuteNonQuery();
objConn.Close();
}
}
public void DeleteAttributeListVal(AttributeSettingsData oliveDoc)
{
object result = new object();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_delete_attr_list_val", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_Attribute_id", (object)oliveDoc.AttributeId ?? (object)DBNull.Value);
objCmd.ExecuteNonQuery();
objConn.Close();
}
}
/// <summary>
/// Its for adding group directly against the folder or document
/// </summary>
/// <param name="oliveDoc"></param>
public void SaveObjectAttributeGroup(AttributeSettingsData oliveDoc)
{
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_save_object_attr_group", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_object_id", (object)oliveDoc.ObjectId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("an_group_id", (object)oliveDoc.GroupId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("an_version_number", (object)oliveDoc.CurrentVersion ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.User ?? (object)DBNull.Value);
objCmd.ExecuteNonQuery();
objConn.Close();
}
}
/// <summary>
/// Its for adding or saving Group
/// </summary>
/// <param name="oliveDoc"></param>
public void SaveAttributeGroup(AttributeSettingsData oliveDoc)
{
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_save_attr_group", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_group_id", (object)oliveDoc.GroupId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_attr_id", (object)oliveDoc.AttributeId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_delete_flag", (object)oliveDoc.DeleteFlag ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.User ?? (object)DBNull.Value);
objCmd.ExecuteNonQuery();
objConn.Close();
}
}
public List <AttributeSettingsData> GetFullAttributeList(string Status, string Search_Param)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("P_SEARCH_ATTR_LIST", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("as_status", OracleType.VarChar).Value = Status;
objCmd.Parameters.Add("as_attr_name", OracleType.VarChar).Value = Search_Param;
objCmd.Parameters.Add("p_cur_attr", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.AttributeId = Convert.ToInt32(dr["attr_id"]);
outTemp.AttributeName = Convert.ToString(dr["attr_name"]);
outTemp.AttributeType = Convert.ToString(dr["Data_Type"]);
outTemp.AttributeStatus = Common.GetStringToBoolAttribute(Convert.ToString(dr["status"]));
outTemp.Description = Convert.ToString(dr["Description"]);
outTemp.Style = Convert.ToString(dr["Style"]);
outTemp.StyleVal = Convert.ToString(dr["StyleSml"]);
outTemp.DefaultValFlag = Common.GetStringToBoolAttribute(Convert.ToString(dr["default_val_flag"]));
outTemp.DefaultVal = Convert.ToString(dr["default_val"]);
outTemp.IsValueMandatory = Common.GetStringToBoolAttribute(Convert.ToString(dr["VAL_MAND"]));
outTemp.IsInhMandatory = Common.GetStringToBoolAttribute(Convert.ToString(dr["INHERIT_MAND"]));
outTemp.LibraryId = Convert.ToInt32(dr["LIBRARY_ID"]);
outTemp.LibraryName = Convert.ToString(dr["Library_Name"]);
outTemp.CreatedBy = Convert.ToString(dr["Insert_By"]);
outTemp.CreatedDate = TypeConvert.Convert2DateTime(dr["Insert_Date"]);
outTemp.Updatedby = Convert.ToString(dr["update_by"]);
outTemp.UpdatedDate = TypeConvert.Convert2DateTime(dr["update_date"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
private void CopySystemGroups()
{
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
oAttributeSettingsData.LibraryId = ViewState["LibraryId"].ToString().ToInt();
for (int i = 0; i < cblGroup.Items.Count; i++)
{
if (cblGroup.Items[i].Selected)
{
var itemValue = cblGroup.Items[i].Value;
oAttributeSettingsData.GroupId = cblGroup.Items[i].Value.ToInt();
oAttributeSettingsData.CreatedBy = Session["LoggedUser"].ToString();
oAttributeSettingsData.CreatedDate = System.DateTime.Now;
oClient.CopyGroupsToNew(oAttributeSettingsData);
}
}
FillLibraryAttributesGroups();
}
private void SaveListDetails(string inId)
{
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
oAttributeSettingsData.AttributeId = inId.ToInt();
oClient.DeleteAttributeListVal(oAttributeSettingsData);
string txt = txtListValues.Text;
string[] lst = txt.Split(new Char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries);
if (lst.Length > 0)
{
for (int i = 0; i < lst.Length - 1; i++)
{
oAttributeSettingsData.ListVal = lst[i];
oAttributeSettingsData.Updatedby = Session["LoggedUser"].ToString();
oClient.SaveAttributeListVal(oAttributeSettingsData);
}
}
}
public string DeleteAttributeGroupMaster(AttributeSettingsData oliveDoc)
{
object result = new object();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("p_delete_attr_group_master", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
OracleParameter p_msg = new OracleParameter("p_msg", OracleType.VarChar, 1000);
p_msg.Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("an_group_id", (object)oliveDoc.GroupId ?? (object)DBNull.Value);
objCmd.Parameters.Add(p_msg);
objCmd.ExecuteNonQuery();
result = p_msg.Value;
objConn.Close();
}
return(result.ToString());
}
/// <summary>
/// Its for adding or saving system Attribute groups from library
/// </summary>
/// <param name="oliveDoc"></param>
public string CopyGroupsToNew(AttributeSettingsData oliveDoc)
{
object result = new object();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
OracleCommand objCmd = new OracleCommand("P_COPY_GROUP_MASTER", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
OracleParameter p_msg = new OracleParameter("p_msg", OracleType.VarChar, 1000);
p_msg.Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("an_group_id", Convert.ToInt32((object)oliveDoc.GroupId ?? (object)DBNull.Value));
objCmd.Parameters.AddWithValue("an_new_library_id", (object)oliveDoc.LibraryId ?? (object)DBNull.Value);
objCmd.Parameters.AddWithValue("as_user", (object)oliveDoc.CreatedBy ?? (object)DBNull.Value);
objCmd.Parameters.Add(p_msg);
objCmd.ExecuteNonQuery();
result = p_msg.Value;
objConn.Close();
}
return(result.ToString());
}
public List <AttributeSettingsData> GetAttributeByLibrary(int LibraryId, bool Status)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("p_get_library_attr_list", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_library_id", OracleType.Int32).Value = LibraryId;
objCmd.Parameters.Add("as_is_system_attr", OracleType.VarChar).Value = Common.GetBoolToString(Status);
objCmd.Parameters.Add("p_cur_attr", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.AttributeId = Convert.ToInt32(dr["attr_id"]);
outTemp.AttributeName = Convert.ToString(dr["attr_name"]);
outTemp.AttributeType = Convert.ToString(dr["Data_Type"]);
outTemp.AttributeStatus = Common.GetStringToBoolAttribute(Convert.ToString(dr["status"]));
outTemp.Description = Convert.ToString(dr["Description"]);
outTemp.Style = Convert.ToString(dr["Style"]);
outTemp.StyleVal = Convert.ToString(dr["StyleSml"]);
outTemp.DefaultValFlag = Common.GetStringToBoolAttribute(Convert.ToString(dr["default_val_flag"]));
outTemp.DefaultVal = Convert.ToString(dr["default_val"]);
outTemp.IsValueMandatory = Common.GetStringToBoolAttribute(Convert.ToString(dr["VAL_MAND"]));
outTemp.IsInhMandatory = Common.GetStringToBoolAttribute(Convert.ToString(dr["INHERIT_MAND"]));
outTemp.LibraryId = Convert.ToInt32(dr["LIBRARY_ID"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
public List <AttributeSettingsData> GetGroupAttributes(int GroupId, int LibraryId, string GroupFlag)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("p_get_group_attr", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("an_group_id", OracleType.VarChar).Value = GroupId;
objCmd.Parameters.Add("an_library_id", OracleType.Int32).Value = LibraryId;
objCmd.Parameters.Add("as_group_flag", OracleType.VarChar).Value = GroupFlag;
objCmd.Parameters.Add("p_cur_attr", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AttributeSettingsData outTemp = new AttributeSettingsData();
List <AttributeSettingsData> AttributeSettingsDataTemp = new List <AttributeSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
outTemp.GroupId = Convert.ToInt32(dr["group_id"]);
outTemp.AttributeId = Convert.ToInt32(dr["attr_id"]);
outTemp.AttributeName = Convert.ToString(dr["attr_name"]);
outTemp.AttributeType = Convert.ToString(dr["DATA_TYPE"]);
outTemp.AttributeStatus = Common.GetStringToBool(Convert.ToString(dr["status"]));
outTemp.CreatedBy = Convert.ToString(dr["Insert_By"]);
outTemp.CreatedDate = TypeConvert.Convert2DateTime(dr["Insert_Date"]);
outTemp.Updatedby = Convert.ToString(dr["update_by"]);
outTemp.UpdatedDate = TypeConvert.Convert2DateTime(dr["update_date"]);
AttributeSettingsDataTemp.Add(outTemp);
outTemp = new AttributeSettingsData();
}
return(AttributeSettingsDataTemp.ToList());
}
private void AttributeSaveOrEdit()
{
string strMsg, NewAttrId;
AttributeService.AttributeSettingsClient oClient = new AttributeService.AttributeSettingsClient(ServiceConfig.AttributeSettingsDataEndPoint(), ServiceConfig.AttributeSettingsDataUri());
AttributeService.AttributeSettingsData oAttributeSettingsData = new AttributeSettingsData();
oAttributeSettingsData.AttributeId = ViewState["AttributeId"] == null ? 0 : Convert.ToInt16(ViewState["AttributeId"].ToString());
oAttributeSettingsData.AttributeName = txtAttributeName.Text;
oAttributeSettingsData.Style = ddlStyle.SelectedValue;
oAttributeSettingsData.Description = txtAttrDescription.Text.Trim();
string strTest = ddlAttributeType.SelectedItem.Text;
string[] saTest = strTest.Split(' ');
foreach (string strWord in saTest)
{
AttrType = (strWord.Substring(0, 1));
}
oAttributeSettingsData.AttributeType = AttrType;
if (chkAttributeStatus.Checked == true)
{
oAttributeSettingsData.AttributeStatus = true;
}
else
{
oAttributeSettingsData.AttributeStatus = false;
}
if (chkDefault.Checked)
{
oAttributeSettingsData.DefaultValFlag = true;
oAttributeSettingsData.DefaultVal = txtDefaultValue.Text.Trim();
if (txtDefaultValue.Text == string.Empty)
{
string txt = txtListValues.Text;
string[] lst = txt.Split(new Char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries);
if (lst.Length > 0)
{
oAttributeSettingsData.DefaultVal = lst[0];
}
}
}
else
{
oAttributeSettingsData.DefaultValFlag = false;
oAttributeSettingsData.DefaultVal = string.Empty;
}
if (chkInhMand.Checked)
{
oAttributeSettingsData.IsInhMandatory = true;
}
else
{
oAttributeSettingsData.IsInhMandatory = false;
}
if (chkValMan.Checked)
{
oAttributeSettingsData.IsValueMandatory = true;
}
else
{
oAttributeSettingsData.IsValueMandatory = false;
}
oAttributeSettingsData.LibraryId = ViewState["LibraryId"].ToString().ToInt();
oAttributeSettingsData.CreatedBy = Session["LoggedUser"].ToString();
oAttributeSettingsData.CreatedDate = System.DateTime.Now;
oAttributeSettingsData.Updatedby = Session["LoggedUser"].ToString();
oAttributeSettingsData.UpdatedDate = System.DateTime.Now;
oAttributeSettingsData.User = Session["LoggedUser"].ToString();
strMsg = oClient.SaveAttribute(oAttributeSettingsData, out NewAttrId);
if (listVal.Visible)
{
SaveListDetails(NewAttrId);
}
Common.SavedMessage(this, strMsg);
FillLibraryAttributes();
}
