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