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