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();
}
}
