public JsonResult details() { SellerDAL sellerObj = new SellerDAL(); List <Seller> sell = new List <Seller>(); try { var result = sellerObj.GetAllSellers(); foreach (var obj in result) { Seller sellObj = new Seller(); sellObj.SellerId = obj.SellerId; sellObj.Gstnumber = obj.Gstnumber; sellObj.Name = obj.Name; sellObj.DateOfBirth = obj.DateOfBirth; sellObj.EmailId = obj.EmailId; sellObj.Gender = obj.Gender; sellObj.Address = obj.Address; sell.Add(sellObj); } return(Json(sell)); } catch (Exception) { return(null); } }
public string Add(string GST, string Name, string EmailId, string password, string gender, DateTime DOB, string Address) { string result = ""; try { SellerDAL sellerObj = new SellerDAL(); result = sellerObj.AddSeller(GST, Name, EmailId, password, gender, DOB, Address); } catch (Exception) { result = "Failed"; } return(result); }
public JsonResult validate(string EmailId, string UserPassword) { string result = ""; try { SellerDAL sellerObj = new SellerDAL(); result = sellerObj.ValidateSellerLogin(EmailId, UserPassword); } catch (Exception) { result = "Failed"; } return(Json(result)); }
public string delete(string EmailId) { string result = ""; try { SellerDAL sellerObj = new SellerDAL(); result = sellerObj.DeleteSeller(EmailId); } catch (Exception) { result = "Failed"; } return(result); }
public JsonResult display(string EmailId) { SellerDAL sellerObj = new SellerDAL(); try { var obj = sellerObj.GetSellerByEmail(EmailId); Seller sellObj = new Seller(); sellObj.SellerId = obj.SellerId; sellObj.Gstnumber = obj.Gstnumber; sellObj.Name = obj.Name; sellObj.DateOfBirth = obj.DateOfBirth; sellObj.EmailId = obj.EmailId; sellObj.Gender = obj.Gender; sellObj.Address = obj.Address; return(Json(sellObj)); } catch (Exception) { return(null); } }
public IController CreateController(System.Web.Routing.RequestContext requestContext, string controllerName) { Type controllerType = Type.GetType(string.Concat(_controllerNamespace, ".", controllerName, "Controller")); dynamic service = new CustomerProductDAL(); switch (controllerName) { case "CustomerProducts": { service = new CustomerProductDAL(); break; } case "Orders": { service = new OrderDAL(); break; } case "Home": { service = new DashBoardDAL(); break; } case "Categories": { service = new CategoryDAL(); break; } case "Products": { service = new ProductDAL(); break; } case "BulkBuys": { service = new BulkBuyDAL(); break; } case "Buyers": { service = new BuyerDAL(); break; } case "Sellers": { service = new SellerDAL(); break; } case "Borrowers": { service = new BorrowerDAL(); break; } case "ProductTypes": { service = new ProductTypeDAL(); break; } case "Customers": { service = new CustomerDAL(); break; } case "Account": { service = new AccountDAL(); break; } case "Manage": { service = new ManageDAL(); break; } case "Vendors": { service = new VendorDAL(); break; } } IController controller = Activator.CreateInstance(controllerType, new[] { service }) as Controller; return(controller); }
//Update method to update new house object into tbl_HouseInfo public static void Update(SellerDAL newSeller) { string sqlUpdate = String.Format( "UPDATE tbl_sellerInfo SET Name='{0}', Address='{1}', Phone='{2}', commissionRate='{3}', AskPrice='{4}', Email='{5}', Notes='{6}' WHERE sellerID='{7}'" , newSeller.name, newSeller.address,newSeller.phone, newSeller.commissionRate,newSeller.askPrice,newSeller.email, newSeller.notes,newSeller.sellerId); SqlCommand updateCommand = new SqlCommand(sqlUpdate, sellerConn); try { sellerConn.Open(); updateCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sellerConn.Close(); } }
//Insert method to insert new seller object into tbl_HouseInfo public static Int32 Insert(SellerDAL newSeller) { string sqlInsert = String.Format("INSERT INTO tbl_sellerInfo (Name, Address, Phone, commissionRate,AskPrice,Email,Notes)" + " VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", newSeller.name, newSeller.address, newSeller.phone, newSeller.commissionRate, newSeller.askPrice, newSeller.email, newSeller.notes); SqlCommand insertCommand = new SqlCommand(sqlInsert, sellerConn); try { sellerConn.Open(); insertCommand.ExecuteNonQuery(); insertCommand.CommandText="SELECT @@IDENTITY"; return Convert.ToInt32(insertCommand.ExecuteScalar()); } catch (Exception ex) { throw ex; } finally { sellerConn.Close(); } }