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)); } }