public int insertItems(BusinessEntitiesBS.ItemEntities.ItemObj itemObj)
{
IAdminDA itemValues = new DataAccessBS.AdminClasses.AdminDA();
int itemId = itemValues.insertItemDA(itemObj);
return itemId;
}
public int insertCatagoryDA(BusinessEntitiesBS.Catagory_Entities.catagoryObj catObjDa)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[3];
//Catgory parameters
sqlParams[0] = new SqlParameter("@catagoryName", catObjDa.catagoryName);
sqlParams[1] = new SqlParameter("@CatagoryDescription", catObjDa.catagoryDesc);
sqlParams[2] = new SqlParameter("@catStatus", catObjDa.catagoryStatus);
DataTable idcDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_CATAGORY", sqlParams).Tables[0];
int idCat = Convert.ToInt32(idcDt.Rows[0].ItemArray[0].ToString());
if (idcDt.Rows.Count > 0)
{
return idCat;
}
else
{
return -1;
}
}
catch(SqlException exc)
{
return -1;
throw exc;
}
}
public int insertCatagory(BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj)
{
try
{
IAdminDA catInsert = new DataAccessBS.AdminClasses.AdminDA();
int catChk = catInsert.insertCatagoryDA(catObj);
return catChk;
}
catch
{
return -1;
}
}
public int UpdateUsers(BusinessEntitiesBS.UserEntities.userobj updateuserObj, int userid)
{
IAdminDA UpdateUserValues = new DataAccessBS.AdminClasses.AdminDA();
int updateuserId = UpdateUserValues.UpdateUserDA(updateuserObj, userid);
return updateuserId;
}
public int UpdateItems(BusinessEntitiesBS.ItemEntities.ItemObj updateitemObj, int itemid)
{
IAdminDA UpdateItemValues = new DataAccessBS.AdminClasses.AdminDA();
int updateitemId = UpdateItemValues.UpdateItemDA(updateitemObj, itemid);
return updateitemId;
}
public int insertMerchant(BusinessEntitiesBS.merchantObj merchantValues)
{
try
{
IAdminDA merchantInsert = new DataAccessBS.AdminClasses.AdminDA();
int merchantChk = merchantInsert.insertMerchantDA(merchantValues);
return merchantChk;
}
catch
{
return -1;
}
}
public int insertGroup(BusinessEntitiesBS.GroupEntities.grpObj grpObj)
{
IAdminDA inertGrp = new DataAccessBS.AdminClasses.AdminDA();
return inertGrp.insertGrpDA(grpObj);
}
public int insertGrpDA(BusinessEntitiesBS.GroupEntities.grpObj grpObjDa)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[7];
//Catgory parameters
sqlParams[0] = new SqlParameter("@grpName", grpObjDa.grpName);
sqlParams[1] = new SqlParameter("@grpDesc", grpObjDa.grpDesc);
sqlParams[2] = new SqlParameter("@grpSts", grpObjDa.grpStatus);
sqlParams[3] = new SqlParameter("@grpBR", grpObjDa.grpBR);
sqlParams[4] = new SqlParameter("@grpNR", grpObjDa.grpNR);
sqlParams[5] = new SqlParameter("@grpChk", grpObjDa.fixedGrp);
sqlParams[6] = new SqlParameter("@grpQty", grpObjDa.Quantity);
DataTable idDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_GROUP", sqlParams).Tables[0];
int returnedId = Convert.ToInt32(idDt.Rows[0].ItemArray[0].ToString());
SqlParameter[] grpSqlParams = new SqlParameter[3];
grpSqlParams[0] = new SqlParameter("@grpID", returnedId);
grpSqlParams[1] = new SqlParameter("@separator", ",");
grpSqlParams[2] = new SqlParameter("@Array", grpObjDa.itemIdStr);
int retItemGrp = DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "ParseArray", grpSqlParams);
if (idDt.Rows.Count > 0 && retItemGrp == -1)
{
return returnedId;
}
else
{
return -1;
}
}
catch (SqlException exc)
{
return -1;
throw exc;
}
}
public int insertItemDA(BusinessEntitiesBS.ItemEntities.ItemObj itemObjDa)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[7];
//Catgory parameters
sqlParams[0] = new SqlParameter("@itemName", itemObjDa.itemName);
sqlParams[1] = new SqlParameter("@itemDescription", itemObjDa.itemDesc);
sqlParams[2] = new SqlParameter("@catId", itemObjDa.itemCatagory);
sqlParams[3] = new SqlParameter("@itemBR", itemObjDa.itemBR);
sqlParams[4] = new SqlParameter("@itemNR", itemObjDa.itemNR);
sqlParams[5] = new SqlParameter("@itemQty", itemObjDa.itemQty);
sqlParams[6] = new SqlParameter("@itemSts", itemObjDa.itemStatus);
DataTable idDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_ITEMS", sqlParams).Tables[0];
int returnedId = Convert.ToInt32(idDt.Rows[0].ItemArray[0].ToString());
string imgPath = "~/ItemImages/" + itemObjDa.itemCatagory+"/"+returnedId+ "/" +returnedId+"small.jpg";
SqlParameter[] imgSqlParams = new SqlParameter[2];
imgSqlParams[0] = new SqlParameter("@itemID", returnedId);
imgSqlParams[1] = new SqlParameter("@itemImagePath", imgPath);
int retImgPth = DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "USP_INSERT_ITEM_IMAGEPATH", imgSqlParams);
if (idDt.Rows.Count > 0 && retImgPth > 0)
{
return returnedId;
}
else
{
return -1;
}
}
catch (SqlException exc)
{
return -1;
throw exc;
}
}
/// <summary>
/// This method will do
/// </summary>
/// <param name="userobjDA"></param>
public void insertUserDA(BusinessEntitiesBS.UserEntities.userobj userobjDA)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[3];
//User parameters
sqlParams[0] = new SqlParameter("@uname", userobjDA.uname);
sqlParams[1] = new SqlParameter("@emailid", userobjDA.emailid);
sqlParams[2] = new SqlParameter("@pwd", userobjDA.pwd);
DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "USP_INSERT_USERS", sqlParams);
}
catch (SqlException exc)
{
throw exc;
}
}
public int insertOrdersDA(BusinessEntitiesBS.UserEntities.OrderItems orderitems)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[10];
//User parameters
sqlParams[0] = new SqlParameter("@userId", orderitems.userid);
sqlParams[1] = new SqlParameter("@purchaseDate", orderitems.purchaseDate);
sqlParams[2] = new SqlParameter("@ItemString", orderitems.cartItems);
sqlParams[3] = new SqlParameter("@totalPrice", orderitems.totalBill);
sqlParams[4] = new SqlParameter("@Address", orderitems.ShippingAdr);
sqlParams[5] = new SqlParameter("@totalItems", orderitems.totalItems);
sqlParams[6] = new SqlParameter("@separator", ';');
sqlParams[7] = new SqlParameter("@separator2", ',');
sqlParams[8] = new SqlParameter("@SizeString", orderitems.TypeItem);
sqlParams[9] = new SqlParameter("@areaId", orderitems.areaId);
DataTable idDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_ORDER_ITEMS", sqlParams).Tables[0];
int returnedId = Convert.ToInt32(idDt.Rows[0].ItemArray[0].ToString());
if (idDt.Rows.Count > 0)
{
return returnedId;
}
else
{
return -1;
}
}
catch (SqlException exc)
{
throw exc;
return -1;
}
}
public void insertUser(BusinessEntitiesBS.UserEntities.userobj userobj)
{
IUserDA userInsert = new DataAccessBS.UserClasses.UserDA();
userInsert.insertUserDA(userobj);
}
public int insertOrders(BusinessEntitiesBS.UserEntities.OrderItems orderitems)
{
IUserDA orderInsert = new DataAccessBS.UserClasses.UserDA();
return orderInsert.insertOrdersDA(orderitems);
}
public int UpdateUserDA(BusinessEntitiesBS.UserEntities.userobj updateuserObjDa, int userid)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[7];
//Catgory parameters
sqlParams[0] = new SqlParameter("@uid", userid);
sqlParams[1] = new SqlParameter("@username", updateuserObjDa.uname);
sqlParams[2] = new SqlParameter("@pwd", updateuserObjDa.pwd);
sqlParams[3] = new SqlParameter("@email", updateuserObjDa.emailid);
sqlParams[4] = new SqlParameter("@phone", updateuserObjDa.phno);
sqlParams[5] = new SqlParameter("@address", updateuserObjDa.address);
sqlParams[6] = new SqlParameter("@actvsts", updateuserObjDa.userstatus);
int updated = DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "USP_UPDATE_USERS", sqlParams);
if (updated > 0)
{
return updated;
}
else
{
return -1;
}
}
catch (SqlException exc)
{
return -1;
throw exc;
}
}
public int UpdateItemDA(BusinessEntitiesBS.ItemEntities.ItemObj updateitemObjDa, int itemid)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[12];
//Catgory parameters
sqlParams[0] = new SqlParameter("@itemId", itemid);
sqlParams[1] = new SqlParameter("@itemName", updateitemObjDa.itemName);
sqlParams[2] = new SqlParameter("@itemDescription", updateitemObjDa.itemDesc);
sqlParams[3] = new SqlParameter("@catId", updateitemObjDa.itemCatagory);
sqlParams[4] = new SqlParameter("@itemBR", updateitemObjDa.itemBR);
sqlParams[5] = new SqlParameter("@itemNR", updateitemObjDa.itemNR);
sqlParams[6] = new SqlParameter("@itemQty", updateitemObjDa.itemQty);
sqlParams[7] = new SqlParameter("@itemSts", updateitemObjDa.itemStatus);
sqlParams[8] = new SqlParameter("@featuredFlag", updateitemObjDa.featuredFlag);
sqlParams[9] = new SqlParameter("@itemType", updateitemObjDa.itemType);
sqlParams[10] = new SqlParameter("@subCatId", updateitemObjDa.itemSubCatId);
sqlParams[11] = new SqlParameter("@merchantId", updateitemObjDa.merchantId);
int updated = DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "USP_UPDATE_ITEMS", sqlParams);
if (updated > 0)
{
return updated;
}
else
{
return -1;
}
}
catch (SqlException exc)
{
return -1;
throw exc;
}
}
public int insertMerchantDA(BusinessEntitiesBS.merchantObj merchantValues)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[8];
//Merchant parameters
sqlParams[0] = new SqlParameter("@name", merchantValues.mName);
sqlParams[1] = new SqlParameter("@type", merchantValues.mType);
sqlParams[2] = new SqlParameter("@address", merchantValues.mAddress);
sqlParams[3] = new SqlParameter("@phno", merchantValues.mPhno);
sqlParams[4] = new SqlParameter("@loginid", merchantValues.mLoginId);
sqlParams[5] = new SqlParameter("@pwd", merchantValues.mPwd);
sqlParams[6] = new SqlParameter("@areaId", Int32.Parse(merchantValues.mArea));
sqlParams[7] = new SqlParameter("@catId", merchantValues.mCatid);
int count = DBHelper.ExecuteNonQuery(DBCommon.ConnectionString, "USP_INSERT_MERCHANT", sqlParams);
return count;
}
catch (SqlException exc)
{
return -1;
throw exc;
}
}
