public static List<Package> GetAll(Package srchPackage, string executedBy)
{
List<Package> cusList = null;
try
{
Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection);
DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Package_GetAll);
db.AddInParameter(cmd, "IsActive", DbType.Boolean, srchPackage.IsActive);
db.AddInParameter(cmd, "PackageCode", DbType.String, srchPackage.PackageCode);
db.AddInParameter(cmd, "PackageName", DbType.String, srchPackage.PackageName);
db.AddInParameter(cmd, "ItemID", DbType.Int32, srchPackage.ItemID);
DataSet ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
cusList = Utility.DataTableToCollection<Package>(ds.Tables[0]);
}
}
catch (Exception ex)
{
cusList = null;
}
return cusList;
}
public static bool UpdatePackage(Package package, string executedBy)
{
return PackageDAO.Update(package, executedBy);
}
public static List<Package> GetAllPackage(Package srchPackage, string executedBy)
{
return PackageDAO.GetAll(srchPackage, executedBy);
}
public static bool AddPackage(Package package, string executedBy)
{
return PackageDAO.Insert(package, executedBy);
}
public static bool Insert(Package package, string executedBy)
{
bool rslt = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection);
DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Package_Insert);
db.AddInParameter(cmd, "ItemID", DbType.Int32, package.Item.ItemID);
db.AddInParameter(cmd, "QtyPerPack", DbType.Int32, package.QtyPerPack);
db.AddInParameter(cmd, "PackageName", DbType.String, package.PackageName);
db.AddInParameter(cmd, "IsActive", DbType.Boolean, package.IsActive);
db.AddInParameter(cmd, "CreatedBy", DbType.Int32, 1);
db.AddOutParameter(cmd, "NewID", DbType.Int32, 4);
db.ExecuteNonQuery(cmd);
int newID = 0;
int.TryParse(db.GetParameterValue(cmd, "NewID").ToString(), out newID);
if (newID > 0)
{
rslt = true;
package.PackageID = newID;
}
}
catch (Exception ex)
{
rslt = false;
}
return rslt;
}
public static bool Update(Package package, string executedBy)
{
bool rslt = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection);
DbCommand cmd = db.GetStoredProcCommand(Constants.SP_Package_Update);
db.AddInParameter(cmd, "PackageID", DbType.Int32, package.PackageID);
db.AddInParameter(cmd, "QtyPerPack", DbType.Int32, package.QtyPerPack);
db.AddInParameter(cmd, "PackageName", DbType.String, package.PackageName);
db.AddInParameter(cmd, "IsActive", DbType.Boolean, package.IsActive);
db.AddInParameter(cmd, "UpdatedBY", DbType.Int32, 1);
db.ExecuteNonQuery(cmd);
rslt = true;
}
catch (Exception ex)
{
rslt = false;
}
return rslt;
}
public ActionResult Index(FormCollection collection)
{
//get the non property checkbox value , find a more suitable way later
bool bIsActive = Request.Form.GetValues("active") != null && Request.Form.GetValues("active")[0] != null ? true : false;
string item = Request.Form.GetValues("Items") != null ? Request.Form.GetValues("Items")[0] : "";
Package srchPackage = new Package();
srchPackage.ItemID = int.Parse(item.ToString());
srchPackage.PackageName = collection["name"].Trim();
srchPackage.IsActive = bIsActive;
srchPackage.PackageCode = "";
List<Package> packList = PackageManager.GetAllPackage(srchPackage, "nirshan");
List<PackageModel> customerList = Utility.ConvetrToList<PackageModel, Package>(packList);
List<SelectListItem> Items;
Items = GetItemsSelectList();
ViewBag.Items = Items;
return View(customerList);
}
//
// GET: /Package/
public ActionResult Index()
{
Package sample = new Package() { PackageCode = "", PackageName = "", IsActive = true };
List<PackageModel> packages = Utility.ConvetrToList<PackageModel, Package>(PackageManager.GetAllPackage(sample, "nirshan"));
List<SelectListItem> Items;
Items = GetItemsSelectList();
ViewBag.Items = Items;
return View(packages);
}