public string StoreReservationSave(T_STORE_RESERVATION Param, LOGIN_INFO login = null)
{
string msg = string.Empty;
try
{
using (TransactionScope tran = new TransactionScope())
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "HomePage\\T_STORE_RESERVATION.xml", "StoreReservationSave"
, Param.IDX.ToString("0")
, Param.STORE_CODE.ToString()
, Param.REG_DATE.ToString(DateTime.Now.ToString("yyyyMMddHHmmdd"))
, Param.REQUEST_DATE.ToString("")
, Param.NAME.ToString("")
, Param.EMAIL.ToString("")
, Param.PHONE.ToString("")
, Param.PEOPLE_NUMBER.ToString("")
, Param.CONTENT.ToString("")
, Param.REMARK.ToString("")
, Param.STATUS.ToString("1")
, ""
, Param.INSERT_CODE.ToString("0")
);
db.ExecuteCommand(sql);
tran.Complete();
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
public JsonResult StoreReservationSave(T_STORE_RESERVATION param)
{
param.STORE_CODE = SessionHelper.LoginInfo.STORE_CODE;
string msg = new HomePageService().StoreReservationSave(param);
if (string.IsNullOrEmpty(msg))
{
new MailHelper().SendMail(new MAILINFO()
{
ACCEPT_ID = param.EMAIL + ";" + SessionHelper.LoginInfo.STORE.EMAIL
// ,SENDER_ID="*****@*****.**"
,
SENDER_NAME = SessionHelper.LoginInfo.STORE.STORE_NAME
,
SUBJECT = "[예약메일] - (" + param.REQUEST_DATE + ")" + param.NAME + "님이 예약을 요청하였습니다."
,
CONTENT = param.CONTENT
});
}
return(new JsonResult {
Data = new { error_message = msg }
});
}
/// <summary>
/// 온라인 메뉴 + 자리 예약
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public JsonResult CartReservation(T_STORE_RESERVATION Param)
{
string msg = string.Empty, redirect_Url = string.Empty;
msg = new OrderService().StoreOnlineCartReservationSave(Param, SessionHelper.LoginInfo);
/// 에러가 없을 경우 메일 발송
if (string.IsNullOrEmpty(msg))
{
SessionHelper.LoginInfo.SHOPPING_CART = new SHOPPING_CART();
new MailHelper().SendMail(new MAILINFO()
{
ACCEPT_ID = Param.EMAIL + ";" + SessionHelper.LoginInfo.STORE.EMAIL
// ,SENDER_ID="*****@*****.**"
,
SENDER_NAME = SessionHelper.LoginInfo.STORE.STORE_NAME
,
SUBJECT = "[예약메일] - (" + Param.REQUEST_DATE + ")" + Param.NAME + "님이 예약을 요청하였습니다."
,
CONTENT = Param.CONTENT
});
}
return(new JsonResult {
Data = new { redirect_url = redirect_Url, error_message = msg }
});
}
public string StoreOnlineCartReservationSave(T_STORE_RESERVATION Param, LOGIN_INFO login = null)
{
string msg = string.Empty;
Int64 nSALE_CODE = 0;
OrderService service = new OrderService(db);
try
{
using (TransactionScope tran = new TransactionScope())
{
if (login != null && login.SHOPPING_CART != null && (login.SHOPPING_CART.ITEM_LIST != null && login.SHOPPING_CART.ITEM_LIST.Count() > 0))
{
Param.STORE_CODE = login.STORE_CODE;
SHOPPING_CART cart = login.SHOPPING_CART;
string sSaleData = service.SaleSave(new T_SALE
{
SALE_CODE = 0,
BILL_NO = "",
STORE_CODE = (int)Param.STORE_CODE,
MEMBER_CODE = login.MEMBER.MEMBER_CODE,
TOT_TAX = cart.TOT_TAX,
TAX1 = cart.TAX1,
TAX2 = cart.TAX2,
TAX3 = cart.TAX3,
DELIVERY_FEE = login.SHOPPING_CART.DELIVERY_FEE,
TIP_AMT = (login.SHOPPING_CART.TIP_LIST == null) ? 0 : login.SHOPPING_CART.TIP_LIST.Sum(s => s.TOT_TIP_TAX),
ADD_AMT = login.SHOPPING_CART.ITEM_LIST.Sum(s => s.ADD_ITEM_LIST == null ? 0 : s.ADD_ITEM_LIST.Sum(ss => ss.PRICE)),
ITEM_DISCOUNT_AMT = (login.SHOPPING_CART.DISCOUNT_LIST == null ? 0 : login.SHOPPING_CART.DISCOUNT_LIST.Where(w => w.ITEM_SEQ != null && w.ITEM_SEQ > 0).Sum(s => s.DISCOUNT_AMT)),
ORDER_DISCOUNT_TYPE = cart.ORDER_DISCOUNT_TYPE,
ORDER_DISCOUNT_AMT = cart.ORDER_DISCOUNT_AMT,
SALE_AMT = cart.TOTAL_AMT,
REMARK = "",
INSERT_CODE = (int)login.MEMBER.MEMBER_CODE
});
if (sSaleData.Contains("Error =>"))
{
return(sSaleData);
}
else
{
if (sSaleData.Split(':').Count() == 2)
{
nSALE_CODE = Convert.ToInt64(sSaleData.Split(':')[1]);
}
}
#region >> 매출 아이템 정보 등록
if (cart.ITEM_LIST != null)
{
foreach (SHOPPING_ITEM itemData in cart.ITEM_LIST)
{
T_SALE_ITEM itemSaveData = new T_SALE_ITEM {
};
itemSaveData.SALE_CODE = nSALE_CODE;
itemSaveData.ITEM_SEQ = itemData.ITEM_SEQ;
itemSaveData.ITEM_CODE = itemData.ITEM_CODE;
itemSaveData.ITEM_NAME = itemData.ITEM_NAME;
itemSaveData.ITEM_TYPE = itemData.ITEM_TYPE;
itemSaveData.COST = itemData.COST;
itemSaveData.TOT_TAX = itemData.TOT_TAX;
itemSaveData.TAX1 = itemData.TAX1;
itemSaveData.TAX2 = itemData.TAX2;
itemSaveData.TAX3 = itemData.TAX3;
itemSaveData.CNT = itemData.CNT;
itemSaveData.PRICE = itemData.PRICE;
itemSaveData.DISCOUNT_TYPE = itemData.DISCOUNT_TYPE;
itemSaveData.DISCOUNT_AMT = itemData.DISCOUNT_AMT;
itemSaveData.TOPPING_CODE = itemData.TOPPING_CODE;
itemSaveData.REMARK = itemData.MEMO;
itemSaveData.INSERT_CODE = (int)login.MEMBER.MEMBER_CODE;
#region >> 세트메뉴정보 및 토핑 정보 등록
if (itemData.ADD_ITEM_LIST != null && itemData.ADD_ITEM_LIST.Count() > 0)
{
foreach (T_SALE_ITEM_ADD addData in itemData.ADD_ITEM_LIST)
{
addData.SALE_CODE = nSALE_CODE;
addData.ITEM_SEQ = itemData.ITEM_SEQ;
addData.INSERT_CODE = (int)login.MEMBER.MEMBER_CODE;
msg = service.SaleItemAddSave(addData);
if (!string.IsNullOrEmpty(msg))
{
return(msg);
}
}
}
#endregion
msg = service.SaleItemSave(itemSaveData);
if (!string.IsNullOrEmpty(msg))
{
return(msg);
}
}
}
#endregion
#region >> 쿠폰 사용정보 등록
if (login.SHOPPING_CART.COUPON_LIST != null && login.SHOPPING_CART.COUPON_LIST.Count() > 0)
{
//SALE_CODE
foreach (CART_COUPON_USE couponData in login.SHOPPING_CART.COUPON_LIST)
{
T_SALE_COUPON coupon = service.GetCouponList(new T_SALE_COUPON_COND {
COUPON_CODE = couponData.COUPON_CODE
}).FirstOrDefault();
if (coupon == null)
{
return("해당쿠폰은 유효하지 않은 쿠폰입니다.");
}
if (Convert.ToInt32(couponData.USE_DATE) < Convert.ToInt32(coupon.FR_DATE))
{
return("해당쿠폰은 유효하지 않은 쿠폰입니다. 사용가능일 : " + coupon.FR_DATE.ToFormatDate() + "~" + coupon.TO_DATE.ToFormatDate());
}
if (coupon.USE_YN)
{
return("이미 사용된 쿠폰입니다.(사용가능매장 : " + coupon.STORE_NAME + " 사용일:" + coupon.USE_DATE + ")");
}
if (coupon.COMPANY_CODE != null && coupon.COMPANY_CODE != couponData.COMPANY_CODE)
{
return("해당업체에서는 사용이 불가능합니다..(사용가능업체 : " + coupon.COMPANY_NAME + " 사용가능일:" + Global.Format.ConvertFromToFormatDate(coupon.FR_DATE, coupon.TO_DATE) + ")");
}
if (coupon.STORE_CODE != null && coupon.STORE_CODE != couponData.STORE_CODE)
{
return("해당업체에서는 사용이 불가능합니다..(사용가능매장 : " + coupon.STORE_CODE + " 사용가능일:" + Global.Format.ConvertFromToFormatDate(coupon.FR_DATE, coupon.TO_DATE) + ")");
}
if (coupon.ITEM_GROUP_CODE != null && coupon.ITEM_GROUP_CODE != couponData.ITEM_GROUP_CODE)
{
return("해당품목그룹은 사용이 불가능합니다..(사용가능품목그룹 : " + coupon.ITEM_GROUP_NAME + " 사용가능일:" + Global.Format.ConvertFromToFormatDate(coupon.FR_DATE, coupon.TO_DATE) + ")");
}
if (coupon.ITEM_CODE != null && coupon.ITEM_CODE != couponData.ITEM_CODE)
{
return("해당품목은 사용이 불가능합니다..(사용가능품목 : " + coupon.ITEM_NAME + " 사용가능일:" + Global.Format.ConvertFromToFormatDate(coupon.FR_DATE, coupon.TO_DATE) + ")");
}
couponData.SALE_CODE = nSALE_CODE;
coupon.SALE_CODE = couponData.SALE_CODE;
coupon.SALE_ITEM_SEQ = couponData.SALE_ITEM_SEQ;
coupon.ITEM_CODE = couponData.ITEM_CODE;
coupon.USE_DATE = couponData.USE_DATE;
coupon.USE_YN = couponData.USE_YN;
coupon.DISCOUNT_RATE = coupon.DISCOUNT_RATE;
coupon.USE_DISCOUNT_AMT = coupon.DISCOUNT_AMT;
coupon.INSERT_CODE = login.MEMBER.MEMBER_CODE;
msg = service.SaleCouponSave(coupon);
if (string.IsNullOrEmpty(msg))
{
return(msg);
}
}
}
#endregion
#region >> 할인정보 등록
if (cart.DISCOUNT_LIST != null && cart.DISCOUNT_LIST.Count() > 0)
{
foreach (T_SALE_DISCOUNT disData in cart.DISCOUNT_LIST)
{
disData.SALE_CODE = nSALE_CODE;
disData.INSERT_CODE = (int)login.MEMBER.MEMBER_CODE;
msg = service.SaleDiscountSave(disData);
if (!string.IsNullOrEmpty(msg))
{
return(msg);
}
}
}
#endregion
#region >> 팁 정보 등록
if (cart.TIP_LIST != null && cart.TIP_LIST.Count() > 0)
{
foreach (T_SALE_TIP disData in cart.TIP_LIST)
{
disData.SALE_CODE = nSALE_CODE;
disData.INSERT_CODE = (int)login.MEMBER.MEMBER_CODE;
msg = service.SaleTipSave(disData);
if (!string.IsNullOrEmpty(msg))
{
return(msg);
}
}
}
#endregion
}
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "HomePage\\T_STORE_RESERVATION.xml", "StoreReservationSave"
, Param.IDX.ToString("0")
, Param.STORE_CODE.ToString()
, Param.REG_DATE.ToString(DateTime.Now.ToString("yyyyMMddHHmmdd"))
, Param.REQUEST_DATE.ToString("")
, Param.NAME.ToString("")
, Param.EMAIL.ToString("")
, Param.PHONE.ToString("")
, Param.PEOPLE_NUMBER.ToString("")
, Param.CONTENT.ToString("")
, Param.REMARK.ToString("")
, Param.STATUS.ToString("1")
, nSALE_CODE.ToString()
, Param.INSERT_CODE.ToString("0")
);
db.ExecuteCommand(sql);
tran.Complete();
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
