/// <summary> /// Create Alert /// </summary> /// <param name="alertModel"></param> /// <returns></returns> public int InsertStoreAlert(AlertInsertModel alertModel) { int AlertConfigInsertCount = 0; try { if (alertModel.AlertID > 0) { if (alertModel.CommunicationModeDetails.Count > 0) { conn.Open(); for (int i = 0; i < alertModel.CommunicationModeDetails.Count; i++) { MySqlCommand Targetcmd = new MySqlCommand("SP_InsertStoreAlertMasterConfig", conn) { CommandType = CommandType.StoredProcedure }; Targetcmd.Parameters.AddWithValue("@_alertID", alertModel.AlertID); Targetcmd.Parameters.AddWithValue("@_commMode", alertModel.CommunicationModeDetails[i].Communication_Mode); Targetcmd.Parameters.AddWithValue("@_commFor", alertModel.CommunicationModeDetails[i].CommunicationFor); Targetcmd.Parameters.AddWithValue("@_content", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].Content) ? string.Empty : alertModel.CommunicationModeDetails[i].Content); Targetcmd.Parameters.AddWithValue("@_toemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].ToEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].ToEmailID); Targetcmd.Parameters.AddWithValue("@_ccemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].CCEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].CCEmailID); Targetcmd.Parameters.AddWithValue("@_bccemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].BCCEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].BCCEmailID); Targetcmd.Parameters.AddWithValue("@_emailSubject", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].Subject) ? string.Empty : alertModel.CommunicationModeDetails[i].Subject); Targetcmd.Parameters.AddWithValue("@_createdBy", alertModel.CreatedBy); Targetcmd.Parameters.AddWithValue("@_isactive", Convert.ToInt16(alertModel.isAlertActive)); AlertConfigInsertCount += Targetcmd.ExecuteNonQuery(); } } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(AlertConfigInsertCount); }
public ResponseModel CreateAlert([FromBody] AlertInsertModel alertModel) { int insertCount = 0; ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { ////Get token (Double encrypted) and get the tenant id string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token)); SettingsCaller newAlert = new SettingsCaller(); alertModel.TenantId = authenticate.TenantId; alertModel.CreatedBy = authenticate.UserMasterID; insertCount = newAlert.CreateAlert(new AlertService(Cache, Db), alertModel); statusCode = insertCount == 0 ? (int)EnumMaster.StatusCode.RecordAlreadyExists : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = insertCount; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// Create Alert /// </summary> /// <param name="alertModel"></param> /// <returns></returns> public int InsertAlert(AlertInsertModel alertModel) { int InsertAlertID = 0; int AlertConfigInsertCount = 0; DataSet ds = new DataSet(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_InsertAlert", conn); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@_tenantID", alertModel.TenantId); cmd.Parameters.AddWithValue("@_alertTypeName", alertModel.AlertTypeName); cmd.Parameters.AddWithValue("@_isAlertActive", Convert.ToInt16(alertModel.isAlertActive)); cmd.Parameters.AddWithValue("@_createdBy", alertModel.CreatedBy); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { InsertAlertID = ds.Tables[0].Rows[0]["AlertId"] == System.DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["AlertId"]); } if (InsertAlertID > 0) { if (alertModel.CommunicationModeDetails.Count > 0) { for (int i = 0; i < alertModel.CommunicationModeDetails.Count; i++) { MySqlCommand Targetcmd = new MySqlCommand("SP_InsertAlerMasterConfig", conn); Targetcmd.Connection = conn; Targetcmd.Parameters.AddWithValue("@_alertID", InsertAlertID); Targetcmd.Parameters.AddWithValue("@_commMode", alertModel.CommunicationModeDetails[i].Communication_Mode); Targetcmd.Parameters.AddWithValue("@_commFor", alertModel.CommunicationModeDetails[i].CommunicationFor); Targetcmd.Parameters.AddWithValue("@_content", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].Content) ? string.Empty : alertModel.CommunicationModeDetails[i].Content); Targetcmd.Parameters.AddWithValue("@_toemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].ToEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].ToEmailID); Targetcmd.Parameters.AddWithValue("@_ccemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].CCEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].CCEmailID); Targetcmd.Parameters.AddWithValue("@_bccemail", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].BCCEmailID) ? string.Empty : alertModel.CommunicationModeDetails[i].BCCEmailID); Targetcmd.Parameters.AddWithValue("@_emailSubject", string.IsNullOrEmpty(alertModel.CommunicationModeDetails[i].Subject) ? string.Empty : alertModel.CommunicationModeDetails[i].Subject); Targetcmd.Parameters.AddWithValue("@_createdBy", alertModel.CreatedBy); Targetcmd.Parameters.AddWithValue("@_isactive", Convert.ToInt16(alertModel.isAlertActive)); Targetcmd.CommandType = CommandType.StoredProcedure; AlertConfigInsertCount += Targetcmd.ExecuteNonQuery(); } } } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(AlertConfigInsertCount); }
/// <summary> /// UpdateAlert /// </summary> public int CreateAlert(IAlerts Alert, AlertInsertModel alertModel) { _Alerts = Alert; return(_Alerts.InsertAlert(alertModel)); }