//[AuthorizeRoles("Admin")]
public ActionResult GetoutbondData(string id_outbond)
{
Console.WriteLine("outbondData Triggered, Fetching for id_outbond " + id_outbond);
outbond outbond;
try
{
using (DemoEntities1 db = new DemoEntities1())
{
int MID = int.Parse(id_outbond);
outbond = db.outbonds.Where(o => o.id_outbond.Equals(MID))?.FirstOrDefault();
}
return(Json(new
{
success = true,
harga = outbond.harga
}));
}
catch (Exception ex)
{
return(Json(new
{
success = false
}));
}
return(Json(new
{
success = false
}));
}
public UserProfileView GetUserProfile(int userID)
{
UserProfileView UPV = new UserProfileView();
using (DemoEntities1 db = new DemoEntities1())
{
var user = db.SYSUsers.Find(userID);
if (user != null)
{
UPV.SYSUserID = user.SYSUserID;
UPV.LoginName = user.LoginName;
UPV.Password = user.PasswordEncryptedText;
var SUP = db.SYSUserProfiles.Find(userID);
if (SUP != null)
{
UPV.FirstName = SUP.FirstName;
UPV.LastName = SUP.LastName;
UPV.Gender = SUP.Gender;
}
var SUR = db.SYSUserRoles.Find(userID);
if (SUR != null)
{
UPV.LOOKUPRoleID = SUR.LOOKUPRoleID;
UPV.RoleName = SUR.LOOKUPRole.RoleName;
UPV.IsRoleActive = SUR.IsActive;
}
}
}
return(UPV);
}
public bool IsUserInRole(string loginName, string roleName)
{
using (DemoEntities1 db = new DemoEntities1())
{
SYSUser SU = db.SYSUsers.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault();
if (SU != null)
{
var roles = from q in db.SYSUserRoles
join r in db.LOOKUPRoles on q.LOOKUPRoleID equals r.LOOKUPRoleID
where r.RoleName.Equals(roleName) && q.SYSUserID.Equals(SU.SYSUserID)
select r.RoleName;
if (roles != null)
{
return(roles.Any());
}
else
{
if (roleName == "null")
{
return(true);
}
}
}
return(false);
}
}
public bool IsLoginNameExist(string loginName)
{
using (DemoEntities1 db = new DemoEntities1())
{
return(db.SYSUsers.Where(o => o.LoginName.Equals(loginName)).Any());
}
}
public void Update(MT_SellOut entity, params Expression <Func <T, object> >[] updatedProperties)
{
using (var ctx = new DemoEntities1())
{
ctx.MT_SellOut.Attach(entity);
var entry = ctx.Entry(entity);
entry.Property(e => e.Perform).IsModified = true;
entry.Property(e => e.Rate).IsModified = true;
ctx.SaveChanges();
}
//if (updatedProperties.Any())
//{
// foreach (var property in updatedProperties)
// {
// entry.Property(property).IsModified = true;
// db.SaveChanges();
// }
//}
//else
//{
// foreach (var property in entry.OriginalValues.PropertyNames)
// {
// var original = entry.OriginalValues.GetValue<object>(property);
// var current = entry.CurrentValues.GetValue<object>(property);
// if (original != null && !original.Equals(current))
// entry.Property(property).IsModified = true;
// }
//}
//var dbEntityEntry = db.Entry(entity);
}
//[AuthorizeRoles("Admin")]
public ActionResult DeleteOrder(int orderID)
{
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContext = db.Database.BeginTransaction())
{
try
{
var or = db.laporans.Where(o => o.id_laporan.Equals(orderID));
if (or.Any())
{
db.laporans.Remove(or.FirstOrDefault());
db.SaveChanges();
}
dbContext.Commit();
}
catch (Exception ex)
{
dbContext.Rollback();
}
}
}
return(Json(new { success = true }));
}
public UserDataView GetUserDataView(string loginName)
{
UserDataView UDV = new UserDataView();
List <UserProfileView> profiles = GetAllUserProfiles();
List <LOOKUPAvailableRole> roles = GetAllRoles();
int? userAssignedRoleID = 0, userID = 0;
string userGender = string.Empty;
userID = GetUserID(loginName);
using (DemoEntities1 db = new DemoEntities1())
{
userAssignedRoleID = db.SYSUserRoles.Where(o => o.SYSUserID == userID)?.FirstOrDefault().LOOKUPRoleID;
userGender = db.SYSUserProfiles.Where(o => o.SYSUserID == userID)?.FirstOrDefault().Gender;
}
List <Gender> genders = new List <Gender>();
genders.Add(new Gender {
Text = "Male", Value = "M"
});
genders.Add(new Gender {
Text = "Female", Value = "F"
});
UDV.UserProfile = profiles;
UDV.UserRoles = new UserRoles {
SelectedRoleID = userAssignedRoleID, UserRoleList = roles
};
UDV.UserGender = new UserGender {
SelectedGender = userGender, Gender = genders
};
return(UDV);
}
public void Addoutbond(addoutbondView m)
{
using (DemoEntities1 db = new DemoEntities1())
{
outbond mn = new outbond();
mn.harga = m.harga;
mn.keterangan = m.keterangan;
db.outbonds.Add(mn);
db.SaveChanges();
}
}
public int GetUserID(string loginName)
{
using (DemoEntities1 db = new DemoEntities1())
{
var user = db.SYSUsers.Where(o => o.LoginName.Equals(loginName));
if (user.Any())
{
return(user.FirstOrDefault().SYSUserID);
}
}
return(0);
}
public void AddUserAccount(UserSignUpView user)
{
using (DemoEntities1 db = new DemoEntities1())
{
SYSUser SU = new SYSUser();
SU.LoginName = user.LoginName;
//TODO : Implement Base64 Encode.
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowMOdifiedDateTime = DateTime.Now;
//Commit Change.
db.SYSUsers.Add(SU);
db.SaveChanges();
SYSUserProfile SUP = new SYSUserProfile();
SUP.SYSUserID = SU.SYSUserID;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SYSUserProfiles.Add(SUP);
db.SaveChanges();
if (user.LOOKUPRoleID > 0)
{
SYSUserRole SUR = new SYSUserRole();
SUR.LOOKUPRoleID = user.LOOKUPRoleID;
SUR.SYSUserID = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SYSUserRoles.Add(SUR);
db.SaveChanges();
}
}
}
public List <LOOKUPAvailableRole> GetAllRoles()
{
using (DemoEntities1 db = new DemoEntities1())
{
var roles = db.LOOKUPRoles.Select(o => new LOOKUPAvailableRole
{
LOOKUPRoleID = o.LOOKUPRoleID,
RoleName = o.RoleName,
RoleDescription = o.RoleDescription
}).ToList();
return(roles);
}
}
public void AddCustomer(addCustomerView c)
{
using (DemoEntities1 db = new DemoEntities1())
{
pelanggan p = new pelanggan();
p.no_id = c.no_id;
p.nama = c.nama;
p.alamat = c.alamat;
p.no_tlp1 = c.no_tlp1;
p.no_tlp2 = c.no_tlp2;
db.pelanggans.Add(p);
db.SaveChanges();
}
}
public string GetUserPassword(string loginName)
{
using (DemoEntities1 db = new DemoEntities1())
{
var user = db.SYSUsers.Where(o => o.LoginName.ToLower().Equals(loginName));
if (user.Any())
{
return(user.FirstOrDefault().PasswordEncryptedText);
}
else
{
return(string.Empty);
}
}
}
public ActionResult EditCustomer(
int id_pelanggan, string no_id, string nama, string alamat, string no_tlp1, string no_tlp2)
{
CustomerProfileView CPV = new CustomerProfileView();
CPV.id_pelanggan = id_pelanggan;
CPV.no_id = no_id;
CPV.nama = nama;
CPV.alamat = alamat;
CPV.no_tlp1 = no_tlp1;
CPV.no_tlp2 = no_tlp2;
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContext = db.Database.BeginTransaction())
{
try
{
pelanggan p = db.pelanggans.Find(id_pelanggan);
p.alamat = CPV.alamat;
p.nama = CPV.nama;
p.no_id = CPV.no_id;
p.no_tlp1 = CPV.no_tlp1;
p.no_tlp2 = CPV.no_tlp2;
db.SaveChanges();
dbContext.Commit();
}
catch (Exception ex)
{
dbContext.Rollback();
}
}
}
return(Json(new
{
success = true,
id_pelanggan = CPV.id_pelanggan,
no_id = CPV.no_id,
nama = CPV.nama,
alamat = CPV.alamat,
no_tlp1 = CPV.no_tlp1,
no_tlp2 = CPV.no_tlp2
}));
}
public List <outbondProfileView> GetAlloutbonds()
{
List <outbondProfileView> outbonds = new List <outbondProfileView>();
using (DemoEntities1 db = new DemoEntities1())
{
outbondProfileView MV;
var outbond = db.outbonds.ToList();
foreach (outbond m in db.outbonds)
{
MV = new outbondProfileView();
MV.id_outbond = m.id_outbond;
MV.keterangan = m.keterangan;
MV.harga = (int)m.harga;
outbonds.Add(MV);
}
return(outbonds);
}
}
public List <UserProfileView> GetAllUserProfiles()
{
List <UserProfileView> profiles = new List <UserProfileView>();
using (DemoEntities1 db = new DemoEntities1())
{
UserProfileView UPV;
var users = db.SYSUsers.ToList();
foreach (SYSUser u in db.SYSUsers)
{
UPV = new UserProfileView();
UPV.SYSUserID = u.SYSUserID;
UPV.LoginName = u.LoginName;
UPV.Password = u.PasswordEncryptedText;
var SUP = db.SYSUserProfiles.Find(u.SYSUserID);
if (SUP != null)
{
UPV.FirstName = SUP.FirstName;
UPV.LastName = SUP.LastName;
UPV.Gender = SUP.Gender;
}
var SUR = db.SYSUserRoles.Where(o => o.SYSUserID.Equals(u.SYSUserID));
if (SUR.Any())
{
var userRole = SUR.FirstOrDefault();
UPV.LOOKUPRoleID = userRole.LOOKUPRoleID;
UPV.RoleName = userRole.LOOKUPRole.RoleName;
UPV.IsRoleActive = userRole.IsActive;
}
profiles.Add(UPV);
}
}
return(profiles);
}
public List <CustomerProfileView> GetAllCustomers()
{
List <CustomerProfileView> customers = new List <CustomerProfileView>();
using (DemoEntities1 db = new DemoEntities1())
{
CustomerProfileView CV;
var customer = db.pelanggans.ToList();
foreach (pelanggan p in db.pelanggans)
{
CV = new CustomerProfileView();
CV.id_pelanggan = p.id_pelanggan;
CV.no_id = p.no_id;
CV.nama = p.nama;
CV.alamat = p.alamat;
CV.no_tlp1 = p.no_tlp1;
CV.no_tlp2 = p.no_tlp2;
customers.Add(CV);
}
return(customers);
}
}
public void DeleteUser(int userID)
{
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var SUR = db.SYSUserRoles.Where(o => o.SYSUserID == userID);
if (SUR.Any())
{
db.SYSUserRoles.Remove(SUR.FirstOrDefault());
db.SaveChanges();
}
var SUP = db.SYSUserProfiles.Where(o => o.SYSUserID == userID);
if (SUP.Any())
{
db.SYSUserProfiles.Remove(SUP.FirstOrDefault());
db.SaveChanges();
}
var SU = db.SYSUsers.Where(o => o.SYSUserID == userID);
if (SU.Any())
{
db.SYSUsers.Remove(SU.FirstOrDefault());
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
public List <OrderProfileView> GetAllOrders()
{
List <OrderProfileView> orders = new List <OrderProfileView>();
using (DemoEntities1 db = new DemoEntities1())
{
OrderProfileView OV;
//var orderData = db.laporans.ToList(); ???
foreach (laporan l in db.laporans)
{
OV = new OrderProfileView();
OV.id_laporan = l.id_laporan;
pelanggan pelanggan = db.pelanggans.Where(o => o.id_pelanggan.Equals(l.id_pelanggan)).FirstOrDefault();
OV.namapelanggan = pelanggan.nama;
outbond outbond = db.outbonds.Where(o => o.id_outbond.Equals(l.id_outbond)).FirstOrDefault();
OV.namaoutbond = outbond.keterangan;
OV.keterangan = l.keterangan;
OV.tgl_akhir = (DateTime)l.tgl_akhir;
OV.tgl_mulai = (DateTime)l.tgl_mulai;
OV.tgl_pesan = (DateTime)l.tgl_pesan;
OV.harga = l.harga;
OV.quantity = l.quantity;
OV.jumlah = l.jumlah;
orders.Add(OV);
}
}
orders.Reverse();
return(orders);
}
//[AuthorizeRoles("Admin")]
public ActionResult UpdateoutbondData(int id_outbond, string keterangan, int harga)
{
outbondProfileView MPV = new outbondProfileView();
MPV.id_outbond = id_outbond;
MPV.keterangan = keterangan;
MPV.harga = harga;
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContext = db.Database.BeginTransaction())
{
try
{
outbond m = db.outbonds.Find(MPV.id_outbond);
m.keterangan = MPV.keterangan;
m.harga = MPV.harga;
db.SaveChanges();
dbContext.Commit();
}
catch (Exception ex)
{
dbContext.Rollback();
}
}
}
return(Json(new
{
success = true,
id_outbond = MPV.id_outbond,
keterangan = MPV.keterangan,
harga = MPV.harga
}));
}
public void AddOrder(addOrderView m)
{
using (DemoEntities1 db = new DemoEntities1())
{
outbond mn = db.outbonds.Find(m.id_outbond);
mn.harga = mn.harga;
mn.id_outbond = mn.id_outbond;
mn.keterangan = mn.keterangan;
laporan lp = new laporan();
lp.id_outbond = m.id_outbond;
lp.id_pelanggan = m.id_pelanggan;
lp.keterangan = m.keterangan;
lp.tgl_akhir = m.tgl_akhir;
lp.tgl_mulai = m.tgl_mulai;
lp.tgl_pesan = m.tgl_pesan;
lp.quantity = m.quantity;
lp.harga = m.harga;
lp.jumlah = m.jumlah;
db.laporans.Add(lp);
db.SaveChanges();
}
}
// //[AuthorizeRoles("Admin")]
public ActionResult DeleteCustomer(int id_pelanggan)
{
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContext = db.Database.BeginTransaction())
{
try
{
var mn = db.pelanggans.Where(o => o.id_pelanggan.Equals(id_pelanggan));
if (mn.Any())
{
db.pelanggans.Remove(mn.FirstOrDefault());
db.SaveChanges();
}
dbContext.Commit();
}
catch (Exception ex)
{
dbContext.Rollback();
}
}
}
return(Json(new { success = true }));
}
public GenericRepository(DemoEntities1 db)
{
this.db = db;
table = db.Set <T>();
}
public GenericRepository()
{
this.db = new DemoEntities1();
table = db.Set <T>();
}
public void UpdateUserAccount(UserProfileView user)
{
using (DemoEntities1 db = new DemoEntities1())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
SYSUser SU = db.SYSUsers.Find(user.SYSUserID);
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSYSUserID = user.SYSUserID;
SU.RowModifiedSYSUserID = user.SYSUserID;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowMOdifiedDateTime = DateTime.Now;
db.SaveChanges();
var userProfile = db.SYSUserProfiles.Where(o => o.SYSUserID == user.SYSUserID);
if (userProfile.Any())
{
SYSUserProfile SUP = userProfile.FirstOrDefault();
SUP.SYSUserID = SU.SYSUserID;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSYSUserID = user.SYSUserID;
SUP.RowModifiedSYSUserID = user.SYSUserID;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
if (user.LOOKUPRoleID > 0)
{
var userRole = db.SYSUserRoles.Where(o => o.SYSUserID == user.SYSUserID);
SYSUserRole SUR = null;
if (userRole.Any())
{
SUR = userRole.FirstOrDefault();
SUR.LOOKUPRoleID = user.LOOKUPRoleID;
SUR.SYSUserID = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSYSUserID = user.SYSUserID;
SUR.RowModifiedSYSUserID = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
}
else
{
SUR = new SYSUserRole();
SUR.LOOKUPRoleID = user.LOOKUPRoleID;
SUR.SYSUserID = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSYSUserID = user.SYSUserID;
SUR.RowModifiedSYSUserID = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SYSUserRoles.Add(SUR);
}
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
