/// <summary>
/// Insert Block Email
/// </summary>
/// <param name="blockEmailMaster"></param>
/// <returns></returns>
public int InsertBlockEmail(BlockEmailMaster blockEmailMaster)
{
int success = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_AddBlockEmail", conn)
{
Connection = conn
};
cmd.Parameters.AddWithValue("@Email_ID", string.IsNullOrEmpty(blockEmailMaster.EmailID) ? "" :blockEmailMaster.EmailID.TrimEnd(','));
cmd.Parameters.AddWithValue("@_Reason", string.IsNullOrEmpty(blockEmailMaster.Reason) ? "" : blockEmailMaster.Reason);
cmd.Parameters.AddWithValue("@Created_By", blockEmailMaster.CreatedBy);
cmd.Parameters.AddWithValue("@Tenant_Id", blockEmailMaster.TenantID);
cmd.CommandType = CommandType.StoredProcedure;
success = cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(success);
}
/// <summary>
/// List of Block Email
/// </summary>
/// <param name="TenantId"></param>
/// <returns></returns>
public List <BlockEmailMaster> ListBlockEmail(int TenantId)
{
DataSet ds = new DataSet();
List <BlockEmailMaster> listBlockEmail = new List <BlockEmailMaster>();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_ListBlockEmail", conn)
{
Connection = conn,
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@Tenant_Id", TenantId);
MySqlDataAdapter da = new MySqlDataAdapter
{
SelectCommand = cmd
};
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
BlockEmailMaster blockEmailMaster = new BlockEmailMaster
{
BlockEmailID = ds.Tables[0].Rows[i]["BlockEmailID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["BlockEmailID"]),
EmailID = ds.Tables[0].Rows[i]["EmailId"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["EmailId"]),
Reason = ds.Tables[0].Rows[i]["Reason"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Reason"]),
BlockedBy = ds.Tables[0].Rows[i]["BlockedBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["BlockedBy"]),
BlockedDate = ds.Tables[0].Rows[i]["BlockedDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["BlockedDate"]),
ModifyBy = ds.Tables[0].Rows[i]["ModifyBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifyBy"]),
ModifyDate = ds.Tables[0].Rows[i]["ModifyDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifyDate"])
};
listBlockEmail.Add(blockEmailMaster);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(listBlockEmail);
}
public int UpdateBlockEmail(IBlockEmail blockEmail, BlockEmailMaster blockEmailMaster)
{
_blockEmail = blockEmail;
return(_blockEmail.UpdateBlockEmail(blockEmailMaster));
}
public int InsertBlockEmail(IBlockEmail blockEmail, BlockEmailMaster blockEmailMaster)
{
_blockEmail = blockEmail;
return(_blockEmail.InsertBlockEmail(blockEmailMaster));
}