public HttpResponseMessage GetPhoneBook(PhoneBookModel phoneBook)
{
var principal = Thread.CurrentPrincipal;
List <PhoneBookResponseModel> lstGroups = new List <PhoneBookResponseModel>();
PhoneBookResponseModel group;
if (principal.Identity.IsAuthenticated)
{
Common.User user = ((MyPrincipal)principal).UserDetails;
DataTable dtGroups = Facade.PhoneBook.GetPhoneBookOfUser(user.UserGuid, phoneBook.PhoneBookGuid, string.Empty);
foreach (DataRow row in dtGroups.Rows)
{
group = new PhoneBookResponseModel();
group.PhoneBookGuid = Helper.GetGuid(row["Guid"]);
group.Name = row["Name"].ToString();
lstGroups.Add(group);
}
PhoneBookResponse response = new PhoneBookResponse();
response.IsSuccessful = true;
response.PhoneBooks = lstGroups;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Accepted));
}
}
public Guid InsertAccount(Common.User user)
{
Guid guid = Guid.NewGuid();
try
{
ExecuteSPCommand("InsertAccount",
"@Guid", guid,
"@UserName", user.UserName,
"@Password", user.Password,
"@ParentGuid", user.ParentGuid,
"@RoleGuid", user.RoleGuid,
"@PriceGroupGuid", user.PriceGroupGuid,
"@IsFixPriceGroup", user.IsFixPriceGroup,
"@IsAdmin", user.IsAdmin,
"@IsActive", user.IsActive,
"@ExpireDate", user.ExpireDate,
"@MaximumAdmin", user.MaximumAdmin,
"@MaximumUser", user.MaximumUser,
"@MaximumEmailAddress", user.MaximumEmailAddress,
"@MaximumPhoneNumber", user.MaximumPhoneNumber,
"@PanelPrice", user.PanelPrice,
"@DomainGuid", user.DomainGuid);
return(guid);
}
catch
{
guid = Guid.Empty;
return(guid);
}
}
public DataTable gridAgentRatio_OnDataBind(string sortField, string searchFiletrs, string toolbarFilters, string userData, int pageNo, int pageSize, ref int resultCount, ref string customData)
{
string agentGuid = string.Empty;
string agentTitle = string.Empty;
decimal ratio;
List <DataRow> lstAgents = Facade.SmsSenderAgent.GetUserAgents(Facade.SmsSenderAgent.GetFirstParentMainAdmin(UserGuid)).AsEnumerable().ToList();
DataTable dtAgentRatio = new DataTable();
dtAgentRatio.Columns.Add("Guid", typeof(Guid));
dtAgentRatio.Columns.Add("Price", typeof(string));
dtAgentRatio.Columns.Add("AgentID", typeof(string));
dtAgentRatio.Columns.Add("Agent", typeof(string));
dtAgentRatio.Columns.Add("Ratio", typeof(decimal));
Common.User user = Facade.User.LoadUser(UserGuid);
Common.GroupPrice groupPrice = Facade.GroupPrice.LoadGroupPrice(user.PriceGroupGuid);
string price = Helper.FormatDecimalForDisplay(groupPrice.BasePrice);
var xelement = XElement.Parse(groupPrice.AgentRatio);
List <XElement> lstOperatorElement = xelement.Elements("Table").ToList();
foreach (var item in lstOperatorElement)
{
agentGuid = item.Element("AgentID").Value;
agentTitle = lstAgents.Where(agent => Helper.GetGuid(agent["Guid"]) == Helper.GetGuid(agentGuid)).First()["Name"].ToString();
ratio = Helper.GetDecimal(item.Element("Ratio").Value);
dtAgentRatio.Rows.Add(Guid.NewGuid(), price, agentGuid, agentTitle, ratio);
}
return(dtAgentRatio);
}
public HttpResponseMessage CheckUserLoginInfo()
{
var principal = Thread.CurrentPrincipal;
if (principal.Identity.IsAuthenticated)
{
Common.User user = ((MyPrincipal)principal).UserDetails;
UserInfoResponse userInfo = new UserInfoResponse();
userInfo.IsSuccessful = true;
userInfo.Credit = user.Credit;
userInfo.FirstName = user.FirstName;
userInfo.LastName = user.LastName;
userInfo.Mobile = user.Mobile;
userInfo.Email = user.Email;
userInfo.ExpireDate = user.ExpireDate;
userInfo.Domain = user.DomainGuid.ToString();
return(Request.CreateResponse(HttpStatusCode.OK, userInfo));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Accepted));
}
}
public Guid RegisterUser(Common.User user)
{
Guid guid = Guid.NewGuid();
try
{
ExecuteSPCommand("RegisterUser",
"@Guid", guid,
"@Type", user.Type,
"@UserName", user.UserName,
"@Password", user.Password,
"@Email", user.Email,
"@Mobile", user.Mobile,
"@ParentGuid", user.ParentGuid,
"@RoleGuid", user.RoleGuid,
"@PriceGroupGuid", user.PriceGroupGuid,
"@IsFixPriceGroup", user.IsFixPriceGroup,
"@IsAdmin", user.IsAdmin,
"@IsActive", user.IsActive,
"@ExpireDate", user.ExpireDate,
"@MaximumAdmin", user.MaximumAdmin,
"@MaximumUser", user.MaximumUser,
"@PanelPrice", user.PanelPrice,
"@DomainGuid", user.DomainGuid);
return(guid);
}
catch
{
guid = Guid.Empty;
return(guid);
}
}
private void ConfirmUser(Common.User user, bool autoLogin)
{
if (user.IsActive == true)
{
if (chkRemaindMe.Checked)
{
HttpCookie cooky = new HttpCookie("UserName", user.UserName);
cooky.Expires = DateTime.Now.AddYears(1);
Response.Cookies.Add(cooky);
}
else
{
Response.Cookies.Remove("UserName");
}
Session["UserGuid"] = user.UserGuid;
Session["IsAdmin"] = user.IsAdmin;
Session["IsSuperAdmin"] = user.IsSuperAdmin;
Session["IsMainAdmin"] = user.IsMainAdmin;
Session["ParentGuid"] = user.ParentGuid;
Session["ExpireDate"] = user.ExpireDate;
Session.Remove("SessionExpired");
Session.Remove("ChallengeString");
CheckDomain();
}
else if (!autoLogin)
{
lblError.Text = Language.GetString("UserIsNotActive");
}
}
public async Task <ActionResult> AddUser(Common.User newUser)
{
if (newUser == null)
{
return new ActionResult {
IsSucceeded = false, Message = "Null object received."
}
}
;
var res = new ActionResult();
using (var db = new DBEntities())
{
try
{
db.Users.Add(newUser.ToUser());
await db.SaveChangesAsync();
res.IsSucceeded = true;
}
catch (Exception ex)
{
res.IsSucceeded = false;
res.Message = ex.Message;
res.ErrorMetadata = ex.StackTrace;
}
}
return(res);
}
public static string GetEmailBookOfUser(Guid userGuid, bool showEmailCount, bool showCheckBox)
{
Business.EmailBook emailBookController = new Business.EmailBook();
string tree = string.Empty;
Common.User user = Facade.User.LoadUser(userGuid);
bool isAdmin = Helper.GetBool(user.IsAdmin.ToString());
DataTable dataTableEmailBookUser = emailBookController.GetEmailBookUser(isAdmin, user.UserGuid, user.ParentGuid);
DataTable dataTableRoot = emailBookController.GetRoot();
if (dataTableRoot.Rows.Count == 0)
return string.Empty;
Guid rootGuid = Helper.GetGuid(dataTableRoot.Rows[0]["Guid"].ToString());
tree += "<div class='myList'><ul class='browser filetree'>";
tree += string.Format("<li><span class='root folder' guid='{0}'>{1}{2}</span><ul id='child'>",
Guid.Empty,
showCheckBox ? "<input onclick='checkBoxControlChecked(this);' type='checkbox'/>" : string.Empty,
dataTableRoot.Rows[0]["Name"].ToString());
GenerateTree(dataTableEmailBookUser, rootGuid, showEmailCount, showCheckBox, ref tree);
tree += "</ul></li></ul></div>";
return tree;
}
public static DataTable GetEmailBookOfUser(Guid userGuid)
{
Business.EmailBook emailBookController = new Business.EmailBook();
Common.User user = Facade.User.LoadUser(userGuid);
bool isAdmin = Helper.GetBool(user.IsAdmin.ToString());
return emailBookController.GetEmailBookUser(isAdmin, user.UserGuid, user.ParentGuid);
}
//public static Dictionary<Operators, int> GetCountUserNumberOfOperators(Guid parentGuid)
//{
// Business.User userController = new Business.User();
// DataTable dtSmsInfo = userController.GetCountUserNumberOfOperators(parentGuid);
// Dictionary<Business.Operators, int> operatorCountNumberDictionary = new Dictionary<Business.Operators, int>();
// foreach (DataRow dataRow in dtSmsInfo.Rows)
// {
// switch (Helper.GetInt(dataRow["Operator"]))
// {
// case (int)Business.Operators.MCI:
// operatorCountNumberDictionary.Add(Business.Operators.MCI, Helper.GetInt(dataRow["Count"]));
// break;
// case (int)Business.Operators.MTN:
// operatorCountNumberDictionary.Add(Business.Operators.MTN, Helper.GetInt(dataRow["Count"]));
// break;
// case (int)Business.Operators.Rightel:
// operatorCountNumberDictionary.Add(Business.Operators.Rightel, Helper.GetInt(dataRow["Count"]));
// break;
// }
// }
// return operatorCountNumberDictionary;
//}
//public static Dictionary<Operators, int> GetCountRoleNumberOfOperators(Guid userGuid, Guid roleGuid)
//{
// Business.User userController = new Business.User();
// DataTable dtSmsInfo = userController.GetCountRoleNumberOfOperators(roleGuid, userGuid);
// Dictionary<Business.Operators, int> operatorCountNumberDictionary = new Dictionary<Business.Operators, int>();
// foreach (DataRow dataRow in dtSmsInfo.Rows)
// {
// switch (Helper.GetInt(dataRow["Operator"]))
// {
// case (int)Business.Operators.MCI:
// operatorCountNumberDictionary.Add(Business.Operators.MCI, Helper.GetInt(dataRow["Count"]));
// break;
// case (int)Business.Operators.MTN:
// operatorCountNumberDictionary.Add(Business.Operators.MTN, Helper.GetInt(dataRow["Count"]));
// break;
// case (int)Business.Operators.Rightel:
// operatorCountNumberDictionary.Add(Business.Operators.Rightel, Helper.GetInt(dataRow["Count"]));
// break;
// }
// }
// return operatorCountNumberDictionary;
//}
#endregion
public static Common.User LoadUser(Guid userGuid)
{
Business.User userController = new Business.User();
Common.User commonUser = new Common.User();
userController.Load(userGuid, commonUser);
return(commonUser);
}
private static void setValue <T>(string key, T i, Common.User u = null)
{
List <Models.ParameterMaster> lstParam = new List <Models.ParameterMaster>();
key = GetKey(key, u);
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
if (KeyExist(key, lstParam))
{
if (i == null)
{
Common.GyomuDataAccess.DeleteParameter(key);
}
else
{
string strVal = i.ToString();
Common.GyomuDataAccess.UpdateParameter(key, strVal);
}
}
else
{
if (i != null)
{
string strVal = i.ToString();
Common.GyomuDataAccess.InsertParameter(key, strVal);
}
}
scope.Complete();
}
}
public static void DecreaseCostOfSmsSend(Guid userGuid, Common.SmsSendType smsSendType, decimal price, string description, Guid smsSentGuid, DataAccessBase dataAccessBase)
{
Business.Transaction transactionController = new Business.Transaction(dataAccessBase);
Business.User userController = new Business.User(dataAccessBase);
Common.User user = new Common.User();
lock (lockDecreaseCostOfSmsSend)
{
transactionController.BeginTransaction();
try
{
userController.Load(userGuid, user);
if (price > user.Credit)
{
throw new UserCreditNotEnoughException();
}
Decrease(userGuid, price, GetTypeCreditChanges(smsSendType), description, smsSentGuid, transactionController.DataAccessProvider);
transactionController.CommitTransaction();
}
catch (Exception ex)
{
transactionController.RollbackTransaction();
throw new InnerTransactionException(ex);
}
}
}
public bool UpdateProfile(Common.User user)
{
return(base.ExecuteSPCommand("UpdateProfile",
"@Guid", user.UserGuid,
"@FirstName", user.FirstName,
"@LastName", user.LastName,
"@FatherName", user.FatherName,
"@NationalCode", user.NationalCode,
"@ShCode", user.ShCode,
"@Email", user.Email,
"@Phone", user.Phone,
"@Mobile", user.Mobile,
"@FaxNumber", user.FaxNumber,
"@Address", user.Address,
"@ZoneGuid", user.ZoneGuid,
"@BirthDate", Helper.GetDateTimeForDB(user.BirthDate),
"@ZipCode", user.ZipCode,
"@Type", user.Type,
"@CompanyName", user.CompanyName,
"@CompanyNationalId", user.CompanyNationalId,
"@EconomicCode", user.EconomicCode,
"@CompanyCEOName", user.CompanyCEOName,
"@CompanyCEONationalCode", user.CompanyCEONationalCode,
"@CompanyCEOMobile", user.CompanyCEOMobile,
"@CompanyPhone", user.CompanyPhone,
"@CompanyZipCode", user.CompanyZipCode,
"@CompanyAddress", user.CompanyAddress));
}
public static void SetStringValueWithUserEncryption(string key, string v, Common.User u)
{
string root_key = GetStringValue(GetKey(USER_ROOTKEY, u));
string user_key = Common.UserEncryption.Decrypt(root_key);
string crypted = Common.AESEncryption.AESEncrypt(v, user_key);
setValue <string>(key, crypted, u);
}
public IActionResult Test([FromBody] NewProject project)
{
Common.IUser user1 = new Common.User();
user1.firstName = "Tom";
user1.lastName = "Memanee";
_logger.LogCritical(user1.ToString());
return(Json(user1));
}
public void AddUser(Common.User user)
{
if (user == null)
{
throw new ArgumentException("user");
}
users.Add(user);
}
public void UpdateUser(Common.User user, int id)
{
int index = users.FindIndex(item => item.ID == id);
users[index].LastName = user.LastName;
users[index].FirstName = user.FirstName;
users[index].DateOfBirthDay = user.DateOfBirthDay;
}
protected void btnPayment_Click(object sender, EventArgs e)
{
Common.Fish fish = new Common.Fish();
string result = string.Empty;
try
{
Common.AccountInformation accountInfo = Facade.AccountInformation.LoadAccountInformation(Helper.GetGuid(hdnAccountGuid.Value));
Common.User parent = Facade.User.LoadUser(Facade.User.GetGuidOfParent(Guid.Empty, DomainName));
switch (accountInfo.Bank)
{
case (int)Banks.Mellat:
BehPardakhtMellat behPardakht = new BehPardakhtMellat();
if (Helper.CheckDataConditions(accountInfo.TerminalID).IsEmpty ||
Helper.CheckDataConditions(accountInfo.UserName).IsEmpty ||
Helper.CheckDataConditions(accountInfo.Password).IsEmpty)
{
throw new Exception(Language.GetString("OnlineGatewayInfoIncorrect"));
}
behPardakht.TerminalID = Helper.GetLong(accountInfo.TerminalID);
behPardakht.UserName = accountInfo.UserName;
behPardakht.Password = accountInfo.Password;
behPardakht.Amount = Helper.GetLong(txtPanelPrice.Text);
behPardakht.CallBackUrl = string.Format("{0}/{1}/{2}/{3}/", "http://" + Helper.GetLocalDomain(Request.Url.Authority), "SalePackage", PackageId, (int)Business.Banks.Mellat);
string refID = behPardakht.Request(ref result);
if (Helper.CheckDataConditions(refID).IsEmpty)
{
throw new Exception(Language.GetString("DontAccessToOnlineGateway"));
}
#region InsertFish
fish.ReferenceID = refID;
fish.CreateDate = DateTime.Now;
fish.PaymentDate = DateTime.Now;
fish.SmsCount = 0;
fish.Amount = Helper.GetDecimal(txtPanelPrice.Text);
fish.OrderID = behPardakht.OrderID.ToString();
fish.Type = (int)Business.TypeFish.OnLine;
fish.Status = (int)Business.FishStatus.Checking;
fish.AccountInformationGuid = accountInfo.AccountInfoGuid;
fish.UserGuid = UserGuid;
Facade.Fish.InsertOnlinePayment(fish);
#endregion
Page.ClientScript.RegisterClientScriptBlock(typeof(string), "behpardakht", string.Format("<script language=javascript type='text/javascript'>$(function(){{{0}}});</script>", behPardakht.GotoGateway(refID)));
break;
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltrUserName.Text = Facade.User.GetUserNameAndFamily(UserGuid);
Common.User user = Facade.User.LoadUser(UserGuid);
int panelFullDays = user.ExpireDate.Subtract(user.CreateDate).Days;
int panelRemainingDays = user.ExpireDate.Subtract(DateTime.Now).Days;
panelExpireDays = string.Format("[{0},{1}]", panelRemainingDays, panelFullDays);
}
private void InitializePage()
{
btnPayment.Text = Language.GetString(btnPayment.Text);
Common.User user = Facade.User.LoadUser(UserGuid);
txtPanelPrice.Text = Helper.FormatDecimalForDisplay(user.PanelPrice);
txtPanelPrice.Enabled = false;
}
/// <summary>
/// 删除用户记录（删除用户时使用）
/// </summary>
/// <param name="userId">被删除用户</param>
/// <param name="takeOver">接管用户</param>
/// <param name="takeOverAll">是否接管被删除用户的所有内容</param>
public void DeleteUser(long userId, Common.User takeOver, bool takeOverAll)
{
List <Sql> sqls = new List <Sql>();
if (takeOver != null)
{
//更改群主
sqls.Add(Sql.Builder.Append("update spb_Groups set UserId = @0 where UserId = @1", takeOver.UserId, userId));
//获取用户Id为userId创建的群组
Sql havedGroups = Sql.Builder;
havedGroups.Select("GroupId")
.From("spb_Groups")
.Where("UserId = @0", userId);
IEnumerable <long> groupIds = CreateDAO().Fetch <long>(havedGroups);
//获取我加入用户Id为userId创建的群组的群组ID
if (groupIds.Count() > 0)
{
Sql joinedGroups = Sql.Builder;
joinedGroups.Select("GroupId")
.From("spb_GroupMembers")
.Where("UserId = @userId and GroupId in (@groupIds)", new { userId = takeOver.UserId }, new { groupIds = groupIds });
IEnumerable <long> joinedIds = CreateDAO().Fetch <long>(joinedGroups);
sqls.Add(Sql.Builder.Append("delete from spb_GroupMembers where UserId = (@userId) and GroupId in (@groupIds)", new { userId = takeOver.UserId }, new { groupIds = groupIds }));
sqls.Add(Sql.Builder.Append("delete from spb_GroupMemberApplies where UserId = (@userId) and GroupId in (@groupIds)", new { userId = takeOver.UserId }, new { groupIds = groupIds }));
if (joinedIds.Count() > 0)
{
sqls.Add(Sql.Builder.Append("update spb_Groups set MemberCount = MemberCount - 1 where GroupId in(@joinedIds)", new { joinedIds = joinedIds }));
}
}
//此选项尚未用到
if (takeOverAll)
{
}
}
//获取用户ID为userId加入的群组
Sql userJoinedGroups = Sql.Builder;
userJoinedGroups.Select("GroupId")
.From("spb_GroupMembers")
.Where("UserId = @userId", new { userId = userId });
IEnumerable <long> userJoinedIds = CreateDAO().Fetch <long>(userJoinedGroups);
sqls.Add(Sql.Builder.Append("delete from spb_GroupMembers where UserId = @0", userId));
sqls.Add(Sql.Builder.Append("delete from spb_GroupMemberApplies where UserId = @0", userId));
if (userJoinedIds.Count() > 0)
{
sqls.Add(Sql.Builder.Append("update spb_Groups set MemberCount = MemberCount - 1 where GroupId in(@userJoinedIds)", new { userJoinedIds = userJoinedIds }));
}
CreateDAO().Execute(sqls);
}
public static void RemoveUser(Common.User user)
{
User u = Mapper.CastUser(user);
using (dbRamotEntities db = new dbRamotEntities())
{
db.User.Remove(u);
db.SaveChanges();
}
}
public static void UpdateUser(Common.User user)
{
User u = Mapper.CastUser(user);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <User>(db.Set <User>().Find(u.Id)).CurrentValues.SetValues(u);
db.SaveChanges();
}
}
public bool ValidateUserPassword(string username, string password)
{
Common.User user =
new Common.User()
{
username = username,
password = password
};
return(this.BLL.ValidateUserPassword(user));
}
//פונקציה השומרת פרטי משתמש חדש במערכת
public int saveNewUser(Common.User u)
{
var dalUser = Converters.ConvertToDal.US(u);
var res = save.saveNewUser(dalUser);
string subject = " תודה רבה שנרשמתם ל TakeABow ";
string message = "השם משתמש שלך באפלקציה שלנו הוא: " + dalUser.Id.ToString();
new MailManager().SendEmail(u.Email, subject, message);
return(res);
}
public static string GetAdminAESEncryptStringValue(string key, Common.User u)
{
string aes_key = getAdminAESKey(u);
string encrypted = GetStringValue(key);
if (string.IsNullOrEmpty(encrypted))
{
return(null);
}
return(Common.AESEncryption.AESDecrypt(encrypted, aes_key));
}
public async Task <IHttpActionResult> Put([FromBody] Common.User user)
{
var res = await DataFacade.Current.AddUser(user);
if (!res.IsSucceeded)
{
//TODO: Log in file if is ON
return(StatusCode(HttpStatusCode.InternalServerError));
}
return(Ok(res));
}
public UserForm(Common.User user)
{
InitializeComponent();
if (user != null)
{
UserID = user.ID;
FirstName_textBox.Text = user.FirstName;
LastName_textbox.Text = user.LastName;
birthdate_MaskedTextBox.Text = user.Birthday.ToString();
}
this.Text = "Change User";
}
/// <summary>
/// 指定用户接管当前用户的问题
/// </summary>
/// <param name="userId">当前用户id</param>
/// <param name="takeOverUser">指定用户</param>
public void TakeOver(long userId, Common.User takeOverUser)
{
List <Sql> sqls = new List <Sql>();
//更新问题的作者
sqls.Add(Sql.Builder.Append("update spb_AskQuestions set UserId=@0,Author=@1,LastModifier=@2 where UserId=@3", takeOverUser.UserId, takeOverUser.DisplayName, takeOverUser.DisplayName, userId));
//更新最后回答用户
sqls.Add(Sql.Builder.Append("update spb_AskQuestions set LastAnswerUserId=@0,LastAnswerAuthor=@1 where LastAnswerUserId=@2", takeOverUser.UserId, takeOverUser.DisplayName, userId));
CreateDAO().Execute(sqls);
}
public static bool AdvanceUpdate(Common.User user)
{
try
{
Business.User userController = new Business.User();
return(userController.AdvanceUpdate(user));
}
catch (Exception ex)
{
throw ex;
}
}
static RepositoryContainer()
{
Common.GameState fakeGame = new Common.GameState() {
BlackGamer = Guid.Parse("{6FD1D512-A178-4ED8-AC24-B98B2C2EE5ED}"),
WhiteGamer = Guid.Parse("{9D3C6BEB-08D5-458D-82DA-1046EC616BC7}"),
GameId = Guid.Parse("{46BF4054-2274-4F8D-950C-08E25A08899C}")
};
games.StartGame(fakeGame);
Common.User fakeUser = new Common.User() {
Login = "******",
Name = "Name",
Password = "******",
userId = Guid.NewGuid()
};
users.UserRegister(fakeUser);
}
public string CheckUser(string userName, string password)
{
if (CheckUserLogIn(userName, password))
{
string token = CreateToken();
Common.User user = new Common.User(userName, password);
string json = Newtonsoft.Json.JsonConvert.SerializeObject(user);
CacheManager.CacheInsert(token, json);
return token;
}
return string.Empty;
}
