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