//2.2)This method is used to find OA from database
public Owner_Registration GetOwnerByID(string id)
{
using (MSMSDBEntities db = new MSMSDBEntities())
{
Owner_Registration admin = db.Owner_Registration.Find(id);
return(admin);
}
}
//2.11)This method is used to edit owner in database
public int EditOwner(Owner_Registration adm)
{
int i = 0;
using (MSMSDBEntities db = new MSMSDBEntities())
{
db.Entry(adm).State = EntityState.Modified;
i += db.SaveChanges();
}
return(i);
}
//2)OperationalAdmin Controller
//2.1)This method is used to add new OA to database
public int AddOwner(Owner_Registration adm)
{
int i = 0;
using (MSMSDBEntities db = new MSMSDBEntities())
{
db.Owner_Registration.Add(adm);
i += db.SaveChanges();
}
return(i);
}
public string EditOwner(OwnerViewModel model)
{
var file = model.OwnerImageFile;
var file1 = model.ImagePAN;
var file2 = model.ImageAadhar;
byte[] ImageBytes = null;
byte[] PanBytes = null;
byte[] AadharBytes = null;
string email = null;
if (file != null)
{
//var fileName = Path.GetFileName(file.FileName);
//var fileExtension = Path.GetExtension(file.FileName);
//var fileNameWithoutExtension = Path.GetFileNameWithoutExtension(file.FileName);
file.SaveAs(HttpContext.Current.Server.MapPath("/img/" + file.FileName));
file1.SaveAs(HttpContext.Current.Server.MapPath("/img/" + file1.FileName));
file2.SaveAs(HttpContext.Current.Server.MapPath("/img/" + file2.FileName));
BinaryReader reader = new BinaryReader(file.InputStream);
ImageBytes = reader.ReadBytes(file.ContentLength);
BinaryReader reader1 = new BinaryReader(file1.InputStream);
PanBytes = reader1.ReadBytes(file1.ContentLength);
BinaryReader reader2 = new BinaryReader(file2.InputStream);
AadharBytes = reader2.ReadBytes(file2.ContentLength);
Owner_Registration adm = new Owner_Registration();
adm.Owner_Email = model.Owner_Email;
adm.Name = model.Name;
adm.Age = model.Age;
adm.Gender = model.Gender;
adm.Password = model.Password;
adm.Phone = model.Phone;
adm.Pan_Number = PanBytes;
adm.Aadhar_Number = AadharBytes;
adm.Permanent_Address = model.Permanent_Address;
adm.Current_Address = model.Current_Address;
adm.Photo = ImageBytes;
adm.Status = model.Status;
if (IObjRep.EditOwner(adm) > 0)
{
email = adm.Owner_Email;
}
}
return(email);
}
public Owner_Registration UpdateOWner(Owner_Registration owner, string ownerEmail)
{
string strcon = ConfigurationManager.ConnectionStrings["MSMS"].ConnectionString;
using (SqlConnection con = new SqlConnection(strcon))
{
con.Open();
SqlCommand cmd = new SqlCommand("update Owner_Registration set Status='Active' where Owner_Email='" + ownerEmail + "'", con);
cmd.ExecuteNonQuery();
con.Close();
}
return(owner);
}
public Owner_Registration InsertOwnerReg(Owner_Registration owner)
{
try
{
using (MSMSEntities db = new MSMSEntities())
{
db.Owner_Registration.Add(owner);
db.SaveChanges();
}
}
catch (Exception Ex)
{
}
return(owner);
}
public ActionResult Login(Owner log, string Login)
{
if (Login == "Login")
{
Owner_Registration emp = ObjBal.Owner_Login(log);
if (emp != null)
{
Session["Owner_Email"] = emp.Owner_Email;
Session["Owner_Image"] = emp.Owner_Image;
FormsAuthentication.SetAuthCookie(emp.Owner_Email, false);
return(RedirectToAction("Branch", "DashBoard"));
}
}
return(View());
}
public Owner_Registration UpdateOwner(Owner_Registration owner)
{
Owner_Registration listUp = new Owner_Registration();
try
{
using (MSMSEntities db = new MSMSEntities())
{
//listUp= db.Entry(owner).State = System.Data.Entity.EntityState.Modified;
db.Entry(owner).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception Ex)
{
}
return(owner);
}
public ActionResult OwnerRegistrationAdd(Owner_Registration Owner, string Register, HttpPostedFileBase Image, HttpPostedFileBase Image1, HttpPostedFileBase Image2)
{
if (ModelState.IsValid)
{
if (Register == "Register")
{
if (Image == null)
{
Response.Write("<script>alert('Please Select Pan_Image')</script>");
return(View());
}
if (Image1 == null)
{
Response.Write("<script>alert('Please Select Aadhar_Image')</script>");
return(View());
}
if (Image2 == null)
{
Response.Write("<script>alert('Please Select Owner_Image')</script>");
return(View());
}
Owner.Pan_Number = new byte[Image.ContentLength];
Image.InputStream.Read(Owner.Pan_Number, 0, Image.ContentLength);
Owner.Aadhar_Number = new byte[Image1.ContentLength];
Image1.InputStream.Read(Owner.Aadhar_Number, 0, Image1.ContentLength);
Owner.Owner_Image = new byte[Image2.ContentLength];
Image2.InputStream.Read(Owner.Owner_Image, 0, Image2.ContentLength);
ObjBal.InsertOwnerReg(Owner);
Session["Owner_Email"] = Owner.Owner_Email;
return(RedirectToAction("StoreAdd"));
}
}
return(View());
}
public Owner_Registration UpdateOWner(Owner_Registration owner, string userId)
{
return(Iobj.UpdateOWner(owner, userId));
}
public Owner_Registration UpdateOwner(Owner_Registration owner, string ddlDepId)
{
return(Iobj.UpdateOwner(owner));
}
public Owner_Registration InsertOwnerReg(Owner_Registration owner)
{
return(Iobj.InsertOwnerReg(owner));
}
public ActionResult StoreAdd(Store_Registration store, string txtOwnerEmail, string ddlDepId, Owner_Registration owner, string Register, HttpPostedFileBase Image)
{
if ("Register" == "Register")
{
store.License_Image_Copy = new byte[Image.ContentLength];
Image.InputStream.Read(store.License_Image_Copy, 0, Image.ContentLength);
if (txtOwnerEmail == null)
{
ObjBal.UpdateOwner(owner, ddlDepId);
}
else
{
ObjBal.UpdateOwner(owner, txtOwnerEmail);
}
ObjBal.storeRegister(store);
}
return(View());
}
