//Add New Supplier to Database
public Boolean AddNewUser(System_Users user)
{
Boolean insert;
try
{
insert = false;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_InsertNewUser", conn))
{
cmd.CommandTimeout = 200;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = user.UserName;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = user.Phone;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = user.Address;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = user.Email;
cmd.Parameters.Add("@Role", SqlDbType.NVarChar).Value = user.Role;
cmd.ExecuteNonQuery();
insert = true;
}
}
}
catch (SqlException ex)
{
throw new Exception("SQL Error : " + ex.Message);
}
return(insert);
}
//Update Supplier status
public Boolean DeleteSelectedUser(System_Users user)
{
Boolean update;
try
{
update = false;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_UpdateUserStatusById", conn))
{
cmd.CommandTimeout = 200;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = user.UserID;
cmd.ExecuteNonQuery();
update = true;
}
}
}
catch (SqlException ex)
{
throw new Exception("SQL Error : " + ex.Message);
}
return(update);
}
public async Task <IHttpActionResult> PostSystem_Users(System_Users system_Users)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.System_Users.Add(system_Users);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (System_UsersExists(system_Users.Username))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = system_Users.Username }, system_Users));
}
//-------------------------------------------------------------------------------------------
protected void UserInfoNext_Click(object sender, EventArgs e)
{
Page.Validate("RegisterInfo");
if (Page.IsValid)
{
string username = ((TextBox)GetControlFromWizard(UserInfoStep, "UserName")).Text;
string password = ((TextBox)GetControlFromWizard(UserInfoStep, "Password")).Text;
WeavverMembershipProvider provider = (WeavverMembershipProvider)System.Web.Security.Membership.Provider;
System_Users item = provider.GetUser(username);
if (item != null)
{
UsernameTaken();
}
else if (Request.QueryString["checkingout"] == "true")
{
Session["UserPassword"] = password;
CaptchaStepNext_Click(null, e);
}
else
{
Session["UserPassword"] = password;
Title.Text = "Our lord <a href='http://www.reddit.com/r/inglip' target='_blank'>Inglip</a> requires your verification:";
Wizard1.ActiveStepIndex++;
}
ReloadCaptcha();
}
}
public async Task <String> removeuser(String allusernames)
{
ARAVIND_DBEntities records = new ARAVIND_DBEntities();
if (allusernames == null)
{
return("0");
}
else
{
string [] usernames = allusernames.Split('$');
for (int i = 0; i < usernames.Length; i++)
{
if (usernames[i] != null)
{
try
{
string temp = usernames[i];
System_Users user = await records.System_Users.FindAsync(temp);
records.System_Users.Remove(user);
await records.SaveChangesAsync();
}
catch (Exception e)
{
return("1");
}
}
}
return("1");
}
}
public async Task <IHttpActionResult> PutSystem_Users([FromUri] System_Users system_Users)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(system_Users).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!System_UsersExists(system_Users.Username))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <String> DeleteSystem_Users(string allusernames)
{
if (allusernames == null)
{
return("0");
}
else
{
string[] usernames = allusernames.Split('$');
for (int i = 0; i < usernames.Length; i++)
{
if (usernames[i] != null)
{
try
{
string temp = usernames[i];
System_Users user = await db.System_Users.FindAsync(temp);
db.System_Users.Remove(user);
await db.SaveChangesAsync();
}
catch (Exception e)
{
return("1");
}
}
}
return("1");
}
}
public async Task <IHttpActionResult> GetSystem_Users(string id)
{
System_Users system_Users = await db.System_Users.FindAsync(id);
if (system_Users == null)
{
return(NotFound());
}
return(Ok(system_Users));
}
public ActionResult Index(System_Users obj)
{
if (ModelState.IsValid)
{
RegistrationEntities db = new RegistrationEntities();
db.System_Users.Add(obj);
db.SaveChanges();
}
return(View(obj));
}
//Populate GridView
public List <System_Users> GetUsersDetails()
{
List <System_Users> userslist = null;
try
{
userslist = new List <System_Users>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_getAllUsers", conn))
{
cmd.CommandTimeout = 200;
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
System_Users user = new System_Users();
user.Address = (string)dr["Address"];
user.Email = (string)dr["Email"];
user.Phone = (string)dr["Phone"];
user.UserID = (string)dr["UserID"];
user.UserName = (string)dr["UserName"];
user.Role = (string)dr["UserRole"];
userslist.Add(user);
}
dr.Close();
}
}
}
catch (SqlException ex)
{
throw new Exception("SQL Error : " + ex.Message);
}
return(userslist);
}
public async Task <String> adduser(String username, String password, String questionsupdate, String getresults, String newsignup)
{
int flag = 0;
ARAVIND_DBEntities record = new ARAVIND_DBEntities();
System_Users user = new System_Users();
user.Username = username;
user.Password = SHA1.Encode(password);
user.Questions_Update = questionsupdate;
user.View_Results = getresults;
user.New_Signup = newsignup;
try
{
record.System_Users.Add(user);
await record.SaveChangesAsync();
return("1");
}
catch (Exception e)
{
return("0");
}
}
//-------------------------------------------------------------------------------------------
protected void CaptchaStepNext_Click(object sender, EventArgs e)
{
if (Request["checkingout"] == "true" ||
Request["recaptcha_response_field"] == ConfigurationManager.AppSettings["recaptcha_bypasskey"] ||
Weavver.Vendors.Google.reCAPTCHA.Verify(ConfigurationManager.AppSettings["recaptcha_privatekey"],
Request.UserHostAddress,
Request["recaptcha_challenge_field"],
Request["recaptcha_response_field"]))
{
string emailaddress = ((TextBox)GetControlFromWizard(UserInfoStep, "EmailAddress")).Text;
string username = ((TextBox)GetControlFromWizard(UserInfoStep, "UserName")).Text;
string password = ((TextBox)GetControlFromWizard(UserInfoStep, "Password")).Text;
string firstname = ((TextBox)GetControlFromWizard(UserInfoStep, "FirstName")).Text;
string lastname = ((TextBox)GetControlFromWizard(UserInfoStep, "LastName")).Text;
string orgname = ((TextBox)GetControlFromWizard(UserInfoStep, "OrganizationName")).Text;
string referredby = (Session["ReferredBy"] == null) ? null : Session["referredby"].ToString();
WeavverMembershipProvider provider = (WeavverMembershipProvider)System.Web.Security.Membership.Provider;
MembershipCreateStatus status = MembershipCreateStatus.Success;
MembershipUser user = provider.CreateUser(username, Session["UserPassword"].ToString(), emailaddress, "NONE", "", false, Guid.NewGuid(), Request.UserHostAddress, referredby, out status);
if (status == MembershipCreateStatus.Success)
{
using (WeavverEntityContainer data = new WeavverEntityContainer())
{
System_Users newUser = provider.GetUser(username);
Logistics_Organizations newOrg = new Logistics_Organizations();
newOrg.Id = Guid.NewGuid();
newOrg.OrganizationId = new Guid(ConfigurationManager.AppSettings["default_organizationid"]);
newOrg.OrganizationType = OrganizationTypes.Personal.ToString();
newOrg.Name = (!String.IsNullOrEmpty(orgname)) ? orgname : firstname + " " + lastname;
newOrg.EIN = "";
newOrg.Founded = DateTime.UtcNow;
newOrg.Bio = "My bio";
newOrg.CreatedAt = DateTime.UtcNow;
newOrg.CreatedBy = newUser.Id;
newOrg.UpdatedAt = DateTime.UtcNow;
newOrg.UpdatedBy = newUser.Id;
data.Logistics_Organizations.AddObject(newOrg);
data.System_Users.Attach(newUser);
newUser.OrganizationId = newOrg.Id;
newUser.FirstName = firstname;
newUser.LastName = lastname;
int changedRows = data.SaveChanges();
if (changedRows > 0)
{
// add this user as an administrator to their ORG
string oldAppName = Roles.ApplicationName;
Roles.ApplicationName = newOrg.Id.ToString();
Roles.CreateRole("Administrators");
Roles.AddUserToRole(newUser.Username, "Administrators");
Roles.ApplicationName = oldAppName;
}
}
//newOrg.Commit();
MailMessage mNewUser = new MailMessage("*****@*****.**", System.Configuration.ConfigurationManager.AppSettings["admin_address"]);
mNewUser.Subject = "New user";
//mm.Body = CreateUserWizard1.Email;
mNewUser.Body = "User: "******"\r\n"
+ "Created At: " + DateTime.Now.ToString() + "\r\n"
+ "By IP: " + Request.UserHostAddress + "\r\n"
+ "Referred By: " + Session["ReferredBy"];
SmtpClient client2 = new SmtpClient(System.Configuration.ConfigurationManager.AppSettings["smtp_server"]);
client2.Send(mNewUser);
FormsAuthentication.SetAuthCookie(username, true);
if (Request.QueryString["checkingout"] == "true")
{
Response.Redirect("~/workflows/sales_orderplace");
}
else
{
provider.SendUserActivationInstructions(user.UserName, Request.Url.Scheme + "://" + Request.Url.Host);
Wizard1.ActiveStepIndex++;
}
}
else
{
throw new Exception("We could not create your account. Please try again later.");
}
}
else
{
ReloadCaptcha();
((Literal)GetControlFromWizard(CaptchaStep, "CaptchaError")).Text = "Please try again.";
}
}
public string EditFLPCBomInfo(FlowChartBomGet bomItem, int currUser)
{
string result = string.Empty;
FlowChart_PC_MH_Relationship pcItem = new FlowChart_PC_MH_Relationship();
pcItem.FlowChart_Detail_UID = bomItem.FlowChart_Detail_UID;
pcItem.Place = bomItem.Place;
pcItem.Modified_UID = currUser;
pcItem.Modified_Date = DateTime.Now;
//检查用户表中是否存在
try
{
using (var trans = new TransactionScope())
{
//删除以前的那条数据
var deleteItem = flowChartPCMHRelationshipRepository.GetById(bomItem.PC_MH_UID);
flowChartPCMHRelationshipRepository.Delete(deleteItem);
var hasUserItem = systemUserRepository.GetMany(m => m.User_NTID.ToUpper().Equals(bomItem.User_NTID.ToUpper())).FirstOrDefault();
if (hasUserItem != null)
{
if (!hasUserItem.MH_Flag)
{
result = "该账号已经存在，并且不是物料员所属的帐号";
return(result);
}
else //用户表已经存在，直接新增该账户
{
pcItem.MH_UID = hasUserItem.Account_UID;
flowChartPCMHRelationshipRepository.Add(pcItem);
}
}
else //新增用户表和关系表
{
//获取maxAccountUID
int maxAccountID = flowChartPCMHRelationshipRepository.InsertBomUserInfo(null);
System_Users newUserItem = new System_Users();
newUserItem.Account_UID = maxAccountID + 1;
newUserItem.User_NTID = bomItem.User_NTID;
newUserItem.User_Name = bomItem.User_NTID;
newUserItem.System_Language_UID = StructConstants.SystemLanguageUID.Chinese_CN;
newUserItem.Enable_Flag = true;
newUserItem.Email = "";
newUserItem.Modified_UID = currUser;
newUserItem.Modified_Date = pcItem.Modified_Date;
newUserItem.MH_Flag = true;
newUserItem.EmployeePassword = JGP.Common.PasswordUtil.EncryptionHelper.Encrypt("123456", "");
systemUserRepository.Add(newUserItem);
//新增关系表
newUserItem.FlowChart_PC_MH_Relationship1.Add(pcItem);
}
unitOfWork.Commit();
trans.Complete();
}
}
catch (Exception ex)
{
result = "数据修改错误";
}
return(result);
}
public string InsertBomUserInfo(List <FlowChartPCMHRelationshipVM> list)
{
if (list.Count() == 0)
{
return(string.Empty);
}
//var MHRoleUid =
// systemRoleRepository.GetMany(m => m.Role_Name == "维护角色").Select(m => m.Role_UID).FirstOrDefault();
var ErrorInfo = "";
try
{
using (TransactionScope scope = new TransactionScope())
{
var languageUID = list.First().FlowchartPCDTOItem.System_Language_UID;
foreach (var item in list)
{
var flowchartPCItem = AutoMapper.Mapper.Map <FlowChart_PC_MH_Relationship>(item.FlowchartPCDTOItem);
var hasExistUserItem = systemUserRepository.GetMany(m => m.User_NTID.ToUpper().Equals(item.UserNTID.ToUpper())).FirstOrDefault();
if (hasExistUserItem == null)
{
int maxAccountID = flowChartPCMHRelationshipRepository.InsertBomUserInfo(list);
System_Users userItem = new System_Users();
userItem.Account_UID = maxAccountID + 1;
userItem.User_NTID = item.UserNTID;
userItem.User_Name = item.UserNTID;
userItem.Enable_Flag = true;
userItem.Email = "";
userItem.System_Language_UID = languageUID;
userItem.Modified_UID = item.FlowchartPCDTOItem.Modified_UID;
userItem.Modified_Date = item.FlowchartPCDTOItem.Modified_Date;
userItem.MH_Flag = true;
userItem.EmployeePassword = JGP.Common.PasswordUtil.EncryptionHelper.Encrypt("123456", "");
systemUserRepository.Add(userItem);
userItem.FlowChart_PC_MH_Relationship1.Add(flowchartPCItem);
//SystemUserRoleDTO userRoleDTO = new SystemUserRoleDTO();
//userRoleDTO.Account_UID = userDTO.Account_UID;
//userRoleDTO.Modified_UID = this.CurrentUser.AccountUId;
//userRoleDTO.Modified_Date = userDTO.Modified_Date;
}
else
{
hasExistUserItem.FlowChart_PC_MH_Relationship1.Add(flowchartPCItem);
}
//数据提交后才能查找的到值，才能判断是否重复UserNTID
unitOfWork.Commit();
}
scope.Complete();
}
}
catch (Exception e)
{
ErrorInfo = "插入数据失败！" + e.ToString();
}
return(ErrorInfo);
}
