public BaseOutput DeleteSMSModel(Int64 id)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
tbl_SMSModel _SMSModel = cRUDOperation.GetSMSModelByID(id);
if (_SMSModel != null)
{
List <tbl_SMSDetail> tbl_SMSDetails = cRUDOperation.GetSMSDetailsByModelID(_SMSModel.ID);
foreach (var item in tbl_SMSDetails)
{
tbl_SMSDetail tbl_SMSDetail = cRUDOperation.DeleteSMSDetail(item.ID, 0);
}
tbl_SMSModel tbl_SMSModel = cRUDOperation.DeleteSMSModel(id, 0);
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput UpdateSMSModel(SMSModel item)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
tbl_SMSModel tbl_SMSModel = new tbl_SMSModel()
{
ID = item.ID,
UserID = item.UserID,
TotalMessageCount = item.TotalMessageCount,
ShortMessageCount = item.ShortMessageCount,
OutMessageCount = item.OutMessageCount,
InMessageCount = item.InMessageCount,
OutMessageForeignCount = item.OutMessageForeignCount,
InMessageForeigCount = item.InMessageForeigCount,
OutMessageRoamingCount = item.OutMessageRoamingCount,
InMessageRoamingCount = item.InMessageRoamingCount,
BeginDate = item.BeginDate,
EndDate = item.EndDate,
};
tbl_SMSModel _SMSModel = cRUDOperation.UpdateSMSModel(tbl_SMSModel);
if (_SMSModel != null)
{
foreach (var smsDetail in item.SMSDetails)
{
tbl_SMSDetail tbl_SMSDetail = cRUDOperation.UpdateSMSDetail(smsDetail);
}
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput GetSMSModelsByID(Int64 id, out SMSModel sMSModel)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
sMSModel = null;
try
{
tbl_SMSModel tbl_SMSModel = cRUDOperation.GetSMSModelByID(id);
if (tbl_SMSModel != null)
{
sMSModel = new SMSModel()
{
ID = tbl_SMSModel.ID,
TotalMessageCount = tbl_SMSModel.TotalMessageCount,
ShortMessageCount = tbl_SMSModel.ShortMessageCount,
OutMessageCount = tbl_SMSModel.OutMessageCount,
InMessageCount = tbl_SMSModel.InMessageCount,
OutMessageForeignCount = tbl_SMSModel.OutMessageForeignCount,
InMessageForeigCount = tbl_SMSModel.InMessageForeigCount,
OutMessageRoamingCount = tbl_SMSModel.OutMessageRoamingCount,
InMessageRoamingCount = tbl_SMSModel.InMessageRoamingCount,
BeginDate = tbl_SMSModel.BeginDate,
EndDate = tbl_SMSModel.EndDate,
};
List <tbl_SMSDetail> tbl_SMSDetails = cRUDOperation.GetSMSDetailsByModelID(sMSModel.ID);
sMSModel.SMSDetails = tbl_SMSDetails;
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput GetLastSMSModelByUserName(string userName, out SMSModel sMSModel)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
sMSModel = null;
try
{
tbl_SMSModel tbl_SMSModel = cRUDOperation.GetLastSMSModelByUserName(userName);
if (tbl_SMSModel != null)
{
sMSModel = new SMSModel()
{
ID = tbl_SMSModel.ID,
TotalMessageCount = tbl_SMSModel.TotalMessageCount,
ShortMessageCount = tbl_SMSModel.ShortMessageCount,
OutMessageCount = tbl_SMSModel.OutMessageCount,
InMessageCount = tbl_SMSModel.InMessageCount,
OutMessageForeignCount = tbl_SMSModel.OutMessageForeignCount,
InMessageForeigCount = tbl_SMSModel.InMessageForeigCount,
OutMessageRoamingCount = tbl_SMSModel.OutMessageRoamingCount,
InMessageRoamingCount = tbl_SMSModel.InMessageRoamingCount,
BeginDate = tbl_SMSModel.BeginDate,
EndDate = tbl_SMSModel.EndDate,
};
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput AddSMSModel(SMSModel item)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
tbl_SMSModel sMSModel = new tbl_SMSModel()
{
UserID = item.UserID,
TotalMessageCount = item.TotalMessageCount,
ShortMessageCount = item.ShortMessageCount,
OutMessageCount = item.OutMessageCount,
InMessageCount = item.InMessageCount,
OutMessageForeignCount = item.OutMessageForeignCount,
InMessageForeigCount = item.InMessageForeigCount,
OutMessageRoamingCount = item.OutMessageRoamingCount,
InMessageRoamingCount = item.InMessageRoamingCount,
BeginDate = item.BeginDate,
EndDate = item.EndDate,
};
List <tbl_SMSDetail> tbl_SMSDetails = new List <tbl_SMSDetail>();
tbl_SMSDetails = item.SMSDetails;
tbl_SMSModel _SMSModel = cRUDOperation.AddSMSModel(sMSModel, tbl_SMSDetails);
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
