protected void Page_Load(object sender, EventArgs e)
{
Album objAlbum=new Album();
Membership ObjMembership =new Membership();
UserDetails ObjUser = new UserDetails();
if (Session["uid_gender"] == null)
{
Response.Redirect("~/Default.aspx?refPage=" + Page.AppRelativeVirtualPath);
}
else
{
if (!IsPostBack)
{
ObjUser.User_Id = Session["uid_gender"].ToString().Split('_')[0];
lblUser.Text= ObjUser.GetName();
lblProfileID.Text = Session["uid_gender"].ToString().Split('_')[0];
imgProfileImage.ImageUrl = "~/ProfileImages/" + objAlbum.GetProfilePicture(Session["uid_gender"].ToString().Split('_')[0]);
ObjMembership = ObjMembership.GetMembershipDetail();
if (ObjMembership != null)
{
lblPlane.Text = ObjMembership.PlaneName;
}
else
{
lblPlane.Text = "Free Plan";
}
}
}
}
public void CustomerAccountUpdated(Membership.CustomerAccount account)
{
if (OnCustomerAccountUpdated != null)
{
OnCustomerAccountUpdated(this, account);
}
}
async public Task<bool> JoinLeague()
{
var membership = new Membership {
AthleteId = App.CurrentAthlete.Id,
LeagueId = League.Id,
CurrentRank = 0,
};
var task = AzureService.Instance.SaveMembership(membership);
await RunSafe(task);
var theme = membership.League?.Theme;
var getLeaderboardTask = AzureService.Instance.GetLeagueById(membership.LeagueId, true);
await RunSafe(getLeaderboardTask);
if(getLeaderboardTask.IsCompleted && !getLeaderboardTask.IsFaulted)
{
membership.League.Theme = theme;
membership.League.LocalRefresh();
}
if(task.IsCompleted && !task.IsFaulted)
{
var regTask = AzureService.Instance.UpdateAthleteNotificationHubRegistration(App.CurrentAthlete, true);
await RunSafe(regTask);
}
NotifyPropertiesChanged();
return task.IsCompleted && !task.IsFaulted;
}
public Membership Create(Membership membership)
{
var request = new RestRequest("memberships.xml", Method.POST) { XmlSerializer = new XmlIgnoreSerializer() };
request.AddBody(membership);
var response = _client.Execute<Membership>(request);
return response.Data;
}
public Application()
{
Settings = new Settings();
Membership = new Membership();
Organisations = new Organisations();
}
public void Init()
{
var sIndex = new IndexState();
var qIndex = new IndexQueries(sIndex);
var hIndex = new IndexEventhandlers(sIndex);
var qMembership = new MembershipQueries(qIndex);
var hMembership = new MembershipEventhandlers(hIndex);
When = new Membership(qMembership,hMembership);
Given = When.Handle;
Then = new Mock<Contracts.Membership.IHandleEvents>();
When.Handle = Then.Object;
}
private static async Task FillMembership(StackPanel view, Membership membership)
{
Grid message = new Grid();
message.ColumnDefinitions.Add(new ColumnDefinition { Width = GridLength.Auto });
message.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(10, GridUnitType.Pixel) });
message.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
message.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto });
message.RowDefinitions.Add(new RowDefinition { Height = new GridLength(10, GridUnitType.Pixel) });
Image image = new Image
{
Width = 50,
Height = 50,
Source = new BitmapImage(new Uri("ms-appx:///Assets/cow.png", UriKind.Absolute))
};
Grid.SetRow(image, 0);
Grid.SetColumn(image, 0);
Team team = await Api.Do.GetTeam(membership.TeamId);
string descriptor = "";
if (membership.Status == MembershipStatus.Invited)
{
descriptor += "Invited to " + team.Name;
}
else if (membership.Status == MembershipStatus.Admin)
{
descriptor += "Created " + team.Name;
}
else if (membership.Status == MembershipStatus.Member)
{
descriptor += "Joined " + team.Name;
}
else if (membership.Status == MembershipStatus.Left)
{
descriptor += "Left " + team.Name;
}
TextBlock text = new TextBlock
{
FontSize = 20,
TextWrapping = TextWrapping.Wrap,
VerticalAlignment = Windows.UI.Xaml.VerticalAlignment.Center,
Text = descriptor
};
Grid.SetColumn(text, 2);
Grid.SetRow(text, 0);
message.Children.Add(image);
message.Children.Add(text);
view.Children.Add(message);
}
public Credential Register(Membership.User user, string scene, IDictionary<string, object> extendedProperties = null)
{
//创建一个新的凭证对象
var credential = this.CreateCredential(user, scene, extendedProperties);
if(credential == null)
throw new InvalidOperationException();
//注册新建的凭证
this.Register(credential);
//返回注册成功的凭证
return credential;
}
public override object Deserialize(IDictionary<string, object> dictionary, Type type, JavaScriptSerializer serializer)
{
if (dictionary != null)
{
var membership = new Membership();
membership.Id = dictionary.GetValue<int>(RedmineKeys.ID);
membership.Project = dictionary.GetValueAsIdentifiableName(RedmineKeys.PROJECT);
membership.Roles = dictionary.GetValueAsCollection<MembershipRole>(RedmineKeys.ROLES);
return membership;
}
return null;
}
void CreateMembership()
{
// Got new room, now create membership.
var newMembership = new Membership(testRoom, person);
// Commit to Spark.
StartCoroutine(newMembership.Commit(error =>
{
// Failed!
Fail(error.Message);
}, commited =>
{
// Seems to have worked, but we don't know for sure yet.
membership = newMembership;
GetMembership();
}));
}
async public Task<bool> JoinLeague()
{
var membership = new Membership {
AthleteId = App.Instance.CurrentAthlete.Id,
LeagueId = League.Id,
};
var success = await AzureService.Instance.MembershipManager.InsertAsync(membership);
if(success)
{
App.Instance.CurrentAthlete.LocalRefresh();
membership.LocalRefresh();
}
return success;
}
public void Add_New_Membership_To_Group()
{
var group = redmineManager.GetObject<Group>("9", new NameValueCollection() { { "include", "memberships" } });
var mbs = new Membership();
mbs.Roles = new List<MembershipRole>();
mbs.Roles.Add(new MembershipRole()
{
Inherited = true,
Name = "role de test"
});
group.Memberships.Add(mbs);
redmineManager.UpdateObject("9", group);
var updatedGroup = redmineManager.GetObject<Group>("9", new NameValueCollection() { { "include", "memberships" } });
}
public Certification(string certificationId, Membership.User user, string scene, TimeSpan duration, DateTime issuedTime, IDictionary<string, object> extendedProperties = null)
{
if(string.IsNullOrWhiteSpace(certificationId))
throw new ArgumentNullException("certificationId");
if(user == null)
throw new ArgumentNullException("user");
_user = user;
_certificationId = certificationId.Trim();
_scene = scene == null ? null : scene.Trim();
_duration = duration;
_issuedTime = issuedTime;
_timestamp = issuedTime;
if(extendedProperties != null && extendedProperties.Count > 0)
_extendedProperties = new Dictionary<string, object>(extendedProperties, StringComparer.OrdinalIgnoreCase);
}
void GetMembership()
{
var retrieve = new Membership(membership.Id);
StartCoroutine(retrieve.Load(error =>
{
// Failed!
Fail(error.Message);
}, success =>
{
if (retrieve.Room.Id == membership.Room.Id)
{
// Create is now known to have passed here.
Debug.Log("Create Membership Passed!");
// Get Membership just passed.
Debug.Log("Get Membership Passed!");
// Move on.
UpdateMembership();
}
}));
}
void DeleteMembership()
{
var oldMembershipId = string.Copy(membership.Id);
StartCoroutine(membership.Delete(error =>
{
Fail(error.Message);
}, success =>
{
// Double check (Expect get to know fail).
var checkDelete = new Membership(oldMembershipId);
StartCoroutine(checkDelete.Load(error =>
{
Debug.Log(error.Message);
TestEnd();
}, getSuccess =>
{
Fail("Should fail to Get deleted Membership");
}));
}));
}
public bool CreateCustomer(Membership.CustomerAccount u, ref CreateUserStatus status, string clearPassword)
{
bool result = false;
if (u != null)
{
Membership.CustomerAccount testUser = new Membership.CustomerAccount();
testUser = Customers.FindByEmail(u.Email);
if (testUser != null)
{
if (testUser.Bvin != string.Empty)
{
status = CreateUserStatus.DuplicateUsername;
return false;
}
}
if (u.Salt == string.Empty)
{
u.Salt = System.Guid.NewGuid().ToString();
u.Password = u.EncryptPassword(clearPassword);
}
if (Customers.Create(u) == true)
{
result = true;
status = CreateUserStatus.Success;
}
else
{
status = CreateUserStatus.UpdateFailed;
}
}
return result;
}
public static Membership Create()
{
if (_instance==null)
_instance = new Membership();
return _instance;
}
// methods
public static MembershipUserCollection AllMembershipUsers()
{
return(Membership.GetAllUsers());
}
public UserRightsMessageComposer(Membership Membership, int CharacterId)
{
base.WriteHeader(MessageComposerIds.UserRightsMessageComposer);
base.Write((int)Membership);
base.Write(CharacterId);
}
/// <summary>
/// Adds a membership parameter to the command.
/// </summary>
/// <param name="value">The value for the membership.</param>
/// <returns>This instance of the <see cref="HouseholdDataCommandBuilder"/>.</returns>
internal HouseholdDataCommandBuilder AddMembershipParameter(Membership value)
{
AddTinyIntParameter("@membership", (int)value, 4);
return(this);
}
public void ProcessRequest(HttpContext context)
{
SqlConnection conn = new SqlConnection(strcon);
context.Response.ContentType = "text/plain";
String jsonString = String.Empty;
jsonString = "{\n\"resultlist\": [\n"; /*json Loop Start*/
userid = context.Request.Form["usrId"];
pass = context.Request.Form["usrPass"];
//userid = context.Request.QueryString["userid"];
//pass = context.Request.QueryString["pass"];
CustomProfile profile = CustomProfile.GetProfile(userid);
if (Membership.ValidateUser(userid, pass))
{
BrilliantWMS.UserCreationService.iUserCreationClient UserCreationClient = new BrilliantWMS.UserCreationService.iUserCreationClient();
string usrName = profile.Personal.UserName.ToString();
string cmpny = profile.Personal.CompanyID.ToString();
string cmpnyNm = profile.Personal.CName.ToString();
string deptID = profile.Personal.DepartmentID.ToString();
string deptNm = profile.Personal.Department.ToString();
string mobNo = profile.Personal.MobileNo;
string dbid = profile.Personal.UserID.ToString();
string type = profile.Personal.UserType.ToString();
string warehouseList = GetWarehouseList(dbid);
cmd.CommandType = CommandType.Text;
cmd.CommandText = " select Name from mCompany where ID=" + cmpny + "";
cmd.Connection = conn;
cmd.Parameters.Clear();
da.SelectCommand = cmd;
da.Fill(ds, "tbl1");
dt = ds.Tables[0];
string CompanyName = ds.Tables[0].Rows[0]["Name"].ToString();
SqlCommand cmd3 = new SqlCommand();
SqlDataAdapter da3 = new SqlDataAdapter();
DataSet ds3 = new DataSet();
DataTable dt3 = new DataTable();
cmd3.CommandType = CommandType.Text;
cmd3.CommandText = "select MobileInterface from mUserProfileHead where id=" + dbid + "";
cmd3.Connection = conn;
cmd3.Parameters.Clear();
da3.SelectCommand = cmd3;
da3.Fill(ds3, "tbl4");
dt3 = ds3.Tables[0];
int mobileinterface = Convert.ToInt32(dt3.Rows[0]["MobileInterface"].ToString());
if (mobileinterface == 1)
{
SqlCommand cmd1 = new SqlCommand();
SqlDataAdapter da1 = new SqlDataAdapter();
DataSet ds1 = new DataSet();
DataTable dt1 = new DataTable();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select top(1) U.WarehoueID ,W.WarehouseName from mUserWarehouse U left outer join mWarehouseMaster W on U.WarehoueID=W.ID where U.UserID=" + dbid + "";
cmd1.Connection = conn;
cmd1.Parameters.Clear();
da1.SelectCommand = cmd1;
da1.Fill(ds1, "tbl2");
dt1 = ds1.Tables[0];
string warehouseID = "", wName = "";
if (dt1.Rows.Count > 0)
{
warehouseID = ds1.Tables[0].Rows[0]["WarehoueID"].ToString();
wName = ds1.Tables[0].Rows[0]["WarehouseName"].ToString();
}
jsonString = jsonString + "{\n";
jsonString = jsonString + "\"username\": \"" + usrName.Trim() + "\",\n";
jsonString = jsonString + "\"companyid\": \"" + cmpny.Trim() + "\",\n";
jsonString = jsonString + "\"companyname\": \"" + CompanyName.Trim() + "\",\n";
jsonString = jsonString + "\"warehouseid\": \"" + warehouseID.Trim() + "\",\n";
jsonString = jsonString + "\"warehouse\": \"" + wName.Trim() + "\",\n";
jsonString = jsonString + "\"warehouselist\": \"" + warehouseList.Trim() + "\",\n";
jsonString = jsonString + "\"userid\": \"" + userid.Trim() + "\",\n";
jsonString = jsonString + "\"dbid\": \"" + dbid.Trim() + "\",\n";
jsonString = jsonString + "\"mobile\": \"" + mobNo.Trim() + "\",\n";
jsonString = jsonString + "\"usertype\": \"" + type.Trim() + "\",\n";
jsonString = jsonString + "\"authmsg\": \"success\"\n";
}
else
{
jsonString = jsonString + "{\"authmsg\": \"failed\"";
}
}
else
{
jsonString = jsonString + "{\"authmsg\": \"failed\"";
}
jsonString = jsonString + "}]\n}"; /*json Loop End*/
context.Response.Write(jsonString);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
// Membership.CreateUser("admin", "humabilal786", "*****@*****.**");
// iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
// iBiz.FinPro.UserProfile.objUserProfile oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
// oProfile.userEmail = "*****@*****.**";
// oProfile.userFirstName = "Bilal";
// oProfile.userIsActive = true;
// oProfile.userIsOfficial = false;
// oProfile.userLastName = "Muhammad";
// bProfile.Add(oProfile);
Membership.CreateUser("admin", "admin123", "*****@*****.**");
iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
iBiz.FinPro.UserProfile.objUserProfile oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
oProfile.userEmail = "*****@*****.**";
oProfile.userFirstName = "Bilal";
oProfile.userIsActive = true;
oProfile.userIsOfficial = true;
oProfile.userLastName = "Muhammad";
bProfile.Add(oProfile);
//Membership.CreateUser("naeem", "naeem786", "*****@*****.**");
////iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
//oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
//oProfile.userEmail = "*****@*****.**";
//oProfile.userFirstName = "Naeem";
//oProfile.userIsActive = true;
//oProfile.userIsOfficial = false;
//oProfile.userLastName = "Akhtar";
//bProfile.Add(oProfile);
////Rafphi Qadeer
//Membership.CreateUser("rafphi", "qadeer786", "*****@*****.**");
//oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
//oProfile.userEmail = "*****@*****.**";
//oProfile.userFirstName = "Rafphi";
//oProfile.userIsActive = true;
//oProfile.userIsOfficial = false;
//oProfile.userLastName = "Qadeer";
//bProfile.Add(oProfile);
//Membership.CreateUser("zeeshan", "zeeshantrd786", "*****@*****.**");
//oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
//oProfile.userEmail = "*****@*****.**";
//oProfile.userFirstName = "Zeeshan";
//oProfile.userIsActive = true;
//oProfile.userIsOfficial = false;
//oProfile.userLastName = "Aftab";
//bProfile.Add(oProfile);
//Membership.CreateUser("admin", "humabilal786", "*****@*****.**");
//iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
//iBiz.FinPro.UserProfile.objUserProfile oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
//oProfile.userEmail = "*****@*****.**";
//oProfile.userFirstName = "Bilal";
//oProfile.userIsActive = true;
//oProfile.userIsOfficial = false;
//oProfile.userLastName = "Muhammad";
//bProfile.Add(oProfile);
//Membership.CreateUser("admin", "humabilal786", "*****@*****.**");
//iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
//iBiz.FinPro.UserProfile.objUserProfile oProfile = new iBiz.FinPro.UserProfile.objUserProfile();
//oProfile.userEmail = "*****@*****.**";
//oProfile.userFirstName = "Bilal";
//oProfile.userIsActive = true;
//oProfile.userIsOfficial = false;
//oProfile.userLastName = "Muhammad";
//bProfile.Add(oProfile);
}
catch (Exception)
{
throw;
}
}
private void BindData(string strOrder)
{
try
{
int pageSize = 50;
DataSet objds = new DataSet();
objSticker.ActiveStatus = Session["Status"] != null?int.Parse(Session["Status"].ToString()) : 1;
objSticker.ComplaintRefNo = Session["ComplaintNo"] != null ? Session["ComplaintNo"].ToString() : "";
objSticker.StickerCode = Session["StickerCode"] != null ? Session["StickerCode"].ToString() : "";
if (ddlConsumptionStatus.SelectedIndex == 1)
{
objSticker.ProductDivisionSno = 0;
}
else
{
objSticker.ProductDivisionSno = Session["ProductDivision"] != null?int.Parse(Session["ProductDivision"].ToString()) : 0;
}
objSticker.ConsumptionStatus = Session["IsConsumed"] != null?int.Parse(Session["IsConsumed"].ToString()) : 1;
if (!(Roles.IsUserInRole(Membership.GetUser().UserName, "SC") || Roles.IsUserInRole(Membership.GetUser().UserName, "SC_SIMS")))
{
objSticker.RegionSno = Session["Region"] != null?int.Parse(Session["Region"].ToString()) : 0;
objSticker.BranchSno = Session["Branch"] != null?int.Parse(Session["Branch"].ToString()) : 0;
objSticker.AscId = Session["ServiceContractor"] != null?int.Parse(Session["ServiceContractor"].ToString()) : 0;
objSticker.Type = "SELECTFOROTHERS";
}
else
{
objSticker.Type = "SELECTFORASC";
objSticker.AscId = AscId;
}
objSticker.EmpCode = Membership.GetUser().UserName.ToString();
objSticker.SortingOrder = strOrder;
objSticker.PageSize = pageSize;
objSticker.PageIndex = _currentPage;
objSticker.BindAscStickerDetails(gvStickerDetails);
lblCount.Text = Convert.ToString(objSticker.TotalPage);
generatePager(objSticker.TotalPage, pageSize, _currentPage);
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
public ActionResult Login(LoginViewModel modelo)
{
try
{
if (ModelState.IsValid)
{
this.InicializaView();
modelo.UserName = modelo.UserName.ToLower();
if (Membership.ValidateUser(modelo.UserName, modelo.Password))
{
var N9999USUBusiness = new N9999USUBusiness();
// Busca código do usuário
dadosUsuario = N9999USUBusiness.ListaDadosUsuarioPorLogin(modelo.UserName);
modelo.versaoSistema = "Produção";
if (dadosUsuario != null)
{
var n9999MENBusiness = new N9999MENBusiness();
var n9999SIS = new N9999SIS();
var lista = n9999MENBusiness.MontarMenu(dadosUsuario.CODUSU, (int)Enums.Sistema.NWORKFLOW);
N0203REGBusiness N0203REGBusiness = new N0203REGBusiness();
if (lista.Count > 0)
{
this.Logado = ((char)Enums.Logado.Sim).ToString();
this.PermissoesDeAcesso = lista;
this.TramitesNotificao = ListaN0203TRAPesquisaa;
this.ProtocolosPendentes = listaAprovacao;
var ActiveDirectoryBusiness = new ActiveDirectoryBusiness();
this.NomeUsuarioLogado = Abreviar(ActiveDirectoryBusiness.ListaDadosUsuarioAD(modelo.UserName).Nome, true);
this.LoginUsuario = modelo.UserName;
this.CodigoUsuarioLogado = dadosUsuario.CODUSU.ToString();
this.Empresa = "NUTRIPLAST INDÚSTRIA E COMÉRCIO LTDA";
this.EmpresaFilial = "CASCAVEL";
//this.EmpresaFilialArmazem = "CENTRO DE DISTRIBUIÇÃO";
this.NomeAbreviadoEmpresa = "NUTRIPLAN";
this.CnpjEmpresa = "78.575.511/0001-29";
this.EnderecoEmpresa = "Av. Das Agroindústrias, 1829 - Distrito Industrial Domiciano Theobaldo Bresolin";
this.CepEmpresa = "85818-560";
return(this.RedirectToAction("InformacoesProtocolo", "InformacoesProtocolo"));
}
else
{
ModelState.AddModelError("", "Usuário não possuí acesso ao Sistema de Ocorrência. Favor abrir chamado solicitando acesso.");
}
}
else
{
ModelState.AddModelError("", "Usuário não possuí acesso ao Sistema de Ocorrência. Favor abrir chamado solicitando acesso.");
}
}
else
{
ModelState.AddModelError("", "Usuário ou senha inválida.");
}
}
return(this.View("Login", this.loginViewModel));
}
catch (Exception ex)
{
this.Session["ExceptionErro"] = ex;
return(this.RedirectToAction("ErroException", "Erro"));
}
}
public bool ValidateUser(string username, string password)
{
return(Membership.ValidateUser(username, password));
}
public ActionResult FormYonetim(string name, string description, DateTime createdAt, string[] fields)
{
Form form = new Form();
form.name = name;
form.description = description;
form.createdAt = Convert.ToDateTime(createdAt);
//Form eklendiğinde sisteme login olan kullanıcının "UserID"si bilgisi "createdBy"a eklendi
Guid userId = (Guid)Membership.GetUser().ProviderUserKey;
form.createdBy = userId;
db.Forms.Add(form);
db.SaveChanges();
Form form2 = new Form();
form2 = db.Forms.OrderByDescending(x => x.id).FirstOrDefault();
int lastAddId = form2.id;
//databaseden son eklenen formun Id sini al
for (int i = 0; i < fields.Length; i++)
{
string[] degerler = fields[i].Split(',');
string alanAdi = degerler[0];
string type = degerler[1];
string required = degerler[2];
Field field = new Field();
field.name = alanAdi;
field.dataType = type;
if (required == "true")
{
field.required = true;
}
else
{
field.required = false;
}
field.formId = lastAddId;
db.Fields.Add(field);
db.SaveChanges();
//database ekleme işlemleri
//alınan ıd yi de ekle
}
//string message = "Kaydedildi";
//ViewBag.Message = message;
//return View();
return(RedirectToAction("Index", "Form"));
}
public HttpResponseMessage PostHash(String hsID, [FromBody] HandshakeRequest hsRequest)
{
Handshake h = new Handshake();
Boolean providerActive = false, providerIsPartner = false;
int employerID = 0;
string cnxString = "";
CCHEncrypt e = new CCHEncrypt();
using (ValidateMobilePartner vmp = new ValidateMobilePartner(hsID, hsRequest.OrganizationID))
{
vmp.ForEachProvider(delegate(Boolean valid, Boolean isPartner, int empId, string cnx, string un)
{
providerActive = valid;
providerIsPartner = isPartner;
employerID = empId;
cnxString = cnx;
Request.UserName(un);
MembershipUser mu = Membership.GetUser(un, true);
Request.UserID(mu.ProviderUserKey.ToString());
});
}
if (providerActive && providerIsPartner)
{
e.UserKey = Request.EncryptionKey();
e.SecretKey = Properties.Settings.Default.SecretKey;
e.Add("UserID", Request.UserID());
e.Add("EmployerID", employerID.ToString());
using (GetPartnerEmployeeInfoByName gpeibn = new GetPartnerEmployeeInfoByName())
{
gpeibn.FirstName = hsRequest.FirstName;
gpeibn.LastName = hsRequest.LastName;
gpeibn.DOB = hsRequest.DOB;
gpeibn.SubscriberMedicalID = hsRequest.MedicalID;
//gpeibn.RelationshipCode = hsRequest.RelationshipCode;
gpeibn.GetData(cnxString);
if (gpeibn.Tables.Count == 0 ||
gpeibn.Tables[0].Rows.Count == 0 ||
gpeibn.Tables[0].Rows[0][0].ToString() == string.Empty)
{
return(Request.CreateErrorResponse(HttpStatusCode.NoContent, new Exception("User Not Found")));
}
//UserAccess Check dstrickland 7/8/2015
using (var cpaa = new CheckPersonApplicationAccess(gpeibn.CCHID, cnxString))
{
if (!cpaa.HasAccess)
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized,
new Exception(cpaa.ErrorMessage)));
}
}
e.Add("CCHID", gpeibn.CCHID.ToString());
gpeibn.ForEach <Handshake.EmployeeInfoData>(
delegate(Handshake.EmployeeInfoData eid)
{
h.EmployeeInfo = eid;
}
);
//CreateLoginAudit(Request.UserName(), Request.RequestUri.Host.ToString(), gpeibn.CCHID, cnxString);
using (InsertUserLoginHistory iulh = new InsertUserLoginHistory())
{
iulh.UserName = Request.UserName();
iulh.CCHID = gpeibn.CCHID;
iulh.Domain = Request.RequestUri.Host;
iulh.CchApplicationId = 2; // 1 is for Transparency App; 2 is for HR App
iulh.PostData(cnxString);
}
}
h.AuthHash = e.ToString();
return(this.Request.CreateResponse <Handshake>(HttpStatusCode.OK, h));
}
else
{
return(this.Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
private void BindControl()
{
try
{
if (Roles.IsUserInRole(Membership.GetUser().UserName, "SC") || Roles.IsUserInRole(Membership.GetUser().UserName, "SC_SIMS"))
{
objCombo.EmpId = Membership.GetUser().UserName;
objCombo.BindSCProductDivisionByUsername(ddlProductDivision);
}
else
{
objCommonMIS.EmpId = Membership.GetUser().UserName;
objCommonMIS.BusinessLine_Sno = "2";
objCommonMIS.GetUserRegions(ddlRegion);
if (ddlRegion.Items.Count == 2)
{
ddlRegion.SelectedIndex = 1;
}
objCommonMIS.RegionSno = ddlRegion.SelectedValue;
objCommonMIS.GetUserBranchs(ddlBranches);
if (ddlBranches.Items.Count == 2)
{
ddlBranches.SelectedIndex = 1;
}
objCommonMIS.BranchSno = ddlBranches.SelectedValue;
objCommonMIS.GetUserSCs(ddlAsc);
if (ddlAsc.Items.Count == 2)
{
ddlAsc.SelectedIndex = 1;
}
objCommonMIS.GetUserProductDivisions(ddlProductDivision);
}
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void btnClear_Click(object sender, EventArgs e)
{
try
{
if (!(Roles.IsUserInRole(Membership.GetUser().UserName, "SC") && Roles.IsUserInRole(Membership.GetUser().UserName, "SC_SIMS")))// For Other Role
{
if (ddlRegion.Items.Count > 1)
{
ddlRegion.SelectedValue = "0";
}
if (ddlBranches.Items.Count > 1)
{
ddlBranches.SelectedValue = "0";
}
if (ddlAsc.Items.Count > 1)
{
ddlAsc.SelectedValue = "0";
}
}
ddlConsumptionStatus.SelectedValue = "0";
ddlActiveStatus.SelectedValue = "1";
txtComplaintRefNo.Text = "";
txtStickerCode.Text = "";
if (ddlProductDivision.Items.Count > 1)
{
ddlProductDivision.SelectedValue = "0";
}
SetControlValueToSession();
BindData(sortingOrder);
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
private void SetControlValueToSession()
{
Session["Status"] = ddlActiveStatus.SelectedValue;
Session["ComplaintNo"] = txtComplaintRefNo.Text;
Session["StickerCode"] = txtStickerCode.Text;
Session["IsConsumed"] = ddlConsumptionStatus.SelectedValue;
Session["ProductDivision"] = ddlProductDivision.SelectedValue;
if (!(Roles.IsUserInRole(Membership.GetUser().UserName, "SC") && Roles.IsUserInRole(Membership.GetUser().UserName, "SC_SIMS")))// For Other Role
{
Session["Region"] = ddlRegion.SelectedValue;
Session["Branch"] = ddlBranches.SelectedValue;
Session["ServiceContractor"] = ddlAsc.SelectedValue;
}
_currentPage = 1;
}
public virtual MembershipUser CreateUser(string username, string password, string cellPhoneNo, out MembershipCreateStatus status)
{
var args = new ValidatePasswordEventArgs(username, password, true);
OnValidatingPassword(args);
if (args.Cancel)
{
status = MembershipCreateStatus.InvalidPassword;
return null;
}
if (this.RequiresUniqueCellPhoneNo &&
!this.GetUserNameByCellPhoneNo(cellPhoneNo).IsEmpty())
{
status = MembershipCreateStatus.DuplicateEmail;
return null;
}
var membershipUser = this.GetUser(username, false);
if (membershipUser == null)
{
User user = new User
{
Name = username
};
string token = null;
object dbtoken = DBNull.Value;
if (this.RequireConfirmationToken)
{
token = SecurityHelper.GenerateToken();
dbtoken = token;
}
Membership membership = new Membership
{
CellPhoneNo = cellPhoneNo,
IsApproved = true,
Password = SecurityHelper.EncodePassword(password),
ConfirmationToken = dbtoken.ToString()
};
int createdResult = this.DbProvider.CreateUser(user, membership);
status = createdResult > 0 ? MembershipCreateStatus.Success : MembershipCreateStatus.UserRejected;
return this.GetUser(username, false);
}
status = MembershipCreateStatus.DuplicateUserName;
return null;
}
protected void ButtonNewUser_Click(object sender, EventArgs e)
{
MembershipCreateStatus _return;
//SnitzMembershipProvider provider = (SnitzMembershipProvider)Membership.Providers["SnitzMembershipProvider"];
MembershipUser mu = Membership.CreateUser(tbxUserName.Text, tbxPassword.Text, tbxEmail.Text, ".", ".", cbxApproval.Checked, null, out _return);
switch (_return)
{
case MembershipCreateStatus.DuplicateUserName:
LabelInsertMessage.Text = "Username already exists. Please enter a different user name.";
break;
case MembershipCreateStatus.DuplicateEmail:
LabelInsertMessage.Text = "A username for that e-mail address already exists. Please enter a different e-mail address.";
break;
case MembershipCreateStatus.InvalidPassword:
LabelInsertMessage.Text = "The password provided is invalid. Please enter a valid password value.";
break;
case MembershipCreateStatus.InvalidEmail:
LabelInsertMessage.Text = "The e-mail address provided is invalid. Please check the value and try again.";
break;
case MembershipCreateStatus.InvalidAnswer:
LabelInsertMessage.Text = "The password retrieval answer provided is invalid. Please check the value and try again.";
break;
case MembershipCreateStatus.InvalidQuestion:
LabelInsertMessage.Text = "The password retrieval question provided is invalid. Please check the value and try again.";
break;
case MembershipCreateStatus.InvalidUserName:
LabelInsertMessage.Text = "The user name provided is invalid. Please check the value and try again.";
break;
case MembershipCreateStatus.ProviderError:
LabelInsertMessage.Text = "The authentication provider returned an error. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
break;
case MembershipCreateStatus.UserRejected:
LabelInsertMessage.Text = "The user creation request has been canceled. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
break;
case MembershipCreateStatus.Success:
LabelInsertMessage.Text = "Member " + tbxUserName.Text + " Inserted Successfully.";
LabelInsertMessage.ForeColor = Color.Green;
new SnitzMembershipProvider().UnlockUser(tbxUserName.Text);
foreach (ListItem item in roles.Items)
{
if (item.Selected)
{
Roles.AddUserToRole(tbxUserName.Text, item.Value);
}
}
if (cbxSendEmail.Checked)
{
SendEmail(tbxUserName.Text, tbxPassword.Text);
}
mu.UnlockUser();
break;
default:
LabelInsertMessage.Text = "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
break;
}
tbxUserName.Text = "";
tbxPassword.Text = "";
tbxEmail.Text = "";
cbxApproval.Checked = false;
cbxSendEmail.Checked = false;
}
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
{
var args = new ValidatePasswordEventArgs(username, password, true);
OnValidatingPassword(args);
if (args.Cancel)
{
status = MembershipCreateStatus.InvalidPassword;
return null;
}
if (this.RequiresUniqueEmail &&
!this.GetUserNameByEmail(email).IsEmpty())
{
status = MembershipCreateStatus.DuplicateEmail;
return null;
}
var membershipUser = this.GetUser(username, false);
if (membershipUser == null)
{
User user = new User
{
Name = username
};
string token = null;
object dbtoken = DBNull.Value;
if (this.RequireConfirmationToken)
{
token = SecurityHelper.GenerateToken();
dbtoken = token;
}
Membership membership = new Membership
{
Email = email,
IsApproved = isApproved,
Password = SecurityHelper.EncodePassword(password),
PasswordQuestion = passwordQuestion,
PasswordAnswer = passwordAnswer,
ConfirmationToken = dbtoken.ToString()
};
int createdResult = this.DbProvider.CreateUser(user, membership);
status = createdResult > 0 ? MembershipCreateStatus.Success : MembershipCreateStatus.UserRejected;
return this.GetUser(username, false);
}
status = MembershipCreateStatus.DuplicateUserName;
return null;
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
if (Page.IsValid == true)
{
ShowPartialUserEmailRequest.Visible = false;
try
{
bool boolMembershipUserCreated = false;
string AccessCode = Utility.GetQueryStringValueByKey(Request, "ActivationKey");
if (AccessCode != string.Empty && AccessCode != null)
{
user = User.Select(Guid.Parse(AccessCode));
}
bool PartialEmail = false;
if (user.IsPartialUser == false)
{
PartialEmail = checkPartialEmail();
}
if (PartialEmail == false)
{
user.Email = Email.Text.Trim();
user.Status = "Active";
user.PersonalEmail = Email.Text.Trim();
user.Password = Password.Text.Trim();
user.UserName = UserName.Text.Trim();
user.Question = Question.Text.Trim();
user.Answer = Answer.Text.Trim();
aspnet_Roles aspnet_Roles_ = new aspnet_Roles();
aspnet_Roles_ = aspnet_Roles.Select("landlord");
user.FirstName = FirstName.Text.Trim();
user.MiddleName = MiddleName.Text.Trim();
user.LastName = LastName.Text.Trim();
user.RoleId = aspnet_Roles_.RoleId;
user.ReferralCode = ReferralCode.Text.Trim();
object objCreateMembershipUser = new object();
bool IsActivate = false;
if (SystemConfig.GetValue(Enums.SystemConfig.IsEmailActivation).ToLower() == "true")
{
IsActivate = false;
}
else
{
IsActivate = true;
}
if (user.IsPartialUser)
{
objCreateMembershipUser = user.AddMembershipPartialUser(user.UserName, user.Password, user.Email, user.Question, user.Answer, IsActivate, user.UserId.Value, "landlord");
}
else
{
objCreateMembershipUser = user.AddMembershipUser(user.UserName, user.Password, user.Email, user.Question, user.Answer, IsActivate, "landlord");
}
bool.TryParse(objCreateMembershipUser.ToString(), out boolMembershipUserCreated);
if (boolMembershipUserCreated)
{
Session[Constants.SESSION_LOGGED_USER] = user;
MembershipUser newUser = Membership.GetUser(user.UserName);
user.UserId = Guid.Parse(newUser.ProviderUserKey.ToString());
user.AspnetUserId = Guid.Parse(newUser.ProviderUserKey.ToString());
user.CreatedBy = Guid.Parse(newUser.ProviderUserKey.ToString());
user.UpdatedBy = Guid.Parse(newUser.ProviderUserKey.ToString());
if (user.Save())
{
landload.LandlordId = user.UserId.HasValue ? user.UserId.Value : Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
landload.LandlordName = user.FirstName + " " + user.MiddleName + " " + user.LastName;
landload.user = user;
landload.CreatedBy = Guid.Parse(newUser.ProviderUserKey.ToString());
landload.UpdatedBy = Guid.Parse(newUser.ProviderUserKey.ToString());
if (landload.Save())
{
}
}
if (SystemConfig.GetValue(Enums.SystemConfig.IsEmailActivation).ToLower() == "true")
{
string strMsgContent = message((Guid)newUser.ProviderUserKey);
string strMsgTitle = SystemConfig.GetValue(RHP.Common.Enums.SystemConfig.SITEURL) + "- Action required for account activation.";
int rtn = SendEmail(user.Email, strMsgTitle, strMsgContent);
if (rtn == 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Create_Account_Success + "'); window.location = '/Login.aspx?type=l'; }", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Sending_Email_Error + "'); window.location = '/Login.aspx?type=l'; }", true);
}
// success
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Create_Account_Success + "'); window.location = '/Login.aspx?type=l'; }", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Profile_Create_Unsuccess + " - " + objCreateMembershipUser.ToString() + "'); }", true);
}
}
else
{
User user_check = new User();
if (user_check.IsPartialUserEmailExist(Email.Text.Trim().ToLower()))
{
ShowfullRegistration.Visible = false;
ShowPartialUserEmailRequest.Visible = true;
lblpartialuserEmail.Text = Email.Text.Trim();
lblpartialuserEmail2.Text = Email.Text.Trim();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Profile_Create_Unsuccess + " - " + Messages.EmailAddressExist + "'); }", true);
ShowPartialUserEmailRequest.Visible = false;
ShowfullRegistration.Visible = true;
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Profile_Create_Unsuccess + "'); }", true);
// throw new Exception("LandLord Profile info : " + ex.ToString());
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Validation_Fail + "'); }", true);
}
}
public bool CreateCustomer(Membership.CustomerAccount u, string clearPassword)
{
CreateUserStatus status = CreateUserStatus.None;
return CreateCustomer(u, ref status, clearPassword);
}
public void BindDropCustomer()
{
//colCust = objCustomer.Get_All();
//drpCustomer.DataTextField = "Customer_Name";
//drpCustomer.DataValueField = "CustId";
//drpCustomer.DataSource = colCust;
//drpCustomer.DataBind();
//ListItem item = new ListItem();
//item.Text = "------------Select-------------";
//item.Value = "0";
//drpCustomer.Items.Add(item);
//drpCustomer.SelectedValue = "0";
BLLCollection <Customer_mst> colCtS = new BLLCollection <Customer_mst>();
string userName = "";
MembershipUser User = Membership.GetUser();
if (User != null)
{
userName = User.UserName.ToString();
}
if (userName != "")
{
int userid;
int Flagcount = 0;
objOrganization = objOrganization.Get_Organization();
objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);
if (objUser.Userid != 0)
{
userid = objUser.Userid;
colUserToSite = ObjUserToSite.Get_All_By_userid(userid);
foreach (UserToSiteMapping obj in colUserToSite)
{
int siteid;
Site_mst objSite1 = new Site_mst();
siteid = obj.Siteid;
objSite1 = objSite1.Get_By_id(siteid);
if (objSite1.Siteid != 0)
{
colCustToSite = objCustToSite.Get_All_By_siteid(objSite1.Siteid);
foreach (CustomerToSiteMapping objcts in colCustToSite)
{
Customer_mst objC = new Customer_mst();
int FlagStatus = 0;
objC = objC.Get_By_id(objcts.Custid);
if (Flagcount == 0)
{
colCtS.Add(objC);
}
else
{
foreach (Customer_mst objCus in colCtS)
{
if (objC.Custid == objCus.Custid)
{
FlagStatus = 1;
}
}
if (FlagStatus == 0)
{
colCtS.Add(objC);
}
}
Flagcount = Flagcount + 1;
}
}
}
}
}
drpCustomer.DataTextField = "Customer_Name";
drpCustomer.DataValueField = "CustId";
drpCustomer.DataSource = colCtS;
drpCustomer.DataBind();
if (colCtS.Count == 0)
{
ListItem item = new ListItem();
item.Text = "-------------Select-------------";
item.Value = "0";
drpCustomer.Items.Add(item);
}
}
public KeyValueList SignIn(string username, string password)
{
string errorMessage = string.Empty;
if (password.Length == 0)
{
errorMessage = "Please enter password";
}
if (username.Length == 0)
{
errorMessage = "Please enter user name";
}
if (errorMessage.Length == 0)
{
// Here must be validation with password. You can add third party validation here;
bool success = Membership.ValidateUser(username, password);
if (!success)
{
errorMessage = "Validation failed. User name '" + username + "' was not found.";
}
}
var results = new KeyValueList();
if (errorMessage.Length > 0)
{
results.Add("Status", false);
results.Add("Message", errorMessage);
}
else
{
FormsAuthentication.Initialize();
var user = Membership.GetUser(username, true);
if (user == null)
{
results.Add("Status", false);
results.Add("Message", "'" + username + "' was not found.");
}
else
{
var roles = Roles.GetRolesForUser(username);
string rolesString = string.Empty;
for (int i = 0; i < roles.Length; i++)
{
if (i > 0)
{
rolesString += ",";
}
rolesString += roles[i];
}
var loginRememberMinutes = 30;
var ticket = new FormsAuthenticationTicket(1, user.UserName, DateTime.Now, DateTime.Now.AddMinutes(loginRememberMinutes), true, rolesString, FormsAuthentication.FormsCookiePath);
// Encrypt the cookie using the machine key for secure transport.
var hash = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash); // Hashed ticket
// Set the cookie's expiration time to the tickets expiration time
if (ticket.IsPersistent)
{
cookie.Expires = ticket.Expiration;
}
HttpContext.Current.Response.Cookies.Add(cookie);
// Create Identity.
var identity = new System.Security.Principal.GenericIdentity(user.UserName);
// Create Principal.
var principal = new RolePrincipal(identity);
System.Threading.Thread.CurrentPrincipal = principal;
// Create User.
HttpContext.Current.User = new System.Security.Principal.GenericPrincipal(identity, roles);
results.Add("Status", true);
results.Add("Message", "Welcome!");
}
}
return(results);
}
public bool UpdateCustomer(Membership.CustomerAccount u)
{
CreateUserStatus s = new CreateUserStatus();
return UpdateCustomer(u, ref s);
}
/// <summary>
/// Validate if the user is a memeber of the school of ICT against the active directory
/// </summary>
/// <returns></returns>
public bool IsSchoolOfICTMember()
{
dal = new LoginDAL();
Membership membership = new Membership(userInformation.GetDepartment(), userInformation.GetDescription());
if (dal.MembershipExists(membership))
{
return true;
}
else
{
return false;
}
}
public override void NotifyPropertiesChanged()
{
_membership = null;
base.NotifyPropertiesChanged();
SetPropertyChanged("Membership");
SetPropertyChanged("IsCurrentMemebership");
SetPropertyChanged("EmptyMessage");
SetPropertyChanged("IsFirstPlace");
SetPropertyChanged("CanChallenge");
SetPropertyChanged("CanRevokeChallenge");
SetPropertyChanged("Membership");
SetPropertyChanged("CanDeleteMembership");
SetPropertyChanged("RankDescription");
SetPropertyChanged("Stats");
SetPropertyChanged("JoinDescription");
}
public Stream AdminUsuarioCUD(List<Usuario> nuevos, List<Usuario> viejos, List<Usuario> eliminados)
{
var db = new CoomuceEntities();
var transaction = db.Database.BeginTransaction();
try
{
// hay datos para eliminar?
if (eliminados.Count > 0)
{
// marcar registros para eliminar
eliminados.ForEach(e => db.Entry(e).State = EntityState.Deleted);
// eliminar registros
db.Usuario.RemoveRange(eliminados);
}
// hay datos para actualizar?
if (viejos.Count > 0)
{
// obtengo los id's de los items editados
var listaId = viejos.Select(v => v.idUsuario).ToList();
// obtengo los items editados
var itemEditar = db.Usuario.Where(r => listaId.Contains(r.idUsuario)).ToList();
// obtengo los datos editados
itemEditar.ForEach(r =>
{
var v = viejos.Where(i => i.idUsuario == r.idUsuario).FirstOrDefault();
r.idTipoIdentificacion = v.idTipoIdentificacion;
r.identificacionUsuario = v.identificacionUsuario;
r.primerApellidoUsuario = v.primerApellidoUsuario;
r.segundoApellidoUsuario = v.segundoApellidoUsuario;
r.primerNombreUsuario = v.primerNombreUsuario;
r.segundoNombreUsuario = v.segundoNombreUsuario;
r.emailUsuario = v.emailUsuario;
r.celularUsuario = v.celularUsuario;
r.idRol = v.idRol;
r.estaHabilitadoUsuario = v.estaHabilitadoUsuario;
});
}
// hay datos para adicionar?
if (nuevos.Count > 0)
{
foreach (var item in nuevos)
{
// obtener login de usuario
string loginUsuario = string.Format("{0}{1}{2}",
item.primerNombreUsuario.Substring(0, 1),
item.primerApellidoUsuario.Replace(" ", ""),
(string.IsNullOrEmpty(item.segundoApellidoUsuario) ? "" : item.segundoApellidoUsuario.Substring(0, 1)));
// verificar si hay un usuario con el mismo login
var existenLogin = db.Usuario
.Where(r => r.loginUsuario.Substring(0, loginUsuario.Length).Equals(loginUsuario))
.Count();
// se encontro usuarios con el mismo login?
if (existenLogin > 0)
{
existenLogin++;
loginUsuario += existenLogin.ToString();
}
item.loginUsuario = loginUsuario;
// se genera la contraseña
item.passwordUsuario = Membership.GeneratePassword(12, 0);
RNGCryptoServiceProvider provider = new RNGCryptoServiceProvider();
byte[] data = new byte[5];
provider.GetBytes(data);
item.passwordSaltUsuario = Convert.ToBase64String(data);
item.passwordHashUsuario = FormsAuthentication.HashPasswordForStoringInConfigFile(item.passwordUsuario + item.passwordSaltUsuario, "SHA1");
}
// agregar rango de nuevos registros
db.Usuario.AddRange(nuevos);
}
// guardo datos y confirmo transacción
db.SaveChanges();
transaction.Commit();
// hay nuevos datos?, si es asi enviamos los correos con las claves de acceso
if (nuevos.Count > 0)
{
foreach (var item in nuevos)
{
bool credencialesEnviadas = false;
credencialesEnviadas = gen.EnviarCorreo(item, 0);
}
}
return gen.EscribirJson(new { message = Mensajes.Guardar, success = true });
}
catch (Exception ex)
{
transaction.Rollback();
return gen.EscribirJson(new { message = string.Format(Mensajes.Error, ex.Message), success = false });
}
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
try
{
// Create new user.
MembershipCreateStatus status;
string Password = GeneratePWD();
MembershipUser newUser = Membership.CreateUser(Email.Text, Password, Email.Text, null, null, true, out status);
//if (!Roles.IsUserInRole("Manager"))
//{
string role = "Manager";
if (!Roles.RoleExists(role))
{
Roles.CreateRole(role);
Roles.AddUserToRole(Email.Text, role);
}
else
{
//Roles.RemoveUserFromRole(Email.Text, role);
Roles.AddUserToRole(Email.Text, role);
}
clsESPSql.ExecNonQuery("update aspnet_Users set pwd='" + Password + "', mobilealias='" + Mobile.Text + "' where username='******'");
try
{
LIBtblOrgBasicInfo objLIBtblOrgBasicInfo = new LIBtblOrgBasicInfo();
DALtblOrgBasicInfo objDALtblOrgBasicInfo = new DALtblOrgBasicInfo();
MyCLS.TransportationPacket tp = new MyCLS.TransportationPacket();
objLIBtblOrgBasicInfo.id = -1;
objLIBtblOrgBasicInfo.username = Email.Text;
objLIBtblOrgBasicInfo.Name = Name.Text;
objLIBtblOrgBasicInfo.Email = Email.Text;
objLIBtblOrgBasicInfo.phone = Mobile.Text;
objLIBtblOrgBasicInfo.designation = Designation.Text;
objLIBtblOrgBasicInfo.OrgName = Orgnaisation.Text;
objLIBtblOrgBasicInfo.industry = Industry.SelectedItem.Text;
objLIBtblOrgBasicInfo.Orglevel = ddlLevel.SelectedValue;
objLIBtblOrgBasicInfo.dt = DateTime.Now.ToShortDateString();
tp.MessagePacket = objLIBtblOrgBasicInfo;
tp = objDALtblOrgBasicInfo.InserttblOrgBasicInfo(tp);
DataTable dt = clsESPSql.ExecQuery("SP_GetManager ");
rptuserlist.DataSource = dt;
rptuserlist.DataBind();
ViewState["dt"] = dt;
}
catch (Exception ex)
{
MyCLS.clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), true);
}
DALCommon cmn = new DALCommon();
string strBody = cmn.prcFindInFile(Server.MapPath("mail.html").ToString(), "#UserName#", Email.Text);
strBody = cmn.prcFindInString(strBody, "#Password#", Password);
cmn.SendHtmlFormattedEmail(Email.Text, "User Created", strBody);
// Response.Redirect("user.aspx", false);
UserName.Text = "";
Email.Text = "";
Mobile.Text = "";
Designation.Text = "";
Orgnaisation.Text = "";
Industry.SelectedIndex = 0;
ddlLevel.SelectedIndex = 0;
lblErrorMessage.Text = "User Created successfully";
lblErrorMessage.ForeColor = System.Drawing.Color.Green;
}
catch (MembershipCreateUserException ex)
{
lblErrorMessage.Text = GetErrorMessage(ex.StatusCode);
}
}
public Membership GetMembershipDetail()
{
try
{
DALuser.Open();
SqlDataReader dr = DbManager.GetDataReader("select * from tblUser_Plan where Member_ID='" + User_Id + "' and ActivationStatus='A'");
bool IsValidate = false;
Membership ObjReturn=null;
IsValidate = dr.HasRows;
if (IsValidate)
{
ObjReturn = new Membership();
ObjReturn.StartDate = Convert.ToDateTime( dr["Start_date"].ToString());
ObjReturn.EndDate = Convert.ToDateTime(dr["End_date"].ToString());
ObjReturn.PlaneID = dr["Plan_Id"].ToString();
}
dr.Close();
DALuser.Close();
return ObjReturn;
}
catch (Exception ex)
{
throw;
}
}
static public string GeneratePassword(int length, int numberOfNonAlphanumericCharacters)
{
return(Membership.GeneratePassword(length, numberOfNonAlphanumericCharacters));
}
public void Authenticate(object sender, AuthenticateEventArgs e)
{
var l = (Login)sender;
e.Authenticated = Membership.ValidateUser(l.UserName, l.Password);
}
public static string GenerateHash(string password, ref string salt)
{
salt = salt ?? Membership.GeneratePassword(5, 1);
return(CalculateHash(password, salt));
}
public string ChangePassword(string oldPassword, string newPassword, string Remarks) // Last update 27-9-13
{
MembershipUser mUser = Membership.GetUser();
string StrMsg = string.Empty;
if (mUser == null)
{
StrMsg = "You are not a valid user";
}
//else if (mUser.LastPasswordChangedDate.AddDays(1) > DateTime.Today)
// StrMsg = "You cannot change the password on the same day";
else
{
// Change 27-9-13
bool IsSCRole = HttpContext.Current.User.IsInRole("SC");
string Pwd = mUser.GetPassword();
if (IsSCRole)
{
if (BPSecurity.ProtectPassword(oldPassword) == Pwd)
{
if (IsPasswordMatchWithLast4(mUser.UserName, BPSecurity.ProtectPassword(newPassword)))
{
StrMsg = "Your Password matches with your Last 4 passwords. Please choose different password.";
}
else if (mUser.ChangePassword(Pwd, BPSecurity.ProtectPassword(newPassword)))
{
UpdatePasswordHisortLog(mUser.UserName, BPSecurity.ProtectPassword(newPassword), Remarks);
StrMsg = "";
}
else
{
StrMsg = "Error !!";
}
}
else
{
StrMsg = "Wrong old Password .";
}
}
else // Added 27-9-13 for other Roles then SC
{
if (oldPassword == Pwd)
{
if (mUser.ChangePassword(Pwd, newPassword))
{
StrMsg = "";
}
else
{
StrMsg = "Error !!";
}
}
else
{
StrMsg = "Wrong oldPassword .";
}
}
}
return(StrMsg);
}
/// <summary>
/// Get Invoice details
/// </summary>
protected void InvoiceDetails()
{
try
{
ClearInvoiceControl();
objsimsinvoice.UserName = Membership.GetUser().UserName;
objsimsinvoice.ProductDivisionId = 18;
objsimsinvoice.YearId = Convert.ToInt32(Ddlyear.SelectedValue);
if (ddlSerContractor.SelectedValue.Equals("0"))
{
spnSoldto.Visible = false;
}
if (!string.IsNullOrEmpty(ddlMonth.SelectedValue) && ddlMonth.SelectedValue != "0")
{
objsimsinvoice.MonthId = Convert.ToInt32(ddlMonth.SelectedValue);
}
else
{
objsimsinvoice.MonthId = DateTime.Now.Month;
ddlMonth.SelectedValue = DateTime.Now.Month.ToString();
}
hdnRawUrl.Value = "yId=" + objsimsinvoice.YearId.ToString() + "&mId=" + objsimsinvoice.MonthId.ToString();
if (!Roles.GetRolesForUser(objCommonMIS.EmpId).Any(x => (x.Contains("SC") || x.Contains("SC_SIMS"))))
{
objsimsinvoice.AscId = Convert.ToInt32(ddlSerContractor.SelectedValue);
objsimsinvoice.RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
objsimsinvoice.BranchId = Convert.ToInt32(ddlBranch.SelectedValue);
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=" + ddlSerContractor.SelectedValue + "|" + ddlRegion.SelectedValue + "|" + ddlBranch.SelectedValue;
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=" + ddlRegion.SelectedItem.Text + "|" + ddlBranch.SelectedItem.Text;
}
else
{
objsimsinvoice.AscId = 0;
objsimsinvoice.RegionId = 0;
objsimsinvoice.BranchId = 0;
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=";
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=";
}
DataSet dsInvoice = objsimsinvoice.GetInvoiceDetails();
if (dsInvoice != null)
{
if (dsInvoice.Tables[1].Rows.Count > 0)
{
lblCustomerName.Text = "<b>" + dsInvoice.Tables[1].Rows[0]["Sc_Name"].ToString() + "</b>";
lblAscAddress.Text = dsInvoice.Tables[1].Rows[0]["Addres"].ToString();
}
if (dsInvoice.Tables[2].Rows.Count > 0)
{
lblInvoiceNo.Text = dsInvoice.Tables[2].Rows[0]["InvoiceNo"].ToString();
lblInvoiceDate.Text = dsInvoice.Tables[2].Rows[0]["InvoiceDt"].ToString();
}
if (dsInvoice.Tables[0].Rows.Count > 0)
{
taxableAmt = Math.Round(Convert.ToDouble(dsInvoice.Tables[0].Compute("Sum(TaxableAmt)", "")), 2);
foreach (DataRow dr in dsInvoice.Tables[0].Rows)
{
if (dr["ActivityParameter_SNo"].ToString().Equals("0"))
{
lblQuanityfd.Text = dr["Quantity"].ToString();
lblfdUnitPrice.Text = dr["UnitPrice"].ToString();
lblfdamount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("953"))
{
lbllcopquantity1.Text = dr["Quantity"].ToString();
lbllcopunitprice1.Text = dr["UnitPrice"].ToString();
lbllcopamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("961"))
{
lbllcopquantity2.Text = dr["Quantity"].ToString();
lbllcopunitprice2.Text = dr["UnitPrice"].ToString();
lbllcopamount2.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("952"))
{
lbllcopgyquantity1.Text = dr["Quantity"].ToString();
lbllcopgyunitprice1.Text = dr["UnitPrice"].ToString();
lbllcopgyamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("960"))
{
lbllcopgyquantity2.Text = dr["Quantity"].ToString();
lbllcopgyunitprice2.Text = dr["UnitPrice"].ToString();
lbllcopgyamount2.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("957"))
{
lblcoquantity1.Text = dr["Quantity"].ToString();
lblcounitprice1.Text = dr["UnitPrice"].ToString();
lblcoamount1.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("958"))
{
lblcoquantity2.Text = dr["Quantity"].ToString();
lblcounitprice2.Text = dr["UnitPrice"].ToString();
lblcoamount2.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("954"))
{
lblcoquantity3.Text = dr["Quantity"].ToString();
lblcounitprice3.Text = dr["UnitPrice"].ToString();
lblcoamount3.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("955"))
{
lblcoquantity4.Text = dr["Quantity"].ToString();
lblcounitprice4.Text = dr["UnitPrice"].ToString();
lblcoamount4.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("956"))
{
lblcoquantity5.Text = dr["Quantity"].ToString();
lblcounitprice5.Text = dr["UnitPrice"].ToString();
lblcoamount5.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("959"))
{
lblFoodProcessorQuantity.Text = dr["Quantity"].ToString();
lblFoodProcessorUnitPrice.Text = dr["UnitPrice"].ToString();
lblFoodProcessorAmount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("964"))
{
lbllocalforoutstationwaterqty.Text = dr["Quantity"].ToString();
lbllocalforoutstationwaterUnitPrice.Text = dr["UnitPrice"].ToString();
lbllocalforoutstationwaterAmount.Text = dr["Amount"].ToString();
}
if (dr["ActivityParameter_SNo"].ToString().Equals("965"))
{
lbllocalforoutstationexptwaterqty.Text = dr["Quantity"].ToString();
lbllocalforoutstationexptwaterUnitPrice.Text = dr["UnitPrice"].ToString();
lbllocalforoutstationexptwaterAmount.Text = dr["Amount"].ToString();
}
}
double totalPrice = Convert.ToDouble(lblfdamount.Text) + Convert.ToDouble(lbllcopamount1.Text) +
Convert.ToDouble(lbllcopamount2.Text) + Convert.ToDouble(lbllcopgyamount1.Text) +
Convert.ToDouble(lbllcopgyamount2.Text) + Convert.ToDouble(lblcoamount1.Text) +
Convert.ToDouble(lblcoamount2.Text) + Convert.ToDouble(lblcoamount3.Text) +
Convert.ToDouble(lblcoamount4.Text) + Convert.ToDouble(lblcoamount5.Text) +
Convert.ToDouble(lbllocalforoutstationwaterAmount.Text) + Convert.ToDouble(lbllocalforoutstationexptwaterAmount.Text) +
Convert.ToDouble(lblFoodProcessorAmount.Text);
lblTotalAmount.Text = totalPrice.ToString("F");
lblTax.Text = taxableAmt.ToString("F"); //Convert.ToString(Math.Round((totalPrice * 12.35) / 100, 2));
lblServiceChargesBracks.Text = "(+) ";
lblServiceChargesBracks.ForeColor = System.Drawing.Color.Green;
chkServicetaxoption.Checked = true;
lblTAmount.Text = (totalPrice + taxableAmt).ToString("F"); //(Math.Round(totalPrice + ((totalPrice * 12.35) / 100), 2)).ToString("F");
tblInvoiceDtls.Visible = true;
tblInvoiceAscdetails.Visible = true;
tblEmptyMessage.Visible = false;
tblPrint.Visible = true;
hdnRawUrl.Value = hdnRawUrl.Value + "&tx=1";
SummaryData();
if (Convert.ToInt32(Ddlyear.SelectedValue) == 2015 && Convert.ToInt32(ddlMonth.SelectedValue) == 12)
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)<br/>Swach Bharat Cess (0.50 % from November 2015)";
}
else if (Convert.ToInt32(Ddlyear.SelectedValue) > 2015)
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)<br/>Swach Bharat Cess (0.50 % from November 2015)";
}
else
{
lblServicetax.Text = "Service Tax (14.00 % from June 2015)";
}
}
else
{
tblInvoiceAscdetails.Visible = false;
tblInvoiceDtls.Visible = false;
tblPrint.Visible = false;
tblEmptyMessage.Visible = true;
lblEmptyMessage.Text = "<b>No record found for this selection.</b>";
}
}
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
public Certification(string certificationId, Membership.User user, string scene, TimeSpan duration)
: this(certificationId, user, scene, duration, DateTime.Now, null)
{
}
protected void Page_Load(object sender, EventArgs e)
{
//string userRole = objCommonClass.GetRolesForUser(Membership.GetUser().UserName.ToString());
objCommonMIS.EmpId = Membership.GetUser().UserName;
if (!Page.IsPostBack)
{
// Bind Year and month
for (int i = DateTime.Now.Year; i >= DateTime.Now.Year - 2; i--)
{
Ddlyear.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
for (int i = 1; i <= 12; i++)
{
ddlMonth.Items.Add(new ListItem(mfi.GetMonthName(i).ToString(), i.ToString()));
}
ddlMonth.Items.Insert(0, new ListItem("Select", "0"));
taxableAmt = 0.00;
if (!Roles.GetRolesForUser(objCommonMIS.EmpId).Any(x => (x.Contains("SC") || x.Contains("SC_SIMS"))))
{
objCommonMIS.BusinessLine_Sno = "2";
objCommonMIS.GetUserRegionsMTS_MTO(ddlRegion);
if (ddlRegion.Items.Count > 0)
{
ddlRegion.SelectedIndex = 0;
}
if (ddlRegion.Items.FindByValue("8").Value.Equals("8"))
{
ListItem lstRegion = ddlRegion.Items.FindByValue("8");
ddlRegion.Items.Remove(lstRegion);
}
objCommonMIS.RegionSno = ddlRegion.SelectedValue;
objCommonMIS.GetUserBranchs(ddlBranch);
objCommonMIS.BranchSno = ddlBranch.SelectedValue;
objCommonMIS.GetUserSCs(ddlSerContractor);
if (ddlSerContractor.Items.Count == 2)
{
ddlSerContractor.SelectedIndex = 1;
}
ddlSerContractor.Visible = false; // Added by Mukesh as on 24 Jun 2015
lblASCShowHide.Visible = false;
TrInvoiceHideShow.Visible = false;
chkServicetaxoption.Visible = false;
lblServiceChargesBracks.Visible = false;
ShowHideInvoiceDate.Visible = false;
SummaryTable.Visible = false;
ClearSearchControl();
}
else
{
UserMaster objUserMaster = new UserMaster();
objUserMaster.BindUseronUserName(Membership.GetUser().UserName.ToString(), "SELECT_USER_BY_USRNAME");
trRB.Visible = false;
ddlSerContractor.Items.Clear();
ddlSerContractor.Items.Add(new ListItem(objUserMaster.Name.ToString()));
ddlSerContractor.SelectedIndex = 0;
ddlSerContractor.Enabled = false;
ddlSerContractor.Visible = true; // Added by Mukesh as on 24 Jun 2015
lblASCShowHide.Visible = true;
TrInvoiceHideShow.Visible = true;
InvoiceDetails();
}
}
}
async public Task<bool> SaveLeague()
{
League.Name = League.Name ?? League.Name.Trim();
League.Sport = League.Sport ?? League.Sport.Trim();
League.CreatedByAthleteId = App.CurrentAthlete.Id;
League.Memberships.Clear();
League.MembershipIds.Clear();
League.OngoingChallenges.Clear();
League.PastChallenges.Clear();
var task = AzureService.Instance.SaveLeague(League);
await RunSafe(task);
if(task.IsFaulted)
return false;
if(!_wasMember && IsMember)
{
var membership = new Membership {
AthleteId = App.CurrentAthlete.Id,
LeagueId = League.Id,
CurrentRank = 0,
};
task = AzureService.Instance.SaveMembership(membership);
await RunSafe(task);
return !task.IsFaulted;
}
return true;
}
protected void imgBtnInsert_Click(object sender, ImageClickEventArgs e)
{
SqlCommand cmd = new SqlCommand();
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB");
con.ConnectionString = ConfigurationManager.ConnectionStrings["PATENTCN"].ConnectionString;
if (FileUpload1.HasFile == false)
{
ClientScript.RegisterStartupScript(GetType(), "Information", "<script>alert('Please select Upload File')</script>");
return;
}
try
{
string sql = "insert into PatentFileDetails (EntryDt,FileNo,FileDescription,FileName,ModifiedDt,Comments,UserName) values (case when @EntryDt='' then null else convert(smalldatetime,@EntryDt,103) end,@FileNo,@FileDescription,@FileName, case when @ModifiedDt='' then null else convert(smalldatetime,@ModifiedDt,103) end,case when @Comments='' then null else @Comments end,@UserName)";
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
Trans = con.BeginTransaction();
cmd.Transaction = Trans;
SqlParameter pm1 = new SqlParameter();
pm1.ParameterName = "@EntryDt";
pm1.SourceColumn = "EntryDt";
pm1.Value = DateTime.Now.ToShortDateString();
pm1.DbType = DbType.String;
pm1.Direction = ParameterDirection.Input;
SqlParameter pm2 = new SqlParameter();
pm2.ParameterName = "@FileNo";
pm2.SourceColumn = "FileNo";
pm2.Value = ddlFileNo.SelectedItem.Text.Trim();
pm2.DbType = DbType.String;
pm2.Direction = ParameterDirection.Input;
string docInfo;
if (ddlDocInfo.SelectedItem.Text.Trim() != "Others")
{
docInfo = ddlDocInfo.SelectedItem.Text.Trim();
}
else
{
docInfo = txtDocInfo.Text.Trim();
}
SqlParameter pm3 = new SqlParameter();
pm3.ParameterName = "@FileDescription";
pm3.SourceColumn = "FileDescription";
pm3.Value = docInfo;
pm3.DbType = DbType.String;
pm3.Direction = ParameterDirection.Input;
string fname = FileUpload1.FileName;
SqlParameter pm4 = new SqlParameter();
pm4.ParameterName = "@FileName";
pm4.SourceColumn = "FileName";
pm4.Value = fname;
pm4.DbType = DbType.String;
pm4.Direction = ParameterDirection.Input;
SqlParameter pm5 = new SqlParameter();
pm5.ParameterName = "@ModifiedDt";
pm5.SourceColumn = "ModifiedDt";
pm5.Value = DateTime.Now.ToShortDateString();
pm5.DbType = DbType.String;
pm5.Direction = ParameterDirection.Input;
SqlParameter pm6 = new SqlParameter();
pm6.ParameterName = "@Comments";
pm6.SourceColumn = "Comments";
pm6.Value = txtComment.Text.Trim();
pm6.DbType = DbType.String;
pm6.Direction = ParameterDirection.Input;
SqlParameter pm7 = new SqlParameter();
pm7.ParameterName = "@UserName";
pm7.SourceColumn = "UserName";
pm7.Value = Membership.GetUser().UserName.ToString();
pm7.DbType = DbType.String;
pm7.Direction = ParameterDirection.Input;
cmd.Parameters.Add(pm1);
cmd.Parameters.Add(pm2);
cmd.Parameters.Add(pm3);
cmd.Parameters.Add(pm4);
cmd.Parameters.Add(pm5);
cmd.Parameters.Add(pm6);
cmd.Parameters.Add(pm7);
cmd.ExecuteNonQuery();
try
{
HttpPostedFile file1 = FileUpload1.PostedFile;
Int32 fileLength = file1.ContentLength;
string fileName = file1.FileName;
byte[] buffer = new byte[fileLength];
file1.InputStream.Read(buffer, 0, fileLength);
FileStream newFile;
string strPath = @"F:\PatentDocument\" + ddlFileNo.SelectedItem.Text.Trim() + @"\";
if (!Directory.Exists(strPath))
{
Directory.CreateDirectory(strPath);
}
if (!File.Exists(strPath + fname))
{
newFile = File.Open(strPath + fname, FileMode.Create);
newFile.Write(buffer, 0, buffer.Length);
newFile.Close();
}
else
{
ClientScript.RegisterStartupScript(GetType(), "Information", "<script>alert('This File exists in this Folder')</script>");
Trans.Rollback();
con.Close();
return;
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Error", "<script>alert('" + ex.Message.ToString() + "')</script>");
Trans.Rollback();
con.Close();
return;
}
ClientScript.RegisterStartupScript(GetType(), "Success", "<script>alert('This Record successfully added')</script>");
Trans.Commit();
con.Close();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "Error", "<script>alert('" + ex.Message.ToString() + "')</script>");
Trans.Rollback();
con.Close();
return;
}
imgBtnClear_Click(sender, e);
}
public bool DoPasswordsMatchForCustomer(string trialpassword, Membership.CustomerAccount u)
{
return u.Password.Equals(u.EncryptPassword(trialpassword), StringComparison.InvariantCulture);
}
/// <summary>
/// Creates the facebook user
/// </summary>
/// <param name="facebookUser">
/// The facebook user.
/// </param>
/// <param name="userGender">
/// The user gender.
/// </param>
/// <param name="message">
/// The message.
/// </param>
/// <returns>
/// Returns if the login was successfully or not
/// </returns>
private static bool CreateFacebookUser(FacebookUser facebookUser, int userGender, out string message)
{
if (YafContext.Current.Get <BoardSettings>().DisableRegistrations)
{
message = YafContext.Current.Get <ILocalization>().GetText("LOGIN", "SSO_FAILED");
return(false);
}
// Check user for bot
var isPossibleSpamBot = false;
var userIpAddress = YafContext.Current.Get <HttpRequestBase>().GetUserRealIPAddress();
// Check content for spam
if (YafContext.Current.Get <ISpamCheck>().CheckUserForSpamBot(facebookUser.UserName, facebookUser.Email, userIpAddress, out var result))
{
YafContext.Current.Get <ILogger>().Log(
null,
"Bot Detected",
$"Bot Check detected a possible SPAM BOT: (user name : '{facebookUser.UserName}', email : '{facebookUser.Email}', ip: '{userIpAddress}', reason : {result}), user was rejected.",
EventLogTypes.SpamBotDetected);
if (YafContext.Current.Get <BoardSettings>().BotHandlingOnRegister.Equals(1))
{
// Flag user as spam bot
isPossibleSpamBot = true;
}
else if (YafContext.Current.Get <BoardSettings>().BotHandlingOnRegister.Equals(2))
{
message = YafContext.Current.Get <ILocalization>().GetText("BOT_MESSAGE");
if (!YafContext.Current.Get <BoardSettings>().BanBotIpOnDetection)
{
return(false);
}
YafContext.Current.GetRepository <BannedIP>()
.Save(
null,
userIpAddress,
$"A spam Bot who was trying to register was banned by IP {userIpAddress}",
YafContext.Current.PageUserID);
// Clear cache
YafContext.Current.Get <IDataCache>().Remove(Constants.Cache.BannedIP);
if (YafContext.Current.Get <BoardSettings>().LogBannedIP)
{
YafContext.Current.Get <ILogger>()
.Log(
null,
"IP BAN of Bot During Registration",
$"A spam Bot who was trying to register was banned by IP {userIpAddress}",
EventLogTypes.IpBanSet);
}
return(false);
}
}
var memberShipProvider = YafContext.Current.Get <MembershipProvider>();
var pass = Membership.GeneratePassword(32, 16);
var securityAnswer = Membership.GeneratePassword(64, 30);
var user = memberShipProvider.CreateUser(
facebookUser.UserName,
pass,
facebookUser.Email,
memberShipProvider.RequiresQuestionAndAnswer ? "Answer is a generated Pass" : null,
memberShipProvider.RequiresQuestionAndAnswer ? securityAnswer : null,
true,
null,
out var status);
// setup initial roles (if any) for this user
RoleMembershipHelper.SetupUserRoles(YafContext.Current.PageBoardID, facebookUser.UserName);
// create the user in the YAF DB as well as sync roles...
var userID = RoleMembershipHelper.CreateForumUser(user, YafContext.Current.PageBoardID);
// create empty profile just so they have one
var userProfile = YafUserProfile.GetProfile(facebookUser.UserName);
// setup their initial profile information
userProfile.Save();
userProfile.Facebook = facebookUser.ProfileURL;
userProfile.FacebookId = facebookUser.UserID;
userProfile.Homepage = facebookUser.ProfileURL;
if (facebookUser.Birthday.IsSet())
{
var ci = CultureInfo.CreateSpecificCulture("en-US");
DateTime.TryParse(facebookUser.Birthday, ci, DateTimeStyles.None, out var userBirthdate);
if (userBirthdate > DateTimeHelper.SqlDbMinTime().Date)
{
userProfile.Birthday = userBirthdate;
}
}
userProfile.RealName = facebookUser.Name;
userProfile.Gender = userGender;
if (facebookUser.Location != null && facebookUser.Location.Name.IsSet())
{
userProfile.Location = facebookUser.Location.Name;
}
if (YafContext.Current.Get <BoardSettings>().EnableIPInfoService)
{
var userIpLocator = YafContext.Current.Get <IIpInfoService>().GetUserIpLocator();
if (userIpLocator != null)
{
userProfile.Country = userIpLocator["CountryCode"];
}
}
userProfile.Save();
// setup their initial profile information
userProfile.Save();
if (userID == null)
{
// something is seriously wrong here -- redirect to failure...
message = YafContext.Current.Get <ILocalization>().GetText("LOGIN", "SSO_FAILED");
return(false);
}
if (YafContext.Current.Get <BoardSettings>().NotificationOnUserRegisterEmailList.IsSet())
{
// send user register notification to the following admin users...
YafContext.Current.Get <ISendNotification>().SendRegistrationNotificationEmail(user, userID.Value);
}
if (isPossibleSpamBot)
{
YafContext.Current.Get <ISendNotification>().SendSpamBotNotificationToAdmins(user, userID.Value);
}
// send user register notification to the user...
YafContext.Current.Get <ISendNotification>()
.SendRegistrationNotificationToUser(user, pass, securityAnswer, "NOTIFICATION_ON_FACEBOOK_REGISTER");
// save the time zone...
var userId = UserMembershipHelper.GetUserIDFromProviderUserKey(user.ProviderUserKey);
var autoWatchTopicsEnabled = YafContext.Current.Get <BoardSettings>().DefaultNotificationSetting
== UserNotificationSetting.TopicsIPostToOrSubscribeTo;
YafContext.Current.GetRepository <User>().Save(
userId,
YafContext.Current.PageBoardID,
facebookUser.UserName,
facebookUser.UserName,
facebookUser.Email,
TimeZoneInfo.Local.Id,
null,
null,
null,
null,
null,
YafContext.Current.Get <BoardSettings>().DefaultNotificationSetting,
autoWatchTopicsEnabled,
TimeZoneInfo.Local.SupportsDaylightSavingTime,
null,
null);
// save the settings...
YafContext.Current.GetRepository <User>().SaveNotification(
userId,
true,
autoWatchTopicsEnabled,
YafContext.Current.Get <BoardSettings>().DefaultNotificationSetting,
YafContext.Current.Get <BoardSettings>().DefaultSendDigestEmail);
// save avatar
YafContext.Current.GetRepository <User>().SaveAvatar(
userId,
$"https://graph.facebook.com/v3.3/{facebookUser.UserID}/picture",
null,
null);
YafContext.Current.Get <IRaiseEvent>().Raise(new NewUserRegisteredEvent(user, userId));
SingleSignOnUser.LoginSuccess(AuthService.facebook, user.UserName, userId, true);
message = string.Empty;
return(true);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
#region Declaration of Local Variables
int siteid, priorityid;
int SLAid = 0;
int createdbyid = 0;
int requesterid = 0;
int FlagInsert;
int requesttypeid;
string userName;
bool FlagUserStatus;
FlagUserStatus = true;
FlagInsert = 0;
#endregion
#region Fetch Current User
MembershipUser User = Membership.GetUser();
userName = User.UserName.ToString();
#endregion
#region Get Current Site and Priority id
siteid = Convert.ToInt16(drpSite.SelectedValue);
priorityid = Convert.ToInt16(drpPriority.SelectedValue);
#endregion
#region Get SLAid on the basis of siteid and Priority id
if (siteid != 0 && priorityid != 0)
{
SLAid = objIncident.Get_By_SLAid(siteid, priorityid);
requesttypeid = Convert.ToInt16(Resources.MessageResource.strRequestTypeId.ToString());
if (requesttypeid == Convert.ToInt16(drpRequestType.SelectedValue))
{
SLAid = 0;
}
}
#endregion
if (userName != "")
{
#region Find Userid of User who Created this Request
objOrganization = objOrganization.Get_Organization();
objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);
if (objUser.Userid != 0)
{
createdbyid = objUser.Userid;
}
#endregion
#region Find Userid of User who is Requesting to log a call
#region If User Already Exist
if (Session["UserCreate"].ToString() == "Exist")
{
objUser = objUser.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
if (objUser.Userid != 0)
{
requesterid = objUser.Userid;
}
}
#endregion
#region If New User is to be Created
else if (Session["UserCreate"].ToString() == "create")
{
string varEmail = "";
string varRoleName = Resources.MessageResource.BasicUserRole.ToString();
if (txtEmail.Text == "")
{
varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString();
}
else
{
varEmail = txtEmail.Text;
}
int roleid = objRole.Get_By_RoleName(varRoleName);
int status;
objOrganization = objOrganization.Get_Organization();
UserLogin_mst objUserLogin = new UserLogin_mst();
objUserLogin.Username = txtUsername.Text.Trim().ToString();
objUserLogin.Password = Resources.MessageResource.strDefaultPassword.ToString();
objUserLogin.Roleid = roleid;
objUserLogin.Orgid = objOrganization.Orgid;
objUserLogin.ADEnable = false;
objUserLogin.Enable = true;
objUserLogin.Createdatetime = DateTime.Now.ToString();
status = objUserLogin.Insert();
if (status == 1)
{
// Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database
MembershipCreateStatus Mstatus = default(MembershipCreateStatus);
// Call Membership.CreateUser function to create Membership user
Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus);
// Call Roles.AddUserToRole Function to Add User To Role
Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName);
// Declare Local Variable Userid to fetch userid of newly created user
// Create Object objUserLogin of UserLogin_mst()Class
objUserLogin = new UserLogin_mst();
// Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName
requesterid = objUserLogin.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid);
// If userid not equal to 0 then we get userid of Newly created user otherwise error Occured
ContactInfo_mst objContactInfo = new ContactInfo_mst();
objContactInfo.Userid = requesterid;
objContactInfo.Emailid = varEmail;
objContactInfo.Firstname = txtUsername.Text.ToString();
objContactInfo.Lastname = txtUsername.Text.ToString();
objContactInfo.Insert();
}
}
#endregion
#region If User is Not to be Created
else if (Session["UserCreate"].ToString() == "notcreate")
{
FlagUserStatus = false;
}
#endregion
#endregion
}
objIncident.Title = txtTitle.Text.Trim();
//objIncident.Title = drpTitle.SelectedItem.Text;
objIncident.Slaid = SLAid;
objIncident.Createdbyid = createdbyid;
objIncident.Requesterid = requesterid;
objIncident.Siteid = siteid;
objIncident.Description = txtDescription.Text.ToString().Trim();
objIncident.Deptid = Convert.ToInt16(drpDepartment.SelectedValue);
objIncident.Createdatetime = DateTime.Now.ToString();
IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true);
String datetime = txtReportedDate.Text.Trim();
DateTime dt = DateTime.Parse(datetime, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
//changed by prachi
//objIncident.Reporteddatetime = dt.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
DateTime dtNowForTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, Convert.ToInt32(drpTimeHours.SelectedItem.Text), Convert.ToInt32(drpTimeMin.SelectedItem.Text), 0);
//end prachi
objIncident.Reporteddatetime = dt.ToShortDateString() + " " + dtNowForTime.ToShortTimeString();
objIncident.Modeid = Convert.ToInt16(drpMode.SelectedValue);
//objIncident.ExternalTicketNo = txtExternalTicket.Text.ToString().Trim();
if (FlagUserStatus == true)
{
FlagInsert = objIncident.Insert();
#region Save Assetid and incident id in incidenttoassetmaaping
// Get Asset and Incident Id for incidenttoassetmaaping
objOrganization = objOrganization.Get_Organization();
objUser = objUser.Get_UserLogin_By_UserName(txtUsername.Text.Trim().ToString().Trim(), objOrganization.Orgid);
int userid = Convert.ToInt16(objUser.Userid);
int tempuser1 = Convert.ToInt16(Session["tempuser1"]);
if (tempuser1 == 1)
{
assetid = Convert.ToInt16(Session["assetid"]);
}
else
{
assetid = Convert.ToInt16(objusertoasset.Get_AssetId_By_UserId(userid));
}
int incid = Convert.ToInt16(objIncident.Get_TopIncidentId());
//if (txtassignasset.Text != "")
{
//assetid = Convert.ToInt16(txtassignasset.Text);
if (assetid != 0)
{
objincidenttoasset.Insert(incid, assetid);
objusertoasset.Insert(userid, assetid);
Session.Abandon();
}
}
#endregion
}
if (FlagInsert == 1)
{
int FlagIncdStatesInsert;
int incidentid;
incidentid = objIncident.Get_Current_Incidentid();
objIncidentStates.Incidentid = incidentid;
objIncidentStates.Priorityid = Convert.ToInt16(drpPriority.SelectedValue);
objIncidentStates.Categoryid = Convert.ToInt16(drpCategory.SelectedValue);
objIncidentStates.Statusid = Convert.ToInt16(drpStatus.SelectedValue);
objIncidentStates.Subcategoryid = Convert.ToInt16(drpSubcategory.SelectedValue);
objIncidentStates.Technicianid = Convert.ToInt16(drpTechnician.SelectedValue);
if (Convert.ToInt16(drpTechnician.SelectedValue) != 0)
{
objIncidentStates.AssignedTime = DateTime.Now.ToString();
}
objIncidentStates.Requesttypeid = Convert.ToInt16(drpRequestType.SelectedValue);
FlagIncdStatesInsert = objIncidentStates.Insert();
if (FlagIncdStatesInsert == 1)
{
objIncidentHistory.Incidentid = incidentid;
objIncidentHistory.Operation = "create";
objIncidentHistory.Operationownerid = createdbyid;
objIncidentHistory.Insert();
objSentmailtoUser.SentmailUser(requesterid, incidentid, "open");
if (Convert.ToInt16(drpTechnician.SelectedValue) != 0)
{
objSentmailtoUser.SentmailTechnician(Convert.ToInt16(drpTechnician.SelectedValue), incidentid);
}
////////////////////Added by lalit 28nov to /////////////////////////////////////////////////////
if (Session["id"] != null)
{
int id = Convert.ToInt32(Session["id"].ToString());
SqlConnection con;
SqlCommand cmd;
string connection = ConfigurationManager.ConnectionStrings["CSM_DB"].ConnectionString;
con = new SqlConnection(connection);
cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandText = "update storemail set IsActive=2 where id='" + id + "'";
cmd.ExecuteNonQuery();
}
Response.Redirect("~/Incident/IncidentRequestUpdate.aspx?" + incidentid + "");
}
}
}
protected void lnkDownload_Click(object sender, EventArgs e)
{
try
{
objSticker.EmpCode = Membership.GetUser().UserName;
objSticker.SortingOrder = "Region_desc Asc";
objSticker.AscId = AscId;
objSticker.ConsumptionStatus = Convert.ToInt32(ddlConsumptionStatus.SelectedValue);
objSticker.ComplaintRefNo = "";
objSticker.StickerCode = "";
objSticker.ActiveStatus = Convert.ToInt32(ddlActiveStatus.SelectedValue);
if (ddlConsumptionStatus.SelectedIndex == 1)
{
objSticker.ProductDivisionSno = 0;
}
else
{
objSticker.ProductDivisionSno = Convert.ToInt32(ddlProductDivision.SelectedValue);
}
if (Roles.IsUserInRole(Membership.GetUser().UserName, "SC") || Roles.IsUserInRole(Membership.GetUser().UserName, "SC_SIMS"))
{
objSticker.Type = "DOWNLAODRPTBYASC";
}
else
{
objSticker.Type = "DOWNLAODRPTBYOTHERS";
objSticker.RegionSno = Convert.ToInt32(ddlRegion.SelectedValue);
objSticker.BranchSno = Convert.ToInt32(ddlBranches.SelectedValue);
objSticker.AscId = Convert.ToInt32(ddlAsc.SelectedValue);
}
GridView grdDownlaod = new GridView();
objSticker.BindAscStickerDetails(grdDownlaod);
Response.Clear();
Response.ClearContent();
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "attachment; filename=StickerDetails.xls");
grdDownlaod.RenderControl(new HtmlTextWriter(Response.Output));
Response.Flush();
Response.End();
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
public bool UpdateCustomer(Membership.CustomerAccount u, ref CreateUserStatus status)
{
bool result = false;
if (u != null)
{
Membership.CustomerAccount testUser = new Membership.CustomerAccount();
testUser = Customers.FindByEmail(u.Email);
if (testUser != null && testUser.Bvin != string.Empty)
{
if (testUser.Bvin != u.Bvin)
{
status = CreateUserStatus.DuplicateUsername;
return false;
}
}
if (Customers.Update(u) == true)
{
result = true;
status = CreateUserStatus.Success;
}
else
{
status = CreateUserStatus.UpdateFailed;
}
}
return result;
}
/// <summary>
/// User requests login to the system. This method attempts to authenticate the player (or create a new account, depending on method parms)
/// </summary>
public void DoDatabaseLogin(INetworkConnection con, Packet pMsg)
{
PacketLoginRequest p = pMsg as PacketLoginRequest;
ServerUser.AccountName = p.AccountName;
Log1.Logger("Zeus").Info("User " + p.AccountName + " from " + RemoteIP + " is attempting login...");
string msg = "";
#if DEBUG
DateTime start = DateTime.Now;
#endif
bool isLocal = IsLocalConnection();
bool hasAccountAccess = isLocal || Membership.ValidateUser(p.AccountName, p.Password);
#if DEBUG
DateTime end = DateTime.Now;
TimeSpan len = end - start;
Log1.Logger("Zeus").Debug("DB call to validate user took " + len.TotalSeconds.ToString() + " seconds.");
#endif
if (!hasAccountAccess)
{
PacketLoginResult lrf = (PacketLoginResult)CreatePacket((int)PacketType.LoginResult, 0, true, true);
lrf.IsCritical = true; // this along with reply code failure forces D/C
lrf.ReplyCode = ReplyType.Failure;
lrf.ReplyMessage = string.Format("Authentication Failed. No account matching these credentials was found. Goodbye.");
pMsg.ReplyPacket = lrf;
Log1.Logger("Zeus").Info(p.AccountName + ": " + lrf.ReplyMessage);
return;
}
MembershipUser usr = Membership.GetUser(p.AccountName, true);
if (usr == null && isLocal)
{
usr = new MembershipUser("CustomizedMembershipProvider", Environment.MachineName + "\\" + Environment.UserName, Guid.NewGuid(), "", "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.MinValue);
}
ServerUser.ID = (Guid)usr.ProviderUserKey;
// Cache this user's profile data
ServerUser.Profile.Load(MyServer.RequireAuthentication);
if (isLocal)
{
ServerUser.Profile.UserRoles = new string[] { "Administrator" };
}
// check if suspension needs to be lifted
DateTime suspensionRelease = ServerUser.Profile.AddedProperties.GetDateTimeProperty("SuspensionRelease").GetValueOrDefault(DateTime.MinValue);
bool isSuspended = false;
if (suspensionRelease != DateTime.MinValue)
{
isSuspended = true;
// currently suspended. need to lift suspension?
if (suspensionRelease < DateTime.UtcNow)
{
DB.Instance.User_Unsuspend(ServerUser.ID, "System", suspensionRelease, "Suspension expired. Time served.", -1);
isSuspended = false;
}
}
if (isSuspended && !ServerUser.Profile.IsUserInRole("Administrator"))
{
PacketLoginResult lrf = (PacketLoginResult)CreatePacket((int)PacketType.LoginResult, 0, true, true);
lrf.IsCritical = true; // this along with reply code failure forces D/C
lrf.ReplyCode = ReplyType.Failure;
lrf.ReplyMessage = "[" + p.AccountName + "] is currently suspended until " + suspensionRelease.ToString("g") + " UTC. Access to Zeus is denied.";
pMsg.ReplyPacket = lrf;
Log1.Logger("LoginServer.Inbound.Login").Info(lrf.ReplyMessage);
return;
}
bool accountIsActive = isLocal || ServerUser.Profile.IsUserInRole("ActiveCustomerService");
if (!accountIsActive)
{
PacketLoginResult lrf = (PacketLoginResult)CreatePacket((int)PacketType.LoginResult, 0, true, true);
lrf.IsCritical = true; // this along with reply code failure forces D/C
lrf.ReplyCode = ReplyType.Failure;
lrf.ReplyMessage = "Authentication Failed. This account does not have the proper credential to connect. Goodbye.";
pMsg.ReplyPacket = lrf;
Log1.Logger("Zeus.Inbound.Client.Login").Info(p.AccountName + ": " + lrf.ReplyMessage);
return;
}
PacketLoginResult result = CreateLoginResultPacket();
if (result.ReplyCode == ReplyType.OK)
{
ServerUser.AuthTicket = Guid.NewGuid();
ServerUser.IsAuthenticated = true;
ServerUser.ID = (Guid)usr.ProviderUserKey;
ConnectionManager.AuthorizeUser(ServerUser, false);
result.Parms.SetProperty(-1, ServerUser.Profile.UserRoles);
result.Parms.SetProperty(-2, ServerUser.Profile.MaxCharacters);
result.Parms.SetProperty((int)PropertyID.Name, MyServer.ServerUserID);
LoggedInAndReady();
}
pMsg.ReplyPacket = result;
Log1.Logger("Zeus").Info("Zeus client *" + ServerUser.AccountName + "* authentication: " + result.ReplyCode.ToString() + ". " + result.ReplyMessage);
}
public bool ApplyToOrder(MerchantTribeApplication app,
Orders.Order o,
Membership.CustomerAccount currentCustomer,
DateTime currentDateTimeUtc,
PromotionActionMode mode)
{
if (app == null) return false;
if (o == null) return false;
if (currentDateTimeUtc == null) return false;
PromotionContext context = new PromotionContext(app, o, currentCustomer, currentDateTimeUtc);
context.CustomerDescription = this.CustomerDescription;
// Make sure we have an active promotion before applying
if (GetStatus(context.CurrentDateAndTimeUtc) != PromotionStatus.Active) return false;
// Make sure we meet all requirements
// NOTE: we order by processing cost which should allow us to check
// the fastest items first. For example, checking userID is faster
// than checking user group because ID is in the context and group
// requires a database call.
foreach (IPromotionQualification q in this._Qualifications.OrderBy(y => y.ProcessingCost))
{
if (!q.MeetsQualification(context)) return false;
}
// We're qualified, do actions
foreach (IPromotionAction a in this._Actions)
{
a.ApplyAction(context, mode);
}
return true;
}
private IEnumerable <DiscountProduct> GetAllForProductAndCurrentUser(int productId, ILocalization localization)
{
return(GetAll(localization).Where(discount => discount.IsActive && discount.Products.Any(x => x.Id == productId) && (!discount.MemberGroups.Any() || Membership.GetUser() != null && discount.MemberGroups.Intersect(Roles.GetRolesForUser(Membership.GetUser().UserName)).Any())));
}
