public string EditPayment(PayMode Model)
{
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedPaymentValue = new LMS_Datas.PayMode
{
Active = true,
PayModeId = Model.PayModeId,
PayMode1 = Model.PayMode1
};
entity.PayModes.Attach(enditedPaymentValue);
entity.Entry(enditedPaymentValue).Property(x => x.PayMode1).IsModified = true;
entity.Entry(enditedPaymentValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
public string EditCustomerVoucher(CustomerVoucher Model, FormCollection form)
{
string statusDDLValue = form["VoucherName"].ToString();
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedCustomerVoucherValue = new LMS_Datas.CustomerVoucher
{
Active = true,
CustomerId = Model.CustomerId,
VoucherId = Model.VoucherId,
AssignNo = Model.AssignNo
};
entity.CustomerVouchers.Attach(enditedCustomerVoucherValue);
entity.Entry(enditedCustomerVoucherValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
// Admin is Client Here
public string EditClient(AdminViewModel Model)
{
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedAdminValue = new LMS_Datas.Admin
{
Active = true,
AdminId = Model.AdminId,
Address = Model.Address,
EmailId = Model.EmailId,
dob = Model.dob,
Name = Model.ClientName,
MobileNo = Model.MobileNo
};
entity.Admins.Attach(enditedAdminValue);
entity.Entry(enditedAdminValue).Property(x => x.cityId).IsModified = false;
entity.Entry(enditedAdminValue).Property(x => x.stateId).IsModified = false;
entity.Entry(enditedAdminValue).Property(x => x.dob).IsModified = false;
entity.Entry(enditedAdminValue).Property(x => x.gender).IsModified = false;
entity.Entry(enditedAdminValue).Property(x => x.countryId).IsModified = false;
entity.Entry(enditedAdminValue).Property(x => x.Name).IsModified = true;
entity.Entry(enditedAdminValue).Property(x => x.EmailId).IsModified = true;
entity.Entry(enditedAdminValue).Property(x => x.MobileNo).IsModified = true;
//entity.Entry(enditedValue).State = EntityState.Modified;
entity.SaveChanges();
int?loginid = (from loginId in entity.Logins where loginId.UserId == Model.AdminId select loginId.UserId).FirstOrDefault();
var enditedAdminLoginValue = new Login
{
UserName = Model.UserName,
Password = Model.Password,
UserId = loginid,
Activate = "true"
};
entity.Logins.Attach(enditedAdminLoginValue);
entity.Entry(enditedAdminLoginValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
public string EditDiscount(Discountper Model)
{
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedDiscountValue = new LMS_Datas.Discountper
{
DiscountRate = Model.DiscountRate,
Persons = Model.Persons,
Activate = true,
DiscountPerId = Model.DiscountPerId
};
entity.Discountpers.Attach(enditedDiscountValue);
entity.Entry(enditedDiscountValue).Property(x => x.DiscountPerId).IsModified = true;
entity.Entry(enditedDiscountValue).Property(x => x.Activate).IsModified = true;
entity.Entry(enditedDiscountValue).Property(x => x.Persons).IsModified = true;
entity.Entry(enditedDiscountValue).Property(x => x.DiscountRate).IsModified = true;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
public string DeleteCard(int id)
{
string msg;
try
{
var enditedDiscountper = new LMS_Datas.Card1
{
CardId = id,
Activate = false
};
entity.Card1.Attach(enditedDiscountper);
//entity.Entry(enditedDiscountper).Property(x => x.CardId).IsModified = true;
entity.Entry(enditedDiscountper).Property(x => x.Activate).IsModified = true;
entity.Entry(enditedDiscountper).Property(x => x.CardName).IsModified = false;
entity.Entry(enditedDiscountper).Property(x => x.ValidFrom).IsModified = false;
entity.Entry(enditedDiscountper).Property(x => x.ValidTo).IsModified = false;
entity.Entry(enditedDiscountper).Property(x => x.persons).IsModified = false;
entity.Entry(enditedDiscountper).Property(x => x.discountPer).IsModified = false;
entity.Entry(enditedDiscountper).Property(x => x.TransactionDetails).IsModified = false;
entity.SaveChanges();
msg = "Delete Successfully";
return(msg);
}
catch (Exception e1)
{
msg = "Validation data not successfully";
return(msg);
}
}
public string EditPackage(Point Model)
{
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedPointsValue = new LMS_Datas.Point
{
Active = true,
Points = Model.Points,
Amount = Model.Amount,
PointsId = Model.PointsId
};
entity.Points.Attach(enditedPointsValue);
entity.Entry(enditedPointsValue).Property(x => x.Active).IsModified = true;
entity.Entry(enditedPointsValue).Property(x => x.Points).IsModified = true;
entity.Entry(enditedPointsValue).Property(x => x.PointsId).IsModified = true;
entity.Entry(enditedPointsValue).Property(x => x.Amount).IsModified = true;
//entity.Entry(enditedPackageValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
public string EditCustomerCard(CustomerCard Model, FormCollection form)
{
string CustomerName = form["CustomerName"].ToString();
string CardName = form["CardName"].ToString();
string referenceNo = form["ReferenceNo"].ToString();
int id = Convert.ToInt16(form["id"].ToString());
int customerId = (from customer in entity.Customers where customer.Name == CustomerName select customer.CustomerId).FirstOrDefault();
int CardId = (from card in entity.Card1 where card.CardName == CardName select card.CardId).FirstOrDefault();
string msgClient = null;
if (customerId != 0 && CardId != 0)
{
try
{
if (ModelState.IsValid)
{
var enditedCustomerCardValue = new LMS_Datas.CustomerCard
{
CustomerId = customerId,
Cardid = CardId,
referenceNo = referenceNo,
CustomerCardId = id
};
entity.CustomerCards.Attach(enditedCustomerCardValue);
entity.Entry(enditedCustomerCardValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
}
else
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}
public string EditCountry(country Model)
{
string msg;
try
{
if (ModelState.IsValid)
{
entity.Entry(Model).State = EntityState.Modified;
entity.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation data not successfully";
}
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return(msg);
}
// Admin is Client Here
public string EditVoucher(Voucher Model)
{
string msgClient;
try
{
if (ModelState.IsValid)
{
var enditedVoucherValue = new LMS_Datas.Voucher
{
Activate = true,
VoucherName = Model.VoucherName,
description = Model.description,
ValidFrom = Model.ValidFrom,
ValidTo = Model.ValidTo,
VoucherId = Model.VoucherId,
persons = Model.persons
};
entity.Vouchers.Attach(enditedVoucherValue);
entity.Entry(enditedVoucherValue).State = EntityState.Modified;
entity.SaveChanges();
msgClient = "Saved Successfully";
}
else
{
msgClient = "Validation data not successfully";
}
}
catch (Exception ex)
{
msgClient = "Error in Retriving Data";
}
return(msgClient);
}