private ProfilesMaster CollectDataForProfiles(DataRow ProfilesRow)
{
try
{
ProfilesMaster ProfilesObject = new ProfilesMaster();
ProfileNames Profilesnamesobj = new ProfileNames();
ProfilesObject.ServerType = ProfilesRow["ServerType"].ToString();
ProfilesObject.RelatedTable = ProfilesRow["RelatedTable"].ToString();
ProfilesObject.RelatedField = ProfilesRow["RelatedField"].ToString();
ProfilesObject.DefaultValue = ProfilesRow["DefaultValue"].ToString();
ProfilesObject.UnitOfMeasurement = ProfilesRow["UnitofMeasurement"].ToString();
ProfilesObject.AttributeName = ProfilesRow["AttributeName"].ToString();
ProfilesObject.ProfileId = Convert.ToInt32(ProfilesRow["ProfileId"].ToString());
ProfilesObject.isSelected = Convert.ToBoolean(ProfilesRow["isSelected"].ToString());
//ProfilesObject.ProfileId = Convert.ToInt32(ProfileComboBox.SelectedItem.Value);
//Profilesnamesobj.ProfileName = ProfileComboBox.SelectedItem.Text;
return(ProfilesObject);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
protected void ProfilesGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
ProfilesMaster StObject = new ProfilesMaster();
StObject.Id = int.Parse(e.Keys[0].ToString());
//Delete row from DB
Object ReturnValue = VSWebBL.SecurityBL.ProfilesMasterBL.Ins.DeleteData(StObject);
if (Convert.ToBoolean(ReturnValue) == false)
{
}
else
{
ASPxGridView gridView = (ASPxGridView)sender;
gridView.CancelEdit();
e.Cancel = true;
FillProfilesGrid();
}
//Update Grid after inserting new row, refresh grid as in page load
}
public DataTable GetAllDataByServerType(string ServerType, string RoleType, string ProfileName)
{
DataTable ProfilesMasterTable = new DataTable();
ProfilesMaster ReturnObj = new ProfilesMaster();
string SqlQuery = "SELECT pm.ID,pm.ServerTypeId,pm.AttributeName,pm.DefaultValue,pm.UnitOfMeasurement,pm.RelatedTable," +
"pm.RelatedField, pm.ProfileId,st.ServerType,pm.isSelected FROM ProfilesMaster pm inner join ServerTypes st on pm.ServerTypeId=st.ID inner join ProfileNames pn on pn.ID=pm.profileId" +
" where st.ServerType='" + ServerType + "' and pm.RoleType='" + RoleType + "'and pn.ProfileName='" + ProfileName + "' union SELECT pm.ID,pm.ServerTypeId,pm.AttributeName,pm.DefaultValue,pm.UnitOfMeasurement,pm.RelatedTable,pm.RelatedField, pm.ProfileId,st.ServerType,pm.isSelected FROM ProfilesMaster pm inner join ServerTypes st on pm.ServerTypeId=st.ID inner join ProfileNames pn on pn.ID=pm.profileId where st.ServerType='" + ServerType + "' and pm.RoleType='" + RoleType + "'and pn.ProfileName='Default' and AttributeName not in (SELECT pm.AttributeName FROM ProfilesMaster pm inner join ServerTypes st on pm.ServerTypeId=st.ID inner join ProfileNames pn on pn.ID=pm.profileId where st.ServerType='" + ServerType + "' and pm.RoleType='" + RoleType + "'and pn.ProfileName='" + ProfileName + "') order by pm.AttributeName";
ProfilesMasterTable = objAdaptor.FetchData(SqlQuery);
try
{
if (ProfilesMasterTable.Rows.Count == 0)
{
SqlQuery = "SELECT pm.ID,pm.ServerTypeId,pm.AttributeName,pm.DefaultValue,pm.UnitOfMeasurement,pm.RelatedTable," +
"pm.RelatedField,isnull(pm.ProfileId,'0') as ProfileId ,st.ServerType,pm.isSelected FROM ProfilesMaster pm inner join ServerTypes st on pm.ServerTypeId=st.ID inner join ProfileNames pn on pn.ID=pm.profileId" +
" where st.ServerType='" + ServerType + "' and (pm.RoleType='" + RoleType + "' or pm.RoleType is NULL) and pn.ProfileName='Default' order by pm.AttributeName";
ProfilesMasterTable = objAdaptor.FetchData(SqlQuery);
}
}
catch
{
}
finally
{
}
return(ProfilesMasterTable);
}
private ProfilesMaster CollectDataForProfiles(string Mode, DataRow ProfilesRow)
{
try
{
ProfilesMaster ProfilesObject = new ProfilesMaster();
//if (Mode == "Update")
//{
//ProfilesObject.ID = int.Parse(ProfilesRow["ID"].ToString());
//}
// ProfilesObject.ServerTypeId = Convert.ToInt32(ProfilesRow["ServerTypeId"]);
ProfilesObject.ServerType = ProfilesRow["ServerType"].ToString();
ProfilesObject.RelatedTable = ProfilesRow["RelatedTable"].ToString();
ProfilesObject.RelatedField = ProfilesRow["RelatedField"].ToString();
ProfilesObject.DefaultValue = ProfilesRow["DefaultValue"].ToString();
ProfilesObject.UnitOfMeasurement = ProfilesRow["UnitofMeasurement"].ToString();
ProfilesObject.AttributeName = ProfilesRow["AttributeName"].ToString();
ProfilesObject.RoleType = "";
if (ProfilesObject.RelatedTable == "ExchangeSettings")
{
ProfilesObject.RoleType = ProfilesRow["RoleType"].ToString();
}
return(ProfilesObject);
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
public bool UpdateeditProfiles(ProfilesMaster StObject, string strsname, string profilemasterid)
{
bool UpdateRet = false;
int Update = 0;
try
{
DataTable dt = new DataTable();
ServerTypes STypebject = new ServerTypes();
ServerTypes RetnSTypebject = new ServerTypes();
STypebject.ServerType = StObject.ServerType;
RetnSTypebject = VSWebDAL.SecurityDAL.ServerTypesDAL.Ins.GetDataForServerType(STypebject);
StObject.ServerTypeId = RetnSTypebject.ID;
if (strsname != "")
{
string SqlQuery = "";
if (StObject.RoleType == null)
{
StObject.RoleType = "";
}
SqlQuery = "select * from ProfilesMaster where ProfileId='" + strsname + "' and ServerTypeId ='" + StObject.ServerTypeId + "'and AttributeName='" + StObject.AttributeName + "'";
dt = objAdaptor.FetchData(SqlQuery);
if (dt.Rows.Count > 0)
{
SqlQuery = "UPDATE ProfilesMaster set AttributeName='" + StObject.AttributeName + "',isSelected='" + StObject.isSelected + "',UnitOfMeasurement='" + StObject.UnitOfMeasurement +
"',RelatedTable='" + StObject.RelatedTable + "',RelatedField='" + StObject.RelatedField + "',DefaultValue='" + StObject.DefaultValue + "',ServerTypeId='" + StObject.ServerTypeId + "',RoleType='" + StObject.RoleType.ToString() + "'where ProfileId='" + strsname + "' and ID='" + profilemasterid + "'";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
}
}
catch
{
Update = 0;
}
if (Update == 0)
{
try
{
string SqlQuery = "";
SqlQuery = "INSERT INTO ProfilesMaster(ServerTypeId,AttributeName,DefaultValue,UnitOfMeasurement,RelatedTable,RelatedField,RoleType,ProfileId,isSelected) VALUES('"
+ StObject.ServerTypeId + "','" + StObject.AttributeName + "','" + StObject.DefaultValue + "','" + StObject.UnitOfMeasurement +
"','" + StObject.RelatedTable + "','" + StObject.RelatedField + "','" + StObject.RoleType.ToString() + "','" + strsname + "','" + StObject.isSelected + "')";
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
catch
{
Update = 0;
}
}
if (Update >= 1)
{
UpdateRet = true;
}
return(UpdateRet);
}
public async Task SaveOrUpdateAsync(ProfilesMaster profilesMaster)
{
using (_unitOfWork)
{
await _db.ProfilesMasters.AddAsync(profilesMaster);
_unitOfWork.Commit();
}
}
public bool UpdateeditProfiles(ProfilesMaster StObject, string strsname, string profilemasterid)
{
try
{
return(VSWebDAL.SecurityDAL.ProfilesMasterDAL.Ins.UpdateeditProfiles(StObject, strsname, profilemasterid));
}
catch (Exception ex)
{
throw ex;
}
}
public object DeleteData(ProfilesMaster StObject)
{
try
{
return(VSWebDAL.SecurityDAL.ProfilesMasterDAL.Ins.DeleteData(StObject));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task UpdateAsync(ProfilesMaster profilesmaster, int?Id)
{
using (_unitOfWork)
{
if (Id != null)
{
_db.ProfilesMasters.Update(profilesmaster);
_db.SaveChanges();
}
}
}
protected void btn_Click(object sender, EventArgs e)
{
ImageButton btn = (ImageButton)sender;
ProfilesMaster ProfilesObject = new ProfilesMaster();
ProfilesObject.Id = int.Parse(btn.CommandArgument);
Id = btn.CommandArgument;
string name = btn.AlternateText;
pnlAreaDtls.Style.Add("visibility", "visible");
divmsg.InnerHtml = "Are you sure you want to delete the Profile " + name + "?";
}
public object DeleteData(ProfilesMaster StObject)
{
bool UpdateRet = false;
int Update = 0;
try
{
string SqlQuery = "delete ProfilesMaster where id=" + StObject.Id;
Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
catch
{
Update = 0;
}
if (Update == 1)
{
UpdateRet = true;
}
return(UpdateRet);
}
protected void btn_OkClick(object sender, EventArgs e)
{
ProfilesMaster ProfilesObject = new ProfilesMaster();
ProfilesObject.Id = int.Parse(Id);
Object ReturnValue = VSWebBL.SecurityBL.ProfilesMasterBL.Ins.DeleteData(ProfilesObject);
if (Convert.ToBoolean(ReturnValue) == false)
{
NavigatorPopupControl.ShowOnPageLoad = true;
MsgLabel.Text = "This Profile cannot be deleted, other dependencies exist.";
}
else
{
//ASPxGridView gridView = (ASPxGridView)sender;
//gridView.CancelEdit();
//e.Cancel = true;
FillProfilesGrid();
}
//pnlAreaDtls.Style.Add("visibility", "hidden");
}
private ProfilesMaster CollectDataForProfiles(DataRow ProfilesRow)
{
try
{
ProfilesMaster ProfilesObject = new ProfilesMaster();
ProfilesObject.ServerType = ProfilesRow["ServerType"].ToString();
ProfilesObject.RelatedTable = ProfilesRow["RelatedTable"].ToString();
ProfilesObject.RelatedField = ProfilesRow["RelatedField"].ToString();
ProfilesObject.DefaultValue = ProfilesRow["DefaultValue"].ToString();
ProfilesObject.UnitOfMeasurement = ProfilesRow["UnitofMeasurement"].ToString();
ProfilesObject.AttributeName = ProfilesRow["AttributeName"].ToString();
return(ProfilesObject);
}
catch (Exception ex)
{
//6/27/2014 NS added for VSPLUS-634
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
public DataTable GetAllDataByServerType(string ServerType)
{
DataTable ProfilesMasterTable = new DataTable();
ProfilesMaster ReturnObj = new ProfilesMaster();
try
{
string SqlQuery = "SELECT pm.ID,pm.ServerTypeId,pm.AttributeName,pm.DefaultValue,pm.UnitOfMeasurement,pm.RelatedTable," +
"pm.RelatedField,pm.ProfileId,st.ServerType,'false' as isSelected FROM ProfilesMaster pm,ServerTypes st " +
"where pm.ServerTypeId=st.ID and ServerType='" + ServerType + "'";
//, s.LocationID
//,Servers s
//pm.ID = s.ID and
ProfilesMasterTable = objAdaptor.FetchData(SqlQuery);
}
catch
{
}
finally
{
}
return(ProfilesMasterTable);
}
/// <summary>
/// Get all Data from ProfilesMaster
/// </summary>
public DataTable GetAllData()
{
DataTable ProfilesMasterTable = new DataTable();
ProfilesMaster ReturnObj = new ProfilesMaster();
try
{
string SqlQuery = "SELECT pm.ID,pm.ServerTypeId,st.ServerType,pm.AttributeName,pm.DefaultValue,pm.UnitOfMeasurement,pm.RelatedTable,pm.RelatedField,st.ServerType,'false' as isSelected" +
" FROM ProfilesMaster pm,ServerTypes st where pm.ServerTypeId=st.ID and ServerType='st.ServerType' and pm.RoleType=''";
//and pm.ProfileId =(select id from ProfileNames where ProfileName='Default' )";
ProfilesMasterTable = objAdaptor.FetchData(SqlQuery);
//"SELECT pm.ID,pm.ServerTypeId,pm.AttributeName,pm.AttributeMeasurement,pm.RelatedTable,pm.RelatedField,st.ServerType " +
//" FROM ProfilesMaster pm,ServerTypes st where pm.ServerTypeId=st.ID";
}
catch
{
}
finally
{
}
return(ProfilesMasterTable);
}
public Task ProfileVerification(ProfilesMaster profile)
{
throw new NotImplementedException();
}
