/// <summary>
/// Insert/ Update HSTimeSlotMaster
/// </summary>
/// <param name="StoreTimeSlotInsertUpdate"></param>
/// <returns></returns>
///
public int InsertUpdateTimeSlotMaster(StoreTimeSlotInsertUpdate Slot)
{
int Result = 0;
try
{
if (conn != null && conn.State == ConnectionState.Closed)
{
conn.Open();
}
MySqlCommand cmd = new MySqlCommand("SP_HSInsertUpdateHSStoreTimeSlotMaster", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@_SlotId", Slot.SlotId);
cmd.Parameters.AddWithValue("@_TenantId", Slot.TenantId);
cmd.Parameters.AddWithValue("@_StoreId", Slot.StoreId);
cmd.Parameters.AddWithValue("@_ProgramCode", Slot.ProgramCode);
cmd.Parameters.AddWithValue("@_TimeSlot", string.IsNullOrEmpty(Slot.TimeSlot) ? "" :Slot.TimeSlot);
cmd.Parameters.AddWithValue("@_MaxCapacity", Slot.MaxCapacity);
cmd.Parameters.AddWithValue("@_OrderNo", Slot.OrderNumber);
cmd.Parameters.AddWithValue("@_CreatedBy", Slot.CreatedBy);
cmd.Parameters.AddWithValue("@_ModifyBy", Slot.ModifyBy);
cmd.CommandType = CommandType.StoredProcedure;
Result = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(Result);
}
public ResponseModel InsertUpdateTimeSlotMaster([FromBody] StoreTimeSlotInsertUpdate Slot)
{
List <AlreadyScheduleDetail> alreadyScheduleDetails = new List <AlreadyScheduleDetail>();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0; int ResultCount = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
Slot.TenantId = authenticate.TenantId;
Slot.ProgramCode = authenticate.ProgramCode;
Slot.CreatedBy = authenticate.UserMasterID;
Slot.ModifyBy = authenticate.UserMasterID;
AppointmentCaller newAppointment = new AppointmentCaller();
ResultCount = newAppointment.InsertUpdateTimeSlotMaster(new AppointmentServices(_connectioSting), Slot);
statusCode = ResultCount.Equals(0) ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = ResultCount;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public int InsertUpdateTimeSlotMaster(IAppointment appointment, StoreTimeSlotInsertUpdate Slot)
{
_AppointmentRepository = appointment;
return(_AppointmentRepository.InsertUpdateTimeSlotMaster(Slot));
}