private void InitOrg() { OrganizationBLL bll = new OrganizationBLL(); IList <OrganizationInfo> orgList = bll.GetOrgList(); ddlOrg.Items.Clear(); foreach (OrganizationInfo info in orgList) { ListItem li = new ListItem(); li.Text = info.OrgName; li.Value = info.ID.ToString(); if (li.Value.Equals(OrgCode, StringComparison.OrdinalIgnoreCase)) { li.Selected = true; } ddlOrg.Items.Add(li); } //获取某个组织的信息 OrganizationInfo orgInfo = bll.GetOrgByID(ddlOrg.SelectedValue); if (orgInfo != null) { txtOrderNo.Text = orgInfo.OrderNo.ToString(); txtOrgCode.Text = orgInfo.OrgCode; txtOrgName.Text = orgInfo.OrgName; } }
public Contact() { Name = new NameInfo(); Organization = new OrganizationInfo(); PhoneNumbers = new List <PhoneInfo>(); EmailAddresses = new List <EmailInfo>(); }
public ActionResult ExitOrganization() { if (userInfo == null) { return(Content("您尚未登陆")); } else if (userInfo.Organization == null) { return(Content("您尚未加入任何组织")); } else { OrganizationInfo organization = userInfo.Organization; userInfo.Organization = null; userInfo.UserAuth = UserAuth.User; ServiceSessionFactory.ServiceSession.UserInfoService.EditEntity(userInfo); if (ServiceSessionFactory.ServiceSession.OrganizationInfoService.OrganizationDelete(organization)) { return(Content("退出成功,且由于您的组织中已无成员,该组织已解散")); } else { return(Content("Success")); } } }
protected void lnkbtnDelete_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtNotes.Text)) { OrganizationInfo o = new OrganizationInfo(OrganizationID); standardstewardshipIds = System.Configuration.ConfigurationManager.AppSettings["StewardshipStandardIDs"]; OrganizationInfo.SetStatus(OrganizationStatus.Deleted, OrganizationID, txtNotes.Text, o.OrganizationTypeId, standardstewardshipIds); Response.Redirect(pageId); lblinfo.Text = "Successfully deleted"; lblinfo.Visible = true; } else { string script = string.Format("alert('{0}');", "Cannot delete please provide notes for deleting."); if (Page != null && !Page.ClientScript.IsClientScriptBlockRegistered("alert")) { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "alert", script, true /* addScriptTags */); } } } catch (Exception ex) { new SqlLog().InsertSqlLog(currentUserInfo.UserId, "viewStakeHolder.lnkbtnDelete_Click", ex); } }
private void UpdateOrganizationLogo(int orgId) { try { string orgName = OrganizationInfo.GetOrgLegalNameByOrgId(orgId); string fileName = string.IsNullOrEmpty(orgName) ? "temp" : orgName + ".jpg"; //Server.HtmlEncode(fUpload.FileName); string RootPath = ConfigurationManager.AppSettings["LogoUploadLocation"]; string Completepath = RootPath + orgId + @"\" + fileName; // Server.MapPath(RootPath + orgId + @"\" + fileName); if (!Directory.Exists(RootPath + orgId)) { Directory.CreateDirectory(RootPath + orgId); } if (System.IO.File.Exists(Completepath)) { System.IO.File.Delete(Completepath); } //fUpload.SaveAs(Completepath); string stt = CreateThumbnail(Completepath, orgName); OrganizationInfo.UpdateOrganizationLogoPath(orgId, orgId + @"/" + stt); } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "RegistrationFormUS.aspx UpdateOrganizationLogo", ex); } }
private void AddOrganizationInfo_FormClosing(object sender, FormClosingEventArgs e) { if (this.DialogResult.Equals(DialogResult.Cancel)) { organizationInfo = null; } }
public long InsertInfo(CompanyInfo info) { OrganizationInfo organinfo = new OrganizationInfo(); organinfo.Fid = Guid.NewGuid(); ///把前台传来的父节点FID赋予ORGANIZATION对象上 organinfo.ParentFid = info.ParentOid; organinfo.Code = info.CCode; organinfo.Name = info.CName; organinfo.ValidFlag = true; organinfo.CreateDate = DateTime.Now; organinfo.CreateUser = info.CreateUser; info.ValidFlag = true; ////再把ORGANIZATION对象与COMPANY对象以OID做关联 info.Oid = organinfo.Fid; using (var trans = new TransactionScope()) { if (new OrganizationDAL().Add(organinfo) == 0) { throw new Exception("ORGANIZATION ADD FAIL"); } info.Id = dal.Add(info); if (info.Id == 0) { throw new Exception("COMPANY ADD FAIL"); } trans.Complete(); } return(info.Id); }
private void LoadStakeholders() { try { pageSize = Convert.ToInt32(ddlPageSize.SelectedValue); gvApplicationApproved.PageSize = pageSize; int OrganizationId = Convert.ToInt32(Request.QueryString["OrganizationId"]); int OrganizationTypeId = Convert.ToInt32(Request.QueryString["OrganizationTypeId"]); string StakeholderName = txtStakeholderName.Text.Trim(); string DBAName = txtDBAName.Text.Trim(); string ContactName = txtPrimaryCotnact.Text.Trim(); string ZIPCode = txtZipCode.Text.Trim(); DateTime CreatedFromDate = txtCreatedFromDate.Text.Trim() == "" ? DateTime.MinValue : Convert.ToDateTime(txtCreatedFromDate.Text, System.Globalization.CultureInfo.InvariantCulture); DateTime CreatedToDate = txtCreatedToDate.Text.Trim() == "" ? DateTime.MinValue : Convert.ToDateTime(txtCreatedToDate.Text, System.Globalization.CultureInfo.InvariantCulture); DataSet ds; ds = OrganizationInfo.SearchStakeholdersByStewardShip(CurPageNum, pageSize, out totalRows, OrganizationId, OrganizationTypeId, true, StakeholderName, DBAName, ContactName, ZIPCode, CreatedFromDate, CreatedToDate, LanguageId); gvApplicationApproved.DataSource = ds; gvApplicationApproved.DataBind(); GridPaging(); } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "Stakeholder/ViewStakeholder", ex); } }
public void getOrganizationUsingDiscovery() { string serviceURL = "https://disco.crm.dynamics.com/XRMServices/2011/Discovery.svc"; string userName = "******"; string password = "******"; OrganizationInfo OrganizationList = GetOrganizations(serviceURL, userName, password); }
protected void gvLatestSteward_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Approve") { OrganizationInfo o = new OrganizationInfo(Convert.ToInt32(e.CommandArgument)); standardIds = System.Configuration.ConfigurationManager.AppSettings["StewardshipStandardIDs"]; OrganizationInfo.SetStatus(OrganizationStatus.Accepted, o.OrganizationId, "Approved from dashboard", o.OrganizationTypeId, standardIds); DataSet ds = UserInfo.getDefaultUsers(o.OrganizationId); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { UserInfo user = new UserInfo(Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"].ToString())); if (!user.IsApproved) { Emails email = new Emails(); email.To = user.Login; email.URL = ConfigurationManager.AppSettings["EmailUrl"].ToString() + "ChangePassword.aspx?userId=" + Encryption.Encrypt(user.UserId.ToString()); email.From = "*****@*****.**"; email.Subject = "Registration Approval Email"; //If thread doesnt works then uncomment the commented area below and comment 2 lines of threading. Thread Email_Thread = new Thread(() => SendEmails(email, Emails.EmailType.ApplicationApprovedEmail.ToString())); Email_Thread.Start(); //SendEmails(email, Emails.EmailType.ApplicationApprovedEmail.ToString()); } } Response.Redirect("/Dashboard/admindashboard.aspx");//,false); //Context.ApplicationInstance.CompleteRequest(); } }
protected void GetProductsByOrgId() { try { chkSelectedProducts.DataSource = Product.GetProductNames(); chkSelectedProducts.DataBind(); DataSet ds = OrganizationInfo.GetProductCategoryByOrgId(UserOrganizationId); if (chkSelectedProducts.Items.Count > 0 && ds != null && ds.Tables[0].Rows.Count > 0) { foreach (ListItem chkbox in chkSelectedProducts.Items) { for (int index = 0; index < ds.Tables[0].Rows.Count; index++) { if (chkbox.Text.ToString().Trim().ToLower() == ds.Tables[0].Rows[index][1].ToString().Trim().ToLower()) { chkbox.Selected = true; } } } } } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "ProductSelection GetProductsByOrgId", ex); } }
protected void lnkbtnDelete_Click(object sender, EventArgs e) { DataSet ds; OrganizationInfo oi = new OrganizationInfo(OrganizationID); string standardstewardshipIds = System.Configuration.ConfigurationManager.AppSettings["StewardshipStandardIDs"]; string[] standanrdIds = standardstewardshipIds.Split(','); foreach (string st in standanrdIds) { ds = OrganizationInfo.SearchStakeholdersByStewardShip(1, 100, out totalRows, OrganizationID, Conversion.ParseInt(st), true, "", "", "", "", DateTime.MinValue, DateTime.MinValue, LanguageId); if (ds.Tables[0].Rows.Count > 0) { gvApplicationApproved.DataSource = ds; gvApplicationApproved.DataBind(); dlg.Visible = true; return; } else if (!string.IsNullOrEmpty(txtNotes.Text)) { dlgcnfdel.Visible = true; } else { string script = string.Format("alert('{0}');", "Cannot delete please provide notes for deleting."); if (Page != null && !Page.ClientScript.IsClientScriptBlockRegistered("function")) { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "function", script, true /* addScriptTags */); } } } }
public static bool Save_Organization(bool isOnlyDelete, OrganizationInfo obj, UserInfo objUserInfo, out string errormsg) { errormsg = ""; flag = false; if (!Validations.ValidateDataType(obj.OrganizationCode, Validations.ValueType.AlphaNumericSpecialChar, false, "Organization Code", out errormsg)) { return(false); } if (!Validations.ValidateDataType(obj.OrganizationName, Validations.ValueType.AlphaNumericSpecialChar, false, "Organization Name", out errormsg)) { return(false); } using (DBHelper dbhlper = new DBHelper("spOrganizationsave", true)) { DBHelper.AddPparameter("@OrganizationCode", obj.OrganizationCode, DBHelper.param_types.Varchar); DBHelper.AddPparameter("@OrganizationName", obj.OrganizationName, DBHelper.param_types.Varchar); DBHelper.AddPparameter("@IsActive", (obj.IsActive ? "Y" : "N"), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? 'Y' : 'N'), DBHelper.param_types.Varchar); DBHelper.AddPparameter("@NewDatauniqueID", 0, DBHelper.param_types.BigInt, 50, DBHelper.param_direction.Output); DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output); return(DBHelper.Execute_NonQuery(out errormsg)); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = OrganizationInfo.GetLogoPath(UserOrganizationId); if (dt != null && dt.Rows.Count > 0) { string str = ConfigurationManager.AppSettings["LogoUploadLocation"] + dt.Rows[0]["vchLogoPath"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["vchLogoPath"].ToString())) { str = str.Replace("//", "/"); logoimg.Src = str; } } UserInfo obj = UserInfo.GetCurrentUserInfo(); UserInfo objUser = new UserInfo(obj.UserId); if (objUser.UserProfileImage != null) { profileimage.Src = "data:image/(gif|png|jpeg|jpg);base64," + Convert.ToBase64String(objUser.UserProfileImage); } } GetMenuPermission(); GetOrganizationAndRoleName(); //lblProduct.Text = CatName; }
protected bool GetData() { UserBLL userbll = new UserBLL(); //获取项目信息 model = bll.GetProjectDetailInfo(projectId.Value); if (model == null) { Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx"); return(false); } WXFQUserApplyInfo userApply = bll.WXGetFQUserApplyInfo(projectId.Value.ToText()); if (userApply != null) { Organization = bll.WXGetOrganizationInfo(userApply.OrgId.HasValue ? userApply.OrgId.Value.ToText() : ""); } //项目展示图 imageList = CommUtils.GetProjectImages(this.projectId.Value); finishProcess = CommUtils.GetProjectProcess(model); SubscribeUserCount = CommUtils.GetSubscribeUserCount(this.projectId.Value); //计算预期收益 PreInterestRate = CommUtils.CalcInvestInterest(model, 10000); EbaoMultiple = int.Parse(Math.Ceiling(model.InterestRate.Value / decimal.Parse("2.5")).ToString()); EbaoInterest = CommUtils.GetEbaoMultipleInterest(model, 10000); preSubscribeList = CommUtils.GetPreSubscribeDetail(model, 10000); return(true); }
protected void lnkbtnApprove_Click(object sender, EventArgs e) { lblinfo.Visible = false; standardstewardshipIds = System.Configuration.ConfigurationManager.AppSettings["StewardshipStandardIDs"]; OrganizationInfo o = new OrganizationInfo(OrganizationID); OrganizationInfo.SetStatus(OrganizationStatus.Accepted, OrganizationID, txtNotes.Text, o.OrganizationTypeId, standardstewardshipIds); DataSet ds = UserInfo.getDefaultUsers(OrganizationID); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { UserInfo user = new UserInfo(Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"].ToString())); if (!user.IsApproved) { Emails email = new Emails(); email.To = user.Login; email.URL = ConfigurationManager.AppSettings["EmailUrl"].ToString() + "ChangePassword.aspx?userId=" + Encryption.Encrypt(user.UserId.ToString()); email.From = "*****@*****.**"; email.Subject = "Registration Approval Email"; Thread Email_Thread = new Thread(() => SendEmails(email, Emails.EmailType.ApplicationApprovedEmail.ToString())); Email_Thread.Start(); } } Response.Redirect(pageId); lblinfo.Text = "Successfully Approved"; lblinfo.Visible = true; }
/// <summary> /// 取得某个部门信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public OrganizationInfo GetOrgByID(string id) { if (!string.IsNullOrEmpty(id)) { Guid orgId = new Guid(id); if (orgId != null) { DataSet ds = dal.GetOrgByID(orgId); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { OrganizationInfo info = new OrganizationInfo(); info.ID = orgId; info.OrgName = dr["OrgName"].ToString(); info.OrgCode = dr["OrgCode"].ToString(); info.OrgDescription = dr["OrgDescription"].ToString(); info.State = int.Parse(dr["State"].ToString()); info.OrderNo = int.Parse(dr["OrderNo"].ToString()); info.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); info.CreatedBy = dr["CreatedBy"].ToString(); return(info); } } } } return(null); }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, OrganizationInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Organization set "); strSql.Append("OrgCode=@OrgCode,"); strSql.Append("OrgName=@OrgName,"); strSql.Append("Manager=@Manager,"); strSql.Append("AssistantManager=@AssistantManager,"); strSql.Append("InnerPhone=@InnerPhone,"); strSql.Append("OuterPhone=@OuterPhone,"); strSql.Append("Fax=@Fax,"); strSql.Append("Sort=@Sort,"); strSql.Append("Address=@Address,"); strSql.Append("Remark=@Remark,"); strSql.Append("ParentID=@ParentID"); strSql.Append(" where OrgID=@OrgID "); SqlParameter[] parameters = { new SqlParameter("@OrgID", SqlDbType.Int, 4), new SqlParameter("@OrgCode", SqlDbType.VarChar, 50), new SqlParameter("@OrgName", SqlDbType.NVarChar, 50), new SqlParameter("@Manager", SqlDbType.NVarChar, 20), new SqlParameter("@AssistantManager", SqlDbType.NVarChar, 20), new SqlParameter("@InnerPhone", SqlDbType.VarChar, 20), new SqlParameter("@OuterPhone", SqlDbType.VarChar, 20), new SqlParameter("@Fax", SqlDbType.VarChar, 20), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Address", SqlDbType.NVarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ParentID", SqlDbType.Int, 4) }; parameters[0].Value = model.OrgID; parameters[1].Value = model.OrgCode; parameters[2].Value = model.OrgName; parameters[3].Value = model.Manager; parameters[4].Value = model.AssistantManager; parameters[5].Value = model.InnerPhone; parameters[6].Value = model.OuterPhone; parameters[7].Value = model.Fax; parameters[8].Value = model.Sort; parameters[9].Value = model.Address; parameters[10].Value = model.Remark; parameters[11].Value = model.ParentID; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public static Organization GetOrganizationById(string id) { OrganizationInfo orgInfo = OrganizationInfoRepo .Read() .FirstOrDefault(org => org.Id == id); return(orgInfo.MappingTo <Organization>()); }
public void UpdatePlayer(int index, OrganizationInfo newOrganization) { players[index] = new NewGamePlayerInfo( players[index].Name, players[index].Color, newOrganization, players[index].ControlType); }
private void InitOrganization() { _organization = new OrganizationInfo { Company = "Smith Co.", JobTitle = "CEO" }; }
public async void OrganizationInfo_TestGetById() { var organizationInfo = await OrganizationInfo.GetOrganizationInfo(1); Assert.NotNull(organizationInfo); Assert.IsType<OrganizationInfo>(organizationInfo); Assert.Equal(1, organizationInfo.Id); }
public Contact(NameInfo nameInfo, OrganizationInfo organizationInfo, List <PhoneInfo> phoneNumbers, List <EmailInfo> emailAddresses) { Name = nameInfo; Organization = organizationInfo; PhoneNumbers = phoneNumbers; EmailAddresses = emailAddresses; }
/// <summary> /// 获得一个组织 /// </summary> /// <param name="code"></param> /// <returns></returns> public static Organization GetOrganization(string code) { OrganizationInfo orgInfo = OrganizationInfoRepo .Read() .FirstOrDefault(org => org.Code == code); return(orgInfo.MappingTo <Organization>()); }
protected void gvApplicationApproved_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteStakeholder") { OrganizationInfo.ApprovedStakeholderInActive(Convert.ToInt32(e.CommandArgument)); LoadStakeholders(); } }
public List <OrganizationInfo> GetOrganizationByCondition(string sqlWhere) { List <OrganizationInfo> organizationInfos = new List <OrganizationInfo>(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetOrganizations")) { if (!string.IsNullOrEmpty(sqlWhere)) { cmd.CommandText = cmd.CommandText + " " + sqlWhere; } using (IDataReader dr = cmd.ExecuteDataReader()) { while (dr.Read()) { OrganizationInfo model = new OrganizationInfo(); if (!Convert.IsDBNull(dr["OrganizationId"])) { model.OrganizationId = Convert.ToInt32(dr["OrganizationId"]); } if (!Convert.IsDBNull(dr["FullName"])) { model.FullName = dr["FullName"].ToString(); } if (!Convert.IsDBNull(dr["ShortName"])) { model.ShortName = dr["ShortName"].ToString(); } if (!Convert.IsDBNull(dr["Code"])) { model.Code = dr["Code"].ToString(); } if (!Convert.IsDBNull(dr["ParentId"])) { model.ParentId = Convert.ToInt32(dr["ParentId"]); } if (!Convert.IsDBNull(dr["CorporateRepresentative"])) { model.CorporateRepresentative = dr["CorporateRepresentative"].ToString(); } if (!Convert.IsDBNull(dr["Enabled"])) { model.Enabled = (bool)dr["Enabled"]; } if (!Convert.IsDBNull(dr["SortCode"])) { model.SortCode = Convert.ToInt32(dr["SortCode"]); } if (!Convert.IsDBNull(dr["Description"])) { model.Description = dr["Description"].ToString(); } organizationInfos.Add(model); } } } return(organizationInfos); }
protected void Page_Load(object sender, EventArgs e) { try { if (!this.IsPostBack) { //获取父id string parentId = Request.QueryString["parentId"]; if (!string.IsNullOrEmpty(parentId)) { this.hidParentId.Value = parentId; } else { YMessageBox.show(this, "未设置父菜单id失败!"); } //获取id string strId = Request.QueryString["id"]; if (!string.IsNullOrEmpty(strId)) { this.hidOrgId.Value = strId; //获取配置文件路径。 string configFile = AppDomain.CurrentDomain.BaseDirectory.ToString() + SystemConfig.databaseConfigFileName; //创建操作对象 OrgOperater orgOper = OrgOperater.createOrgOperater(configFile, SystemConfig.databaseConfigNodeName, SystemConfig.configFileKey); if (orgOper != null) { //获取机构信息 OrganizationInfo org = orgOper.getOrganization(Convert.ToInt32(strId)); if (org != null) { this.txtOrgName.Value = org.name; this.txtOrgOrder.Value = org.order.ToString(); } else { YMessageBox.show(this, "获取机构信息失败!错误信息[" + orgOper.errorMessage + "]"); return; } } else { YMessageBox.show(this, "创建数据库操作对象失败!"); return; } } } } catch (Exception ex) { YMessageBox.show(this, "程序运行出错!错误信息[" + ex.Message + "]"); } }
private static OrganizationInfo GetContainerOrganizationInfo(this Item item) { var organizationInfo = new OrganizationInfo(); var containerOrganizationInfo = item.Container.GetOrganizationInfo(); organizationInfo.AddRange(containerOrganizationInfo.Select(node => new OrganizationInfo.Node(node.ItemInfo, node.RelativePath))); organizationInfo.Last().RelativePath = "./"; return(organizationInfo); }
internal static Organization Resolve(OrganizationInfo selection, Random rng) { if (selection == null) { return(PlayerAssets.OrganizationsRaw[rng.Next(PlayerAssets.OrganizationsRaw.Length)]); } return(selection.Data); }
public List<OrganizationInfo> GetOrganizationByCondition(string sqlWhere) { List<OrganizationInfo> organizationInfos = new List<OrganizationInfo>(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetOrganizations")) { if (!string.IsNullOrEmpty(sqlWhere)) { cmd.CommandText = cmd.CommandText + " " + sqlWhere; } using(IDataReader dr=cmd.ExecuteDataReader()) { while (dr.Read()) { OrganizationInfo model = new OrganizationInfo(); if (!Convert.IsDBNull(dr["OrganizationId"])) { model.OrganizationId = Convert.ToInt32(dr["OrganizationId"]); } if (!Convert.IsDBNull(dr["FullName"])) { model.FullName = dr["FullName"].ToString(); } if (!Convert.IsDBNull(dr["ShortName"])) { model.ShortName = dr["ShortName"].ToString(); } if (!Convert.IsDBNull(dr["Code"])) { model.Code = dr["Code"].ToString(); } if (!Convert.IsDBNull(dr["ParentId"])) { model.ParentId = Convert.ToInt32(dr["ParentId"]); } if (!Convert.IsDBNull(dr["CorporateRepresentative"])) { model.CorporateRepresentative = dr["CorporateRepresentative"].ToString(); } if (!Convert.IsDBNull(dr["Enabled"])) { model.Enabled = (bool)dr["Enabled"]; } if (!Convert.IsDBNull(dr["SortCode"])) { model.SortCode = Convert.ToInt32(dr["SortCode"]); } if (!Convert.IsDBNull(dr["Description"])) { model.Description = dr["Description"].ToString(); } organizationInfos.Add(model); } } } return organizationInfos; }
protected void btndelYes_Click(object sender, EventArgs e) { OrganizationInfo o = new OrganizationInfo(OrganizationID); OrganizationInfo.SetStatus(OrganizationStatus.Deleted, OrganizationID, txtNotes.Text, o.OrganizationTypeId, standardstewardshipIds); Response.Redirect(pageId); lblinfo.Text = "Successfully deleted"; lblinfo.Visible = true; dlgcnfdel.Visible = false; }
public OrganizationInfo GetOrganizationById(int id) { OrganizationInfo model = new OrganizationInfo(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetOrganizationById")) { cmd.SetParameterValue("@OrganizationId", id); using (IDataReader dr = cmd.ExecuteDataReader()) { if (!Convert.IsDBNull(dr["OrganizationId"])) { model.OrganizationId = Convert.ToInt32(dr["OrganizationId"]) ; } if (!Convert.IsDBNull(dr["FullName"])) { model.FullName = dr["FullName"].ToString(); } if (!Convert.IsDBNull(dr["ShortName"])) { model.ShortName = dr["ShortName"].ToString(); } if (!Convert.IsDBNull(dr["Code"])) { model.Code = dr["Code"].ToString(); } if (!Convert.IsDBNull(dr["ParentId"])) { model.ParentId = Convert.ToInt32(dr["ParentId"]) ; } if (!Convert.IsDBNull(dr["CorporateRepresentative"])) { model.CorporateRepresentative = dr["CorporateRepresentative"].ToString(); } if (!Convert.IsDBNull(dr["Enabled"])) { model.Enabled = (bool)dr["Enabled"]; } if (!Convert.IsDBNull(dr["SortCode"])) { model.SortCode = Convert.ToInt32(dr["SortCode"]) ; } if (!Convert.IsDBNull(dr["Description"])) { model.Description = dr["Description"].ToString(); } } } return model; }
public int Update(OrganizationInfo model) { throw new NotImplementedException(); }
public int Insert(OrganizationInfo model) { using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertOrganization")) { cmd.SetParameterValue("@OrganizationId", model.OrganizationId); cmd.SetParameterValue("@FullName", model.FullName); cmd.SetParameterValue("@ShortName", model.ShortName); cmd.SetParameterValue("@Code", model.Code); cmd.SetParameterValue("@ParentId", model.ParentId); cmd.SetParameterValue("@CorporateRepresentative", model.CorporateRepresentative); cmd.SetParameterValue("@Enabled", model.Enabled); cmd.SetParameterValue("@SortCode", model.SortCode); cmd.SetParameterValue("@Description", model.Description); return cmd.ExecuteNonQuery(); } }
public int Insert(OrganizationInfo model) { return _dataAccess.Insert(model); }