public bool SaveSiteUsers(string username, string firstname, string lastname, string email, string address, string city, string state, string country, string createdby, Guid creatorid, string password)
{
dbContext = new MyProjectDataContext();
SiteUser su = new SiteUser();
su.Address = address;
su.City = city;
su.Country = country;
su.CreatedBy = createdby;
su.CreatedOn = DateTime.Now;
su.CreatorId = creatorid;
su.Email = email;
su.FirstName = firstname;
su.IsDeleted = false;
su.IsRejected = false;
su.Lastname = lastname;
su.Password = password;
su.State = state;
su.UpdatedOn = DateTime.Now;
su.Username = username;
try
{
dbContext.SiteUsers.InsertOnSubmit(su);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
return(false);
}
public bool UpdateAdmin(Guid userid, string img_path, string username, string firstname, string lastname, string address, string city, string state, string country)
{
dbContext = new MyProjectDataContext();
var q = from a in dbContext.AdminProfiles
where a.UserId == userid
select a;
if (q.Any())
{
AdminProfile ap = new AdminProfile();
ap.Address = address;
ap.City = city;
ap.Country = country;
ap.FirstName = firstname;
ap.LastName = lastname;
ap.State = state;
ap.Updated = DateTime.Now;
ap.UpdatedBy = username;
ap.UserId = userid;
ap.UserImgPath = img_path;
ap.Username = username;
try
{
dbContext.AdminProfiles.InsertOnSubmit(ap);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
return(false);
}
public bool AddAdmin(Guid userid, string username)
{
dbContext = new MyProjectDataContext();
string imgPath = "~/admin/dist/img/male-user.png";
AdminProfile ap = new AdminProfile();
ap.UserId = userid;
ap.Username = username;
ap.Created = DateTime.Now;
ap.Updated = DateTime.Now;
ap.UpdatedBy = username;
ap.UserImgPath = imgPath;
ap.Rejected = false;
try
{
dbContext.AdminProfiles.InsertOnSubmit(ap);
dbContext.SubmitChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
public bool ActivateAccount(Guid key)
{
MyProjectDataContext dbContext = new MyProjectDataContext();
ActivateUser act = new ActivateUser();
var q = from a in dbContext.ActivateUsers
where a.ActivationKey == key
select a;
foreach (var a in q)
{
a.IsActivated = true;
// a.IsExpired = true;
try
{
dbContext.ActivateUsers.InsertOnSubmit(act);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
return(false);
}
public string Register_Success(UserModel model)
{
if (model != null)
{
Membership m = new Membership();
m.Password = model.Password;
m.UserId = model.UserId;
m.PasswordFailedAttempt = model.PasswordFailedAttempt;
m.Role = model.Role;
m.isSuperAdmin = model.isSuperAdmin;
m.isRejected = model.isRejected;
db.Memberships.InsertOnSubmit(m);
db.SubmitChanges();
return(Constants.SUCCESS);
}
else
{
return(Constants.ERROR);
}
}
public bool Save(string dbname, int websiteid, string websitename, Guid userid, string username)
{
DatabaseDetail dbdetail = new DatabaseDetail();
dbdetail.CreatedBy = username;
dbdetail.CreatedOn = DateTime.Now;
dbdetail.DatabaseName = dbname;
dbdetail.DbForWebsiteId = websiteid;
dbdetail.UpdatedOn = DateTime.Now;
dbdetail.UserId = userid;
dbdetail.Username = username;
dbdetail.WebsiteName = websitename;
try
{
dbContext.DatabaseDetails.InsertOnSubmit(dbdetail);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool SaveActivationKey(Guid userid, Guid key)
{
MyProjectDataContext dbContext = new MyProjectDataContext();
ActivateUser act = new ActivateUser();
act.ActivationKey = key;
act.Created = DateTime.Now;
act.IsActivated = false;
act.IsExpired = false;
act.UserId = userid;
try
{
dbContext.ActivateUsers.InsertOnSubmit(act);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//[ScriptMethod(UseHttpGet = false)]
public static string delete(Guid userid, string websitename, string username)
{
string msg;
// Response.Write(userid);
// Response.Write(websitename);
msg = "Hello";
// datalayer dl = new datalayer();
MyProjectDataContext da = new MyProjectDataContext();
var q = from a in da.Websites
where a.UserId == userid && a.WebsiteName == websitename
select a;
int websiteid = GetWebsiteId(userid, username, websitename);
var q1 = from b in da.WebsitePages
where b.WebsiteId == websiteid
select b;
foreach (var o in q1)
{
da.WebsitePages.DeleteOnSubmit(o); // removing foreign key references
}
foreach (var o in q)
{
da.Websites.DeleteOnSubmit(o);
}
try
{
da.SubmitChanges();
msg = "success";
}
catch
{
msg = "error";
}
// msg=dl.Delete_Website(userid, websitename);
return(msg);
}
public void DoRegistration(string username, string email, string pass)
{
Registration rg = new Registration();
rg.name = username;
rg.email = email;
// rg.password = pass;
da.Registrations.InsertOnSubmit(rg);
da.SubmitChanges();
}
//[ScriptMethod(UseHttpGet = false)]
public static string delete(Guid userid, string websitename, string username)
{
string msg;
// Response.Write(userid);
// Response.Write(websitename);
msg = "Hello";
// datalayer dl = new datalayer();
MyProjectDataContext da = new MyProjectDataContext();
var q = from a in da.Websites
where a.UserId == userid && a.WebsiteName == websitename
select a;
int websiteid = GetWebsiteId(userid, username, websitename);
var q1 = from b in da.WebsitePages
where b.WebsiteId == websiteid
select b;
foreach (var o in q1)
{
da.WebsitePages.DeleteOnSubmit(o); // removing foreign key references
}
foreach (var o in q)
{
da.Websites.DeleteOnSubmit(o);
}
try
{
//deleting name from drop down
web_design_CreateWebsite ob = new web_design_CreateWebsite();
ob.bind_website_ddl();
//ob.ddl_select_website.Items.Remove(websitename);
//--------------------------
//deleting website folder and files
string subPath = "~/web-design/" + username + "/" + websitename + "/";
System.Web.UI.Page p = new System.Web.UI.Page(); //creating instance of object
bool exists = System.IO.Directory.Exists(p.Server.MapPath(subPath));
if (exists)
{
System.IO.Directory.Delete(p.Server.MapPath(subPath), true);
}
//deleting db
DatabaseManagement dbManage = new DatabaseManagement();
dbManage.DeleteDatabaseByWebsiteName(userid, websitename, username);
// end-------------
da.SubmitChanges();
msg = "success";
}
catch
{
msg = "error";
}
// msg=dl.Delete_Website(userid, websitename);
return(msg);
}
